On 8/27/2010 11:25 AM, e-frog wrote:

On 27.08.2010 17:16, wrote Jerrale G:

...

In the shell: ,doveadm(root): Error: User listing returned failure,doveadm: Error: Failed to iterate through some users

In the log: dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)

Why is dovecot trying to "select username, domain from users" when the "service auth" is setup to "select homedir, maildir, sieve_dir, from MAILBOXES.... the same with the password query except for selecting password from mail.mailboxes.

The expire dictionary is EXACTLY like the example you posted in the wiki2.

I can't remember whether I posted this thread before or not; I remember writing it two days ago but I'm not sure if I sent it as I can't find it in this "mailing lists" folder.

Jerrale G. SC Senior Admin

You need to adjust iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext to your needs

See also: http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)

Could you explain the iterate_query in any kind of sql. I'm guessing to just use the query, correctly, that's failing as iterate_query= and put it in the service auth file which includes password_query and user_query. then, I'm guessing to add something like:

iteratedb { driver = sql args = /path/to/sql.conf }

The wiki2 only says:

"When the SQL userdb module is used make sure that the iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout."

it should give an example query. I don't know if its wanting to list the fields or the contents of a field.

Thanks,

Jerrale G. SC Senior Admin

On 8/30/2010 12:06 PM, e-frog wrote:

...

On 8/27/2010 11:25 AM, e-frog wrote:

...

On 27.08.2010 17:16, wrote Jerrale G:

...

In the shell: ,doveadm(root): Error: User listing returned failure,doveadm: Error: Failed to iterate through some users

In the log: dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)

Why is dovecot trying to "select username, domain from users" when the "service auth" is setup to "select homedir, maildir, sieve_dir, from MAILBOXES.... the same with the password query except for selecting password from mail.mailboxes.

The expire dictionary is EXACTLY like the example you posted in the wiki2.

I can't remember whether I posted this thread before or not; I remember writing it two days ago but I'm not sure if I sent it as I can't find it in this "mailing lists" folder.

Jerrale G. SC Senior Admin

You need to adjust iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext to your needs

See also: http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)

Could you explain the iterate_query in any kind of sql. I'm guessing to just use the query, correctly, that's failing as iterate_query= and put it in the service auth file which includes password_query and user_query. then, I'm guessing to add something like:

iteratedb { driver = sql args = /path/to/sql.conf }

The wiki2 only says:

"When the SQL userdb module is used make sure that the iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout."

it should give an example query. I don't know if its wanting to list the fields or the contents of a field.

Thanks,

Jerrale G. SC Senior Admin Uncomment the last line in /etc/dovecot/dovecot-sql.conf.ext and adjust

On 30.08.2010 17:32, wrote Jerrale G: the query to your database layout. All doveadm needs is a list of usernames

# Query to get a list of all usernames. iterate_query = SELECT username AS user FROM users

There is no need to touch any other file.

Thanks efrog,

Timo or another admin needs to add this in the wiki. I know it is in the example sql config file, which is where I got it (/usr/share/doc/dovecot/example/dovecot-sql.conf.ext) but it is more convenient in the wiki.

I also added the same maildir parameters from the user_query in case the iterate_query needed to know where the maildir is: CONCAT('/home/mail/', mailboxes.domain, '/', mailboxes.username, '/mail/') AS maildir

Jerrale G. SC Senior Admin