1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

db_admin_name is not being not changed

Discussion in 'SiteBuilder' started by vma, Feb 17, 2009.

  1. vma

    vma Guest

    0
     
    Hello,

    I have a fresh install of SiteBuilder 4.5 and I am having problems to configure it.

    I am trying to change the admin name for my database. I am using a name different as root. The command:

    # sb_config --db_admin_name adminuser --db_admin_passwd ********

    Returns with:

    Logs saved to /usr/local/sitebuilder/tmp/sb_config-0902170651.log

    But, then, when I try to change --sb_db_admin_name, sb_config returns with the message:

    [FATAL] Could not connect to database: Access denied for user 'root'@'localhost' (using password: NO)

    I understand as per my 1st command SiteBuilder should be using adminuser as the user and the password I provided instead NO password.

    Any idea?

    Thanks in advance

    Victor Marquez
     
  2. vma

    vma Guest

    0
     
    UPDATE:

    Just loged-in to my database server and found that sitebuilder3 database has been created. Also, there is a new user 'sitebuilder_db'.

    So, SiteBuilder used it's own user / password / database name. Now I am not sure if didi this when I instructed sb to use an specific user/password for db admin or if did it before, during the rpm install.

    I'd like to use my own parameters for database name / user / password.

    Thank you

    Victor Marquez
     
  3. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    It looks like default values were not updated for MySQL admin user name and password. You can check it by running 'sb_config --help'.

    Try to update following values with Mysql admin user and password in /usr/local/sitebuilder/utils/SB/Defaults.pm file (safe this file, just in case, before any modifications):

    'db_admin_name' => "root",
    'db_admin_passwd' => "",

    After that run the command one more time.
     
Loading...