Regarding MySQL Auth + server change. HELP!! - GoFuckYourself.com

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?

jayme_ · 03-15-2005, 05:15 PM

"AuthMySQLHost localhost"

mke sure that is where the DB is (in this case localhost)

directfiesta · 03-15-2005, 05:16 PM

You could have use the WHM panel ( or your host could have) to tranfer the whole site in one shot .... Looks like you need to restore your database and/or create it. Not familiar with Nats.

JFPdude · 03-15-2005, 05:17 PM

Also is mod_auth_mysql module installed in apache ?

modF · 03-15-2005, 05:17 PM

I see you don't have AuthMySQLEnable On

Also, is a generic .htaccess file enabled on the new host?

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

Quote:

Originally Posted by jayme_

"AuthMySQLHost localhost"

mke sure that is where the DB is (in this case localhost)

Well, thats where it was before and it was working...
the database is still in the same place, the onyl thing that has changed is that the paysite has been moved from the server where the database used to be and is now on its own server.

so should the DB place not be localhost anymore?

modF · 03-15-2005, 05:25 PM

If the nats database is on a different server, you need to create a user on the databse server to allow the ip of the new server to connect to it. Then change the AuthMySQLHost to the ip (I prefer ip).

Login to the shell of your new box, and try to access the database server using:

mysql -u user -p -h database ip/hostname database name

jayme_ · 03-15-2005, 05:25 PM

Quote:

Originally Posted by AsylumN

Well, thats where it was before and it was working...
the database is still in the same place, the onyl thing that has changed is that the paysite has been moved from the server where the database used to be and is now on its own server.

so should the DB place not be localhost anymore?

it should be the ip address or the hostname of the mysql server.

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

Quote:

Originally Posted by JFPdude

Also is mod_auth_mysql module installed in apache ?

yes, everything was working before, it was installed correctly, and it worked, it only stopped working when I put the paysite ona different server than where the whole NATS instalaltion and mod_auth_mysql was.

So in non-tech jargon, basically I suspect the reason its not working is because on the htaccess file I am specifying the location of where the database is, but I havent taken into account the new paysite server location.

So I suspect that I should change localhost to something else?

jayme_ · 03-15-2005, 05:26 PM

and what modF said^ also

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

ok, wow, im amazed how fast you can get answers on GFY, faster than my host. Guys, I really appreciate it, JFPdude, modF, jayme, thanks so much.

JFPdude · 03-15-2005, 05:28 PM

Quote:

Originally Posted by modF

If the nats database is on a different server, you need to create a user on the databse server to allow the ip of the new server to connect to it. Then change the AuthMySQLHost to the ip (I prefer ip).

Login to the shell of your new box, and try to access the database server using:

mysql -u user -p -h database ip/hostname database name

yup

Nathan · 03-16-2005, 04:04 AM

Quote:

Originally Posted by AsylumN

ok, wow, im amazed how fast you can get answers on GFY, faster than my host. Guys, I really appreciate it, JFPdude, modF, jayme, thanks so much.

If you still need help, let us know please.

03-15-2005, 05:13 PM	#1
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

03-15-2005, 05:16 PM	#3
directfiesta Too lazy to set a custom title Industry Role: Join Date: Oct 2002 Location: Montreal, Quebec Posts: 29,761	You could have use the WHM panel ( or your host could have) to tranfer the whole site in one shot .... Looks like you need to restore your database and/or create it. Not familiar with Nats. __________________ I know that Asspimple is stoopid ... As he says, it is a FACT ! But I can't figure out how he can breathe or type , at the same time ....

03-15-2005, 05:17 PM	#5
modF Confirmed User Join Date: Aug 2002 Posts: 1,888	I see you don't have AuthMySQLEnable On Also, is a generic .htaccess file enabled on the new host? __________________ I do things skype:themodF

03-15-2005, 05:25 PM	#7
modF Confirmed User Join Date: Aug 2002 Posts: 1,888	If the nats database is on a different server, you need to create a user on the databse server to allow the ip of the new server to connect to it. Then change the AuthMySQLHost to the ip (I prefer ip). Login to the shell of your new box, and try to access the database server using: mysql -u user -p -h database ip/hostname database name __________________ I do things skype:themodF

03-15-2005, 05:28 PM	#11
AsylumN Confirmed User Join Date: Mar 2003 Posts: 625	ok, wow, im amazed how fast you can get answers on GFY, faster than my host. Guys, I really appreciate it, JFPdude, modF, jayme, thanks so much. __________________ SexSearch

03-15-2005, 05:15 PM	#2
jayme_ Confirmed User Industry Role: Join Date: Jan 2005 Location: new york city Posts: 158	"AuthMySQLHost localhost" mke sure that is where the DB is (in this case localhost)

03-15-2005, 05:17 PM	#4
JFPdude Confirmed User Join Date: Jan 2002 Location: Mountains of Western North Carolina. Posts: 4,027	Also is mod_auth_mysql module installed in apache ?

03-15-2005, 05:26 PM	#10
jayme_ Confirmed User Industry Role: Join Date: Jan 2005 Location: new york city Posts: 158	and what modF said^ also