dovecot - Sep 2013 - dovecot v-2.0, postfix+mysql configuration issue.

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.

>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.
>