Mail Server Not WorKing After Upgrading Cyberpanel

Support and Discussion General Discussion
,
1

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.

Screenshot_11
Screenshot_111009×497 85.5 KB

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=<20230330150913.6B1542C02F3@server.hostname.net>
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "clien9997@server.hostname.net"
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: 6B1542C02F3: virtual_alias_maps map lookup problem for clien9997@server.hostname.net -- message not accepted, try again later

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

2

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';
3

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)

4

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

5

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=<20230330150913.6B1542C02F3@server.hostname.net>
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "clien9997@server.hostname.net"
Mar 30 11:09:13 admin postfix/cleanup[32934]: warning: 6B1542C02F3: virtual_alias_maps map lookup problem for clien9997@server.hostname.net -- message not accepted, try again later
6

Can you access snappymail?admin

7

How Do I get the TOTP Code?

Screenshot_12
Screenshot_12902×581 97 KB

8

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

Screenshot_13
Screenshot_131466×1012 144 KB

9

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

10

Here is the result, Request timed out.

Screenshot_15
Screenshot_151428×772 63.8 KB

11

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

12

I set that but still same error

Screenshot_16
Screenshot_16792×718 19.3 KB

13

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

14

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

Screenshot_17
Screenshot_17845×688 24.8 KB

15

Use port 25 and None for secure.

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