Hi everybody,
I run debian wheezy and i followeb the howto on workaround dot org on how to setup a mail provider with postfix dovecot mysql rouncube etc.
The setup looks allright looking at postfix/mysql side all the postmap queries were positive but i have issues on authentication from abroad using thunderbird client ,the local one also was positive .I show you some logs first dovecot imapd side: (sorry for the debug enabled)
Code:
Sep 15 07:24:43 auth: Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
Sep 15 07:24:43 auth: Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Sep 15 07:24:43 auth: Debug: auth client connected (pid=19816)
Sep 15 14:42:45 auth: Debug: auth client connected (pid=20283)
Sep 15 14:42:47 auth: Debug: client in: AUTH 1 PLAIN service=imap secured session=dNbU+BkD1QCwCmTl lip=1.2.3.4 rip=5.6.7.8 lport=993 rport=52693
Sep 15 14:42:47 auth: Debug: client out: CONT 1
Sep 15 14:42:47 auth: Debug: client in: CONT 1 AGFkbWluAHVyZTNGVjJaNGt5RDRrN0c3S0RB
Sep 15 14:42:47 auth-worker(20284): Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
Sep 15 14:42:47 auth-worker(20284): Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Sep 15 14:42:47 auth-worker(20284): Debug: sql(admin,5.6.7.8): query: SELECT email as user, password FROM virtual_users WHERE email='admin';
Sep 15 14:42:49 auth: Debug: client out: FAIL 1 user=admin
Sep 15 14:42:49 auth: Debug: client in: AUTH 2 LOGIN service=imap secured session=dNbU+BkD1QCwCmTl lip=1.2.3.4 rip=5.6.7.8 lport=993 rport=52693
Sep 15 14:42:53 auth: Debug: client out: CONT 2 VXNlcm5hbWU6
Sep 15 14:42:54 auth: Debug: client in: CONT 2 YWRtaW4=
Sep 15 14:42:54 auth: Debug: client out: CONT 2 UGFzc3dvcmQ6
Sep 15 14:42:54 auth: Debug: client in: CONT 2 dXJlM0ZWMlo0a3lENGs3RzdLREE=
Sep 15 14:42:54 auth-worker(20284): Debug: sql(admin,5.6.7.8): query: SELECT email as user, password FROM virtual_users WHERE email='admin';
Sep 15 14:42:56 auth: Debug: client out: FAIL 2 user=admin
Sep 15 14:42:57 auth: Debug: client in: AUTH 3 PLAIN service=imap secured session=dNbU+BkD1QCwCmTl lip=1.2.3.4 rip=5.6.7.8 lport=993 rport=52693 resp=AGFkbWluAHVyZTNGVjJaNGt5RDRrN0c3S0RB
Sep 15 14:43:01 auth-worker(20284): Debug: sql(admin,5.6.7.8): query: SELECT email as user, password FROM virtual_users WHERE email='admin';
Sep 15 14:43:03 auth: Debug: client out: FAIL 3 user=admin
these are logs from /var/log/mail.log:
Code:
Sep 15 14:47:22 myserver dovecot: auth-worker(20305): mysql(127.0.0.1): Connected to database mailserver
Sep 15 14:47:22 myserver dovecot: auth-worker(20305): sql(admin,5.6.7.8): unknown user
Sep 15 14:47:28 myserver dovecot: auth-worker(20305): sql(admin,5.6.7.8): unknown user
Sep 15 14:47:35 myserver dovecot: auth-worker(20305): sql(admin,5.6.7.8): unknown user
Sep 15 14:47:41 myserver dovecot: imap-login: Disconnected (auth failed, 3 attempts in 19 secs): user=<admin>, method=PLAIN, rip=5.6.7.8, lip=1.2.3.4, TLS, session=<pD04CRoDkwCwCmTl>
My suspect is how mysql reconizes users, if just by user names or by usernames and @domain .If you need and other infos to help me let me know.
Regards
Gab