Re: userbase question

2018-09-01 Thread Matt Schwartz
Hi Gilles, Thank you for your advice about using wrappers. I decided to implement an mda wrapper as per your suggestion. It is interesting that I still needed to specify either an mbox or maildir in the syntax when I specify a wrapper. In this case, it doesn't seem to matter if I use mbox or maild

Re: userbase question

2018-09-01 Thread Gilles Chehade
On Mon, Aug 27, 2018 at 09:54:05AM -0400, Matt Schwartz wrote: > I am hoping not to have to use sqlite tables. I like the simplicity of > file-based configuration. just for the record: besides table-specific features, all smtpd features are usable from file configurations since I write the featur

Re: userbase question

2018-09-01 Thread Gilles Chehade
On Mon, Aug 27, 2018 at 09:11:02AM -0400, Matt Schwartz wrote: > Hello misc@, > > Below is my configuration file. I am trying to use the userbase > parameter and when I try to send an email to myself, I get the 550 > Invalid Recipient error. I am trying to get the usrbase parameter > working so th

Re: userbase question

2018-08-27 Thread Edgar Pettijohn
Sent from my Verizon SmartphoneOn Aug 27, 2018 8:54 AM, Matt Schwartz wrote:>> I am hoping not to have to use sqlite tables. I like the simplicity of > file-based configuration. > On Mon, Aug 27, 2018 at 9:47 AM Reio Remma wrote: > > > > Iirc I got the .forward file working with sqlite tables, wh

Re: userbase question

2018-08-27 Thread Matt Schwartz
I am hoping not to have to use sqlite tables. I like the simplicity of file-based configuration. On Mon, Aug 27, 2018 at 9:47 AM Reio Remma wrote: > > Iirc I got the .forward file working with sqlite tables, where the user query > also returned the virtual user’s maildir as an extra parameter. >

Re: userbase question

2018-08-27 Thread Reio Remma
Iirc I got the .forward file working with sqlite tables, where the user query also returned the virtual user’s maildir as an extra parameter. Good luck, Reio > On 27 Aug 2018, at 16:11, Matt Schwartz wrote: > > Hello misc@, > > Below is my configuration file. I am trying to use the userbase >

RE: Userbase question.

2018-02-05 Thread Olivier
sers (email, alias) VALUES ('one.user', 'first.domain','vmail') ('postmaster@my.domain', 'my.domain', 'my.aliass'); Olivier. De : Reio Remma [mailto:r...@mrstuudio.ee] Envoyé : Sunday, February 4, 2018 9:22 PM À : misc@op

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,