smtp authentication

Discussion:

smtp authentication

Curtis Maurand

2005-07-01 11:56:37 UTC

Hi,
Is it possible to configure postfix to use dbmail's database for smtp
authentication?

I'm having a problem with evolution trying to do pop before smtp since
I'm using IMAP. While I have imap configured and imap before smtp,
evolution doesn't understand it and i get an error that states I'm
trying to use pop before smtp on a non-pop source. I'd be just as happy
to configure postfix for authentication.

Curtis

Niblett, David A

2005-07-01 16:01:05 UTC

Permalink

Curtis,

You would need to compile your postfix with DB support
and sasl support. Then you can simply use the dbmail_users
table as the authentication for sasl.

I currently run mine that way, I can provide config files
if you like. Check out:

http://www.postfix.org/SASL_README.html

If you lookup sql for sasl you should find all the options
you need. You get to craft the select statement which allows
you to use any table you like.

--
David A. Niblett | email: ***@gru.net
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/

-----Original Message-----
From: Curtis Maurand [mailto:***@maurand.com]
Sent: Friday, July 01, 2005 7:57 AM
To: DBMail mailinglist
Subject: [Dbmail] smtp authentication

Hi,
Is it possible to configure postfix to use dbmail's database for smtp
authentication?

I'm having a problem with evolution trying to do pop before smtp since I'm
using IMAP. While I have imap configured and imap before smtp, evolution
doesn't understand it and i get an error that states I'm trying to use pop
before smtp on a non-pop source. I'd be just as happy to configure postfix
for authentication.

Curtis

Curtis Maurand

2005-07-01 13:16:23 UTC

Permalink

Is there a sasl configuration file I should look at? How should I store
passwords? currently I have a mixture of plaintext and md5's that have
been imported from a linux system. should I store them all as md5's I
like plaintext or something I can decode them later for a user if need be.

Sorry for all the questions. The postfix config look pretty straight
forward, but looking at your configs might be more helpful.

Curtis

Post by Niblett, David A
Curtis,
You would need to compile your postfix with DB support
and sasl support. Then you can simply use the dbmail_users
table as the authentication for sasl.
I currently run mine that way, I can provide config files
http://www.postfix.org/SASL_README.html
If you lookup sql for sasl you should find all the options
you need. You get to craft the select statement which allows
you to use any table you like.
--
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-----Original Message-----
Sent: Friday, July 01, 2005 7:57 AM
To: DBMail mailinglist
Subject: [Dbmail] smtp authentication
Hi,
Is it possible to configure postfix to use dbmail's database for smtp
authentication?
I'm having a problem with evolution trying to do pop before smtp since I'm
using IMAP. While I have imap configured and imap before smtp, evolution
doesn't understand it and i get an error that states I'm trying to use pop
before smtp on a non-pop source. I'd be just as happy to configure postfix
for authentication.
Curtis
_______________________________________________
Dbmail mailing list
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

M. J. [Mike] O'Brien

2005-07-01 17:41:47 UTC

Permalink

You need to store passwords in plaintext to use SASL.

best...
Mike

----- Original Message -----
From: "Curtis Maurand" <***@maurand.com>
To: "DBMail mailinglist" <***@dbmail.org>
Sent: Friday, July 01, 2005 9:16 AM
Subject: Re: [Dbmail] smtp authentication

Post by Curtis Maurand
Is there a sasl configuration file I should look at? How should I store
passwords? currently I have a mixture of plaintext and md5's that have
been imported from a linux system. should I store them all as md5's I
like plaintext or something I can decode them later for a user if need be.
Sorry for all the questions. The postfix config look pretty straight
forward, but looking at your configs might be more helpful.
Curtis

_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Niblett, David A

2005-07-01 17:43:17 UTC

Permalink

This post might be inappropriate. Click to display it.

Mohammad Salaque

2005-07-02 05:55:03 UTC

Permalink

Dear all

Today while trying to install dbmail-2.0.4 in my Solaris 9 (SunOS test
5.9 Generic_118558-06 sun4u sparc SUNW,UltraAX-i2 Solaris) i get the
following error

sort.c:68: error: conflicting types for 'sort_and_deliver'
../sort.h:49: error: previous declaration of 'sort_and_deliver' was here
sort.c:68: error: conflicting types for 'sort_and_deliver'
../sort.h:49: error: previous declaration of 'sort_and_deliver' was here
sort.c: In function `sort_and_deliver':
sort.c:83: error: `SORT_FAILURE' undeclared (first use in this function)
sort.c:83: error: (Each undeclared identifier is reported only once
sort.c:83: error: for each function it appears in.)
sort.c:92: error: `SORT_OVER_QUOTA' undeclared (first use in this function)
sort.c:98: error: `SORT_WEIRD_ERROR' undeclared (first use in this function)
sort.c:103: error: `SORT_SUCCESS' undeclared (first use in this function)
gmake[2]: *** [sort.lo] Error 1
gmake[2]: Leaving directory `/export/home/admin/dbmail-2.0.4/sort'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/export/home/admin/dbmail-2.0.4'
gmake: *** [all-recursive-am] Error 2

i did apply 01_quota.dpatch . and using gmake . as when using make i
am receiving the fallowing error
mksh: Fatal error in reader: = missing from replacement macro reference

Regards.
Salaque

Mohammad Salaque

2005-07-03 05:07:54 UTC

Permalink

i have download dmail-2.1.1 and trying to in install that in my
Solaris. getting follwiong error.

gcc -g -O2 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/local/include/gmime-2.0 -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include -W -Wall -Wpointer-arith
-Wstrict-prototypes -o .libs/dbmail-smtp main.o -L/usr/local/lib
./.libs/libdbmail.a
/export/home/admin/dbmail-2.1.1/mysql/.libs/libsqldbmail.so
-L/usr/local/mysql/lib/mysql
/usr/local/mysql/lib/mysql/libmysqlclient.so -lz -lposix4 -lcrypt
-lgen -lsocket -lm /usr/local/lib/libgmime-2.0.so -lnsl -lgobject-2.0
-lglib-2.0 -R/usr/local/lib/dbmail -R/usr/local/mysql/lib/mysql
-R/usr/local/lib
Undefined first referenced
symbol in file
strcasestr ./.libs/libdbmail.a(pipe.o)
g_mime_shutdown main.o
inet_aton ./.libs/libdbmail.a(dm_cidr.o)
g_str_has_suffix ./.libs/libdbmail.a(misc.o)
ld: fatal: Symbol referencing errors. No output written to .libs/dbmail-smtp
collect2: ld returned 1 exit status
make[2]: *** [dbmail-smtp] Error 1
make[2]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make: *** [all-recursive-am] Error 2
bash-2.05#

Looking for help

M. Salaque

Post by Mohammad Salaque
Dear all
Today while trying to install dbmail-2.0.4 in my Solaris 9 (SunOS test
5.9 Generic_118558-06 sun4u sparc SUNW,UltraAX-i2 Solaris) i get the
following error
sort.c:68: error: conflicting types for 'sort_and_deliver'
../sort.h:49: error: previous declaration of 'sort_and_deliver' was here
sort.c:68: error: conflicting types for 'sort_and_deliver'
../sort.h:49: error: previous declaration of 'sort_and_deliver' was here
sort.c:83: error: `SORT_FAILURE' undeclared (first use in this function)
sort.c:83: error: (Each undeclared identifier is reported only once
sort.c:83: error: for each function it appears in.)
sort.c:92: error: `SORT_OVER_QUOTA' undeclared (first use in this function)
sort.c:98: error: `SORT_WEIRD_ERROR' undeclared (first use in this function)
sort.c:103: error: `SORT_SUCCESS' undeclared (first use in this function)
gmake[2]: *** [sort.lo] Error 1
gmake[2]: Leaving directory `/export/home/admin/dbmail-2.0.4/sort'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/export/home/admin/dbmail-2.0.4'
gmake: *** [all-recursive-am] Error 2
i did apply 01_quota.dpatch . and using gmake . as when using make i
am receiving the fallowing error
mksh: Fatal error in reader: = missing from replacement macro reference
Regards.
Salaque

--
Got my mail ?

Mohammad Salaque

2005-07-09 22:25:20 UTC

Permalink

hello ppl. if anyone could help me i could migrate my full system to
DBmail. and I like to .

Post by Mohammad Salaque
i have download dmail-2.1.1 and trying to in install that in my
Solaris. getting follwiong error.
gcc -g -O2 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/local/include/gmime-2.0 -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include -W -Wall -Wpointer-arith
-Wstrict-prototypes -o .libs/dbmail-smtp main.o -L/usr/local/lib
./.libs/libdbmail.a
/export/home/admin/dbmail-2.1.1/mysql/.libs/libsqldbmail.so
-L/usr/local/mysql/lib/mysql
/usr/local/mysql/lib/mysql/libmysqlclient.so -lz -lposix4 -lcrypt
-lgen -lsocket -lm /usr/local/lib/libgmime-2.0.so -lnsl -lgobject-2.0
-lglib-2.0 -R/usr/local/lib/dbmail -R/usr/local/mysql/lib/mysql
-R/usr/local/lib
Undefined first referenced
symbol in file
strcasestr ./.libs/libdbmail.a(pipe.o)
g_mime_shutdown main.o
inet_aton ./.libs/libdbmail.a(dm_cidr.o)
g_str_has_suffix ./.libs/libdbmail.a(misc.o)
ld: fatal: Symbol referencing errors. No output written to .libs/dbmail-smtp
collect2: ld returned 1 exit status
make[2]: *** [dbmail-smtp] Error 1
make[2]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make: *** [all-recursive-am] Error 2
bash-2.05#
Looking for help
M. Salaque

--
Got my mail ?

Mohammad Salaque

2005-07-10 03:24:07 UTC

Permalink

i fixd that problem now getting

gcc -g -O2 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/local/include/gmime-2.0 -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include -W -Wall -Wpointer-arith
-Wstrict-prototypes -o .libs/dbmail-smtp main.o -L/usr/local/lib
./.libs/libdbmail.a
/export/home/admin/dbmail-2.1.1/mysql/.libs/libsqldbmail.so
-L/usr/local/mysql/lib/mysql
/usr/local/mysql/lib/mysql/libmysqlclient.so -lz -lposix4 -lcrypt
-lgen -lsocket -lm /usr/local/lib/libgmime-2.0.so -lnsl -lgobject-2.0
-lglib-2.0 -R/usr/local/lib/dbmail -R/usr/local/mysql/lib/mysql
-R/usr/local/lib
Undefined first referenced
symbol in file
strcasestr ./.libs/libdbmail.a(pipe.o)
g_mime_shutdown main.o
inet_aton ./.libs/libdbmail.a(dm_cidr.o)
g_str_has_suffix ./.libs/libdbmail.a(misc.o)
ld: fatal: Symbol referencing errors. No output written to .libs/dbmail-smtp
collect2: ld returned 1 exit status
make[2]: *** [dbmail-smtp] Error 1
make[2]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make: *** [all-recursive-am] Error 2

Post by Mohammad Salaque
hello ppl. if anyone could help me i could migrate my full system to
DBmail. and I like to .

--
Got my mail ?

M. J. [Mike] O'Brien

2005-07-10 07:56:47 UTC

Permalink

Firstly, that looks like the wrong linker. You will need to create a unique
path for the DbMail build terminal session that gives oprecedence to your
GNU tools, automake, autoconf, libtool, GCC, ld etc.

2) Wrong version DbMail. You will *not* get 2.1.1-Unstable working on
Solaris.

3) *IF* you have a full GNU set of tools, you might be able to build DbMail
2.0.4 on Solaris 9, but it will be a fight. The big issue will be the linker
and the libs. I can't remember (long ago now) how I pulled it all together
but for sure, after running config (make sure you have bash installed) I had
to edit the LDFLAGS in config.status and run ./config.status or bash
config.status to fix all the Makefiles.

Probably the best thing to do is to run configure and then read
config.status and you will see where the flags are wrong and fix them to
match your system.

You will need a bit of patience as DbMail is totally GNU and Solaris is
totally *NOT* GNU in a manner of speaking :o)

Good luck.

best...
Mike

----- Original Message -----
From: "Mohammad Salaque" <***@gmail.com>
To: "DBMail mailinglist" <***@dbmail.org>
Sent: Saturday, July 09, 2005 11:24 PM
Subject: Re: [Dbmail] Compile error in Solaris 9

i fixd that problem now getting

gcc -g -O2 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/local/include/gmime-2.0 -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include -W -Wall -Wpointer-arith
-Wstrict-prototypes -o .libs/dbmail-smtp main.o -L/usr/local/lib
../.libs/libdbmail.a
/export/home/admin/dbmail-2.1.1/mysql/.libs/libsqldbmail.so
-L/usr/local/mysql/lib/mysql
/usr/local/mysql/lib/mysql/libmysqlclient.so -lz -lposix4 -lcrypt
-lgen -lsocket -lm /usr/local/lib/libgmime-2.0.so -lnsl -lgobject-2.0
-lglib-2.0 -R/usr/local/lib/dbmail -R/usr/local/mysql/lib/mysql
-R/usr/local/lib
Undefined first referenced
symbol in file
strcasestr ./.libs/libdbmail.a(pipe.o)
g_mime_shutdown main.o
inet_aton ./.libs/libdbmail.a(dm_cidr.o)
g_str_has_suffix ./.libs/libdbmail.a(misc.o)
ld: fatal: Symbol referencing errors. No output written to .libs/dbmail-smtp
collect2: ld returned 1 exit status
make[2]: *** [dbmail-smtp] Error 1
make[2]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make: *** [all-recursive-am] Error 2

Post by Mohammad Salaque
hello ppl. if anyone could help me i could migrate my full system to
DBmail. and I like to .

Post by Mohammad Salaque
i have download dmail-2.1.1 and trying to in install that in my
Solaris. getting follwiong error.
gcc -g -O2 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/local/include/gmime-2.0 -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include -W -Wall -Wpointer-arith
-Wstrict-prototypes -o .libs/dbmail-smtp main.o -L/usr/local/lib
./.libs/libdbmail.a
/export/home/admin/dbmail-2.1.1/mysql/.libs/libsqldbmail.so
-L/usr/local/mysql/lib/mysql
/usr/local/mysql/lib/mysql/libmysqlclient.so -lz -lposix4 -lcrypt
-lgen -lsocket -lm /usr/local/lib/libgmime-2.0.so -lnsl -lgobject-2.0
-lglib-2.0 -R/usr/local/lib/dbmail -R/usr/local/mysql/lib/mysql
-R/usr/local/lib
Undefined first referenced
symbol in file
strcasestr ./.libs/libdbmail.a(pipe.o)
g_mime_shutdown main.o
inet_aton ./.libs/libdbmail.a(dm_cidr.o)
g_str_has_suffix ./.libs/libdbmail.a(misc.o)
ld: fatal: Symbol referencing errors. No output written to
.libs/dbmail-smtp
collect2: ld returned 1 exit status
make[2]: *** [dbmail-smtp] Error 1
make[2]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/export/home/admin/dbmail-2.1.1'
make: *** [all-recursive-am] Error 2
bash-2.05#
Looking for help
M. Salaque

--
Got my mail ?

Humberto Valiente G.

2005-07-14 07:23:36 UTC

Permalink

Post by Curtis Maurand
Hi,
Is it possible to configure postfix to use dbmail's database for smtp
authentication?
I'm having a problem with evolution trying to do pop before smtp since
I'm using IMAP. While I have imap configured and imap before smtp,
evolution doesn't understand it and i get an error that states I'm
trying to use pop before smtp on a non-pop source. I'd be just as happy
to configure postfix for authentication.
Curtis
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Yes it is possible ..simple way is

cd /etc/postfix
touch relay.cf
edit relay.cf and add the following
hosts = localhost
user = <dbmail-database-user>
password = <dbmail-database-passwd>
dbname = <database>
table = dbmail_pbsp
select_field = ipnumber
where_field = ipnumber

Then add to mynetworks parameter in postfix
mynetworks = mysql:/etc/postfix/relay.cf 192.168.1.0/24 ....

Edit dbmail.conf and look for the line IMAP/POP_BEFORE_SMTP and change
it to yes

Restart postfix dbmail ....etc.

Configure your mail client to use auth for smtp

It works!!

Leonel Nunez

2005-07-14 11:33:02 UTC

Permalink

Post by Humberto Valiente G.

Yes it is possible ..simple way is
cd /etc/postfix
touch relay.cf
edit relay.cf and add the following
hosts = localhost
user = <dbmail-database-user>
password = <dbmail-database-passwd>
dbname = <database>
table = dbmail_pbsp
select_field = ipnumber
where_field = ipnumber
Then add to mynetworks parameter in postfix
mynetworks = mysql:/etc/postfix/relay.cf 192.168.1.0/24 ....
Edit dbmail.conf and look for the line IMAP/POP_BEFORE_SMTP and change
it to yes
Restart postfix dbmail ....etc.
Configure your mail client to use auth for smtp
It works!!
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

how about encrypted passwords ? does it works with md5 passwords on
the dbmail database
how about username and realm ? does postfix divide the username
***@domain.tld as account and realm using domain.tld ?

Thank you

leonel

Leonel Nunez

2005-07-14 12:39:49 UTC

Permalink

Post by Leonel Nunez

Post by Humberto Valiente G.

Yes it is possible ..simple way is
cd /etc/postfix
touch relay.cf
edit relay.cf and add the following
hosts = localhost
user = <dbmail-database-user>
password = <dbmail-database-passwd>
dbname = <database>
table = dbmail_pbsp
select_field = ipnumber
where_field = ipnumber
Then add to mynetworks parameter in postfix
mynetworks = mysql:/etc/postfix/relay.cf 192.168.1.0/24 ....
Edit dbmail.conf and look for the line IMAP/POP_BEFORE_SMTP and
change it to yes
Restart postfix dbmail ....etc.
Configure your mail client to use auth for smtp
It works!!
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

how about encrypted passwords ? does it works with md5 passwords
on the dbmail database
how about username and realm ? does postfix divide the
domain.tld ?
Thank you
leonel
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Never mind

this is for POP BEFORE SMTP and it's not an option for me

thank you

Leonel

David Rebarchik

2005-07-14 15:12:59 UTC

Permalink

I've got a working AUTH SMTP using saslauth with the same table as dbmail. It
works great, but was a little trouble to set up. You need to have a working
saslauth with mysql. I had to compile my own as all the packages wouldn't
work. It has been some time since I set it up, so I don't remember the
details.

I hope you get it working.

Dave

Leonel Nunez

2005-07-14 15:21:42 UTC

Permalink

Post by David Rebarchik

I have it already with saslauthd
the problem is that I have users with ***@domain1.tld and
***@domain2.tld
saslauthd breaks in user1 as user and domain1.tld as realm

so I can't have the same user for the same username with diferent domains
not a problem right now but it will be

I need to authenticate with the username as ***@domain1.tld

thanks

Leonel

David Rebarchik

2005-07-14 18:51:58 UTC

Permalink

Post by Leonel Nunez

Post by David Rebarchik

I've got a working AUTH SMTP using saslauth with the same table as dbmail.

Post by David Rebarchik
works great, but was a little trouble to set up. You need to have a working
saslauth with mysql. I had to compile my own as all the packages wouldn't
work. It has been some time since I set it up, so I don't remember the
details.
I hope you get it working.
Dave
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

I have it already with saslauthd
saslauthd breaks in user1 as user and domain1.tld as realm
so I can't have the same user for the same username with diferent domains
not a problem right now but it will be
thanks
Leonel
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

In my main.cf for postfix I have:

smtpd_sasl_local_domain = dbmail

to set the default realm to dbmail
and my /usr/local/lib/sasl2/smtpd.conf file is:

sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: mysql
sasl_auto_transition: no
sasl_mech_list: PLAIN LOGIN, CRAM-MD5
sql_user: dbmail
sql_passwd:rmail
sql_hostnames: localhost
sql_database: dbmail
sql_verbose: true
sql_statement: select passwd from users where userid =
IF('%r'='dbmail','%u','%u@%r')

the sql statement will add the realm to the username when checking the database
if it isn't dbmail (the default). This allows me to have the usernames be the
complete e-mail address in both dbmail and with auth smtp.

Hope this helps

Dave

Humberto Valiente G.

2005-07-14 16:47:32 UTC

Permalink

Post by Leonel Nunez

Post by Humberto Valiente G.

Yes it is possible ..simple way is
cd /etc/postfix
touch relay.cf
edit relay.cf and add the following
hosts = localhost
user = <dbmail-database-user>
password = <dbmail-database-passwd>
dbname = <database>
table = dbmail_pbsp
select_field = ipnumber
where_field = ipnumber
Then add to mynetworks parameter in postfix
mynetworks = mysql:/etc/postfix/relay.cf 192.168.1.0/24 ....
Edit dbmail.conf and look for the line IMAP/POP_BEFORE_SMTP and
change it to yes
Restart postfix dbmail ....etc.
Configure your mail client to use auth for smtp
It works!!
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Never mind
this is for POP BEFORE SMTP and it's not an option for me
thank you
Leonel
_______________________________________________
Dbmail mailing list
https://mailman.fastxs.nl/mailman/listinfo/dbmail

yes it works with md5 passwords on the dbmail database
For authentication use : for example ***@domain.tld
username: account
password: account-password

Remember that in your mail client you need to set up "my server require
auth" and it has to use the same username and password that you use to
login into your mail server