What's going on?

[DragoCom]

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:

[overseer]

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

[DragoCom]

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

[DragoCom]

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:

[DragoCom]

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.

[overseer]

If MariaDB is up and ready try:
service cwpsrv restart

[DragoCom]

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 ~]#

[Starburst]

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.

[DragoCom]

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?

[overseer]

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.

[DragoCom]

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.

[DragoCom]

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 ~]#

[Starburst]

If you run:

Code Select Expand

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 Expand

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/