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 >

userbase question

2018-08-27 Thread Matt Schwartz
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 that I can add a .forward file for virtual users as per the table(5) man page

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

Re: Userbase question.

2018-02-04 Thread Reio Remma
ere email=$1; # # Credentials lookup query # query_credentials select email, password from credentials where email=$1 and active = 'Y';  # <-- here your SQL request Sorry for my bad english. I hope that it will be helping. Olivier. *De :*Reio Remma [mailto:r...@mrstuudio.ee] *

Re: Userbase question.

2018-02-04 Thread Reio Remma
p query # query_credentials select email, password from credentials where email=$1 and active = 'Y';  # <-- here your SQL request Sorry for my bad english. I hope that it will be helping. Olivier. *De :*Reio Remma [mailto:r...@mrstuudio.ee] *Envoyé :* Sunday, February 4, 2018 3

Re: Userbase question.

2018-02-04 Thread Reio Remma
; from vusers where email=$1; # # Credentials lookup query # query_credentials select email, password from credentials where email=$1 and active = 'Y';  # <-- here your SQL request Sorry for my bad english. I hope that it will be helping. Olivier. *De :*Reio Remma [mailto:r.

Re: Userbase question.

2018-02-04 Thread Reio Remma
ials select email, password from credentials where email=$1 and active = 'Y';  # <-- here your SQL request Sorry for my bad english. I hope that it will be helping. Olivier. *De :*Reio Remma [mailto:r...@mrstuudio.ee] *Envoyé :* Sunday, February 4, 2018 3:02 PM *À :* misc@opensmtpd.org *Obj

RE: Userbase question.

2018-02-04 Thread Olivier
dentials lookup query # query_credentials select email, password from credentials where email=$1 and active = 'Y'; # <-- here your SQL request Sorry for my bad english. I hope that it will be helping. Olivier. De : Reio Remma [mailto:r...@mrstuudio.ee] Envoyé : Sun

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_