View Full Version : [xubuntu] mod_auth_mysql errors
July 26th, 2009, 09:43 AM
Hi I'm new to servers and struggling to get mod_auth_mysql to work.
I've had mysql working well for some time now, I then added a .htaccess and .htpasswd file and that worked fine.
I've now installed mod_auth_mysql but get errors. My .htaccess looks like this at the moment:
AuthName "some name"
I have also removed the .htpasswd file as I believe it is no longer required.
In my web site each time I expect to see a login box I get a Internal Server Error page. The Apache2 error.log shows (9)Bad file descriptor: Could not open password file: (null) refer: http:// address of my server
Can anybody give me some advice please?
July 26th, 2009, 09:56 AM
AuthName "some name"
July 26th, 2009, 11:24 AM
Hi wojox, thanks for reply.
I tryed your suggestion, it still doesn't work but the error.log now reads:-
[alert] [client 192.168.1.3] /var/www/BWAMgoog/observers/.htaccess: Invalid command 'AuthMySQLEnable', perhaps misspelled or defined by a module not included in the server configuration, referer: http://192.168.1.104/BWAMgoog/index.php
Can you help with this?
July 27th, 2009, 04:26 PM
Well I've got a little further and my .htaccess looks like this:-
AuthName "observers sections"
<Limit GET POST>
Now when I hit the button in my web page I get the login box but when I type in a correct name and password followed by OK the login box reappears empty waiting for me to login.
Here are the changes I've made to the apache2.conf:-
Auth_MySQL_Info localhost name password
Options +Indexes FollowSymLinks MultiViews
AllowOverride AuthConfig Options FileInfo Limit
Allow From All
July 30th, 2009, 08:44 PM
Well I keep trying but have now run out of new ideas.
I get an error message in apache2 error.log:-
[error] [client 192.168.1.3] user joe.bloggs not found
Can any one help please??
July 30th, 2009, 08:49 PM
What does /var/log/mysql/mysql.log say?
July 30th, 2009, 09:06 PM
/var/log/mysql is empty! The folder is empty.
January 1st, 2010, 02:28 AM
I am fighting the same problem you posted. Did you ever get it solved?
Happy New Year!
May 1st, 2012, 08:31 PM
Edit: I didn't realize he had already done the following, and it didn't fix it for him. It did fix it for me however, so I'll leave it for anyone else that comes across this thread with this error.
I know this is an old thread, but it comes up pretty high in a Google search, so I figured I'd post the answer.
Apache2 will still try to use the file auth as the primary authentication source. If the AuthUserFile isn't set, you get the bad file descriptor error. If it is set, then Apache only uses that. The fix is to add this:
You may also need the following:
I don't think you do, but I haven't tested without it.
Powered by vBulletin® Version 4.2.2 Copyright © 2015 vBulletin Solutions, Inc. All rights reserved.