Kryptronic Software Support Forum

I have a dedicated server that I run on.  2 forums and the store run on this server.  I contacted the host and they told me that everything was fine with the sql server.

The problem popped up a couple of days ago.  Things have been running fine for a couple of years.

On the data base, I have had to hire people to build things for me.  What am I looking for to find this database.

jonsidneyb wrote:

When I try this URL I get this 

http://jsburlysflashlights.com/

J.S. Burly's Flashlights...coming soon!

You're getting that because there is a redirect to the store getting triggered.  Under normal circumstances that message would only show up briefly but with the problems you are having it's staying visible longer while CCP tries, and fails, to connect to the MySQL server.

I did get told that it was a hardwired or hardscripted username?

I will contact the host again and see what they tell me.

If the host thinks it is still a software problem can you recommend someone to hire to take a look at it?

It might help to reset the database connection, in case there is a credentials problem.  You will need to know the database username and password as set up in your hosting control panel.  If you don't know what they are or how to find them, check with your host.  To reset the credentials in CCP without losing your data, you should reference .  Beyond that, I have no obvious things to check and would have to suggest you contact Stephen at cartmod.com if you need professional support.

I got this message from my host.



Hi,

Just let them know that your forum is running on the same MYSQL server and it has no issues


My forum is running fine so I am guessing the sql server is fine.

The username and password that the people that looked at it said it would have been inside of clickcart.

I have been using 2 logins to clickcart.  That is what I understand is missing.

I don't think so.  Within CCP, you have to set the username and password for the database so that CCP can talk to the MySQL server.  Each database can have its own username/password, which probably is not the same as your root login or FTP login and should not be the same as your CCP admin login information either.  Generally this is set through the control panel of your host.  What you need to know is the information for the MySQL database.  Specifically:

1. MySQL hostname.  'localhost' usually works, but it might be a specific IP or even a host name, depending on your server's configuration.

2. Database name.  This can be anything, but is often something cryptic with a bunch of underscores.  Looking at your error message, it seems to be set to 'jsbur2_shopCCP51' in CCP currently, although that may or may not be correct.

3. Username for the database.  This is the name of an authorized user for the database.  Again, this is not the same as your root login, FTP login, etc.  It would be the same login you use to access phpMyAdmin, if your host offers that utilty.

4. Password for the database.  This is the password that matches the username as described in 3.

If this information is not set correctly within CCP, which could well be the problem here, it will have to be reset using the instructions in .

Maybe this will get me pointed in the right direction.

What is  RDBMS ?

Ok, let's try to back up and make sure we're all talking about the same thing.  There are several different username/password combinations and we need to not mix ourselves up. 

There is the CCP admin username and password.  That is the one you would type in when you visit http://www.jsburlysflashlights.com/cgi- … admin.cgi.  That username/password is NOT the problem.

Then there is the username/password that lets you into the database.  These credentials are stored inside CCP and would not normally need to be entered by you at all.  The only time you would use these credentials yourself is if you were accessing phpMyAdmin or some other utility for directly accessing the database.  This is probably the username/password that is screwed up.  To fix this, your host will have to take the following steps:

1. Create new database access credentials or take note of the ones that are there.
2. Enter those credentials into CCP according to Nick's instructions:

Nick wrote:

(1) Login via FTP and get a backup copy of the ./data/tables/tables.csv file.  Store that in a directory locally called 'backup'.

(2) Get another copy of that file and store that in a directory locally called 'test'.

(3) In your 'test' copy, do a find and replace on the term ',ALT,'.  Replace with ',CSV,'.

(4) Upload the test copy to the ./data/tables directory in BINARY mode.

(5) Use CCP admin to configure a connection to the SQL server - it will let you now because it believes all tables are in CSV mode.  Enter in your new user/pass now.  Verify a connection could be made.

(6) Upload the backup (original) copy of tables.csv to the ./data/tables directory in BINARY mode.

That should get you going again, if the problem is in fact the database credentials.

They're right, of course... usernames and passwords don't change themselves.  However, it seems far more likely in this case that someone made a configuration mistake on the server than that you were hacked.  I'd need to see more than a database error to think hacking attempt.

As far as the upgrade being the solution, I cannot say since I am not fluent in version 6.1 myself.  Hopefully Dave will jump in here and answer that question for us.

Well obviously someone changed something.  If it wasn't you, it was probably the host.  Perhaps they did an upgrade to the server or something, but they are certainly correct that things don't just change themselves.  Did you get it sorted?

jonsidneyb wrote:

If I purchased an upgrade of ClickCartPro would the custom shipping fields, transaction data, all the other stuff transfer over intact?  I don't know if the upgrade would solve the SQL problem or not?

With or without the upgrade the SQL situation needs to get resolved.  If you migrate to version 6 the current information is going to be required and things working to be able to migrate your 5.1 store and data.  Version 6 requires an SQL database to function so it's probably best to try and get to the bottom of the SQL problem first then consider migrating (which I would highly recommend since 5.1 isn't supported any longer except through these fora and, mostly, Rachael).