Re: Problems with userdb and mail deliveribility

2020-05-17 Thread @lbutlr
On 17 May 2020, at 11:08, Chris Bennett wrote: > > I realize that I dumpimg a lot of info out there. But not what we need. doveconf -n postfix -n (or equivalent) What MTA you are using (postfix, etc) Errors in mail.log showing the failures. > I can shoot for system users, but I really want

Re: Problems with userdb and mail deliveribility

2020-05-17 Thread Chris Bennett
I realize that I dumpimg a lot of info out there. Good news is that I´m online but not in production. I can shoot for system users, but I really want to get the virtual users working. This is a bit of a project. Thanks for anyone who wants to help. I was in a hotel room when I started and now on

dovecot sync not pushing automatically ?

2020-05-17 Thread Laura Smith
Hi, I'm aware its an async process, but despite sending test messages and then waiting a few minutes, the stats are still unchanged : $ sudo doveadm replicator status  

Re: iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
On Sunday, 17 May 2020 11:11, James wrote: > On 17/05/2020 10:43, Laura Smith wrote: > > > Because I wanted to avoid storing uid/gid/home in the database ? > > I use: > > user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, > '*:storage=' || quota || 'M' AS quota_rule FROM mailbox W

Re: iterate_query with static userdb ?

2020-05-17 Thread James
On 17/05/2020 10:43, Laura Smith wrote: Because I wanted to avoid storing uid/gid/home in the database ? I use: user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, '*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username = '%n' AND domain = '%d';" ... uid and gi

Re: iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
On Sunday, 17 May 2020 10:38, Aki Tuomi wrote: > > On 17/05/2020 12:34 Laura Smith wrote: > > > > Hi, > > > > Going by the "static userdb" example  on this page > > (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a > > similar setup in conjunction with pgsql for passdb. > >

Re: iterate_query with static userdb ?

2020-05-17 Thread Aki Tuomi
On 17/05/2020 12:34 Laura Smith wrote: Hi, Going by the "static userdb" example  on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar s

iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
Hi, Going by the "static userdb" example  on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb. However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, becau

Re: "/etc/dovecot/dovecot.conf: passdb is missing driver"

2020-05-17 Thread Aki Tuomi
> On 17/05/2020 11:26 Laura Smith wrote: > > > Hi, > > I'm trying to get dovecot working with postgres, I'm on Debian 10 and have > installed dovecot-pgsql from the Dovecot repo > (https://repo.dovecot.org/ce-2.3-latest/debian/). > > I have the following in my local.conf : > passdb sq

"/etc/dovecot/dovecot.conf: passdb is missing driver"

2020-05-17 Thread Laura Smith
Hi, I'm trying to get dovecot working with postgres, I'm on Debian 10 and have installed dovecot-pgsql from the Dovecot repo (https://repo.dovecot.org/ce-2.3-latest/debian/). I have the following in my local.conf : passdb sql {   args = /etc/dovecot/local_sql_users.conf } And the following