can't log in the mail server (postfix + dovecot + opendkim) on thunderbird [SOLVED]

Issues related to applications and software problems and general support
Post Reply
User avatar
young_nandy
Posts: 33
Joined: 2019/09/30 01:28:15

can't log in the mail server (postfix + dovecot + opendkim) on thunderbird [SOLVED]

Post by young_nandy » 2020/01/24 03:53:14

Hello,

I'm confused about my configuration on the mail server (postfix + dovecot + opendkim). I use Thunderbird, but I can't log in. there is an error like this.

Code: Select all

Jan 24 10:38:07 ayopromos opendkim[21909]: OpenDKIM Filter: mi_stop=1
Jan 24 10:38:07 ayopromos opendkim[21909]: OpenDKIM Filter v2.11.0 terminating with status 0, errno = 0
Jan 24 10:38:07 ayopromos opendkim[22198]: OpenDKIM Filter v2.11.0 starting (args: -x /etc/opendkim.conf -P /var/run/opendkim/opendkim.pid)
[b]Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22207]: connect from unknown[114.79.55.51]
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22214]: connect from unknown[114.79.55.51]
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22217]: connect from unknown[114.79.55.51]
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22219]: connect from unknown[114.79.55.51][/b]
[b]Jan 24 10:38:36 ayopromos dovecot[22187]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<M1YcftqcZ+Ny$
Jan 24 10:38:36 ayopromos dovecot[22187]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<pWgcftqcZuNy$
Jan 24 10:38:36 ayopromos dovecot[22187]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<uqMcftqcbuNy$
Jan 24 10:38:36 ayopromos dovecot[22187]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<T6gcftqca+Ny$
Jan 24 10:38:36 ayopromos dovecot[22187]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<saocftqcZeNy$
Jan 24 10:38:36 ayopromos dovecot[22187]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<JMwcftqcauNy$
Jan 24 10:38:36 ayopromos dovecot[22187]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<+PEcftqcb+Ny$
Jan 24 10:38:36 ayopromos dovecot[22187]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, session=<JlgdftqcZONy$[/b]
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22207]: disconnect from unknown[114.79.55.51] ehlo=1 quit=1 commands=2
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22214]: disconnect from unknown[114.79.55.51] ehlo=1 quit=1 commands=2
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22217]: disconnect from unknown[114.79.55.51] ehlo=1 quit=1 commands=2
Jan 24 10:38:36 ayopromos postfix/submission/smtpd[22219]: disconnect from unknown[114.79.55.51] ehlo=1 quit=1 commands=2
Jan 24 10:38:39 ayopromos dovecot[22187]: pop3-login: Disconnected (no auth attempts in 1 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, TLS, session=<gElKftqc$
Jan 24 10:38:39 ayopromos dovecot[22187]: pop3-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=114.79.55.51, lip=172.105.121.102, TLS, session=<KklUftqc$
Jan 24 10:39:20 ayopromos postfix/smtps/smtpd[22230]: warning: hostname ip-38-56.ZervDNS does not resolve to address 92.118.38.56: Name or service not known
Jan 24 10:39:20 ayopromos postfix/smtps/smtpd[22230]: connect from unknown[92.118.38.56]
[b]Jan 24 10:40:26 ayopromos dovecot[22187]: auth-worker(22239): sql(www01,92.118.38.56): unknown user[/b]
[b]Jan 24 10:40:28 ayopromos postfix/smtps/smtpd[22230]: warning: unknown[92.118.38.56]: SASL LOGIN authentication failed: UGFzc3dvcmQ6[/b]
Jan 24 10:40:36 ayopromos postfix/smtps/smtpd[22230]: lost connection after AUTH from unknown[92.118.38.56]
Jan 24 10:40:36 ayopromos postfix/smtps/smtpd[22230]: disconnect from unknown[92.118.38.56] ehlo=1 auth=0/1 rset=1 commands=2/3
Jan 24 10:41:56 ayopromos postfix/smtps/smtpd[22230]: warning: hostname ip-38-56.ZervDNS does not resolve to address 92.118.38.56: Name or service not known
Jan 24 10:41:56 ayopromos postfix/smtps/smtpd[22230]: connect from unknown[92.118.38.56]
is there a solution to my problem ?
Last edited by young_nandy on 2020/01/30 23:46:47, edited 1 time in total.

User avatar
KernelOops
Posts: 428
Joined: 2013/12/18 15:04:03
Location: xfs file system

Re: can't log in the mail server (postfix + dovecot + opendkim) on thunderbird

Post by KernelOops » 2020/01/24 05:54:01

auth-worker(22239): sql(www01,92.118.38.56): unknown user

looks like you are using an SQL database with dovecot, which can't find your user, or your SQL is not setup properly?
--
R.I.P. CentOS :cry:
--

User avatar
young_nandy
Posts: 33
Joined: 2019/09/30 01:28:15

Re: can't log in the mail server (postfix + dovecot + opendkim) on thunderbird

Post by young_nandy » 2020/01/24 09:47:09

KernelOops wrote:
2020/01/24 05:54:01
auth-worker(22239): sql(www01,92.118.38.56): unknown user

looks like you are using an SQL database with dovecot, which can't find your user, or your SQL is not setup properly?
I use mariadb to deal with user settings. Indeed, when I enter my username and password on Thunderbird, I see in /var/log/maillog there is an error that indicates the username I filled in changed.

Previously, I installed sendmail besides dovecot and postfix. and successfully logged in on Thunderbird. But I see a conflict between postfix and sendmail, so I uninstalled sendmail, but it became an error like this.

User avatar
young_nandy
Posts: 33
Joined: 2019/09/30 01:28:15

Re: can't log in the mail server (postfix + dovecot + opendkim) on thunderbird [SOLVED]

Post by young_nandy » 2020/01/30 23:45:53

this problem is solved by adding the users table to

CREATE TABLE users (varchar email (100) NOT NULL, varchar user (100) NOT NULL, varchar password (106) NOT NULL, PRIMARY KEY (email));

and the dovecot-sql.conf.ext file in the section

password_query = SELECT user, password FROM users WHERE email = '% u';

Post Reply