Del
01-01-1999, 06:35 PM
Okay, question o' the day. It would've been last night's question but the freakin **** **** **** phone company bungled something, and our phones were out all night... (well, maybe it wasn't the phone company, coulda been some drunk hit a phone pole, or some yutz shot his gun up in the air and took out a line, but I prefer to blame the phone company themself) okay, I'm rambling, on to the point.
I've successfully built my first MySQL table, containing three fields username, passwd, and groups. Then I successfully made a tiny li'l perl script that will take formdata username, password twice, groups info, encrypt the password (after making sure the two pwords match), yadda yadda yadda, and it'll insert them into the table. No problems with all this, just project history.
I created an .htaccess file following the fairly lousy (IMHO) docs at the mod_auth_mysql page ( bourbon.netvision.net.il/mysql/mod_auth_mysql/ (http://bourbon.netvision.net.il/mysql/mod_auth_mysql/) ). After having a couple minor problems with spelling (I never can spell require properly, I always forget the 'i' the first time) I go on. When I access the protected dir it asks for username/pass no problem. Enter those, hit the [Okay] button, it auth's me, and I'm in. Now, here's the break, it returns a 500 internal server error. Weird... I've got an index.html page there, even if I type the full url/path to index.html it 500 errors. Below is what the .htaccess file looks like;
============================
AuthName "Insert_Name_Here"
AuthType basic
Auth_MySQL_DB xdowninit
Auth_MySQL_Password_Table auth_http
Auth_MySQL_Group_Table auth_http
Auth_MySQL_Empty_Passwords off
Requre valid-user
===========================
Any ideas? Am I missing something in there? The thing successfully authorizes it seems, as it only asks for user/pass once, then I can return and get straight to the 500 error. My error log shows the following,
[Fri Jan 1 17:28:23 1999] [error] MySQL auth: connect failed: Access denied for user: 'apache@localhost' (Using password: NO)
It looks like it's trying to access the database with the username 'apache', so it makes sense why it's failing, but it's weird that it still seems to grant me access. I just don't know how to fix it http://www.aota.net/ubb/frown.gif
If y'all have any ideas, or see what I'm doing wrong, please lemme know.
Thanks,
Del
------------------
Del
www.downinit.com/ (http://www.downinit.com/)
PS Does this forum have a Preview function somewhere that I'm missing, or is that feature lacking? It'd sure be handy to be able to preview a message before posting http://www.aota.net/ubb/smile.gif
[This message has been edited by Del (edited 01-01-99).]
I've successfully built my first MySQL table, containing three fields username, passwd, and groups. Then I successfully made a tiny li'l perl script that will take formdata username, password twice, groups info, encrypt the password (after making sure the two pwords match), yadda yadda yadda, and it'll insert them into the table. No problems with all this, just project history.
I created an .htaccess file following the fairly lousy (IMHO) docs at the mod_auth_mysql page ( bourbon.netvision.net.il/mysql/mod_auth_mysql/ (http://bourbon.netvision.net.il/mysql/mod_auth_mysql/) ). After having a couple minor problems with spelling (I never can spell require properly, I always forget the 'i' the first time) I go on. When I access the protected dir it asks for username/pass no problem. Enter those, hit the [Okay] button, it auth's me, and I'm in. Now, here's the break, it returns a 500 internal server error. Weird... I've got an index.html page there, even if I type the full url/path to index.html it 500 errors. Below is what the .htaccess file looks like;
============================
AuthName "Insert_Name_Here"
AuthType basic
Auth_MySQL_DB xdowninit
Auth_MySQL_Password_Table auth_http
Auth_MySQL_Group_Table auth_http
Auth_MySQL_Empty_Passwords off
Requre valid-user
===========================
Any ideas? Am I missing something in there? The thing successfully authorizes it seems, as it only asks for user/pass once, then I can return and get straight to the 500 error. My error log shows the following,
[Fri Jan 1 17:28:23 1999] [error] MySQL auth: connect failed: Access denied for user: 'apache@localhost' (Using password: NO)
It looks like it's trying to access the database with the username 'apache', so it makes sense why it's failing, but it's weird that it still seems to grant me access. I just don't know how to fix it http://www.aota.net/ubb/frown.gif
If y'all have any ideas, or see what I'm doing wrong, please lemme know.
Thanks,
Del
------------------
Del
www.downinit.com/ (http://www.downinit.com/)
PS Does this forum have a Preview function somewhere that I'm missing, or is that feature lacking? It'd sure be handy to be able to preview a message before posting http://www.aota.net/ubb/smile.gif
[This message has been edited by Del (edited 01-01-99).]