Kryptronic Software Support Forum

My host as of yesterday is looking at the software so I now have four people working on it.  Seems to have gotten no where.

The thought of the upgrade was to try and solve the sql problem.  One of the people that has been working on this thinks the only fix is reloading the software.  Since Kryptronic did the install I don't have it.

What they are telling me is they don't know what username and password to give the database so that ClickCart will recognize it.   The thought was a new install would do the username password process again so that they could know what to use for the database.

Ok....I will pass this information along.

If your host cannot sort it, you might want to enlist the help of a professional experienced with CCP5.1.  I don't think Kryptronic will support 5.1 any longer, but you could try talking to Stephen at cartmod.com and see if he can help.

The database host is defined in the table altrdbms.csv.  The usual value for the host is .  It can be changed by editing the altrdbms.csv table through FTP or by following the previously given instructions for resetting the password (the host can be changed at the same time).

Now it all starts to make sense.  Well good luck with it.  If you have to make a new DB on the local host, at least you know how to change the configuration now.

Some hosting companies maintain separate database servers - that is the only reason it would have been set up that way.  Nobody would go out of their way to rent a server, set it up as a MySQL server, and put your database on it, just to be contrary.  So what likely happened here is that your host used to maintain a single DB server for a group of web servers.  Perhaps that wasn't working so well and they decided to have each web server also function as a MySQL server, a common configuration and the one that would result in a setting of 'localhost' for the DB server in the CCP control panel.  Of course, that is the sort of thing they should have informed you of, particularly if they weren't going to make the transition seamless.  Another possibility is that you changed hosting companies at some time in the past, but for whatever reason, your DB was left on the old host.  Perhaps one of the many people you hired misunderstood your intentions and though you were renting two separate servers to split the load.  Based on the IP you had for the DB server, where is/was that server?  Is it one owned by your current hosting company?  One owned by a previous hosting company you used to use?  When you first posted, the IP in question was 216.227.209.128.  That IP appears to be a shared server, perhaps belonging to a company called 'LunarPages'... ring any bells?  It also appears to be a very full looking shared server, so I can't imagine it would have made a good place to host a DB.

I will have to still try and rebuild the data if I can but I was told we still might be able to get the store up in a condition when it was first built.  I think that is going on a couple of years ago but need to figure that out.

The script points to that IP but one of the guys says there is a DB that does not have a username setting there. 

He asked me to have the host give it a shot.

Here is what the host sent pack to me.

"I figured it may belong to the store, but there's no way for me to confirm this unless I point the store to it.

The problem with this is, I don't know where the config is stored... if you could ask the kryptonix support guys, in which pl file they store the DB info, I'll try!"

What should I tell the host on this.

Thanks
Jon

hmmm,

He says he needs to know where the "config is stored"

What should I tell him.