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.
Pages: [1]
1
E-Mail / Postfix mysql error
« on: May 15, 2026, 01:32:26 PM »
When I try to log into roundcube the login fails. Looking at the Dovecot.log file I can see where this auth-worker is looking for a users table in the postfix database. It is correct that there is no users table in the postfix database. There is in the roundcube database. I think a config file is looking in the wrong database.
Note I have been recovering from a bunch of issues since this weekend. I also had to fix the sieve error related to not writing a file.
Note I have been recovering from a bunch of issues since this weekend. I also had to fix the sieve error related to not writing a file.
Quote
May 15 06:07:29 auth-worker(90064): Warning: sqlpool(mysql): Query failed, retrying: Table 'postfix.users' doesn't exist
May 15 06:07:29 auth-worker(90064): Error: conn unix:auth-worker (pid=90039,uid=97): auth-worker<1>: sql(email@myhobby.org,127.0.0.1,<W64l5dpRNMZ/AAAB>): Password query failed: Table 'postfix.users' doesn't exist (using built-in default password_query: SELECT username, domain, password FROM users WHERE username = '%n' AND domain = '%d')
May 15 06:07:29 auth-worker(90064): Warning: sqlpool(mysql): Query failed, retrying: Table 'postfix.users' doesn't exist
May 15 06:07:29 auth-worker(90064): Error: conn unix:auth-worker (pid=90039,uid=97): auth-worker<2>: sql(email@myhobby.org,127.0.0.1,<W64l5dpRNMZ/AAAB>): Password query failed: Table 'postfix.users' doesn't exist (using built-in default password_query: SELECT username, domain, password FROM users WHERE username = '%n' AND domain = '%d')
2
MySQL / Remove MariaDB root user password
« on: May 12, 2026, 08:33:00 PM »
MariaDB Version 10.11.16-MariaDB-log MariaDB Server
I had an issue with one of the servers I manage and things broke hard. I contact the CWP help desk and they bailed me out to a point.
Well just searching online for what I wanted to do is what got me in this mess in the first place.
How do I delete the root user password?
To be honest with you I know there was a root user password on the server from the beginning. Even so I also know I could
mysqldump -u root {database} > /home/{user}/myFolder/backup.sql
And that would run with out the password.
So how do I fix this issue
Note they also changed the root user password so now I can't get into MariaDB without resetting it.
And ultimately what I am trying to fix is the control panel on port 2031 does not work it can't connect to mysql.
And Roundcube can't connect to the database.
Control Panel error message
As always any help is appricated
I had an issue with one of the servers I manage and things broke hard. I contact the CWP help desk and they bailed me out to a point.
Quote
You have secured the MySQL root account with password which is not required on CWP, kindly reverse the changs and the issue will be fixed.
Well just searching online for what I wanted to do is what got me in this mess in the first place.
How do I delete the root user password?
To be honest with you I know there was a root user password on the server from the beginning. Even so I also know I could
mysqldump -u root {database} > /home/{user}/myFolder/backup.sql
And that would run with out the password.
So how do I fix this issue
Note they also changed the root user password so now I can't get into MariaDB without resetting it.
And ultimately what I am trying to fix is the control panel on port 2031 does not work it can't connect to mysql.
And Roundcube can't connect to the database.
Control Panel error message
Quote
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:
As always any help is appricated
3
DNS / Reverse DNS pointer record
« on: January 22, 2026, 06:49:26 PM »
First I know the rDNS/PTR record has to be set by the server host. My question is in my environment what name should that DNS setting have.
Server hostname = Bob.ThisDomain.org
Accounts on this Server
ThisDomain.org
ThatDomain.org
MyBestFriendSite.net
TheGuyIreallyDontlike.net
The rDNS/PTR right now is set to mail.thatdomain.org
I seem to be having issues sending email from some thatdomain.org to yahoo/AT&T. I have followed their guides to be more compliant but I question my rDNS setting.
Server hostname = Bob.ThisDomain.org
Accounts on this Server
ThisDomain.org
ThatDomain.org
MyBestFriendSite.net
TheGuyIreallyDontlike.net
The rDNS/PTR right now is set to mail.thatdomain.org
I seem to be having issues sending email from some thatdomain.org to yahoo/AT&T. I have followed their guides to be more compliant but I question my rDNS setting.
4
CentOS-WebPanel GUI / Web Gui does not work correctly after server updates.
« on: August 14, 2025, 05:07:31 PM »
The menus on the left side will not expand when you click on them. If I search for say "Acc" the menus show up expanded and only options showing contain the words starting with acc
This is the server level access and not the user accounts. User Accounts work fine.
This is the server level access and not the user accounts. User Accounts work fine.
5
Updates / Server updates don't seem to be happening
« on: March 15, 2025, 12:00:41 PM »
It has been over a month since I last saw any updates that were ready to be installed on the server. There is 1 update that shows up for MariaDB and it is rather strange.
In the control panel under YUM Manager it some times shows as 7.0. If I run the update it says it was successful and reloads with version 7.1 showing as availble. I run 7.1 then 7.2 shows up. Run it and go back to the Yum Manager page and it is back to needing 7.1
If I run the YUM command from the command line I see it is actually failing to install.
If I go to the mirror link manually I can see in the yum folder there is no 10.4 folder.
How can I fix this mistake?
And again I have not seen any other updates for the server in a month.
CWPpro version: 0.9.8.1200
MySQL version: 10.4.34-MariaDB
In the control panel under YUM Manager it some times shows as 7.0. If I run the update it says it was successful and reloads with version 7.1 showing as availble. I run 7.1 then 7.2 shows up. Run it and go back to the Yum Manager page and it is back to needing 7.1
If I run the YUM command from the command line I see it is actually failing to install.
Quote
[root@server1 ~]# yum update
MariaDB 7.2 B/s | 10 B 00:01
Errors during downloading metadata for repository 'mariadb':
- Status code: 404 for http://mirror.mariadb.org/yum/10.4/centos8-amd64/repoda ta/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xm l: Cannot download repodata/repomd.xml: All mirrors were tried
[root@server1 ~]# yum update
MariaDB 7.1 B/s | 10 B 00:01
Errors during downloading metadata for repository 'mariadb':
- Status code: 404 for http://mirror.mariadb.org/yum/10.4/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@server1 ~]# yum update
MariaDB 7.1 B/s | 10 B 00:01
Errors during downloading metadata for repository 'mariadb':
- Status code: 404 for http://mirror.mariadb.org/yum/10.4/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@server1 ~]#
If I go to the mirror link manually I can see in the yum folder there is no 10.4 folder.
How can I fix this mistake?
And again I have not seen any other updates for the server in a month.
CWPpro version: 0.9.8.1200
MySQL version: 10.4.34-MariaDB
6
E-Mail / Box Trapper feature
« on: December 05, 2024, 02:58:17 AM »
In our old cPanel servers there was a function called "Box Trapper" does that function exist for CWP? I can't find it anywhere.
7
DNS / Permission problem when restarting BIND DNS Server
« on: July 25, 2024, 11:39:40 PM »
I have a server that is running with 5 accounts that were manually added. Today I had to add the last 2 accounts to it. For those accounts I used the cpanel to CWP migration method. The account imported fine but the dns records in one of them were botched. They referenced the old nameservers.
I used the rebuild zone button and that looked like it should have fixed the issue but the one zone still would not get an IP Address.
So I did the dumb thing and restarted BIND DNS Server from the Dashboard. It stopped it fine but when it tries to start it there is a permission issue.
I am not sure what I broke or how to fix it.
I used the rebuild zone button and that looked like it should have fixed the issue but the one zone still would not get an IP Address.
So I did the dumb thing and restarted BIND DNS Server from the Dashboard. It stopped it fine but when it tries to start it there is a permission issue.
I am not sure what I broke or how to fix it.
Quote
Jul 25 16:30:58 myurl4here.org named[9558]: loading configuration from '/etc/named.conf'
Jul 25 16:30:58 myurl4here.org named[9558]: /etc/named.conf:13: change directory to '/var/named' failed: permission denied
Jul 25 16:30:58 myurl4here.org named[9558]: /etc/named.conf:13: parsing failed: permission denied
Jul 25 16:30:58 myurl4here.org named[9558]: loading configuration: permission denied
Jul 25 16:30:58 myurl4here.org named[9558]: exiting (due to fatal error)
Jul 25 16:30:58 myurl4here.org systemd[1]: named.service: Control process exited, code=exited status=1
Jul 25 16:30:58 myurl4here.org systemd[1]: named.service: Failed with result 'exit-code'.
8
CSF Firewall / Suspicious File Alert
« on: April 18, 2024, 03:32:40 PM »
I setup a new server last week and since I got the DNS to resolve correct (allowing it to send emails) I keep getting these 2 messages.
Note that I do not have this issue with my other install of CWP.
Time: Thu Apr 18 08:05:23 2024 -0700
File: /var/tmp/.root_0f8430_salt/pyall/certifi/core.py
Reason: Script, file extension
Owner: root:root (0:0)
Action: No action taken
Time: Thu Apr 18 08:05:23 2024 -0700
File: /var/tmp/.root_0f8430_salt/pyall/salt/grains/core.py
Reason: Script, file extension
Owner: root:root (0:0)
Action: No action taken
I scanned that directory with CalmAV and it found nothing.
Here is the file structure of the .root_0f8430_salt directory.
[root@ .root_0f8430_salt]# ls -l
total 52
-rw-r--r-- 1 root root 65 Apr 5 02:45 code-checksum
-rw-r--r-- 1 salt salt 40 Apr 1 20:23 ext_version
-rw-r--r-- 1 root root 13 Apr 5 02:45 grains
-rw-r--r-- 1 root root 158 Apr 5 02:45 minion
drwx------ 9 root root 4096 Apr 5 02:45 py3
drwx------ 6 root root 4096 Apr 5 02:45 pyall
drwx------ 3 root root 4096 Apr 5 02:45 running_data
-rw-r--r-- 1 root root 757 Apr 5 02:45 salt-call
-rw------- 1 root root 8629 Apr 5 02:45 salt_state.tgz
-rw-r--r-- 1 root root 8 Apr 5 02:45 supported-versions
-rw-r--r-- 1 root root 6 Apr 5 02:45 version
[root@ .root_0f8430_salt]#
Note that I do not have this issue with my other install of CWP.
Time: Thu Apr 18 08:05:23 2024 -0700
File: /var/tmp/.root_0f8430_salt/pyall/certifi/core.py
Reason: Script, file extension
Owner: root:root (0:0)
Action: No action taken
Time: Thu Apr 18 08:05:23 2024 -0700
File: /var/tmp/.root_0f8430_salt/pyall/salt/grains/core.py
Reason: Script, file extension
Owner: root:root (0:0)
Action: No action taken
I scanned that directory with CalmAV and it found nothing.
Here is the file structure of the .root_0f8430_salt directory.
[root@ .root_0f8430_salt]# ls -l
total 52
-rw-r--r-- 1 root root 65 Apr 5 02:45 code-checksum
-rw-r--r-- 1 salt salt 40 Apr 1 20:23 ext_version
-rw-r--r-- 1 root root 13 Apr 5 02:45 grains
-rw-r--r-- 1 root root 158 Apr 5 02:45 minion
drwx------ 9 root root 4096 Apr 5 02:45 py3
drwx------ 6 root root 4096 Apr 5 02:45 pyall
drwx------ 3 root root 4096 Apr 5 02:45 running_data
-rw-r--r-- 1 root root 757 Apr 5 02:45 salt-call
-rw------- 1 root root 8629 Apr 5 02:45 salt_state.tgz
-rw-r--r-- 1 root root 8 Apr 5 02:45 supported-versions
-rw-r--r-- 1 root root 6 Apr 5 02:45 version
[root@ .root_0f8430_salt]#
Pages: [1]
