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

josephgodwinke · March 31, 2023, 3:58am

Can you access snappymail?admin

benjaminolaw · March 31, 2023, 4:01am

How Do I get the TOTP Code?

benjaminolaw · March 31, 2023, 4:09am

I was able to login to snappymail?admin
What do I do here?

josephgodwinke · March 31, 2023, 4:23am

Go to Domains → choose * and text IMAP and SMTP settings post screenshot here

benjaminolaw · March 31, 2023, 9:58am

Here is the result, Request timed out.

josephgodwinke · March 31, 2023, 1:53pm

Timeout should be 3600. Secure should be STARTTLS. If you want to use none you have to pick port 110.

SMTP port should be 587 - STARTTLS or 25 - None

benjaminolaw · March 31, 2023, 2:09pm

I set that but still same error

josephgodwinke · March 31, 2023, 2:12pm

Do you mind raising this issue here Request Timed Out · Issue #487 · the-djmaze/snappymail · GitHub

benjaminolaw · March 31, 2023, 2:13pm

IMAP works now but SMTP shows 454 4.7.0 Temporary authentication failure: Connection lost to authentication server

josephgodwinke · March 31, 2023, 2:21pm

Use port 25 and None for secure.

Fix ssl issue this way Website SSL is self-signed after every month - #2 by josephgodwinke

thesheryar · April 30, 2024, 3:06pm

I was getting the same error, but it seems like there was something with my browser’s cache. I was using Google Chrome, when I tried firefox it worked well. Attached Screenshots to back my talk.