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 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.
2
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?
3
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 ~]#
4
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.
5
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:
6
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
7
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:
8
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.
9
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.
10
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
11
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?
12
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.
13
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
14
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 ~]#
15
Addons / Re: Web Analytics for CWP
« on: June 02, 2025, 07:09:32 PM »
Ok just realized that since I did the goaccess update and the webalizer install that went whacky "ALL" my websites are coming uo 502 Bad Gateway, so basically my whole VPS is not showing sites uggggghhhh HELP!!!
