Postgres?

2014-09-05 Thread Hugo Osvaldo Barrera
Hi,

For a while now I've been wanting to try the postgres support properly. I've
finally sat down to do it, but haven't had much luck:

# grep postgres smtpd.conf
table postgres postgres://postgres.conf
# smtpd -n
fatal: table_create: backend postgres does not exist

Do I need to do any special building? Am I using the wrong syntax?

I'm using OpenBSD-current (updated like 2 weeks ago?).

Thanks,

-- 
Hugo Osvaldo Barrera
A: Because we read from top to bottom, left to right.
Q: Why should I start my reply below the quoted text?


pgpjp9KKBuMOY.pgp
Description: PGP signature


Re: Postgres?

2014-09-05 Thread Giovanni Bechis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 09/05/14 15:19, Hugo Osvaldo Barrera wrote:
 Hi,
 
 For a while now I've been wanting to try the postgres support properly. I've
 finally sat down to do it, but haven't had much luck:
 
 # grep postgres smtpd.conf
 table postgres postgres://postgres.conf
 # smtpd -n
 fatal: table_create: backend postgres does not exist
 
 Do I need to do any special building? Am I using the wrong syntax?
 
 I'm using OpenBSD-current (updated like 2 weeks ago?).
 
 Thanks,
 
This is still work-in-progress on OpenBSD, (see 
http://marc.info/?l=openbsd-portsm=140845596917927w=2), if interested I have 
a quite-working port.
 Cheers
  Giovanni
-BEGIN PGP SIGNATURE-
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJUCfCxAAoJEI7Sc79XDlKKVzwH/1timymhqZvNWuFxr2EvLKMI
jtYXTyVkczE7QkWJQ01MlVPe7OVt0Fi2pZmPFg4eRBdMRauzU8eLIpwl+c3hlGHZ
S600a7Hq1dv6GLnJ2suC5P+1EefUe0jR4t9QMIvbAJF8qcn069gfufgchNVBwl92
F7D/yft1WnwCwOj0dFvGA2ETGjnt6kM5Gp4L1se7CpUBw7ysOtGYlQ3u6yuuWKE/
z0nskJ1w7LVo/LKUxpa3BqBGgmNeG2WKHfj9sA2Qh5K1RL27FIhPM5MTfWGwXJt6
exDGCbaawm9KfB9PsuYF8X7uWI0U1KpBecKLZRlFKmoOhTLXXqyaTopp6w51Qng=
=BKTt
-END PGP SIGNATURE-

-- 
You received this mail because you are subscribed to misc@opensmtpd.org
To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org



Re: Incomplete error messages from bounced emails?

2014-09-05 Thread Giovanni Bechis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 09/01/14 18:53, Hugo Osvaldo Barrera wrote:
 On 2014-09-01 11:46, Gilles Chehade wrote:
 On Sat, Aug 23, 2014 at 12:28:00PM -0300, Hugo Osvaldo Barrera wrote:
 On 2014-08-22 18:32, Giovanni Bechis wrote:
 On 08/22/14 14:30, Hugo Osvaldo Barrera wrote:
 I recently had some messages bounce from gmail.com. I went up to their 
 forums
 to ask what's up, and on the replies, it was pointed out to my that gsmtpd
 actually sends a rather verbose explanation message when it bounces 
 messages
 (eg: if it's spam, invalid return address, blacklisted address, etc).

 Here's the thread were this was pointed to me. I'm guessing that sending 
 an
 email from a non-static IP range is enough to trigger a bounce 
 harmelessly:
 https://productforums.google.com/forum/#!msg/gmail/SQQAbew5tfE/-ue8aO07sf8J

 Can somebody confirm if these explanations are being dropped by smtpd, if
 they're non-standard, or what's going on?

 gmail warnings are splitted in two or more lines and smtpd logs only one 
 of them.
 See https://github.com/OpenSMTPD/OpenSMTPD/issues/365 for details.
  Cheers
   Giovanni

 -- 
 You received this mail because you are subscribed to misc@opensmtpd.org
 To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org


 Looks like the devs were expecting this to make it to the list and it did 
 not.
 Can we bring that up now? Are there any downsides to implementing this?


 Yes, we were waiting for the discussion to come up.

 There's a downside to implementing this:

 Imagine you create an account for me on your server.
 I then decide to go rogue and setup a remote MX which will reply with
 a HUGE response, say 1000s of lines.

 We need to log atomically so:

 a- log line can't be written until we're done reading response;
 b- session needs to remember every line of the response until done reading;

 
 Can't we not-log all of it, but keep the message and send it to the original
 sender?
 
 The logs could be something like:
 
   550 Error... [25 more lines trimmed]
 
I would like to have at maximum 5/6 lines of response on my log to be able to 
found if a problem is recurring and which could be the original cause.
 Cheers
  Giovanni
-BEGIN PGP SIGNATURE-
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJUCfFIAAoJEI7Sc79XDlKKIOgIAJUFm5US9HxXVPAsB8nGTwGH
t7fDfqqbn+Uuhpnilh/zWznrjqmoA1QeJLdvSo31T/mu2hz3EJ8IauLscYnkvCA3
ZB0PjSGFDec1B6cJ3LoyWscSIn/cn1xn/4cUDDAupsyMelIdmfAL4xNOupm073wC
hkEcFqPpqfnTU5aQMV3H/hG7Xs/1jMqjWtNF3IU+gVUfWfilYnu+QAwJq6YBVGFX
lhJn4Eqj4rAOeQfr0jAY1qvbqBcsCDrpfgrHW4LYiNMjrDcfUQ8tkoWjfM+73FY2
iWVmEFvuyybanHjmTGysue4ssAOmrSmot3tw2pAWIRY9Gk0XlL6M17EvGgKhJPg=
=/Zip
-END PGP SIGNATURE-

-- 
You received this mail because you are subscribed to misc@opensmtpd.org
To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org



Re: [userbase] email in login field

2014-09-05 Thread Giovanni Bechis
On 09/01/14 11:56, Gilles Chehade wrote:
 we may want to support email addresses as login, this can be discussed
 it was not designed this way to start with because we didn't support
 !system auth but this has changed and the use case has come up a few
 times
 
at the moment my setup it's working even if a bit hacky from a sql 
point-of-view, I haven't checked the code how difficult would be to support 
email addresses as login.
 Cheers
  Giovanni

-- 
You received this mail because you are subscribed to misc@opensmtpd.org
To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org



Re: [userbase] email in login field

2014-09-05 Thread John Grasty
I would love just a bit more flexibility in that area (email as login) 
as well as in lmtp deliver.


I recently had to move my mail server to postfix for the time being 
because of those limitations. I nearly cried. :-D


Thanks for the great software!

Thanks,
John Grasty

On 5 Sep 2014, at 13:24, Giovanni Bechis wrote:


On 09/01/14 11:56, Gilles Chehade wrote:
we may want to support email addresses as login, this can be 
discussed

it was not designed this way to start with because we didn't support
!system auth but this has changed and the use case has come up a few
times

at the moment my setup it's working even if a bit hacky from a sql 
point-of-view, I haven't checked the code how difficult would be to 
support email addresses as login.

Cheers
Giovanni

--
You received this mail because you are subscribed to 
misc@opensmtpd.org

To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org


--
You received this mail because you are subscribed to misc@opensmtpd.org
To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org



Re: Postgres?

2014-09-05 Thread Hugo Osvaldo Barrera
On 2014-09-05 19:19, Giovanni Bechis wrote:
 On 09/05/14 15:19, Hugo Osvaldo Barrera wrote:
  Hi,
  
  For a while now I've been wanting to try the postgres support properly. I've
  finally sat down to do it, but haven't had much luck:
  
  # grep postgres smtpd.conf
  table postgres postgres://postgres.conf
  # smtpd -n
  fatal: table_create: backend postgres does not exist
  
  Do I need to do any special building? Am I using the wrong syntax?
  
  I'm using OpenBSD-current (updated like 2 weeks ago?).
  
  Thanks,
  
 This is still work-in-progress on OpenBSD, (see 
 http://marc.info/?l=openbsd-portsm=140845596917927w=2), if interested I 
 have a quite-working port.
  Cheers
   Giovanni
 
 -- 
 You received this mail because you are subscribed to misc@opensmtpd.org
 To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
 

Oh, I though the OpenBSD port was actually ahead of -portable.
Would this port be -latest, or another not-yet-public one?

I'd be willing to try it out, so: yes, please! :D

Cheers,

-- 
Hugo Osvaldo Barrera
A: Because we read from top to bottom, left to right.
Q: Why should I start my reply below the quoted text?


pgp3HN9FgZ9iO.pgp
Description: PGP signature