Hi all,
Now I know that there are quite a large number of posts about mod_auth_mysql on this website, so I hope this isn't making things worse.
I am very close to getting mod_auth_mysql going successfully.
However, I am stuck at a tiny little spot - for some reason everything works fine except the login prompt endlessly pops up after entering login details - even if they are entered correctly.
I have followed the instructions here:
http://www.webhostgear.com/215.html
and seemed to have installed mod_auth_mysql perfectly fine.
I also added "AuthMySQLEnable off" to my httpd.conf file as to not make mod_auth_mysql the default auth method.
I made a db in CPanel with username "w_auth", and the db is also called "w_auth".
My table is as below...
CREATE TABLE `user_info` (
`user_name` char(30) NOT NULL default '',
`user_passwd` char(20) NOT NULL default '',
`user_group` char(10) default NULL,
PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
with one record: "user","password","null"
Finally, my .htaccess file is as below...
AuthName "MySQL Testing"
AuthType Basic
AuthUserFile /dev/null
AuthGroupFile /dev/null
AuthMySQLHost localhost
AuthMySQLUser w_auth
AuthMySQLPassword ******** <- that is not the real thing of course ;)
AuthMySQLDB w_auth
AuthMySQLUserTable user_info
AuthMySQLNameField user_name
AuthMySQLPasswordField user_passwd
AuthMySQLPwEncryption none
AuthMySQLEnable On
require valid-user
I am running Apache 1.x with mod_auth_mysql 2.90 and php 4.x
I have root access to the server so I can edit the httpd.conf file if needed.
I have read somewhere that I have to recompile MySQL or something - I really don't want this.
I am running CentOS 4.1 and am using the stock MySQL, PHP, Apache RPM's.
If anyone could help it would be greatly appreciated - I am setting up this server for my Open Source project, so helping me would be also helping the hundreds of community members also (i hope that helps motivate) 🙂
