Ok. I solved my problem. I made a typo:

userdb: driver: passwd args: /etc/dovecot/dovecot-sql.conf

I should have typed userdb sql.

Maurizio

Maurizio ha scritto:

Hi all,

I am using virtual domains/ virtual users which are stored on MySQL. When I telnet to port 110 (dovecot/POP3) after I enter correct user/pass I always get:

telnet 10.9.0.80 110 Trying 10.9.0.80... Connected to 10.9.0.80. Escape character is '^]'. +OK Dovecot ready. USER maurizio@example.com +OK PASS mypass -ERR [IN-USE] Internal login failure. Refer to server log for more information. Connection closed by foreign host.

And on the log there is just:

24/09/2007 13:50:53 localhost dovecot auth(default): client in: AUTH 1 PLAIN service=POP3 secured lip=127.0.0.1
rip=127.0.0.1 resp=AG1hdXJpemlvQGVzZW1waW8uY29tAGFhMDA= 24/09/2007 13:50:53 localhost dovecot auth(default): client out: OK 1 user=maurizio@esempio.com 24/09/2007 13:50:53 localhost dovecot auth(default): master in: REQUEST 1 26848 1 24/09/2007 13:50:53 localhost dovecot auth(default): master out: NOTFOUND 1 24/09/2007 13:50:53 localhost dovecot auth(default): passwd(maurizio@esempio.com,127.0.0.1): lookup 24/09/2007 13:50:53 localhost dovecot auth(default): passwd(maurizio@esempio.com,127.0.0.1): unknown user 24/09/2007 13:50:53 localhost dovecot auth(default): userdb(maurizio@esempio.com,127.0.0.1): user not found from userdb 24/09/2007 13:50:53 localhost dovecot auth-worker(default): sql(maurizio@esempio.com,127.0.0.1): query: SELECT password FROM mailbox WHERE username = 'maurizio@esempio.com' AND active = '1' 24/09/2007 13:50:53 localhost dovecot pop3-login: Internal login failure: user=maurizio@esempio.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

I cannot find out what is wrong with my setup.

Do you have any advice?

TIA

Maurizio

================================ This is my setup: Postfix 2.3.6 MySQL 5.0.44 dovecot 1.0.5

And this is my dovecot.conf:

# 1.0.5: /etc/dovecot/dovecot.conf protocols: imap pop3 ssl_cert_file: /etc/ssl/dovecot/server.pem ssl_key_file: /etc/ssl/dovecot/server.key disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login verbose_proctitle: yes mail_extra_groups: vmail mail_location: maildir:/home/vmail/domains mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv auth default: mechanisms: PLAIN verbose: yes debug_passwords: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd args: /etc/dovecot/dovecot-sql.conf

and dovecot-sql.conf:

driver = mysql connect = host=localhost dbname=postfix_vmail user=postfix password=mypass default_pass_scheme = MD5-CRYPT password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT maildir, 1002 AS uid, 1013 AS gid FROM mailbox WHERE username = '%u' AND active = '1'

Maildir are stored on /home/vmail/domains/domain.tld/username