RE: Compile sasl2 with mysql support

• Previous message: Kenny Olano: "RE: Compile sasl2 with mysql support"
• In reply to: Simon Matter: "RE: Compile sasl2 with mysql support"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> -----Original Message-----
> From: owner-cyrus-sasl at lists dot andrew dot cmu dot edu
> [mailto:owner-cyrus-sasl at lists dot andrew dot cmu dot edu]On Behalf Of Simon Matter
> Sent: Thursday, March 18, 2004 10:56 AM
> To: Kenny Olano
> Cc: cyrus-sasl at lists dot andrew dot cmu dot edu
> Subject: RE: Compile sasl2 with mysql support
>
>
> >
> >
> >> -----Original Message-----
> >> From: Simon Matter [mailto:simon dot matter at ch dot sauter-bc dot com]
> >> Sent: Thursday, March 18, 2004 9:31 AM
> >> To: Kenny Olano
> >> Cc: cyrus-sasl at lists dot andrew dot cmu dot edu
> >> Subject: RE: Compile sasl2 with mysql support
> >>
> >>
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: owner-cyrus-sasl at lists dot andrew dot cmu dot edu
> >> >> [mailto:owner-cyrus-sasl at lists dot andrew dot cmu dot edu]On Behalf Of Simon
> >> Matter
> >> >> Sent: Thursday, March 18, 2004 1:30 AM
> >> >> To: Kenny Olano
> >> >> Cc: cyrus-sasl at lists dot andrew dot cmu dot edu
> >> >> Subject: Re: Compile sasl2 with mysql support
> >> >>
> >> >>
> >> >> > Hello,
> >> >> > I am trying to install sasl2 with mysql support. I
> was able to
> >> find
> >> >> > cyrus-sasl-2.1.18.src.rpm. After building the rpms, it didn't
> >> >> create the
> >> >>
> >> >> Where did you find the src rpm? I'm quite sure you found my
> >> rpms. If so,
> >> >> the mysql stuff is in the cyrus-sasl-sql-2.1.18-1.i386.rpm package.
> >> It
> >> >> includes support for mysql and postgresql.
> >> >>
> >> >> Simon
> >> >>
> >> >> > cyrus-sasl-mysql rpm. What am I doing wrong? Do I have to
> >> >> modify the spec
> >> >> > file?
> >> >> >
> >> >> > cyrus-sasl-debuginfo-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-devel-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-gssapi-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-md5-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-ntlm-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-otp-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-plain-2.1.18-1.i386.rpm
> >> >> > cyrus-sasl-sql-2.1.18-1.i386.rpm
> >> >> >
> >> >> >
> >> > I get the following error in my messages log file: "SQL engine
> >> 'mysql' not
> >> > supported"
> >>
> >> What does 'ldd /usr/lib/sasl2/libsql.so.2.0.18' show you?
> >> BTW I'm not using the sql stuff at all so I don't know whether
> it works.
> >> But I got reports from people using it with 2.1.17, so I expect it
> >> should
> >> work.
> >>
> >> Simon
> >> >
> >> > Here is my smtpd.conf file
> >> >
> >> > pwcheck_method: auxprop
> >> > auxprop_plugin: sql
> >> > sql_engine: mysql
> >> > sql_user: user
> >> > sql_passwd: password
> >> > sql_hostnames: localhost
> >> > sql_database: maildb
> >> > sql_statement: SELECT crypt FROM users WHERE id = '%u'
> >> > sql_verbose: yes
> >> >
> >
> > libpq.so.3 => /usr/lib/libpq.so.3 (0x40047000)
> > libresolv.so.2 => /lib/libresolv.so.2 (0x4005c000)
> > libcrypt.so.1 => /lib/libcrypt.so.1 (0x4006e000)
> > libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
> > libssl.so.4 => /lib/libssl.so.4 (0x4009b000)
> > libcrypto.so.4 => /lib/libcrypto.so.4 (0x400d1000)
> > libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x401c2000)
> > libnsl.so.1 => /lib/libnsl.so.1 (0x40220000)
> > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
> > libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
> > (0x40235000)
> > libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3
> > (0x40248000)
> > libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3
> (0x40258000)
> > libdl.so.2 => /lib/libdl.so.2 (0x4025b000)
> > libz.so.1 => /usr/lib/libz.so.1 (0x4025e000)
>
> It looks like there were no mysql client libs installed on the box where
> you built the rpms, so the sql module was built without mysql support.
> Just install the mysql client libs and rebuild from src rpm again. Then
> install the rpms with rpm -Uvh --replacefiles --replacepkgs
> cyrus-sasl.....
>
> Simon
>
> >
> > Is it possible to down grade down to cyrus-sasl-2.1.17 with out
> messing up
> > the dependencies or do I have to do a --force or do I have to uninstall
> > all
> > the packages that require them and reinstall them?
> >
> >
>
>
I am still getting the same error:
#/var/log/messages
Mar 18 11:32:43 mail3 postfix/smtpd[14092]: SQL engine 'mysql' not supported

#/var/log/mailog
Mar 18 11:32:43 mail3 postfix/smtpd[14092]: warning: SASL authentication
failure: no secret in database
Mar 18 11:32:43 mail3 postfix/smtpd[14092]: warning: unknown[192.168.1.50]:
SASL NTLM authentication failed
Mar 18 11:33:02 mail3 postfix/smtpd[14092]: warning: unknown[192.168.1.50]:
SASL NTLM authentication failed
Mar 18 11:33:04 mail3 postfix/smtpd[14092]: warning: unknown[192.168.1.50]:
SASL LOGIN authentication failed

It looks like I was missing the mysql-shared rpms. I installed it and these
are all the mysql rpms installed on my server:
**Note all these rpms where downloaded from www.mysql.com
MySQL-client 4.0.18-0
MySQL-devel 4.0.18-0
MySQL-server 4.0.18-0
MySQL-shared 4.0.18-0
MySQL-shared-compat 4.0.18-0

I rebuilded the src rpms as a unprivileaged user. Then installed the rpms
as root using:
         rpm -Uvh --replacefiles --replacepkgs cyrus-sasl-*

I configure postfix with sasl using the following command:

make makefiles
'CCARGS=-DHAS_MYSQL -I/usr/include/mysql -DUSE_SASL_AUTH -I/usr/include/sasl
 -I/usr/include'
'AUXLIBS=-L/usr/local/lib/mysql -lmysqlclient -lz -lm -L/usr/local/lib -lsas
l2 -L/usr/lib'

I then restarted saslauthd and postfix. But I am still recieving the same
error mentioned above.

# ldd /usr/lib/sasl2/libsql.so.2.0.18 after I rebuiled cyrus-sasl
libpq.so.3 => /usr/lib/libpq.so.3 (0x40047000)
libresolv.so.2 => /lib/libresolv.so.2 (0x4005c000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4006e000)
libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
libssl.so.4 => /lib/libssl.so.4 (0x4009b000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x400d1000)
libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x401c2000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40220000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2 (0x40235000)
libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40248000)
libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40258000)
libdl.so.2 => /lib/libdl.so.2 (0x4025b000)
libz.so.1 => /usr/lib/libz.so.1 (0x4025e000)

• Previous message: Kenny Olano: "RE: Compile sasl2 with mysql support"
• In reply to: Simon Matter: "RE: Compile sasl2 with mysql support"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]