Rafał Radecki a écrit : > I corrected my mistake but it doesn't help. Any other ideas? >
Please do not top post: put your replies after the text your reply to. did you restart postfix after the fix? if so, download and run saslfinger (see Patrick's signature). - make sure you installed the postgres module for sasl - make sure sasl is looking for smtpd.conf in the directory you use. > 2009/6/21 Patrick Ben Koetter <p...@state-of-mind.de > <mailto:p...@state-of-mind.de>> > > * Rafał Radecki <radecki.ra...@gmail.com > <mailto:radecki.ra...@gmail.com>>: > > Hi all. I'm currently installing an smtp server on CentOS 5.3. > Part of it is > > to use PostgreSQL backend to store virtual > users/domains/aliases/passwords > > and of course to use it for SASL authentication. My > > /usr/lib/sasl2/smtpd.conf file: > > > > pwdcheck_method: auxprop > > Typo! Must be: > > pwcheck_method: auxprop > > > sql_engine: pgsql > > sql_user: postfix > > sql_passwd: some_password > > sql_hostnames: localhost > > sql_database: postfix > > sql_select: SELECT password FROM mailbox WHERE username='%...@%r' > > mech_list: login plain > > You could expand that to "login plain digest-md5 ntlm" if you have the > appropriate mechanisms installed. > > > log_level: 4 > > > > My /etc/postfix/main.cf <http://main.cf>: > > > > smtpd_sasl_auth_enable = yes > > broken_sasl_auth_clients = yes > > smtpd_sasl_local_domain = $mydomain > > smtpd_sasl_security_options = noanonymous > > smtpd_recipient_restrictions = permit_mynetworks, > permit_sasl_authenticated, > > \ > > reject_unauth_destination > > > > virtual_alias_maps = > pgsql:/etc/postfix/pgsql_virtual_alias_maps.cf > <http://pgsql_virtual_alias_maps.cf> > > virtual_alias_domains = $virtual_alias_maps > > virtual_uid_maps = static:1004 > > virtual_gid_maps = static:1004 > > virtual_mailbox_base = /var/spool/mail/virtual > > virtual_mailbox_domains = > pgsql:/etc/postfix/pgsql_virtual_domains_maps.cf > <http://pgsql_virtual_domains_maps.cf> > > virtual_mailbox_maps = > pgsql:/etc/postfix/pgsql_virtual_mailbox_maps.cf > <http://pgsql_virtual_mailbox_maps.cf> > > #virtual_mailbox_limit = 51200000 > > transport_maps = pgsql:/etc/postfix/pgsql_transport.cf > <http://pgsql_transport.cf> > > > > I use that line to insert a record to the PostgreSQL base: > > > > postfix=>INSERT INTO mailbox(username, password, name, maildir) > > postfix->VALUES('r...@example.com > <mailto:r...@example.com>','password','description','r...@example.com/ > <http://r...@example.com/>'<http://r...@example.com/%27 > <http://example.com/%27>> > > ); > > > > But when i try to send mail through my server i get the following > errors in > > /var/log/maillog: > > > > warning: SASL authenticatin problem: unable to open db > etc/sasldb2: no such > > file or directory > > That's because of your typo. It can't find the pwcheck_method and > falls back > to sasldb. > > > p...@rick > > -- > All technical answers asked privately will be automatically answered on > the list and archived for public access unless privacy is explicitely > required and justified. > > saslfinger (debugging SMTP AUTH): > <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/> > >
