currently i'm using MySQL 4.1.16 and i want to update to 5.0.17.
i've a strange problem:
i can compile it with MySQL 5.0.17.
no errors were shown when i start apache2.
so it looks like everything is ok.
BUT i can't login in protected areas anymore.
the apache2 log says: MySQL user xxx not found...
mysql error log doesn't complain anything.
i made it work on another server but i've NO IDEA why it's not working on the other.
my steps are:
configure mysql
make
shutdown mysql + apache2
make install
ldconfig
build mod_auth_mysql
install mod_auth_mysql
start mysql + apache2
i figured out that i need ldconfig else i get can't load libmysqlclient.so.15 when i try to start apache2.
i've my mysql installation path in the ld.so.conf:
/usr/local/mysql/lib/mysql
i also tryed to compile apache2 again. doesn't help.
any ideas?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hmmm, I'm not sure why MySQL 5.0.17 would act differently, but I also admit I haven't tried it on that version yet.
The error indicates we were unable to retrieve the user info from the database.
To start, what do you have in your httpd.conf or .htaccess file for mod_auth_mysql statements? Of course, please be sure to change any critical info such as table names, user id's and passwords. Additionally, what's your table layout?
Another thought here - what charset and coalation is the database using, and what's your default connection set up for?
Finally, what do you see if you turn on MySQL logging and test?
Thanks,
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've wrapped the mod_auth_mysql.c in a configure/makefile that I've had great success in using.
I build the module using gcc and not apxs and I install with 'apxs' only.
This seems to solve most of the problems.
Someone packages the source for Mac OSX however it was put together wrong and requires mysql to be in a specific location and doesn't work with Apache 2.x.
My solution seems to work regardless of the Apache version you're building for and it's a lot easier than the manual approach of building a module.
You can also add additinal source files to handle other modules and make conditional builds by specifying the modules you want to build and install.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
currently i'm using MySQL 4.1.16 and i want to update to 5.0.17.
i've a strange problem:
i can compile it with MySQL 5.0.17.
no errors were shown when i start apache2.
so it looks like everything is ok.
BUT i can't login in protected areas anymore.
the apache2 log says: MySQL user xxx not found...
mysql error log doesn't complain anything.
i made it work on another server but i've NO IDEA why it's not working on the other.
my steps are:
configure mysql
make
shutdown mysql + apache2
make install
ldconfig
build mod_auth_mysql
install mod_auth_mysql
start mysql + apache2
i figured out that i need ldconfig else i get can't load libmysqlclient.so.15 when i try to start apache2.
i've my mysql installation path in the ld.so.conf:
/usr/local/mysql/lib/mysql
i also tryed to compile apache2 again. doesn't help.
any ideas?
Hi, Christian,
Hmmm, I'm not sure why MySQL 5.0.17 would act differently, but I also admit I haven't tried it on that version yet.
The error indicates we were unable to retrieve the user info from the database.
To start, what do you have in your httpd.conf or .htaccess file for mod_auth_mysql statements? Of course, please be sure to change any critical info such as table names, user id's and passwords. Additionally, what's your table layout?
Another thought here - what charset and coalation is the database using, and what's your default connection set up for?
Finally, what do you see if you turn on MySQL logging and test?
Thanks,
Jerry
Can you post the output of 'apxs -q CFLAGS'
I've wrapped the mod_auth_mysql.c in a configure/makefile that I've had great success in using.
I build the module using gcc and not apxs and I install with 'apxs' only.
This seems to solve most of the problems.
Someone packages the source for Mac OSX however it was put together wrong and requires mysql to be in a specific location and doesn't work with Apache 2.x.
My solution seems to work regardless of the Apache version you're building for and it's a lot easier than the manual approach of building a module.
You can also add additinal source files to handle other modules and make conditional builds by specifying the modules you want to build and install.