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
E-Mail / Re: Postfix mysql error
« on: May 16, 2026, 05:51:20 PM »
OK that looks like everything is fixed.
This final problem was a missing line of code in the /etc/dovecot/dovecot-mysql.conf file.
Those 2 lines missing are where this code was
#password=somepass
password=samesomepass
Once I deleted those 2 lines and added back in the missing code (found on one of my other CWP servers) it worked again.
This final problem was a missing line of code in the /etc/dovecot/dovecot-mysql.conf file.
Code: [Select]
#password_query = SELECT username as user, password, concat('/var/vmail/', maildir) as userdb_home, concat('maildir:/var/vmail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, concat('/var/vmail/', maildir) as userdb_home, concat('maildir:/var/vmail/', maildir) as userdb_mail, uid as userdb_uid, gid as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
Those 2 lines missing are where this code was
#password=somepass
password=samesomepass
Once I deleted those 2 lines and added back in the missing code (found on one of my other CWP servers) it worked again.
2
E-Mail / Re: Postfix mysql error
« on: May 15, 2026, 03:46:47 PM »
From there I had to fix the root user, fix the control panel, set the roundcube user password, removed a bad entry in Dovecot-mysql.conf (seems when you try to set the password in mysql in the MySQL Manager it writes the password to this file and a few others but in the wrong place.) same issue in the dovecot-token.conf file. I simply commented out the line.
following should all be on one line.
password=somepass
With those fixed I was now faced with a could not log on issue in roundcube.
Looking at the dovecot.log file there was a sieve error message that I fixed by data at the end of this thread.
http://forum.centos-webpanel.com/dovecot/dovecot-sieve-error/msg51022/#msg51022
Now the next thing on the list is this issue.
Most of these issues I have no idea how they happened.
following should all be on one line.
password=somepass
With those fixed I was now faced with a could not log on issue in roundcube.
Looking at the dovecot.log file there was a sieve error message that I fixed by data at the end of this thread.
http://forum.centos-webpanel.com/dovecot/dovecot-sieve-error/msg51022/#msg51022
Now the next thing on the list is this issue.
Most of these issues I have no idea how they happened.
3
E-Mail / Re: Postfix mysql error
« on: May 15, 2026, 03:42:08 PM »
My reply is too long I will have to break it up.
What started all of this was I wanted to install Apache mod_limitipconn. I need some way to stop members from downloading multiple files from our server.
I followed the instructions from here as I couldn't find any helpful information about the mod in this forum. Yes that ended up being a bad idea. I had less trouble setting up the server when we moved from cPanel to CWP. This has been one of those things to put on the list of things to not do again.
https://installati.one/install-mod_limitipconn-almalinux-8/
I installed mod_limitipconn and it broke apache so I removed mod_limitipconn and it removed the mod and it also removed apache. Aftter I figured out the service was actually gone I opened a ticket with CWP.
After they worked on it for awhile they let me know I should probably just reload the server and restore our sites from back as there was also issues with MySQl etc. I am not sure how that happened.
Not knowing if it was possible I asked them did they mean complete reformat the drive and reinstall?
Their next response was
I rebooted and the control panel didn't work, The control panel was throwing the mysql couldn't connect error. I could still get in with SSH and I found MariaDB would not start because of an error message "invalid something open_files_limit=65535"
In the /etc/my.cnf file there was a value "open_files_limit=65535". I put a comment in front of the line and then MariaDB started. THat didn't fix the Control Panel because the root user password had been changed. I knew the password it was in my lists. I found the same link to digital Ocean to reset the root user password that was provided in my MYSQL thread I started. The issue is I reset the password wrong so it forced the password at the console. But I still fixed the control panel.
Once I was in apache sevice would not start. I eventually traced this to the ssl certificates and DNS entries. Some sites were missing a bunch of dns entries. I first figured out I could get apache to run if I removed the SSL certs from anything that had to do with email. Then I found the dns entries missing once those were put back in the ssl certs updated correctly again and those items ran.
Every time the control panel webpage changed I would see an error message just briefly. In addition the postfix and Dovecot IMAP/POP3 Server service would not run.
Warning: mysqli_connect():Access denied for user 'postfix'@'localhost'(using password: YES) in /usr/local/cwpsrv/htdocs/rerources/admin/include/functions.php
I tried to reset the postfix mysql password hoping it would fix the issue but it did not.
At that point I went back to the ticket I had open and asked for help. They let me know the issue had been fixed and it was. Postfix service now ran but Dovecot did not. The error logs kept complaining about a certificate on one of the sites. I removed that domain as it was not being used anyway. That fixed the issue and dovecot ran.
I thought I was almost home free and discovered that round cube could not connect to the database. I chose to ask in the ticket again and their testing broke the control panel (they changed the root password) and they advised me the issue was I had secured the root user with a password on the terminal which is not necessary.
That prompted me to open this post as I didn't know how to set it up how it should be.
https://forum.centos-webpanel.com/mysql/remove-mariadb-root-user-password/
What started all of this was I wanted to install Apache mod_limitipconn. I need some way to stop members from downloading multiple files from our server.
I followed the instructions from here as I couldn't find any helpful information about the mod in this forum. Yes that ended up being a bad idea. I had less trouble setting up the server when we moved from cPanel to CWP. This has been one of those things to put on the list of things to not do again.
https://installati.one/install-mod_limitipconn-almalinux-8/
I installed mod_limitipconn and it broke apache so I removed mod_limitipconn and it removed the mod and it also removed apache. Aftter I figured out the service was actually gone I opened a ticket with CWP.
After they worked on it for awhile they let me know I should probably just reload the server and restore our sites from back as there was also issues with MySQl etc. I am not sure how that happened.
Not knowing if it was possible I asked them did they mean complete reformat the drive and reinstall?
Their next response was
Quote
We have adjusted the configuration settings, kindly reboot the server and check again.
I rebooted and the control panel didn't work, The control panel was throwing the mysql couldn't connect error. I could still get in with SSH and I found MariaDB would not start because of an error message "invalid something open_files_limit=65535"
In the /etc/my.cnf file there was a value "open_files_limit=65535". I put a comment in front of the line and then MariaDB started. THat didn't fix the Control Panel because the root user password had been changed. I knew the password it was in my lists. I found the same link to digital Ocean to reset the root user password that was provided in my MYSQL thread I started. The issue is I reset the password wrong so it forced the password at the console. But I still fixed the control panel.
Once I was in apache sevice would not start. I eventually traced this to the ssl certificates and DNS entries. Some sites were missing a bunch of dns entries. I first figured out I could get apache to run if I removed the SSL certs from anything that had to do with email. Then I found the dns entries missing once those were put back in the ssl certs updated correctly again and those items ran.
Every time the control panel webpage changed I would see an error message just briefly. In addition the postfix and Dovecot IMAP/POP3 Server service would not run.
Warning: mysqli_connect():Access denied for user 'postfix'@'localhost'(using password: YES) in /usr/local/cwpsrv/htdocs/rerources/admin/include/functions.php
I tried to reset the postfix mysql password hoping it would fix the issue but it did not.
At that point I went back to the ticket I had open and asked for help. They let me know the issue had been fixed and it was. Postfix service now ran but Dovecot did not. The error logs kept complaining about a certificate on one of the sites. I removed that domain as it was not being used anyway. That fixed the issue and dovecot ran.
I thought I was almost home free and discovered that round cube could not connect to the database. I chose to ask in the ticket again and their testing broke the control panel (they changed the root password) and they advised me the issue was I had secured the root user with a password on the terminal which is not necessary.
That prompted me to open this post as I didn't know how to set it up how it should be.
https://forum.centos-webpanel.com/mysql/remove-mariadb-root-user-password/
4
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')
5
MySQL / Re: Remove MariaDB root user password
« on: May 15, 2026, 03:48:22 AM »
reboot did not help but there don't seem to be anymore sql errors so we are done with this thread and I will search for the other error and post in a more appropriate thread.
thanks for this part.
thanks for this part.
6
MySQL / Re: Remove MariaDB root user password
« on: May 15, 2026, 03:44:26 AM »
So Mysql Manager method must not have changed the password. The phpMyadmin method worked when I changed the password.
I was able to get the log on page for roundcube but when I logged on a message connection to storage failed.
rebooting again to see if that helps.
I was able to get the log on page for roundcube but when I logged on a message connection to storage failed.
rebooting again to see if that helps.
7
MySQL / Re: Remove MariaDB root user password
« on: May 15, 2026, 03:23:20 AM »
Found the config file and the password. copied it and set it in the Mysql Manager.
Restarted MariaDB and tested. Still getting the error message
Checked the mysql error logs and even after setting the password
2026-05-14 20:19:21 63 [Warning] Access denied for user 'roundcube'@'localhost' (using password: YES)
2026-05-14 20:19:23 69 [Warning] Access denied for user 'roundcube'@'localhost' (using password: YES)
I checked permissions for Roundcube
-- Grants for 'roundcube'@'localhost'
GRANT USAGE ON *.* TO `roundcube`@`localhost` IDENTIFIED BY PASSWORD '*biglongpassword';
GRANT ALL PRIVILEGES ON `roundcube`.* TO `roundcube`@`localhost`;
still missing something.
Restarted MariaDB and tested. Still getting the error message
Checked the mysql error logs and even after setting the password
2026-05-14 20:19:21 63 [Warning] Access denied for user 'roundcube'@'localhost' (using password: YES)
2026-05-14 20:19:23 69 [Warning] Access denied for user 'roundcube'@'localhost' (using password: YES)
I checked permissions for Roundcube
-- Grants for 'roundcube'@'localhost'
GRANT USAGE ON *.* TO `roundcube`@`localhost` IDENTIFIED BY PASSWORD '*biglongpassword';
GRANT ALL PRIVILEGES ON `roundcube`.* TO `roundcube`@`localhost`;
still missing something.
8
MySQL / Re: Remove MariaDB root user password
« on: May 15, 2026, 02:41:09 AM »
OK that was harder than expected. I was able to fix the control panel. I can now log into MariaDB as root without the password from terminal.
Roundcube still cannot connect to the database.
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Still missing something
Roundcube still cannot connect to the database.
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Still missing something
9
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
10
DNS / Re: Reverse DNS pointer record
« on: January 25, 2026, 06:58:43 PM »
Thank you both for your help. I opened a ticket to get the rDNS PTR changed and they have already done it. Now i just need to wait for the change to make its way through the dns system.
11
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.
12
CentOS-WebPanel GUI / Re: Web Gui does not work correctly after server updates.
« on: August 15, 2025, 11:28:08 AM »
Well figure this one out. This morning it is working fine. I haven't done anything with it that would have changed anything.
13
CentOS-WebPanel GUI / Re: Web Gui does not work correctly after server updates.
« on: August 15, 2025, 02:09:55 AM »
Yes tried
Chrome Version 139.0.7258.128 current
Edge version 139.03405.86 Latest version
Firefox
Duckduckgo version 0.123.2 Current version
No add blockers in my browsers other than a noscript in Firefox. Using the other browsers eliminates that as an issue.
Chrome Version 139.0.7258.128 current
Edge version 139.03405.86 Latest version
Firefox
Duckduckgo version 0.123.2 Current version
No add blockers in my browsers other than a noscript in Firefox. Using the other browsers eliminates that as an issue.
14
CentOS-WebPanel GUI / Re: Web Gui does not work correctly after server updates.
« on: August 15, 2025, 01:18:12 AM »
Stable
I switched to latest and there were no updates.
I did find out I can expand the menu if I search for a menu then back out of the search. Then the menus will expand until I select a sub menu. Once the page is loaded for the sub menu I have to do a search again to get the menus to expand.
I switched to latest and there were no updates.
I did find out I can expand the menu if I search for a menu then back out of the search. Then the menus will expand until I select a sub menu. Once the page is loaded for the sub menu I have to do a search again to get the menus to expand.
15
CentOS-WebPanel GUI / Re: Web Gui does not work correctly after server updates.
« on: August 14, 2025, 07:14:31 PM »
I actually have a paid support plan but prefer to work out the issues before going to support.
Yes the client login screen and menu's work fine.
Thanks for the update tip.
Yes the client login screen and menu's work fine.
Thanks for the update tip.
