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

Upgrade problem : Cannot connect to mysql server

Discussion in 'SiteBuilder' started by Dupont, Sep 29, 2008.

  1. Dupont

    Dupont Guest

    0
     
    Hello,

    I've got a problem when upgrading SiteBuilder from 4.2.0 to 4.5.0. Summary :

    1) vi /etc/apt/sources.list (deb http://autoinstall.plesk.com/debian/SiteBuilder_4.5.0 etch all)
    2) apt-get update
    3) apt-get -f upgrade (problem libc6 !)
    4) cd /var/cache/apt/archives
    5) dpkg -i --force-all libc6_2.3.6.ds1-13etch7_amd64.deb
    6) apt-get update
    7) apt-get -f upgrade

    Output :

    Cannot connect to mysql server. SiteBuilder configuration will exit now.
    Make sure mysql server is installed and running.
    If root password is not empty put it in /root/.my.cnf
    After finishing the installation run sb_config manually.

    8) vi /root/.my.cnf

    [mysqladmin]
    user = root
    password = *********

    9) apt-get -f upgrade

    (same error)
     
  2. Dupont

    Dupont Guest

    0
     
    Episode 2 :

    10) vi /root/.my.cnf

    [mysql]
    password=*****

    11) mysql

    (works. login automatically)

    12) apt-get -f upgrade

    Cannot connect to mysql server. SiteBuilder configuration will exit now.
    Make sure mysql server is installed and running.
    If root password is not empty put it in /root/.my.cnf
    After finishing the installation run sb_config manually.
     
  3. Dupont

    Dupont Guest

    0
     
  4. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    If Sitebuilder screen shows 4.5 version it looks like database was upgraded already.
    Did you try to run 'sb_config' utility for configuration?

    Try to set --db_admin_name and --db_admin_passwd password parameters for 'sb_config' utility using this way:

    # sb_config --db_admin_name root --db_admin_passwd ROOT_PASSWORD

    After that run "sb_config --update_modules --update_templates --update_locales"

    Also check Sitebuilder database version with following request:

    # mysql -uroot -pROOT_PASSWORD sitebuilder3 -e 'select * from config_param;'
     
Loading...