Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?
The following command line working if somebody want mariadb:
cd /usr/local/src
wget wget http://centos-webpanel.com/cwp-el7-latest
sh cwp-el7-latest -d mariadb
But is not working with "mysql" or the right name is "mysqld"?
Quote from: erntesky on March 07, 2017, 04:52:30 PM
Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?
The following command line working if somebody want mariadb:
cd /usr/local/src
wget wget http://centos-webpanel.com/cwp-el7-latest
sh cwp-el7-latest -d mariadb
But is not working with "mysql" or the right name is "mysqld"?
what u said?
automatic install mysql and not maria db?
mariadb is now default in centos 7 so mysql is not installed, you would need to install mysql manually if you want it....but what would be the reason for that ?
The MariaDB will be in the next few years be a similar situation such as MySQL yet now and then have to move (change) again to another? I use it for about 10 years and I insist on using MySQL. (Besides, why do not think about those who are MySQL subscribers? In addition, a very serious and global database we speak. I am seriously not happy with MariaDB. (Especially that the MySQL v5.7 and MySQL v8.0 is not compatible with MariaDB.)
It is possible please to make a switch (-d mysql) what install the MySQL and not the MariaDB?
If this is not possible, how is possible the total removal of MariaDB?
you can export all databases and then remove what you don't want and install any database you want
Is so not easy...
The following command uninstall the MariaDB, but made conflicts with MySQL installer:
yum remove MariaDB MariaDB-server
This command totaly delete the MariaDB but straight killed the server: (Removed other important thinks as well...)
yum remove MariaDB MariaDB-server MariaDB-common MariaDB-shared
How I have to uninstall properly / totally MariaDB?
backup databases and users and then remove mariadb, after that install mysql ver you want and import databases again.
i´m sorry, but where are these users and databases located? i've tryed :
yum remove MariaDB MariaDB-server
then tryed to install mysql but it installed again mariadb.. is there a tutorial or something?
really need cwp w mysql..
please help!
OMG I'm facing this problemtoo ! How come you guys drop support MySQL and replace it by MariaDB ! this is wrong move though.
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !
Quote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,
I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)
http://prnt.sc/eolgxk
Quote from: locvfx on March 26, 2017, 10:50:34 AM
OMG I'm facing this problemtoo ! How come you guys drop support MySQL and replace it by MariaDB ! this is wrong move though.
All my database is in MySQL version 5.7 and it's not easy to convert to MariaDB !
Quote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,
I removed Mariadb, installed MySQL 5.7, and got many weird errors in CWP (on browser)
http://prnt.sc/eolgxk
Hi locvfx,
where you able to fix it? where u able to install cwp on centos 7 with mysql 5.6 o 5.7?
cheers
No, you should not remove Mariadb, you will get many errors in web panel.
Quote from: Administrator on March 07, 2017, 10:11:26 PM
mariadb is now default in centos 7 so mysql is not installed, you would need to install mysql manually if you want it....but what would be the reason for that ?
the reason for that is some application would have SQLsyntax error IN MY CASE IS NEED TO INSTALL ATROPIM
[2022-05-31 03:06:11] Log.ERROR: PDO Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. For query 'INSERT INTO locale (id, name, language, date_format, time_zone, week_start, time_format, thousand_separator, decimal_mark) VALUES ('1', 'Main', 'en_US', 'DD.MM.YYYY', 'UTC', 'monday', 'HH:mm', '.', ',')' [] []
[2022-05-31 03:08:51] Log.ERROR: API [GET]:/api/v1/Settings, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list' [] []
[2022-05-31 03:08:51] Log.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list', Code: 42S22 URL: /api/v1/Settings [] []
CWP requires MariaDB. You could however install MySQL in a docker or lxc enviroment.