Skip to Content
author's profile photo Former Member
Former Member

Cannot log onto MySQL CMS Database after network installation

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2007 at 01:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2007 at 02:36 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 13, 2007 at 09:08 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2007 at 03:55 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.