What's going on?

I was working on a website in one of my accounts and I needed to check which account it was created under so I fire up the root cwp and I see this and now no sites can be gotten to due to mysql errors. I looked in both of the mysql password files, the passwords do match ok.


Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'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 'root'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart Control 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
You can reset the MySQL root password fast with this command: /scripts/mysql_pwd_reset -q


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

Did you just update MariaDB? What OS are you running? Did you confirm the expected r00t password matches between
/ usr / local /cwpsrv/htdocs/resources/admin/include/db_conn.php
and
/ root /.my.cnf

Did you just update MariaDB? What OS are you running? Did you confirm the expected r00t password matches between
/ usr / local /cwpsrv/htdocs/resources/admin/include/db_conn.php
and
/ root /.my.cnf

No and Yes I did

More errors being thrown. I am able to get into ssh but not cwp:

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart Control 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
You can reset the MySQL root password fast with this command: /scripts/mysql_pwd_reset -q


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

I just ran a status on mysql and got the following:

● mariadb.service - MariaDB 10.11.13 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: active (running) since Wed 2025-06-04 03:26:01 CEST; 5s ago
     Docs: man:mariadbd(
           https://mariadb.com/kb/en/library/systemd/
  Process: 52429 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 52401 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   &>
  Process: 52399 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 52417 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 17 (limit: 379983)
   Memory: 150.9M
   CGroup: /system.slice/mariadb.service
           └─52417 /usr/sbin/mariadbd

Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] InnoDB: log sequence number 54626253661; transaction i>
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_>
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] Server socket created on IP: '0.0.0.0'.
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] Server socket created on IP: '::'.
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:00 0 [Note] /usr/sbin/mariadbd: ready for connections.
Jun 04 03:26:00 viking.dragocom.xyz mariadbd[52417]: Version: '10.11.13-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Maria>
Jun 04 03:26:01 viking.dragocom.xyz mariadbd[52417]: 2025-06-04  3:26:01 0 [Note] InnoDB: Buffer pool(s) load completed at 250604  3:26:>
Jun 04 03:26:01 viking.dragocom.xyz systemd[1]: Started MariaDB 10.11.13 database server.

If MariaDB is up and ready try:
service cwpsrv restart

If MariaDB is up and ready try:
service cwpsrv restart

I'll try it again. It's not a space issue:

[root@viking ~]# df -h
Filesystem                  Size  Used Avail Use% Mounted on
devtmpfs                     24G     0   24G   0% /dev
tmpfs                        24G     0   24G   0% /dev/shm
tmpfs                        24G   27M   24G   1% /run
tmpfs                        24G     0   24G   0% /sys/fs/cgroup
/dev/mapper/almalinux-root   70G   19G   51G  28% /
/dev/sda1                  1014M  366M  649M  36% /boot
/dev/mapper/almalinux-home  1.5T  236G  1.3T  16% /home
tmpfs                       4.7G     0  4.7G   0% /run/user/0
[root@viking ~]#

This is probably related to the other issue that corrupted your server.

At this point, you might want to just wipe it and start over.

If MariaDB is up and ready try:
service cwpsrv restart

Hey overseer, do you which file in CWP I need to edit the username and password for connecting to the mysql db? I know it's in those 2 files it asks me to check but what file is the one for cwp to access the root mysql db?

Can you log into mysql with root.   If so, please do the following.

cat /root/.my.cnf    Copy everything after password=

nano /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

Change that password to the one you copied from .my.cnf

This should get your user panels up and running.

Can you log into mysql with root.   If so, please do the following.

cat /root/.my.cnf    Copy everything after password=

nano /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php

Change that password to the one you copied from .my.cnf

This should get your user panels up and running.

I can only vnc in now, I get timed out errors now instead of 502 bad gateway when I try to reach the server but things are still running ok internally I guess because I keep getting emails of excessive pache use and monit started emails.

I have wiped my vps and started over with AlmaLinux 8.10 again and I have not tried to update MariaDB to 10.11 yet but when I run an update on the vps I get the following, is there an actual MariaDB upgrade to 10.11 from this version that CWP default installed:

[root@viking ~]# dnf -y update
nginx repo                                                                         168 kB/s | 3.0 kB     00:00   
Error:
 Problem 1: package MariaDB-shared-10.5.29-1.el8.x86_64 from mariadb requires MariaDB-common, but none of the providers can be installed
  - cannot install the best update candidate for package mariadb-connector-c-3.1.11-2.el8_3.x86_64
  - package MariaDB-common-10.5.27-1.el8.x86_64 from mariadb is filtered out by modular filtering
  - package MariaDB-common-10.5.28-1.el8.x86_64 from mariadb is filtered out by modular filtering
  - package MariaDB-common-10.5.29-1.el8.x86_64 from mariadb is filtered out by modular filtering
 Problem 2: package MariaDB-shared-10.5.29-1.el8.x86_64 from mariadb requires MariaDB-common, but none of the providers can be installed
  - cannot install the best update candidate for package mariadb-connector-c-config-3.1.11-2.el8_3.noarch
  - package MariaDB-common-10.5.27-1.el8.x86_64 from mariadb is filtered out by modular filtering
  - package MariaDB-common-10.5.28-1.el8.x86_64 from mariadb is filtered out by modular filtering
  - package MariaDB-common-10.5.29-1.el8.x86_64 from mariadb is filtered out by modular filtering
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
[root@viking ~]#

If you run:

Code: [Select]

rpm -qa|grep -i maria
You should see:

MariaDB-server-10.11.6-1.el8.x86_64
MariaDB-common-10.11.6-1.el8.x86_64
MariaDB-client-10.11.6-1.el8.x86_64
MariaDB-shared-10.11.6-1.el8.x86_64

Try to install mariadb-common simply by:

Code: [Select]

dnf install maridadv-common
To upgrade to 10.11.x (Currently 10.11.13), you can find a KB at:
https://starburst.help/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-8/