Re: Userbase question.

2018-02-04 Thread Reio Remma
On 05.02.18 2:18, Reio Remma wrote: On 04.02.2018 22:21, Reio Remma wrote: On 04.02.2018 22:01, Reio Remma wrote: On 04.02.2018 21:56, Reio Remma wrote: *De :*Reio Remma [mailto:r...@mrstuudio.ee] *Envoyé :* Sunday, February 4, 2018 3:02 PM *À :* misc@opensmtpd.org *Objet :* Userbase question

Re: Userbase question.

2018-02-04 Thread Reio Remma
On 04.02.2018 22:21, Reio Remma wrote: The only reference I've found that tackles a similar problem: https://hugo.barrera.io/journal/2015/02/15/opensmtpd-dovecot-shared-sql-db/ Rather convoluted for a simple thing though. :) Reio On 04.02.2018 22:01, Reio Remma wrote: On 04.02.2018 21:56, R

Re: Userbase question.

2018-02-04 Thread Reio Remma
The only reference I've found that tackles a similar problem: https://hugo.barrera.io/journal/2015/02/15/opensmtpd-dovecot-shared-sql-db/ Rather convoluted for a simple thing though. :) Reio On 04.02.2018 22:01, Reio Remma wrote: On 04.02.2018 21:56, Reio Remma wrote: Hello! query_userinfo

Re: Userbase question.

2018-02-04 Thread Reio Remma
On 04.02.2018 21:56, Reio Remma wrote: Hello! query_userinfo select 1001,1001,'/var/vmail/' from vusers where email=$1; I now realize you version doesn't return the actual user's virtual mail directory. But maybe it doesn't need to. I suspect Dovecot can handle .forward files as well, though

Re: Userbase question.

2018-02-04 Thread Reio Remma
Hello! query_userinfo select 1001,1001,'/var/vmail/' from vusers where email=$1; Does it match against an actual (whole) e-mail addess or username for you? What does your "accept for domain ..." line in smtpd.conf look like? All the best, Reio On 04.02.2018 21:11, Olivier wrote: Hello I am

RE: Userbase question.

2018-02-04 Thread Olivier
Hello I am using my own server with a postgresql database to store domains, users & password: vmail=> \d List of relations Schema | Name | Type | Owner +--+--+--- public | credentials | t

Re: Userbase question.

2018-02-04 Thread Reio Remma
Hey! uid/gid are for vmail (/home/dovecot directory). I've looked at the smtpd lookup trace and query_userinfo queries the database purely by user name (without domain part). That is essentially where all virtuality fails. :/ If the database was queried by the full e-mail address (not unlike

Re: Userbase question.

2018-02-04 Thread Edgar Pettijohn
what does your smtpd.conf look like? On 02/04/18 08:01, Reio Remma wrote: Hello! I'm trying to figure out how I can have virtual domains/users working completely decoupled from system users. Every virtual/alias path seem to want to end up at a system account so I'm trying to use userbase,

Userbase question.

2018-02-04 Thread Reio Remma
Hello! I'm trying to figure out how I can have virtual domains/users working completely decoupled from system users. Every virtual/alias path seem to want to end up at a system account so I'm trying to use userbase, but userbase seems to take username without the domain part as key. query_