cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot log onto MySQL CMS Database after network installation

Former Member
0 Kudos

Post Author: matthewh

CA Forum: Authentication

I've just installed Crystal Server XI R2 on a brand new server running MySQL 5.0.45 but when the installation completes it says it can't log on to the CMS database. It's created the empty database and I have the db.opt file in there but nothing else - no tables or anything. I've re-run the installation and done a repair and Modify but with no change. The CMS user has full rights to the MySQL instance for now, so it shouldn't have been an issue. Is there a SQL script available I can run to build the initial db manually? Do I need to uninstall and go through it all again? took over 2 hours across the network and the server is in another part of the country.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Post Author: daksri

CA Forum: Authentication

Hi:I was searching to CMS database table info, and came across your inquery. I thought you might help on this. I would like to know how many tables, and what their names in CMS.

Can you please help me on this ?Regards,

dak

Former Member
0 Kudos

Post Author: TAZ

CA Forum: Authentication

You should be able to login with Administrator and blank password. To the CMC anyway. To note the rebuild of the CMS will mean there is no license key and you won't be able to login to anything else until you add the key back via CMC.

Regards,

Tim

Former Member
0 Kudos

Post Author: matthewh

CA Forum: Authentication

That's got the db built and the cms started, so thanks for that - but can't log on now.

Former Member
0 Kudos

Post Author: TAZ

CA Forum: Authentication

Hi Matthew,

I'm not sure why you cannot access your mysql DB but you do not have to reinstall.

Launch the CCM(central configuration manager) If the CMS is not stopped then stop it.

double-click on the CMS choose configuration, choose specify, choose recreate the current data source.

This will reinitialize the CMS DB if the account configured has the proper permissions. It should be a DB owner

Regards,

Tim