I get cyrus-imapd, saslauthd, mysql, cyradm running on my maschine. The mail-transfer works fine (thanks to langthang) but I get always erros in my logfile (/var/log/messages/). Below some error code: ######################################### Mar 18 17:36:35 server postfix/qmgr[21066]: 1A53FE2C22: from=<postfixbuch-users-bounces@listi.jpberlin.de>, size=4232, nrcpt=1 (queue active) Mar 18 17:36:35 server postfix/smtpd[23064]: disconnect from localhost[127.0.0.1] Mar 18 17:36:58 server postfix/smtpd[23094]: sql_select option missing Mar 18 17:36:58 server postfix/smtpd[23094]: auxpropfunc error no mechanism available Mar 18 17:36:58 server postfix/smtpd[23094]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Mar 18 17:36:58 server postfix/smtpd[23094]: connect from localhost[127.0.0.1] Mar 18 17:36:58 server postfix/smtpd[23094]: ABE09E81D0: client=localhost[127.0.0.1] Mar 18 17:36:58 server postfix/cleanup[23070]: ABE09E81D0: message-id=<20050318163636.GA14858@state-of-mind.de> Mar 18 17:36:58 server postfix/smtpd[23094]: disconnect from localhost[127.0.0.1] Mar 18 17:36:58 server postfix/qmgr[21066]: ABE09E81D0: from=<postfixbuch-users-bounces@listi.jpberlin.de>, size=4690, nrcpt=1 (queue active) Mar 18 17:36:59 server amavis[18738]: (18738-06) Passed CLEAN, LOCAL [127.0.0.1] [212.14.92.89] <postfixbuch-users-bounces@listi.jpberlin.de> -> <benjamin@server.linux-world.site>, Message-ID: <20050318163636.GA14858@state-of-mind.de>, Hits: 0.021, 21333 ms Mar 18 17:36:59 server postfix/smtp[23074]: 1A53FE2C22: to=<benjamin@server.linux-world.site>, orig_to=<benjamin@linux-world.site>, relay=127.0.0.1[127.0.0.1], delay=24, status=sent (250 2.6.0 Ok, id=18738-06, from MTA: 250 Ok: queued as ABE09E81D0) Mar 18 17:36:59 server postfix/qmgr[21066]: 1A53FE2C22: removed Mar 18 17:37:00 server master[23099]: about to exec /usr/lib/cyrus/lmtpd Mar 18 17:37:00 server lmtpunix[23099]: executed Mar 18 17:37:00 server lmtpunix[23099]: sql_select option missing Mar 18 17:37:00 server lmtpunix[23099]: auxpropfunc error no mechanism available Mar 18 17:37:00 server lmtpunix[23099]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Mar 18 17:37:01 server lmtpunix[23099]: accepted connection Mar 18 17:37:01 server lmtpunix[23099]: lmtp connection preauth'd as postman Mar 18 17:37:01 server lmtpunix[23099]: IOERROR: fstating sieve script /var/imap/sieve/b/benjamin/defaultbc: No such file or directory Mar 18 17:37:01 server lmtpunix[23099]: duplicate_check: <20050318163636.GA14858@state-of-mind.de> user.benjamin 0 Mar 18 17:37:01 server lmtpunix[23099]: mystore: starting txn 2147484113 Mar 18 17:37:01 server lmtpunix[23099]: mystore: committing txn 2147484113 Mar 18 17:37:01 server lmtpunix[23099]: duplicate_mark: <20050318163636.GA14858@state-of-mind.de> user.benjamin 1111163821 1584 Mar 18 17:37:01 server postfix/pipe[23097]: ABE09E81D0: to=<benjamin@server.linux-world.site>, relay=cyrus, delay=3, status=sent (server.linux-world.site) Mar 18 17:37:01 server postfix/qmgr[21066]: ABE09E81D0: removed Mar 18 17:38:01 server master[9943]: process 23099 exited, status 0 Mar 18 17:41:39 server postfix/smtpd[23208]: sql_select option missing Mar 18 17:41:39 server postfix/smtpd[23208]: auxpropfunc error no mechanism available Mar 18 17:41:39 server postfix/smtpd[23208]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Mar 18 17:41:39 server postfix/smtpd[23208]: connect from localhost[127.0.0.1] Mar 18 17:41:39 server postfix/smtpd[23208]: C4003E788B: client=localhost[127.0.0.1] Mar 18 17:41:39 server postfix/cleanup[23214]: C4003E788B: message-id=<423AFF45.5010605@nicematin.fr> Mar 18 17:41:39 server postfix/qmgr[21066]: C4003E788B: from=<owner-info-cyrus@lists.andrew.cmu.edu>, size=2309, nrcpt=1 (queue active) Mar 18 17:41:39 server postfix/smtpd[23208]: disconnect from localhost[127.0.0.1] Mar 18 17:41:58 server postfix/smtpd[23223]: sql_select option missing Mar 18 17:41:58 server postfix/smtpd[23223]: auxpropfunc error no mechanism available Mar 18 17:41:58 server postfix/smtpd[23223]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Mar 18 17:41:58 server postfix/smtpd[23223]: connect from localhost[127.0.0.1] Mar 18 17:41:58 server postfix/smtpd[23223]: 67CADE81C7: client=localhost[127.0.0.1] Mar 18 17:41:58 server postfix/cleanup[23214]: 67CADE81C7: message-id=<423AFF45.5010605@nicematin.fr> Mar 18 17:41:58 server postfix/qmgr[21066]: 67CADE81C7: from=<owner-info-cyrus@lists.andrew.cmu.edu>, size=2767, nrcpt=1 (queue active) Mar 18 17:41:58 server postfix/smtpd[23223]: disconnect from localhost[127.0.0.1] Mar 18 17:41:58 server amavis[17543]: (17543-09) Passed CLEAN, LOCAL [127.0.0.1] [212.234.170.249] <owner-info-cyrus@lists.andrew.cmu.edu> -> <benjamin@server.linux-world.site>, Message-ID: <423AFF45.5010605@nicematin.fr>, Hits: 0.05, 16132 ms Mar 18 17:41:58 server postfix/smtp[23218]: C4003E788B: to=<benjamin@server.linux-world.site>, orig_to=<benjamin@linux-world.site>, relay=127.0.0.1[127.0.0.1], delay=19, status=sent (250 2.6.0 Ok, id=17543-09, from MTA: 250 Ok: queued as 67CADE81C7) Mar 18 17:41:58 server postfix/qmgr[21066]: C4003E788B: removed Mar 18 17:41:59 server master[23228]: about to exec /usr/lib/cyrus/lmtpd Mar 18 17:41:59 server lmtpunix[23228]: executed Mar 18 17:41:59 server lmtpunix[23228]: sql_select option missing Mar 18 17:41:59 server lmtpunix[23228]: auxpropfunc error no mechanism available Mar 18 17:41:59 server lmtpunix[23228]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql Mar 18 17:41:59 server lmtpunix[23228]: accepted connection Mar 18 17:41:59 server lmtpunix[23228]: lmtp connection preauth'd as postman Mar 18 17:41:59 server lmtpunix[23228]: IOERROR: fstating sieve script /var/imap/sieve/b/benjamin/defaultbc: No such file or directory Mar 18 17:41:59 server lmtpunix[23228]: duplicate_check: <423AFF45.5010605@nicematin.fr> user.benjamin 0 Mar 18 17:41:59 server lmtpunix[23228]: mystore: starting txn 2147484115 Mar 18 17:41:59 server lmtpunix[23228]: mystore: committing txn 2147484115 Mar 18 17:41:59 server lmtpunix[23228]: duplicate_mark: <423AFF45.5010605@nicematin.fr> user.benjamin 1111164119 1585 Mar 18 17:41:59 server postfix/pipe[23226]: 67CADE81C7: to=<benjamin@server.linux-world.site>, relay=cyrus, delay=1, status=sent (server.linux-world.site) Mar 18 17:41:59 server postfix/qmgr[21066]: 67CADE81C7: removed Mar 18 17:42:59 server master[9943]: process 23228 exited, status 0 ######################################### The error-code should be in relation to pam_mysql. Lungthung found an error in my pam_mysql. root@server benjamin # ldd -r /lib/security/pam_mysql.so linux-gate.so.1 => (0xffffe000) libz.so.1 => /lib/libz.so.1 (0xb7fda000) libmysqlclient.so.12 => /usr/lib/libmysqlclient.so.12 (0xb7f9a000) libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7f6b000) libc.so.6 => /lib/libc.so.6 (0xb7e56000) libnsl.so.1 => /lib/libnsl.so.1 (0xb7e40000) libm.so.6 => /lib/libm.so.6 (0xb7e1d000) libssl.so.0.9.7 => /usr/lib/libssl.so.0.9.7 (0xb7dec000) libcrypto.so.0.9.7 => /usr/lib/libcrypto.so.0.9.7 (0xb7cef000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) libdl.so.2 => /lib/libdl.so.2 (0xb7cea000) undefined symbol: pam_get_item (/lib/security/pam_mysql.so) undefined symbol: pam_set_item (/lib/security/pam_mysql.so) undefined symbol: pam_strerror (/lib/security/pam_mysql.so) undefined symbol: pam_get_user (/lib/security/pam_mysql.so) root@server benjamin # How could I solved this problem with the pam module? Any suggestions? Thank you in advances Thx, Benjamin Reproducible: Always Steps to Reproduce: 1. look in logfiles 2. found errors Actual Results: nothing Expected Results: no erros regarding pam_mysql
*** Bug 85788 has been marked as a duplicate of this bug. ***
Looks like its not linking against libpam.
> Looks like its not linking against libpam. Which one is the right libpam? # locate libpam /lib/libpam.so /lib/libpamc.so.0.77 /lib/libpamc.so /lib/libpamc.so.0 /lib/libpam_misc.so.0.77 /lib/libpam_misc.so /lib/libpam_misc.so.0 /lib/libpam.so.0 /lib/libpam.so.0.77 /usr/lib/libpam.so /usr/lib/libpamc.a /usr/lib/libpamc.so /usr/lib/libpam_misc.a /usr/lib/libpam_misc.so /usr/lib/libpam.a Can you please give me the detailed command to link the libpam korrekt? A clean install of pma_mysql doesn't help. P.S. Sorry for opening the BUG REPORT twice times (Bug 85788), it was a typo. Thx, Ben
>Can you please give me the detailed command to link >the libpam korrekt? A clean install of pma_mysql doesn't help. Hello, I configure the mail-server to reduce the error messages which occurs by miss-configuration. The problem... root@server benjamin # ldd -r /lib/security/pam_mysql.so linux-gate.so.1 => (0xffffe000) libz.so.1 => /lib/libz.so.1 (0xb7fda000) libmysqlclient.so.12 => /usr/lib/libmysqlclient.so.12 (0xb7f9a000) libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7f6b000) libc.so.6 => /lib/libc.so.6 (0xb7e56000) libnsl.so.1 => /lib/libnsl.so.1 (0xb7e40000) libm.so.6 => /lib/libm.so.6 (0xb7e1d000) libssl.so.0.9.7 => /usr/lib/libssl.so.0.9.7 (0xb7dec000) libcrypto.so.0.9.7 => /usr/lib/libcrypto.so.0.9.7 (0xb7cef000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) libdl.so.2 => /lib/libdl.so.2 (0xb7cea000) undefined symbol: pam_get_item (/lib/security/pam_mysql.so) undefined symbol: pam_set_item (/lib/security/pam_mysql.so) undefined symbol: pam_strerror (/lib/security/pam_mysql.so) undefined symbol: pam_get_user (/lib/security/pam_mysql.so) root@server benjamin # ... still occur's. I think we should leave this BUG open until the need libaries are all linked correct. Many thanks to langthang who help me to fix the problem in the configuration on the mail-server! Thank, Benjamin
Hello, It seems you have two problems (not sure, to be tested). First, in your log, cyrus-auth wants to access directly to mysql database thanks to this kind of smtp.conf config file : wcheck_method: saslauthd auxprop mech_list: login plain auxprop_plugin: sql sql_engine: mysql sql_hostnames: localhost sql_user: postfix sql_database: postfix sql_passwd: postfix sql_select: select password from mailbox where username = '%u@%r' If you want to use pam_mysql module, it will be suitable to have this : pwcheck_method:pam log_level: 3 Second, You're right. The pam_mysql librairy doesn't seem to be correctly linked. I have corrected this on the 123405 bugg Cyrius
Marking as dupe of the bump bug as there are too many problems with current pam_mysql that needs to be reviewed after a new version is available. *** This bug has been marked as a duplicate of 120842 ***