| View previous topic :: View next topic |
| Author |
Message |
heutger
n00b
Joined: 13 Apr 2004
Posts: 9
|
 Posted: Wed Dec 22, 2004 4:28 pm Post subject: How to get out the MySQL auth from Postfix with SASL |
 |
|
Hi!
I just hopefully read nearly every thread on how to configure Postfix with SASL and MySQL Auth as I have the "inverted" problem, I have Postfix and SASL but didn't want the MySQL Auth as the authentication is already done (with Confixx) otherwise.
But although I checked the Postfix-confs as well as the smtpd.conf of sasl2 for having nothing with mysql or sql in it, it always produces failures like this in my message-log, and I'm getting stupid how to get sql out, as I won't need and also won't need this error. 
Dec 19 18:35:38 psw11 postfix/smtpd[10420]: sql_select option missing
Dec 19 18:35:38 psw11 postfix/smtpd[10420]: auxpropfunc error no mechanism available
Dec 19 18:35:38 psw11 postfix/smtpd[10420]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Please perhaps anyone can list me what I can check further, where MySQL could be included in the postfix/smtpd-conf, I just checked the postfix confs both as well as the smtpd.conf of the sasl2 folder.
As I need mysql for the web part, mysql is sure in the useflags. |
|
| Back to top |
|
 |
kashani
Advocate
Joined: 02 Sep 2002
Posts: 2032
Location: San Francisco
|
| Posted: Wed Dec 22, 2004 7:10 pm Post subject: |
|
|
check /etc/pam.d/smtpd|pop3|etc
That's normally where you specify db lookups if you followed the virtual how-to. You may want to add an /etc/portage/package.use for both cyrus-sasl and Postfix so that they recompile without Mysql support.
If none of this helps post a postconf -n
kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape. |
|
| Back to top |
|
|
heutger
n00b
Joined: 13 Apr 2004
Posts: 9
|
| Posted: Mon Dec 27, 2004 9:33 pm Post subject: |
|
|
| kashani wrote: | check /etc/pam.d/smtpd|pop3|etc
That's normally where you specify db lookups if you followed the virtual how-to. You may want to add an /etc/portage/package.use for both cyrus-sasl and Postfix so that they recompile without Mysql support.
If none of this helps post a postconf -n
kashani |
First one I checked, I also just did a cat /etc/pam.d/* | grep "sql" there is nothing with sql in it. The second one I don't understand as in this behaviour I'm a newbie, what to add in /etc/portage/package.use exactly? In the /etc/make.conf sasl is already a useflag (just sasl not cyrus-sasl).
Here is the postconf -n:
alias_maps = hash:/etc/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = smtp-amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix
debug_peer_level = 2
default_privs = mail
default_process_limit = 20
defer_transports =
disable_dns_lookups = no
disable_vrfy_command = yes
inet_interfaces = all
initial_destination_concurrency = 50
local_destination_concurrency_limit = 20
local_destination_recipient_limit = 300
local_recipient_maps = $relocated_maps $alias_maps unix:passwd.byname
mail_name = psw11.psw.net
mail_spool_directory = /var/mail
mailbox_command =
mailbox_size_limit = 20000000
mailbox_transport =
mailq_path = /usr/bin/mailq
manpage_directory = /usr/share/man
maps_rbl_domains = sbl.spamhaus.org, relays.ordb.org
masquerade_domains =
maximal_queue_lifetime = 1d
message_size_limit = 20000000
mydestination = $myhostname, localhost.$mydomain
myhostname = psw11.psw.net
newaliases_path = /usr/sbin/sendmail
readme_directory = /usr/share/doc/packages/postfix/README_FILES
sample_directory = /usr/share/doc/packages/postfix/samples
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
smtp_connect_timeout = 5s
smtp_data_done_timeout = 120s
smtp_helo_timeout = 60s
smtpd_client_restrictions =
smtpd_helo_required = no
smtpd_helo_restrictions =
smtpd_recipient_restrictions = permit_sasl_authenticated,permit_auth_destination,permit_mynetworks,reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_tls_cert_file = /etc/postfix/certs/psw11_psw_net.crt
smtpd_tls_key_file = /etc/postfix/certs/psw11_psw_net.key
smtpd_tls_loglevel = 3
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
smtpd_use_tls = yes
strict_rfc821_envelopes = no
tls_random_source = /dev/urandom
undisclosed_recipients_header = To: undisclosed-recipients:; |
|
| Back to top |
|
|
cantao
Apprentice
Joined: 07 Jan 2004
Posts: 166
|
| Posted: Wed Mar 23, 2005 1:05 am Post subject: Same problem here... |
|
|
We are having the same problem here. Sometimes syslog-ng or imap or God knows what gets crazy and these annoying messages fill 2Gb in /bar/log/messages. No solution 'till now.
Cheers, Cantão! |
|
| Back to top |
|
|
|
Networking & Security
