Bug 134491 - cyrus-sasl-sqlauxprop is not linked against any database
Summary: cyrus-sasl-sqlauxprop is not linked against any database
Status: RESOLVED FIXED
Alias: None
Product: SUSE LINUX 10.0
Classification: openSUSE
Component: Other (show other bugs)
Version: Final
Hardware: x86-64 SuSE Linux 10.0
: P5 - None : Normal
Target Milestone: ---
Assignee: Carsten Hoeger
QA Contact: E-mail List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-18 21:50 UTC by Florin Vlaicu
Modified: 2005-11-23 13:39 UTC (History)
0 users

See Also:
Found By: Other
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Florin Vlaicu 2005-11-18 21:50:22 UTC
By default it is not linked against mysql or pgsql, although it has sql support enabled.
Nov  9 22:18:20 aka-build postfix/smtpd[23244]: SQL engine 'mysql' not supported
Nov  9 22:18:20 aka-build postfix/smtpd[23244]: auxpropfunc error no mechanism available
Nov  9 22:18:20 aka-build postfix/smtpd[23244]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

I tried to rebuild the package and I modified in the spec file to add in the configure command the following 
--with-mysql=/usr/include/mysql
and 
--with-pgsql=/usr/include/pgsql
Comment 1 Carsten Hoeger 2005-11-22 09:41:21 UTC
Install package postfix-mysql or postfix-postgresql and then it should work as expected.
The SUSE package now contains the dynamic maps patch of the Debian postfix maintainer.
Comment 2 Carsten Hoeger 2005-11-22 09:44:37 UTC
You also have to install the cyrus-sasl-sqlauxprop package, if you want to use sql as sasl auth source.
Comment 3 Florin Vlaicu 2005-11-22 20:39:56 UTC
I have both cyrus-sasl-sqlauxprop and postfix-mysql package installed
This is done today
Nov 22 23:24:55 aka-build postfix/smtpd[13946]: SQL engine 'mysql' not supported
Nov 22 23:24:55 aka-build postfix/smtpd[13946]: auxpropfunc error no mechanism available
Nov 22 23:24:55 aka-buikd postfix/smtpd[13946]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

This is what ldd returns with the stock package
ldd libsql.so
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00002aaaaabdd000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x00002aaaaacf2000)
        /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)

And this is what it gives me with my modified package (I also added a patch on cyrus-sasl to know about crypted passwords)
ldd libsql.so
        libmysqlclient.so.14 => /usr/lib64/libmysqlclient.so.14 (0x00002aaaaabde000)
        libpq.so.4 => /usr/lib64/libpq.so.4 (0x00002aaaaae09000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00002aaaaaf2a000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x00002aaaab03e000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00002aaaab26a000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00002aaaab3a3000)
        libm.so.6 => /lib64/tls/libm.so.6 (0x00002aaaab4b9000)
        libz.so.1 => /lib64/libz.so.1 (0x00002aaaab611000)
        libssl.so.0.9.7 => /usr/lib64/libssl.so.0.9.7 (0x00002aaaab726000)
        libcrypto.so.0.9.7 => /usr/lib64/libcrypto.so.0.9.7 (0x00002aaaab85c000)
        libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x00002aaaaba95000)
        libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x00002aaaabc0d000)
        /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00002aaaabd22000)
        libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x00002aaaabe26000)
        libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00002aaaabf4a000)
        libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0 (0x00002aaaac04c000)

Please observe libmysql.so.14 and libpq.so.4

And here is what cyrus-sasl and postfix packages I have installed

rpm -qa|grep sasl
cyrus-sasl-digestmd5-2.1.21-3
cyrus-sasl-2.1.21-3
cyrus-sasl-crammd5-2.1.21-3
cyrus-sasl-saslauthd-2.1.21-3
cyrus-sasl-sqlauxprop-2.1.21-3
cyrus-sasl-32bit-2.1.21-3
cyrus-sasl-plain-2.1.21-3

rpm -qa|grep postfix
postfix-2.2.5-5
postfix-mysql-2.2.5-5

Maybe I didn't expressed myself properly in my first message
Whith the stock spec in configure stage of the build it says it doesn't find MySQL or PostgreSQL and it disables support for them.

I needed to rebuild the package to add the crypt support to the package and I saw those errors in the logs.

When I added --with-mysql=/usr/include/mysql and 
--with-pgsql=/usr/include/pgsql and recompiled it started working.
Comment 4 Florin Vlaicu 2005-11-22 20:40:47 UTC
forgot to reopen :)
Comment 5 Carsten Hoeger 2005-11-23 08:45:33 UTC
Ah, now I see. It just effects x86_64 and the bug is in cyrus-sasl-sqlauxprop. Tried to reproduce on i586 without success.
Comment 6 Carsten Hoeger 2005-11-23 12:52:38 UTC
fixed in STABLE

Andreas, do you want to have an update for 10.0?
Comment 7 Andreas Jaeger 2005-11-23 13:24:58 UTC
Only for 10.1, so it's fixed.
Comment 8 Carsten Hoeger 2005-11-23 13:39:38 UTC
Okay.
Florin, thank you for reporting.