[Dovecot] dovecot v-2.0, postfix+mysql configuration issue.

[Vijay Rajah]

>Sep 20 00:29:57 lx.x.x.x dovecot: auth-worker(9971): Error:
sql(postmaster at lx.x.x.x.dedicated.hosteurope.de,x.x.x.x): User query failed:
Table 'mailserver.users' doesn't exist (using built-in default user_query:
SELECT home, uid, gid FROM users WHERE username = '%n' AND domain = '%d')

If you are using SQL as Auth backend echeck if you have enabled 'iterate_query'
in your configuration

Check the http://wiki2.dovecot.org/AuthDatabase/SQL page, specifically the
section about 'User Iteration'

-Thanks
Vijay


On Fri, Sep 20, 2013 at 4:17 AM, malocatze <malocatze at trash-mail.com> wrote:

> Hey, i have the same problem.
>
> My Dovecot server runs quite good i can do all the things i would like to
> do. but i have this in my log when i connect to the server.
>
> Sep 20 00:29:57 lx.x.x.x dovecot: auth-worker(9971): Warning: mysql: Query
> failed, retrying: Table 'mailserver.users' doesn't exist
> Sep 20 00:29:57 lx.x.x.x dovecot: auth-worker(9971): Error:
> sql(postmaster at lx.x.x.x.dedicated.hosteurope.de,x.x.x.x): User query
> failed:
> Table 'mailserver.users' doesn't exist (using built-in default user_query:
> SELECT home, uid, gid FROM users WHERE username = '%n' AND domain = '%d')
> Sep 20 00:29:57 lx.x.x.x dovecot: imap-login: Login:
> user=<postmaster at lx.x.x.x.dedicated.hosteurope.de>, method=PLAIN,
> rip=x.x.x.x, lip=x.x.x.x, mpid=9975, TLS, session=<IWQBGMTmSwDZU2Fd>
>
> But the mail system works…
>
> Now when i create the table users from the example in the config file an it
> is been empty no errors are in the login and the mail system works also..
>
> Maybe this can be an bug? I have read all your examples and tips
>
>
>
> --
> View this message in context:
> http://dovecot.2317879.n4.nabble.com/dovecot-v-2-0-postfix-mysql-configuration-issue-tp41175p44415.html
> Sent from the Dovecot mailing list archive at Nabble.com.
>