Upgrade problem : Cannot connect to mysql server

[Dupont]

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)

 

[Dupont]

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.

 

[Dupont]

Episode 3 :

13) I gave up and tried to downgrade to 4.5.0 :

cp -rf /home/sitebuilder4.2.0 /home/sitebuilder4.5.0

14) apachectl restart

15) http://mysitebuilder.com/Login (says 4.5.0)
http://mysitebuilder.com/Admin/License (says 4.5.0)

16) How to get back to 4.2.0 ?

 

[Dmitry Frantsev]

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;'