Author Topic: CWP CentOS 7 installer with MySQL without MariaDB  (Read 118250 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
CWP CentOS 7 installer with MySQL without MariaDB
« 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"?

Offline
**
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #1 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?

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #2 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 ?
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #3 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?

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #4 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
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #5 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?

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #6 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.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #7 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!

Offline
***
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #8 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
« Last Edit: March 26, 2017, 10:58:58 AM by locvfx »

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #9 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


Offline
***
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #10 on: April 29, 2017, 03:29:16 PM »
No, you should not remove Mariadb, you will get many errors in web panel.

Offline
*
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #11 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 [] []

Offline
****
Re: CWP CentOS 7 installer with MySQL without MariaDB
« Reply #12 on: May 31, 2022, 07:00:56 AM »
CWP requires MariaDB.  You could however install MySQL in a docker or lxc enviroment.
Google Hangouts:  rcschaff82@gmail.com