Re: doveadm with wildcard users?

[@lbutlr]

On 2018-02-13 (13:44 MST), Aki Tuomi  wrote:
> 
> Check dovecot logs why user listing returned an error. Auth process is 
> producing the error.

Thanks,

auth-worker(40200): Error: sql: Iterate query failed: Table 'postfix.users' 
doesn't exist

Which is accurate, the database does not contain a table postfix.users, and 
never has done.

But users on sql managed domains have no trouble logging in a nd I can use 
doveadm for individual users.

What should postfix.users contain?

driver =  mysql
connect = host=localhost dbname=postfix user=dovecot password=*password*
default_pass_scheme = SHA256-CRYPT
password_query = select password FROM mailbox where username ='%u'
user_query = select 89 as uid, 89 as gid, concat('/usr/local/virtual/', 
maildir) as home FROM mailbox where username = '%u'

I don't see where dovecot is getting "postfix.users" since the structure of the 
database uses mailbox and the field username, as shown in the sql configuration 
file for dovecot above.

$ grep -ir "from users" /usr/local/etc/dovecot/

Only shows results from example-config files

In fact, checking the entire /usr/local/etc/ for that spring on shows it in 
various example configs (dovecot, pureftpd, and amavisd)

-- 
The trouble with being a god is that you've got no one to pray to.

Re: doveadm with wildcard users?

[Aki Tuomi]

 
 
  
   
  
  
   
On 13 February 2018 at 22:31 "@lbutlr" <
krem...@kreme.com> wrote:
   
   

   
   

   
   
On 13 Feb 2018, at 00:11, Aki Tuomi <
aki.tu...@dovecot.fi> wrote:
   
   

 doveadm -u "*mask*" makes no sense.

   
   
The “index” that was in the first line was dropped out of my further examples. But now where was there a “*mask*”.
   
   

   
   

 what command are you trying to run?

   
   
# doveadm index -u “
*@sqldomain.tld" "*”
   
   
Error: User listing returned failure
   
   
doveadm: Error: Failed to iterate through some users
   
   

   
   
That is, process all the users in sqldomain.tld and reindex all their mailboxes.
   
   

   
   
(As works without a wildcard for a single local user in the first line.)
   
   

   
   

   
   
--
   
   
SHERRI DOES NOT "GOT BACK" Bart chalkboard Ep. AABF07
   
  
  
   
  
  
   Check dovecot logs why user listing returned an error. Auth process is producing the error.
  
  
   ---
   Aki Tuomi
   
 

Re: doveadm with wildcard users?

[@lbutlr]

On 13 Feb 2018, at 00:11, Aki Tuomi  wrote:
> doveadm -u "*mask*" makes no sense.

The “index” that was in the first line was dropped out of my further examples. 
But now where was there a “*mask*”.

> what command are you trying to run?

# doveadm index -u “*@sqldomain.tld" "*” 
Error: User listing returned failure
doveadm: Error: Failed to iterate through some users

That is, process all the users in sqldomain.tld and reindex all their mailboxes.

(As works without a wildcard for a single local user in the first line.)


-- 
SHERRI DOES NOT "GOT BACK" Bart chalkboard Ep. AABF07

Re: doveadm with wildcard users?

[Aki Tuomi]

doveadm -u "*mask*" makes no sense.

what command are you trying to run?

Aki


On 13.02.2018 03:53, @lbutlr wrote:
> # 2.2.33.2 (d6601f4ec): 
>
> If I do 
>
> doveadm index -u user "*"
>
> for a local user, it works fine, but if I do 
>
> doveadm -u "*@sqldomain.tld" "*" 
>
> or
>
> doveadm -u "*@localaliasdomain.tld" "*" 
>
> or
>
> doveadm -u "*@localdomain.tld" "*" 
>
> or
>
> doveadm -u "u...@localdomain.tld" "*" 
>
>
> it fails,  
>
> … -u "u...@sqldomain.tld"
>
> Seems to work
>
> 
> -u user/mask
> Run the command only for the given user. It's also possible to use '*' and 
> '?' wildcards (e.g. -u *@example.org).
>
>

doveadm with wildcard users?

[@lbutlr]

# 2.2.33.2 (d6601f4ec): 

If I do 

doveadm index -u user "*"

for a local user, it works fine, but if I do 

doveadm -u "*@sqldomain.tld" "*" 

or

doveadm -u "*@localaliasdomain.tld" "*" 

or

doveadm -u "*@localdomain.tld" "*" 

or

doveadm -u "u...@localdomain.tld" "*" 


it fails,  

… -u "u...@sqldomain.tld"

Seems to work


-u user/mask
Run the command only for the given user. It's also possible to use '*' and '?' 
wildcards (e.g. -u *@example.org).