List Info

Thread: POP_BEFORE_SMTP




POP_BEFORE_SMTP
country flaguser name
Portugal
2007-08-29 13:56:48

Guys,

Does anyone has this kind of setup?

I’d like to hear some opinions, and a good howto to get postfix read the ip address from the “my”sql table.

In the dbmail side, I know all to make it start working, only the integration with postfix is missing me.

 

Jorge

 

Re: POP_BEFORE_SMTP
country flaguser name
United States
2007-08-29 14:53:35

Its in the docs, but here is my setup.

in main.cf

mynetworks = 66.152.196.64/27,127.0.0.0/8,mysql:/etc/postfix/my_net.cf
smtpd_client_restrictions = permit_mynetworks, reject




/etc/postfix/mynet.cf

user=<username>
password=<database password&gt;
dbname=<dbmaildatabasename>
hosts = <database host>
table = dbmail_pbsp
select_field = since
where_field = ipnumber
additional_conditions = and unix_timestamp() - unix_timestamp(since) <= <number of seconds you want to allow>

In my case

user = dbmail
password = <password>
dbname = oriondbmail
table = dbmail_pbsp
select_field = since
where_field = ipnumber
additional_conditions = and unix_timestamp() - unix_timestamp(since) <= 36000

that equates to 10 hours.
Also in the main.cf file replace the values in mynetworks (aside from the mysql part with your own networks)



Jorge Bastos wrote:
jorgedecimal.pt" type="cite">

Guys,

Does anyone has this kind of setup?

I’d like to hear some opinions, and a good howto to get postfix read the ip address from the “my&#8221;sql table.

In the dbmail side, I know all to make it start working, only the integration with postfix is missing me.

 

Jorge

 


_______________________________________________ DBmail mailing list dbmail.org">DBmaildbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: POP_BEFORE_SMTP
country flaguser name
Portugal
2007-08-29 16:53:15
Good,
I could think in the mynetworks option of postfix.
Tks Curtis, from now i can make my own setup!
 
Jorge
----- Original Message -----
Sent: Wednesday, August 29, 2007 8:53 PM
Subject: Re: [Dbmail] POP_BEFORE_SMTP


Its in the docs, but here is my setup.

in main.cf

mynetworks = 66.152.196.64/27,127.0.0.0/8,mysql:/etc/postfix/my_net.cf
smtpd_client_restrictions = permit_mynetworks, reject




/etc/postfix/mynet.cf

user=<username>;
password=<database password&gt;
dbname=&lt;dbmaildatabasename&gt;
hosts = <database host>
table = dbmail_pbsp
select_field = since
where_field = ipnumber
additional_conditions = and unix_timestamp() - unix_timestamp(since) <= <number of seconds you want to allow>

In my case

user = dbmail
password = <password>
dbname = oriondbmail
table = dbmail_pbsp
select_field = since
where_field = ipnumber
additional_conditions = and unix_timestamp() - unix_timestamp(since) <= 36000

that equates to 10 hours.
Also in the main.cf file replace the values in mynetworks (aside from the mysql part with your own networks)



Jorge Bastos wrote:
jorgedecimal.pt type="cite">

Guys,

Does anyone has this kind of setup?

I’d like to hear some opinions, and a good howto to get postfix read the ip address from the “my”sql table.

In the dbmail side, I know all to make it start working, only the integration with postfix is missing me.

Jorge


_______________________________________________ DBmail mailing list dbmail.org">DBmaildbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail


_______________________________________________
DBmail mailing list
DBmaildbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: POP_BEFORE_SMTP
country flaguser name
Portugal
2007-08-30 08:35:13
I know,
I'm not really going to use PBSM,
I do use SMTP AUTH, i just wanna know how things worked,
just in case.

----- Original Message ----- 
From: "Charles Marcus" <CMarcusMedia-Brokers.com>
To: "DBMail mailinglist" <dbmaildbmail.org>
Sent: Thursday, August 30, 2007 2:19 PM
Subject: Re: [Dbmail] POP_BEFORE_SMTP


> Pop b4 smtp is a really old, badly insecure way to auth
users.
> 
> Just bite the bullet, write up comprehensive
instructions for setting up 
> smtp authentication, be prepared to handle the support
calls from people 
> who can't read and be done with it.
> 
> -- 
> 
> Best regards,
> 
> Charles
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: POP_BEFORE_SMTP
country flaguser name
United States
2007-08-30 09:32:35
I'd love to see working instructions for smtp auth. ; I'd rather use that and change my 40 or 50 users over to that. ;

Curtis

Jorge Bastos wrote:
> I know,
> I'm not really going to use PBSM,
> I do use SMTP AUTH, i just wanna know how things worked, just in case.
>
> ----- Original Message -----
>
From: "Charles Marcus&quot; <CMarcusMedia-Brokers.com>
> To: "DBMail mailinglist" <dbmaildbmail.org>
> Sent: Thursday, August 30, 2007 2:19 PM
> Subject: Re: [Dbmail] POP_BEFORE_SMTP
>
>
>> Pop b4 smtp is a really old, badly insecure way to auth users.
>>
>> Just bite the bullet, write up comprehensive instructions for setting up
>> smtp authentication, be prepared to handle the support calls from people
>> who can't read and be done with it.
>>
&gt;> --
>>
>> Best regards,
>>
&gt;> Charles
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com
Re: POP_BEFORE_SMTP
country flaguser name
Portugal
2007-08-30 09:37:19
I use sasl for that, with sql module to read from mysql database.
but right now, the packages that i have installed on my server are broken for *sql usage and i'm using sasldb mode until that is fixed.
IF you want i can give my configurations
----- Original Message -----
Sent: Thursday, August 30, 2007 3:32 PM
Subject: Re: [Dbmail] POP_BEFORE_SMTP

I'd love to see working instructions for smtp auth. ; I'd rather use that and change my 40 or 50 users over to that. ;

Curtis

Jorge Bastos wrote:
>; I know,
> I'm not really going to use PBSM,
> I do use SMTP AUTH, i just wanna know how things worked, just in case.
>
> ----- Original Message -----
>
From: "Charles Marcus" <CMarcusMedia-Brokers.com>
> To: "DBMail mailinglist" <dbmaildbmail.org>
> Sent: Thursday, August 30, 2007 2:19 PM
> Subject: Re: [Dbmail] POP_BEFORE_SMTP
>
>
>> Pop b4 smtp is a really old, badly insecure way to auth users.
>;>
>&gt; Just bite the bullet, write up comprehensive instructions for setting up
>>; smtp authentication, be prepared to handle the support calls from people
>;> who can't read and be done with it.
>&gt;
>> --
>>;
>> Best regards,
&gt;>
>;> Charles
&gt;> _______________________________________________
>&gt; DBmail mailing list
>&gt; DBmaildbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com


_______________________________________________
DBmail mailing list
DBmaildbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: POP_BEFORE_SMTP
country flaguser name
United States
2007-08-30 09:44:49

I don't want something that doesn't work. ; I want something that is set it and forget it.  Its not supposed to be hard, tedious maybe, but not hard. ; If things are broken, I'm not interested.
Jorge Bastos wrote:
> I use sasl for that, with sql module to read from mysql database.
> but right now, the packages that i have installed on my server are broken
> for *sql usage and i'm using sasldb mode until that is fixed.
> IF you want i can give my configurations
> ----- Original Message -----
>
From: Curtis Maurand
> To: DBMail mailinglist
> Sent: Thursday, August 30, 2007 3:32 PM
> Subject: Re: [Dbmail] POP_BEFORE_SMTP
>
>
> I'd love to see working instructions for smtp auth. I'd rather use that
> and change my 40 or 50 users over to that.
>
> Curtis
>
> Jorge Bastos wrote:
> > I know,
> > I'm not really going to use PBSM,
> > I do use SMTP AUTH, i just wanna know how things worked, just in case.
> >
> > ----- Original Message -----
> >
>
From: &quot;Charles Marcus&quot; <CMarcusMedia-Brokers.com>
> > To: "DBMail mailinglist" <dbmaildbmail.org>
> > Sent: Thursday, August 30, 2007 2:19 PM
> > Subject: Re: [Dbmail] POP_BEFORE_SMTP
> >
> >
> >> Pop b4 smtp is a really old, badly insecure way to auth users.
> >>
> >> Just bite the bullet, write up comprehensive instructions for setting
> up
> >> smtp authentication, be prepared to handle the support calls from
> people
> >> who can't read and be done with it.
> >>
> >> --
> >>
&gt; >> Best regards,
> >>
> >> Charles
> >> _______________________________________________
> >> DBmail mailing list
> >> DBmaildbmail.org
> >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>
> > _______________________________________________
> > DBmail mailing list
> > DBmaildbmail.org
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
>
> --
> Curtis Maurand
> Head Honcho
> Xyonet Hosting Services
> Biddeford, ME 04005
> mailto:curtismaurand.com
> mailto:cmaurandxyonet.com
>
>
> ------------------------------------------------------------------------------
&gt;
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com
Re: POP_BEFORE_SMTP
country flaguser name
Austria
2007-08-30 09:51:47
On Donnerstag, 30. August 2007 Curtis Maurand wrote:
> I'd love to see working instructions for smtp auth. 
I'd rather use
> that and change my 40 or 50 users over to that. 

I use a very simple method: rimap with saslauthd
saslauthd -a rimap -r -O 127.0.0.1

That makes sasl open an IMAP connection to localhost to auth
users.

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                     
.network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg
--import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F
1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID:
1C6FE6B0

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: POP_BEFORE_SMTP
country flaguser name
Portugal
2007-08-30 11:25:43
The bug is with the debian unstable packages, not with sasl!!
So you just compile sasl you're self and it's working.
----- Original Message -----
Sent: Thursday, August 30, 2007 3:44 PM
Subject: Re: [Dbmail] POP_BEFORE_SMTP


I don't want something that doesn't work. ; I want something that is set it and forget it.  Its not supposed to be hard, tedious maybe, but not hard. ; If things are broken, I'm not interested.
Jorge Bastos wrote:
>; I use sasl for that, with sql module to read from mysql database.
> but right now, the packages that i have installed on my server are broken
>; for *sql usage and i'm using sasldb mode until that is fixed.
>; IF you want i can give my configurations
> ----- Original Message -----
>
From: Curtis Maurand
&gt; To: DBMail mailinglist
> Sent: Thursday, August 30, 2007 3:32 PM
> Subject: Re: [Dbmail] POP_BEFORE_SMTP
>
>
> I'd love to see working instructions for smtp auth. I'd rather use that
> and change my 40 or 50 users over to that.
>
> Curtis
>;
> Jorge Bastos wrote:
>; > I know,
> > I'm not really going to use PBSM,
> > I do use SMTP AUTH, i just wanna know how things worked, just in case.
> >
> > ----- Original Message -----
> >
>
From: "Charles Marcus" <CMarcusMedia-Brokers.com>
> > To: "DBMail mailinglist" <dbmaildbmail.org>
> > Sent: Thursday, August 30, 2007 2:19 PM
> > Subject: Re: [Dbmail] POP_BEFORE_SMTP
> >
> >
> >> Pop b4 smtp is a really old, badly insecure way to auth users.
>; >>
&gt; >> Just bite the bullet, write up comprehensive instructions for setting
&gt; up
> >> smtp authentication, be prepared to handle the support calls from
> people
>; >> who can't read and be done with it.
> >>
&gt; >> --
> >>
&gt; >> Best regards,
&gt; >>
&gt; >> Charles
&gt; >> _______________________________________________
> >> DBmail mailing list
> >> DBmaildbmail.org
> >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>
&gt; > _______________________________________________
> > DBmail mailing list
> > DBmaildbmail.org
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
>
> --
> Curtis Maurand
&gt; Head Honcho
>; Xyonet Hosting Services
&gt; Biddeford, ME 04005
> mailto:curtismaurand.com
> mailto:cmaurandxyonet.com
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com


_______________________________________________
DBmail mailing list
DBmaildbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: POP_BEFORE_SMTP
country flaguser name
United States
2007-08-30 16:13:23
Ok, lets see the configs.

Curtis

Michael Monnerie wrote:
> On Donnerstag, 30. August 2007 Curtis Maurand wrote:
>;> I'd love to see working instructions for smtp auth. I'd rather use
>> that and change my 40 or 50 users over to that.
>
> I use a very simple method: rimap with saslauthd
> saslauthd -a rimap -r -O 127.0.0.1
>
> That makes sasl open an IMAP connection to localhost to auth users.
>
> mfg zmi
> --
> // Michael Monnerie, Ing.BSc ----- http://it-management.at
> // Tel: 0676/846 914 666 .network.your.ideas.
> // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import&quot;
> // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0
> // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
&gt;
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>


--
Curtis Maurand
Head Honcho
Xyonet Hosting Services
Biddeford, ME 04005
mailto:curtismaurand.com
mailto:cmaurandxyonet.com
[1-10] [11-20] [21-27]

about | contact  Other archives ( Real Estate discussion Medical topics )