Upgrading from 9.2.3 to 10.1.1

[PTS]

I just got a new dedicated server which has Plesk 9.2.3 installed.

What is the best and safest way to update to the most current version?

Should I upgrade directly to 10.1.1 or update to each individual version one at a time?

 

[lhwparis]

new server? update directly to 10.1.1

 

[PTS]

Ouch, upgraded from 9.2.3 to 10.1.1 and the system pretty much exploded. I upgraded via CLI.

Massive errors on login like:

Internal error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_productUpgrades' doesn't exist

ERROR: Zend_Db_Statement_Exception
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_apsInstances' doesn't exist

Going to reprovision server and try upgrading again version by version.

 

[IgorG]

It looks like database was not correctly upgraded. Try to do it with http://kb.odin.com/en/9330

 

[lvalics]

After update

Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'

Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

 

[IgorG]

Did you try bootstraper repair as it is described in KB article?

 

[lvalics]

Yes, I did, just mail restore is around 2 hours of update
Over 5000 email address.

Now seems to be working.
But still update is not done

 

[ReinhartK]

hi, i have the same problem

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

and in plesk:

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

0: common_func.php3:95
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)')
1: auth.php3:124

when i restart my server the panel shows:

Panel-Version 10.0.1

but the updater shows:

Panel-Version 10.1.1

we can that be?
when i go to the link "domains" plesk shows:

Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

it was a automatic update from 10.0.1 to 10.1.1 - are we just beta-testers?

 

[IgorG]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Your mysql server was not running for some reason during upgrade procedure. Therefore database was not correctly upgraded without connection to mysql server.

 

[ReinhartK]

websites are available, mysql run - but it does not a restart, just when i restart the whole server.

plesk show the following message just in "clients, domains, abonnements":

Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

all other meuitems (serversettings, tools, modules, etc.) working normal.

 

[ReinhartK]

now i got emails:

Unable to update . An error occurred while processing your key. You can try updating it later.

whats wrong with paralells?
just build plesk for paid support?

 

[IgorG]

Did you try it? http://forum.parallels.com/showpost.php?p=436589&postcount=4

 

[ReinhartK]

yes i tried:

/usr/local/psa/bin/init_conf --update -passwd ********

ERR (3): Unable to update local admin information in local Plesk Billing: Execution failed.
Command: billing_update_admin
Details: The following SSO error occurred: (HTTP code: )

SUCCESS: Completed updating administrator's information.

i have 3 folders in /usr/local/psa/bootstrapper

pp10.8.0-bootstrapper
pp10.9.0-bootstrapper
pp10.10.0-bootstrapper

bootstrapper repair:

Trying to start service mysql... Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds

**** Product repair started.

===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Create group swkey-data
Checking for the group 'swkey-data'...
Group 'swkey-data' already exists

Checking for the group 'swkey-data'...
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create Mail accounts
Checking for the group 'popuser'...
Group 'popuser' already exists

Checking for the user 'popuser'...
User 'popuser' already exists

Checking for the user 'mhandlers-user'...
User 'mhandlers-user' already exists

Trying to got legacy variables... done
Trying to save legacy variables... done
Checking for the system groups and users necessary for ftp server...
Checking for the group 'psaftp'...
Group 'psaftp' already exists

Checking for the user 'psaftp'...
User 'psaftp' already exists


Trying to start service mysql... Checking for service MySQL: ..unused
done
Checking for the system groups and users necessary for Apache...
Checking for the group 'www'...
Group 'www' already exists

Checking for the user 'wwwrun'...
User 'wwwrun' already exists


===> Checking for the necessary system accounts
Checking for the system groups and users necessary for MySQL...
Checking for the group 'mysql'...
Group 'mysql' already exists

Checking for the user 'mysql'...
User 'mysql' already exists

Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'wwwrun'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists

Trying to start service mysql... Checking for service MySQL: ..unused
done
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
*************************** cut line 79 - 135, same content ***********************************
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/pp10.10.1-bootstrapper.110203.12.30.log), fix and try again


**** Product repair failed.

***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/pp10.10.1-bootstrapper.110203.12.30.log), fix and try again

and all the same.....

 

[IgorG]

Trying to start service mysql... Checking for service MySQL: ..unused
done
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

Are you sure that your MySQL server is started?

 

[ReinhartK]

yes, all websites with mysql databases are running (wbb3, joomla, etc.)

 

[IgorG]

According to

Checking for service MySQL: ..unused

MySQL server is not running.

 

[ReinhartK]

youre right, i made:
/etc/init.d/mysql status

and it shows:
Checking for service MySQL: unused

now i make:
/etc/init.d/mysql start

then it shows:
Trying to start service mysql... Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds

and all websites are down...............

 

[IgorG]

Well. Now I know that you should fix your MySQL server...

 

[ReinhartK]

when you tell me what plesk had done with my sql server......

 

[ReinhartK]

its BIND that block the port 3306!

made:
rcnamed stop

then:
/etc/init.d/mysql start

and:
rcnamed start

now it shows after:
/etc/init.d/mysql status

Checking for service MySQL: running

but always the same message in plesk:

Internal error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
Message SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.custom' in 'where clause'
File Pdo.php
Line 238
Type Zend_Db_Statement_Exception

and to the link: http://kb.odin.com/en/9330

my password doesnt contains a + or %, etc. just numbers and letters


EDIT:

it works now, the second try was successfull!

thank you igor!