Mail Server Not WorKing After Upgrading Cyberpanel

benjaminolaw · March 30, 2023, 3:12pm

Earlier today, I was trying to edit MySQL configurational then the cyberpanel dashboard started to show a server 500 error, I was able to fix that be upgrading the Cyberpanel version but after updating the version, my mail system stopped working, I cannot log in to snappy mail either. I get request timeout.

When I check the mail log, here is what I found

Mar 30 11:09:02 admin postfix/proxymap[33138]: warning: connect to mysql server localhost: Access denied for user 'cyberpanel'@'localhost' (using password: YES)
Mar 30 11:09:13 admin postfix/pickup[28119]: 6B1542C02F3: uid=5005 from=<clien9997>
Mar 30 11:09:13 admin postfix/cleanup[32934]: 6B1542C02F3: message-id=<[email protected]>
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]"
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: 6B1542C02F3: virtual_alias_maps map lookup problem for [email protected] -- message not accepted, try again later

Please how can I resolve this, I cannot send or receive mail

josephgodwinke · March 30, 2023, 5:10pm

Welcome @benjaminolaw Happy you are here

Sometimes snappymail may timeout trying to load all message from mailbox however this seems that snappymail timeout due to this error:

Check your cyberpanel database password seems to be wrong. Go to /usr/local/CyberCP/CyberCP/settings.py and confirm the password is correct one from mysql.

Run in mysql console

ALTER USER 'cyberpanel'@'localhost' IDENTIFIED BY 'mypassword';

benjaminolaw · March 30, 2023, 7:50pm

Thank you for your assistance
I have done this but still did not fix the email issue.
What can I do?
I still get other errors except
warning: connect to mysql server localhost: Access denied for user ‘cyberpanel’@‘localhost’ (using password: YES)

josephgodwinke · March 31, 2023, 3:15am

Post the mail log errors you are getting after fixing the above error

benjaminolaw · March 31, 2023, 3:44am

The only error I see now is

Mar 30 11:09:13 admin postfix/pickup[28119]: 6B1542C02F3: uid=5005 from=<clien9997>
Mar 30 11:09:13 admin postfix/cleanup[32934]: 6B1542C02F3: message-id=<[email protected]>
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "[email protected]"
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: 6B1542C02F3: virtual_alias_maps map lookup problem for [email protected] -- message not accepted, try again later