It is probably something stupid I have done. I have installed this on debian without problems.
I tried old-password() but that didn't work either.
There is a previous installation of mysql which has /usr/lib/mysql/libmysqlclient.so.10.0.0, this is the only instance of it, the binary install of mysql5 does not have this module in it's lib anywhere (tarball or installation directory). If I need to upgrade the client module, can someone tell me how?
Any help when you have time would be appreciated.
Wayne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It may have something to do with new vs. old passwords; it's really hard to say.
Since code often changes during development, we only test mod_auth_mysql with release-level code. As MySQL5 is still in development, we have not tested it and have no idea if it works.
One other thing which may be related: the default binary distribution for MySQL 4.1.8 only contains static libs and not libmysqlclient.so. But there also seems to be a bug in the building of the library (as indicated on the MySQL web site bugs list). We are currently following this to see how it affects mod_auth_mysql.
Sorry I don't have more info for you on this. But for now I'd recommend using MySQL 4.1.7, which is known to work.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can use clear passwords but not encrypted.
I am using:
Apache 2.0.52
FC3
mysql 5.0.2-alpha-standard
mod_auth_mysql-2.8.1
here is my build log:
[root@server-b mod_auth_mysql-2.8.1]# apxs -c -L/usr/lib/mysql -I/usr/local/mysql5/include -lmysqlclient -lm -lz mod_auth_mysql.c
/usr/local/apache2/build/libtool --silent --mode=compile gcc -prefer-pic -DAP_HAVE_DESIGNATED_INITIALIZER -DLINUX=2 -D_REENTRANT -D_XOPEN_SOURCE=500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -g -O2 -pthread -I/usr/local/apache2/include -I/usr/local/apache2/include -I/usr/local/apache2/include -I/usr/local/mysql5/include -c -o mod_auth_mysql.lo mod_auth_mysql.c && touch mod_auth_mysql.slo
/usr/local/apache2/build/libtool --silent --mode=link gcc -o mod_auth_mysql.la -I/usr/local/mysql5/include -L/usr/lib/mysql -lmysqlclient -lm -lz -rpath /usr/local/apache2/modules -module -avoid-version mod_auth_mysql.lo
[root@server-b mod_auth_mysql-2.8.1]# apxs -i mod_auth_mysql.la /usr/local/apache2/build/instdso.sh SH_LIBTOOL='/usr/local/apache2/build/libtool' mod_auth_mysql.la /usr/local/apache2/modules
/usr/local/apache2/build/libtool --mode=install cp mod_auth_mysql.la /usr/local/apache2/modules/
cp .libs/mod_auth_mysql.so /usr/local/apache2/modules/mod_auth_mysql.so
cp .libs/mod_auth_mysql.lai /usr/local/apache2/modules/mod_auth_mysql.la
cp .libs/mod_auth_mysql.a /usr/local/apache2/modules/mod_auth_mysql.a
ranlib /usr/local/apache2/modules/mod_auth_mysql.a
chmod 644 /usr/local/apache2/modules/mod_auth_mysql.a
PATH="$PATH:/sbin" ldconfig -n /usr/local/apache2/modules
chmod 755 /usr/local/apache2/modules/mod_auth_mysql.so
It is probably something stupid I have done. I have installed this on debian without problems.
I tried old-password() but that didn't work either.
There is a previous installation of mysql which has /usr/lib/mysql/libmysqlclient.so.10.0.0, this is the only instance of it, the binary install of mysql5 does not have this module in it's lib anywhere (tarball or installation directory). If I need to upgrade the client module, can someone tell me how?
Any help when you have time would be appreciated.
Wayne
Wayne,
It may have something to do with new vs. old passwords; it's really hard to say.
Since code often changes during development, we only test mod_auth_mysql with release-level code. As MySQL5 is still in development, we have not tested it and have no idea if it works.
One other thing which may be related: the default binary distribution for MySQL 4.1.8 only contains static libs and not libmysqlclient.so. But there also seems to be a bug in the building of the library (as indicated on the MySQL web site bugs list). We are currently following this to see how it affects mod_auth_mysql.
Sorry I don't have more info for you on this. But for now I'd recommend using MySQL 4.1.7, which is known to work.
Jerry
ok Jerry
Thanks for your quick response. Will do.
Cheers!
Wayne