Kryptronic Software Support Forum

cheesey-steve · 01-20-2009 14:50:47

Hi

I am trying to move our site to a new provider. I have all the files accross and transported the MySQL database but I had to change the username and password on the MySQL database as I could not remeber what the previous settings were

I switched the site to CSV mode so I culd use the admin to change the rdbms database connection details but when I go to the rdbms setup the form does not show any input fields.

I had a look at the csv file containing the mysql details but I dont know how to encrypt the password to make the connection work

Please can someone help. I tried creating a new support ticket but they said I have to go through the forum.

Dave · 01-20-2009 15:19:12

Our resident 5.1 guru Rachael will probably be able to get you going but she won't be able to post anything for a few hours. Help is on the way.

rachaelseven · 01-20-2009 16:24:29

You can't directly encrypt the password, so we've got to work through the admin. The first question is why you're not getting any fields on the RDBMS page. Please go to that page and do a "view source" with your browser. If there are errors in accessing one of the file, it will show up as a comment block in the HTML and that will probably give us a lot of clues. Also, you can review for changing DB passwords to see if that points you in a better direction. Once you've gone that far, please report back and we'll figure out where to go next.

cheesey-steve · 01-21-2009 15:04:12

Thanks for the post back. I have some bigger problems at the moment. I dont know why but my site is now giving me Internal error 500.

I have set the permissions to the htdocs to 755 and the permissions to media and data to 777

I have checked the filepaths ion the cp-app.pl and cp-admin.pl

Still no joy

Have I missed anything?

cheesey-steve · 01-21-2009 15:16:58

OK got the internal server error sorted just trying to get in, but my password does not wish to play... will let you know when I am doing a little better

cheesey-steve · 01-21-2009 15:18:57

I have checked the passwords and they are right but its not letting me in to the admin section.... Any ideas?

rachaelseven · 01-21-2009 15:30:35

Perhaps a corrupted CSV file due to transferring in ascii mode instead of binary - CCP tables (.csv files) must be transferred in binary mode. If the system can't read or write to the admuser table due to that sort of corruption, you won't be able to get in. Internal server errors can be caused by the same thing, so I'm wondering if maybe you corrupted some of the tables during the transfer.

Kryptronic Software Support Forum

#1 01-20-2009 14:50:47

Problems with MySQL setup when moving site

#2 01-20-2009 15:19:12

Re: Problems with MySQL setup when moving site

#3 01-20-2009 16:24:29

Re: Problems with MySQL setup when moving site

#4 01-21-2009 15:04:12

Re: Problems with MySQL setup when moving site

#5 01-21-2009 15:16:58

Re: Problems with MySQL setup when moving site

#6 01-21-2009 15:18:57

Re: Problems with MySQL setup when moving site

#7 01-21-2009 15:30:35

Re: Problems with MySQL setup when moving site

Board footer