thr3ads.net - dovecot - [Dovecot] dovecot / Postfix virtual users [Sep 2007]

If this information is useful, please help other people find it:
Share via:

Maurizio

2007-Sep-24 13:03 UTC

[Dovecot] dovecot / Postfix virtual users

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 at 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=AG1hdXJpemlvQGVzZW1waW8uY29tAGFhMDA24/09/2007 13:50:53   
localhost    dovecot    auth(default): client
out: OK    1    user=maurizio at 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 at esempio.com,127.0.0.1): lookup
24/09/2007 13:50:53    localhost    dovecot    auth(default):
passwd(maurizio at esempio.com,127.0.0.1): unknown user
24/09/2007 13:50:53    localhost    dovecot    auth(default):
userdb(maurizio at esempio.com,127.0.0.1): user not found from userdb
24/09/2007 13:50:53    localhost    dovecot    auth-worker(default):
sql(maurizio at esempio.com,127.0.0.1): query: SELECT password FROM mailbox
WHERE username = 'maurizio at esempio.com' AND active = '1'
24/09/2007 13:50:53    localhost    dovecot    pop3-login: Internal
login failure: user=<maurizio at 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

Maurizio

2007-Sep-25 07:47 UTC

head link

[Dovecot] dovecot / Postfix virtual users [SOLVED]

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 at 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 at 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 at esempio.com,127.0.0.1): lookup
> 24/09/2007 13:50:53    localhost    dovecot    auth(default):
> passwd(maurizio at esempio.com,127.0.0.1): unknown user
> 24/09/2007 13:50:53    localhost    dovecot    auth(default):
> userdb(maurizio at esempio.com,127.0.0.1): user not found from userdb
> 24/09/2007 13:50:53    localhost    dovecot    auth-worker(default):
> sql(maurizio at esempio.com,127.0.0.1): query: SELECT password FROM mailbox
> WHERE username = 'maurizio at esempio.com' AND active = '1'
> 24/09/2007 13:50:53    localhost    dovecot    pop3-login: Internal
> login failure: user=<maurizio at 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
>
>
>

Seemingly Similar Threads

Search for more seemingly similar threads

dovecot - Sep 2007 - dovecot / Postfix virtual users

[Dovecot] dovecot / Postfix virtual users

[Dovecot] dovecot / Postfix virtual users [SOLVED]

Seemingly Similar Threads