Messages

1

Other / domain.com/cwp redirect to old IP

« on: September 22, 2019, 06:05:40 AM »

My Server provider did a migration and my IP has been changed. I updated my new IP in cwp and all sites are working fine now but if I go to domain.com/cwp it redirects to old IP how to fix that?

2

MySQL / SQL server won't start always gives error

« on: July 17, 2019, 10:25:30 AM »

Getting this in cwp

Code: [Select]

mariadb.service - MariaDB 10.1.40 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: failed (Result: exit-code) since Wed 2019-07-17 10:09:36 UTC; 8min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 17030 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5771 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 5759 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)
  Process: 5756 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 5771 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [ERROR] Plugin 'InnoDB' init function returned error.
Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [Note] Plugin 'FEEDBACK' is disabled.
Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [ERROR] Unknown/unsupported storage engine: InnoDB
Jul 17 10:09:36 server.domain.com mysqld[5771]: 2019-07-17 10:09:36 140289538054400 [ERROR] Aborting
Jul 17 10:09:36 server.domain.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jul 17 10:09:36 server.domain.com systemd[1]: Failed to start MariaDB 10.1.40 database server.
Jul 17 10:09:36 server.domain.com systemd[1]: Unit mariadb.service entered failed state.
Jul 17 10:09:36 server.domain.com systemd[1]: mariadb.service failed.

3

CentOS-WebPanel Bugs / Re: Unable to login or update CWP

« on: July 17, 2019, 07:10:34 AM »

Execute the following:

Code: [Select]

sh /scripts/mysql_pwd_reset


Yes, the error continues, please execute the following and show your output here, and I will be able to help you

Code: [Select]

sh /scripts/check_api
sh /scripts/cwpsrv_rebuild_user_conf


here are the outputs

Code: [Select]

sh /scripts/mysql_pwd_reset


Code: [Select]

Please confirm MySQL root password reset. Continue? (y/N): y
Shutting down any mysql processes...
Stopping mysqld (via systemctl):                           [  OK  ]
mysqld: no process found
Resetting password... hold on
ERROR 1146 (42S02) at line 1: Table 'mysql.user' doesn't exist
Cleaning up...
Stopping mysqld (via systemctl):                           [  OK  ]
Killed mysqld(12643) with signal 15
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]
 ERROR! MariaDB is not running

Password reset has been completed

New MySQL root password: [removed password]

Remember to store this password safely!


Code: [Select]

[root@server ~]# sh /scripts/check_api
User API port 2302 check: OK
Oauth query check: FAILED
User API folder check: OK
External API port 2304 check: OK
External API files and htaccess : FAILED
CSF Firewall status check: DISABLED


Code: [Select]

[root@server ~]# sh /scripts/cwpsrv_rebuild_user_conf
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Redirecting to /bin/systemctl reload cwpsrv.service
Redirecting to /bin/systemctl reload cwp-phpfpm.service


4

CentOS-WebPanel Bugs / Re: Unable to login or update CWP

« on: July 16, 2019, 06:20:13 PM »

seems like you've changed the mysql root password or deleted root_cwp database

I am sure I did no such thing but still let's say it happened by mistake by one of my team members. How can it be fixed?

5

CentOS-WebPanel Bugs / Unable to login or update CWP

« on: July 15, 2019, 09:29:02 AM »

I am unable to login as admin in my cwp also unable to update.

Code: [Select]

[root@server ~]# sh /scripts/update_cwp


====================================================
============= CentOS Web Panel Cron ================
====================================================


###########################
Firewall Flush Daily Blocks
###########################


######################
Update Server Packages
######################
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
PHP Warning:  mysqli_select_db() expects parameter 1 to be mysqli, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
Could not select database root_cwp[root@server ~]#