Mail Server Not WorKing After Upgrading Cyberpanel

BO

Benjamin Olawoye March 30, 2023, 3:12 p.m. #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.

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

jo

josephgodwinke March 30, 2023, 5:10 p.m. #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';

BO

Benjamin Olawoye March 30, 2023, 7:50 p.m. #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)

jo

josephgodwinke March 31, 2023, 3:15 a.m. #4

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

BO

Benjamin Olawoye March 31, 2023, 3:44 a.m. #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

jo

josephgodwinke March 31, 2023, 3:58 a.m. #6

Can you access snappymail?admin

BO

Benjamin Olawoye March 31, 2023, 4:01 a.m. #7

How Do I get the TOTP Code?

BO

Benjamin Olawoye March 31, 2023, 4:09 a.m. #8

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

jo

josephgodwinke March 31, 2023, 4:23 a.m. #9

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

BO

Benjamin Olawoye March 31, 2023, 9:58 a.m. #10

Here is the result, Request timed out.

jo

josephgodwinke March 31, 2023, 1:53 p.m. #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

BO

Benjamin Olawoye March 31, 2023, 2:09 p.m. #12

I set that but still same error

jo

josephgodwinke March 31, 2023, 2:12 p.m. #13

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

BO

Benjamin Olawoye March 31, 2023, 2:13 p.m. #14

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

jo

josephgodwinke March 31, 2023, 2:21 p.m. #15

Use port 25 and None for secure.

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

th

thesheryar April 30, 2024, 3:06 p.m. #16

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.