• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • Our UX team believes in the in the power of direct feedback and would like to invite you to participate in interviews, tests, and surveys.
    To stay in the loop and never miss an opportunity to share your thoughts, please subscribe to our UX research program. If you were previously part of the Plesk UX research program, please re-subscribe to continue receiving our invitations.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Upgrade problem : Cannot connect to mysql server

D

Dupont

Guest
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)
 
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.
 
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;'
 
Back
Top