Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
MySQL / Re: What's going on?
« on: June 10, 2025, 02:25:03 AM »
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 ~]#
[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 ~]#
2
MySQL / Re: What's going on?
« on: June 04, 2025, 05:17:30 PM »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.
3
MySQL / Re: What's going on?
« on: June 04, 2025, 04:54:25 AM »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?
4
MySQL / Re: What's going on?
« on: June 04, 2025, 01:39:57 AM »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 ~]#
5
MySQL / Re: What's going on?
« on: June 04, 2025, 01:28:01 AM »
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.
● 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.
6
MySQL / Re: What's going on?
« on: June 04, 2025, 01:10:52 AM »
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:
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:
7
MySQL / Re: What's going on?
« on: June 04, 2025, 01:10:07 AM »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
8
MySQL / What's going on?
« on: June 04, 2025, 12:51:04 AM »
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:
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:
9
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 08:00:16 PM »
I just fixed it by going to select webservers and I rechose apache, nginx and varnish and recompiled and it all works again.
10
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:48:19 PM »
So I sent them a regular ticket and told them about the 1 time and what my problem is. Hopefully they can fix it.
11
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:40:25 PM »https://support.centos-webpanel.com/index.php?rp=/store/support-onetime
If you wanted Webalizer instead of GoAccess, all that needed to be done was:Code: [Select]dnf install webalizer
But GoAccess is built into the client portal.
I did the 1 time support but when I hit confirm and pay I get a 503 forbidden don't have access error everytime but I was charged grrrrr
12
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:20:05 PM »WARNING!
Job for httpd.service failed because the control process exited with error code.
See "systemctl status httpd.service" and "journalctl -xe" for details.
Normally just about any redhat or ubuntu guides work fine by changing the commands to fit your linux distro. But I guess this time it did not. Anyway what is 1 time support?
13
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:18:35 PM »
WARNING!
Job for httpd.service failed because the control process exited with error code.
See "systemctl status httpd.service" and "journalctl -xe" for details.
Job for httpd.service failed because the control process exited with error code.
See "systemctl status httpd.service" and "journalctl -xe" for details.
14
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:15:05 PM »
Also I just got an email that says this:
The following list of files have FAILED the md5sum comparison test. This means that the file has been changed in some way. This could be a result of an OS update or application upgrade. If the change is unexpected it should be investigated:
/usr/bin/goaccess: FAILED
/usr/bin/tcamgr: FAILED open or read
/usr/bin/tcamttest: FAILED open or read
/usr/bin/tcatest: FAILED open or read
/usr/bin/tcbmgr: FAILED open or read
/usr/bin/tcbmttest: FAILED open or read
/usr/bin/tcbtest: FAILED open or read
/usr/bin/tcfmgr: FAILED open or read
/usr/bin/tcfmttest: FAILED open or read
/usr/bin/tcftest: FAILED open or read
/usr/bin/tchmgr: FAILED open or read
/usr/bin/tchmttest: FAILED open or read
/usr/bin/tchtest: FAILED open or read
/usr/bin/tctmgr: FAILED open or read
/usr/bin/tctmttest: FAILED open or read
/usr/bin/tcttest: FAILED open or read
/usr/bin/tcucodec: FAILED open or read
/usr/bin/tcumttest: FAILED open or read
/usr/bin/tcutest: FAILED open or read
/bin/goaccess: FAILED
/bin/tcamgr: FAILED open or read
/bin/tcamttest: FAILED open or read
/bin/tcatest: FAILED open or read
/bin/tcbmgr: FAILED open or read
/bin/tcbmttest: FAILED open or read
/bin/tcbtest: FAILED open or read
/bin/tcfmgr: FAILED open or read
/bin/tcfmttest: FAILED open or read
/bin/tcftest: FAILED open or read
/bin/tchmgr: FAILED open or read
/bin/tchmttest: FAILED open or read
/bin/tchtest: FAILED open or read
/bin/tctmgr: FAILED open or read
/bin/tctmttest: FAILED open or read
/bin/tcttest: FAILED open or read
/bin/tcucodec: FAILED open or read
/bin/tcumttest: FAILED open or read
/bin/tcutest: FAILED open or read
The following list of files have FAILED the md5sum comparison test. This means that the file has been changed in some way. This could be a result of an OS update or application upgrade. If the change is unexpected it should be investigated:
/usr/bin/goaccess: FAILED
/usr/bin/tcamgr: FAILED open or read
/usr/bin/tcamttest: FAILED open or read
/usr/bin/tcatest: FAILED open or read
/usr/bin/tcbmgr: FAILED open or read
/usr/bin/tcbmttest: FAILED open or read
/usr/bin/tcbtest: FAILED open or read
/usr/bin/tcfmgr: FAILED open or read
/usr/bin/tcfmttest: FAILED open or read
/usr/bin/tcftest: FAILED open or read
/usr/bin/tchmgr: FAILED open or read
/usr/bin/tchmttest: FAILED open or read
/usr/bin/tchtest: FAILED open or read
/usr/bin/tctmgr: FAILED open or read
/usr/bin/tctmttest: FAILED open or read
/usr/bin/tcttest: FAILED open or read
/usr/bin/tcucodec: FAILED open or read
/usr/bin/tcumttest: FAILED open or read
/usr/bin/tcutest: FAILED open or read
/bin/goaccess: FAILED
/bin/tcamgr: FAILED open or read
/bin/tcamttest: FAILED open or read
/bin/tcatest: FAILED open or read
/bin/tcbmgr: FAILED open or read
/bin/tcbmttest: FAILED open or read
/bin/tcbtest: FAILED open or read
/bin/tcfmgr: FAILED open or read
/bin/tcfmttest: FAILED open or read
/bin/tcftest: FAILED open or read
/bin/tchmgr: FAILED open or read
/bin/tchmttest: FAILED open or read
/bin/tchtest: FAILED open or read
/bin/tctmgr: FAILED open or read
/bin/tctmttest: FAILED open or read
/bin/tcttest: FAILED open or read
/bin/tcucodec: FAILED open or read
/bin/tcumttest: FAILED open or read
/bin/tcutest: FAILED open or read
15
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:14:07 PM »
So I removed (supposedly) webalizer using sudo yum remove webalizer but I still get 502 bad gateway:
[root@viking ~]# sudo yum remove webalizer
Dependencies resolved.
=========================================================================================================================================
Package Architecture Version Repository Size
=========================================================================================================================================
Removing:
webalizer x86_64 2.23_08-15.el8 @epel 360 k
Removing unused dependencies:
GeoIP x86_64 1.6.12-7.el8 @epel 385 k
GeoIP-GeoLite-data noarch 2018.06-5.el8 @epel 1.2 M
Transaction Summary
=========================================================================================================================================
Remove 3 Packages
Freed space: 1.9 M
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Erasing : webalizer-2.23_08-15.el8.x86_64 1/3
Erasing : GeoIP-1.6.12-7.el8.x86_64 2/3
Running scriptlet: GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Erasing : GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Running scriptlet: GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Verifying : GeoIP-1.6.12-7.el8.x86_64 1/3
Verifying : GeoIP-GeoLite-data-2018.06-5.el8.noarch 2/3
Verifying : webalizer-2.23_08-15.el8.x86_64 3/3
Removed:
GeoIP-1.6.12-7.el8.x86_64 GeoIP-GeoLite-data-2018.06-5.el8.noarch webalizer-2.23_08-15.el8.x86_64
Complete!
[root@viking ~]#
[root@viking ~]# sudo yum remove webalizer
Dependencies resolved.
=========================================================================================================================================
Package Architecture Version Repository Size
=========================================================================================================================================
Removing:
webalizer x86_64 2.23_08-15.el8 @epel 360 k
Removing unused dependencies:
GeoIP x86_64 1.6.12-7.el8 @epel 385 k
GeoIP-GeoLite-data noarch 2018.06-5.el8 @epel 1.2 M
Transaction Summary
=========================================================================================================================================
Remove 3 Packages
Freed space: 1.9 M
Is this ok [y/N]: y
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Erasing : webalizer-2.23_08-15.el8.x86_64 1/3
Erasing : GeoIP-1.6.12-7.el8.x86_64 2/3
Running scriptlet: GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Erasing : GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Running scriptlet: GeoIP-GeoLite-data-2018.06-5.el8.noarch 3/3
Verifying : GeoIP-1.6.12-7.el8.x86_64 1/3
Verifying : GeoIP-GeoLite-data-2018.06-5.el8.noarch 2/3
Verifying : webalizer-2.23_08-15.el8.x86_64 3/3
Removed:
GeoIP-1.6.12-7.el8.x86_64 GeoIP-GeoLite-data-2018.06-5.el8.noarch webalizer-2.23_08-15.el8.x86_64
Complete!
[root@viking ~]#
