login / passwd problem

clubcosmic · 1-15-05, 10:36 AM

hi all,

i have the same login script running on 2 different databases (pw servers). The login script executes fine on one but all of a sudden the very same script and table wont run on the other. I think it has to do with the password won't authenticate on the disabled one.

i thought perhaps the table was corrupt so i created a new one and still. i also copied the good script and modified to login and it still wont work.

could it be the collation? any ideas?

tnx
c.c.

B&T · 1-15-05, 10:53 AM

Since you have not [rovided any information to help you, I can only guess. If it works on one server and not the other I suspect it is a file path issue- maybe coded for one of them?

clubcosmic · 1-15-05, 11:12 AM

the script works if i omit the the password.

WHERE password=PASSWORD('$var')

and just connect using the username withought a password. So i think that the password is not mathing the password in the db and it is encrypted.

I'm sure it's at the mysql table level where the passwords just dont match. plus all the tables are latin1_swedish_ci

Can a password be translated correctly if latin1_swedish_ci?

1-15-05, 10:36 AM	#1
clubcosmic Join Date: Sep 2002 Posts: 25 Reputation: 19	login / passwd problem hi all, i have the same login script running on 2 different databases (pw servers). The login script executes fine on one but all of a sudden the very same script and table wont run on the other. I think it has to do with the password won't authenticate on the disabled one. i thought perhaps the table was corrupt so i created a new one and still. i also copied the good script and modified to login and it still wont work. could it be the collation? any ideas? tnx c.c.

1-15-05, 10:53 AM	#2
B&T Just tryin' to help Join Date: Jan 2003 Location: along the journey Posts: 8,036 Reputation: 125	Since you have not [rovided any information to help you, I can only guess. If it works on one server and not the other I suspect it is a file path issue- maybe coded for one of them? __________________ Enhance your PowWeb experience @ B&T's Tips & Scripts Got some free time? You can find Nothing of Value @ PrettyWorthless.com

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

1-15-05, 11:12 AM	#3
clubcosmic Join Date: Sep 2002 Posts: 25 Reputation: 19	the script works if i omit the the password. WHERE password=PASSWORD('$var') and just connect using the username withought a password. So i think that the password is not mathing the password in the db and it is encrypted. I'm sure it's at the mysql table level where the passwords just dont match. plus all the tables are latin1_swedish_ci Can a password be translated correctly if latin1_swedish_ci?