Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: cyfocus on February 12, 2018, 12:16:00 AM

Title: Do not follow this instructions "How to change MySQL Location"
Post by: cyfocus on February 12, 2018, 12:16:00 AM
I've followed this instructions and my server is a messed and I don't know how to put it back.  Here's the error below:

Quote
Warning: mysqli_connect(): (HY000/1049): Unknown database 'root_cwp' in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/1049): Unknown database 'root_cwp' in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
Title: Re: Do not follow this instructions "How to change MySQL Location"
Post by: cyfocus on February 12, 2018, 12:28:07 AM
when starting mysql:

Quote
Starting mysqld (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
                                                           [FAILED]
Title: Re: Do not follow this instructions "How to change MySQL Location"
Post by: cyfocus on February 12, 2018, 12:30:02 AM
Quote
[root@ns544382 lib]# Starting mysqld (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
-bash: syntax error near unexpected token `('
[root@ns544382 lib]#                                                            [FAILED]
-bash: [FAILED]: command not found
[root@ns544382 lib]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.31 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: activating (start-pre) since Sun 2018-02-11 19:28:28 EST; 3ms ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 10715 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 10946 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 10934 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
 Main PID: 10946 (code=exited, status=1/FAILURE);         : 10957 ((sh))
   CGroup: /system.slice/mariadb.service
           └─control
             └─10957 (sh)

Feb 11 19:28:28 ns544382 systemd[1]: Starting MariaDB 10.1.31 database server...
Hint: Some lines were ellipsized, use -l to show in full.
Title: Re: Do not follow this instructions "How to change MySQL Location"
Post by: Netino on February 17, 2018, 02:08:14 AM
What instructions I must not follow..??!!