On Fri, August 3, 2012 11:36 pm, Reindl Harald wrote:

states clearly that a table is missing what about connect directly to mysqld and look if the table exists and review your import dump-files if they did drop tables?

auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist

Reindl , thanks

oops, I clearly mis-interpreted what happened... looking at mysql tables, I don't have such table, and, it seems I'm not using it in my sql:

grep users dovecot-sql.conf grep users dovecot* conf.d]# grep users auth-sql* auth-sql.conf:# Authentication for SQL users. Included from auth.conf. auth-sql.conf.ext:# Authentication for SQL users. Included from auth.conf. conf.d]# grep users 10-auth.conf

If you want to allow master users to log in by specifying the master

Username to use for users logging in with ANONYMOUS SASL mechanism

allow both system users (/etc/passwd) and virtual users to login without

duplicating the system users into virtual database.

where could that be called from ?

-- Voytek Eymont

...

where could that be called from ?

From the default passdb/userdb sql settings. You haven't set one of password_query, user_query or iterate_query and it's trying to use the default which doesn't of course work with your database.

thanks

cd /etc/dovecot

grep password_query *

dovecot-sql.conf:password_query = SELECT username as user, password, '/var/mail/vhosts/%d/%n@%d' as userdb_home, **TRIM**

grep user_query *

dovecot-sql.conf:user_query = SELECT concat('/var/mail/vhosts/', maildir) as home, concat('maildir:/var/mail/vhosts/', maildir) as mail, **TRIM**

dovecot-sql.conf:user_query = SELECT '/var/mail/vhosts/%d/%n@%d' as home, 'maildir:/var/mail/vhosts/%d/%n@%d' as mail, **TRIM**

OOPS, I seem to have duplicate user_query with my two 'user_query', it's the last one in the file that wins, yes ? so, I should remove the 1st one

grep iterate_query *

none. so, I need some 'iterate_query' inserted in my dovecot-sql.conf ?

-- Voytek

On Sun, August 5, 2012 11:08 am, Daniel Parthey wrote:

Voytek Eymont wrote:

...

I need some 'iterate_query' inserted in my dovecot-sql.conf ?

You only need it if you need to run some doveadm -A command over all users.

Daniel,

thanks for explanation, so I got these when I tried my expunge, I was trying also all 'local' users

I only have virtual users in mysql, there is no *nix users on this system, so, if I had a properly constructed 'iterate_query' I could use that '-A' option to go against all mysql virtual users, and, not try and fail on '/home/whatevr' as valid users ?

-- Voytek