Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Install a MySQL authentication module for Apache' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Install a MySQL authentication module for Apache
Authored by: hedgepig on Oct 06, '04 01:11:15PM

The build process and the installation into the module directory work without incident, but apache just doesn't want to start afterwards. Configtest gives me just "...because of an unknown error" on the loadmodule line.

I am also uncertain if I understand how the table setup should be. Even the original documentation that comes with the sourcecode is wrong about the initial table design! (The primary key of the table can't have a name, that doesn't exist in the columnnames. This error is also present in this hint, thats why I doubt that it will work for anyone)

So which database is used anyway? The original documentation says: it is assumed that every database has this user-info table... :( (If that is actually true, this is pretty poor programming!)
Also: as which user does the module try to access the userinformation table?

Maybe someone can enlighten me here...
Did it really work for someone?



[ Reply to This | # ]
Perhaps this will help
Authored by: XJ0 on Oct 06, '04 09:33:58PM

As to the configtest error, i am not sure. I assume you checked the module directory to make sure the mod is there and the http.conf has right path to the mod:

ie: Loadmodule mod_auth_mysql libexec/httpd/mod_auth_mysql.so
and you did add:
addmodule mod_auth_mysql.c

you could try using >apsx -i -a mod_auth_mysql.so

for the DB your correct. the primary key should be : user_name
In the apache <Directory /xxx/xxx/xx> example you will see that i have set the DB to users --> AuthMySQLDB users.
The mod is supposed to assume this DB but i found it doesn't so i set it.
The mod also seems to try to use the user www to access the DB unless told otherwise. For this reason i setup a webaccess user in mysql and told the mod to use that user.

Sorry i didn't make this clear.



[ Reply to This | # ]