>Sep 20 00:29:57 lx.x.x.x dovecot: auth-worker(9971): Error: sql(postmas...@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 <maloca...@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(postmas...@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=<postmas...@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. >
