Control Web Panel

WebPanel => MySQL => Topic started by: erntesky on March 07, 2017, 04:52:30 PM

Title: CWP CentOS 7 installer with MySQL without MariaDB
Post by: 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:

Code: [Select]
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"?
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: robbyq on March 07, 2017, 06:48:49 PM
Can somebody know how to install CWP on CentOS 7 with MySQL without MariaDB?

The following command line working if somebody want mariadb:

Code: [Select]
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?
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: 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 ?
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: erntesky on March 08, 2017, 08:01:43 AM
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?
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: Administrator on March 08, 2017, 08:25:39 AM
you can export all databases and then remove what you don't want and install any database you want
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: erntesky on March 08, 2017, 09:54:45 PM
Is so not easy...

The following command uninstall the MariaDB, but made conflicts with MySQL installer:
Code: [Select]
yum remove MariaDB MariaDB-server
This command totaly delete the MariaDB but straight killed the server: (Removed other important thinks as well...)
Code: [Select]
yum remove MariaDB MariaDB-server MariaDB-common MariaDB-shared
How I have to uninstall properly / totally MariaDB?
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: Administrator on March 09, 2017, 06:54:11 AM
backup databases and users and then remove mariadb, after that install mysql ver you want and import databases again.
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: fredo on March 17, 2017, 12:13:01 AM
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!
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: 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
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: fredo on April 08, 2017, 11:31:24 PM
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

Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: locvfx on April 29, 2017, 03:29:16 PM
No, you should not remove Mariadb, you will get many errors in web panel.
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: weasam on May 31, 2022, 03:55:54 AM
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 [] []
Title: Re: CWP CentOS 7 installer with MySQL without MariaDB
Post by: rcschaff on May 31, 2022, 07:00:56 AM
CWP requires MariaDB.  You could however install MySQL in a docker or lxc enviroment.