GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Regarding MySQL Auth + server change. HELP!!

AsylumN · 03-15-2005, 05:13 PM

Guys, I need a quick answer, so I thought I would give this a shot as it might be faster than my host!

Ok, I had MySQL Auth set up on my server for my password management for a paysite that is with NATS, and I just moved that paysite to another server today, and I uploaded my htaccess file for MySQL Auth to the new server, and I assumed it would work right because none of the structure of the site has changed (such as the domain or the location of the folders), only the server has changed!

Well, nowwhen I click on the link to go to the members section of the paysite, it gives me a 500 internal server error.

What do i need to change on the htaccess file (if thats the problem)? Here is how it is now:

AuthName "Members Only"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLHost localhost
AuthMySQLDB dreamland
AuthMySQLUser nats
AuthMySQLPassword *****
AuthMySQLUserTable members
AuthMySQLNameField username
AuthMySQLPasswordField password
AuthMySQLPwEncryption none
AuthMySQLUserCondition "status=1 AND siteid=3"
require valid-user

Now before the site was on the same server as my authmysql database, so since it has moved, maybe I am supposed to change the AuthMySQLDB? Is thats what causing the problem?

03-15-2005, 05:13 PM
AsylumN Confirmed User Join Date: Mar 2003 Posts: 625	Regarding MySQL Auth + server change. HELP!! Guys, I need a quick answer, so I thought I would give this a shot as it might be faster than my host! Ok, I had MySQL Auth set up on my server for my password management for a paysite that is with NATS, and I just moved that paysite to another server today, and I uploaded my htaccess file for MySQL Auth to the new server, and I assumed it would work right because none of the structure of the site has changed (such as the domain or the location of the folders), only the server has changed! Well, nowwhen I click on the link to go to the members section of the paysite, it gives me a 500 internal server error. What do i need to change on the htaccess file (if thats the problem)? Here is how it is now: AuthName "Members Only" AuthType Basic AuthGroupFile /dev/null AuthMySQLHost localhost AuthMySQLDB dreamland AuthMySQLUser nats AuthMySQLPassword ***** AuthMySQLUserTable members AuthMySQLNameField username AuthMySQLPasswordField password AuthMySQLPwEncryption none AuthMySQLUserCondition "status=1 AND siteid=3" require valid-user Now before the site was on the same server as my authmysql database, so since it has moved, maybe I am supposed to change the AuthMySQLDB? Is thats what causing the problem? __________________ SexSearch