Update from 8.4 to 8.6 get a error

[Edmund@]

Hi Folks,

i have a big Problem i hope you can please Help me,

i have make a Update on a Linux SuSE 9.3 Server from 8.4 to 8.6 over the Plesk webconfig, but the Updatet get a error "Plesk autoupdate failure"

and now i can not Start the "psa" Service, so my Plesk is not running :-(

Please Help me, when you need more logs no problem, tell me

i hope you can help me

when i start the psa Service:

s15224170:/etc/init.d # ./psa start
Starting xinetd service... done
Starting named service... done
Starting mysql service... done
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... not installed
Syntax OK
Starting Plesk... done
Starting drwebd service... not installed

s15224170:/etc/init.d # ./psa status
psa dead but subsys locked
s15224170:/etc/init.d #


i have Try this, but this whos dont work

cd /root/psa/PSA_8.6.0/dist-rpm-SuSE-10.1-x86_64/base
rpm -Uvh * --force

her is the Install Update log:

http://www.ejro-it.de/error.txt

 

[Ma2T]

I'm a big time novice to plesk, so i'm far from an expert.

But after looking through your install error log, the problems seem to happen after mysql tries (and fails) to restart.

===> Installing psa database
Trying to start MySQL server... Trying to define valid mysql credentials... Trying to establish test connection...

Check the error reason(see log file: /tmp/psa_8.6.0_suse9.3.build86080722.00_upgrade.080815.15.56.log

Seems to me that you need to fix the connection to mysql, then it might work okay?

 

[Edmund@]

Hi Ma2T,

hmm when i look in the log file (/tmp/psa_8.6.0_suse9.3.build86080722.00_upgrade.080815. 15.56.log)

he can not conect to MySQL, but MySQL works fine

all outer webseits can working whis my MySQL.

i can seein the log file he can not open the /root/.my.cnf file,

the file dont exist on my Server

do you have i idee ???


===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash
/bin/rbash is already registered as login shell

Trying to restart service mysql... Checking for service MySQL: ..running
done
===> Installing psa database
Trying to start MySQL server... Checking for service MySQL: ..running
Trying to define valid mysql credentials... Trying to establish test connection... ERROR 2013 (HY000): Lost connection to MySQL server during query
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Trying to establish test connection... Could not open required defaults file: /root/.my.cnf
Fatal error in defaults handling. Program aborted

ERROR while trying to establish test connection

Aborting...

 

[Ma2T]

Hi Edmund,

Thats intersting that Mysql still works for other sites, I don't know :/ . Sorry I can't help you more.

I hope someone who knows more will reply for you.

 

[hardweb]

This issue can have roots in multiple issue, anyway you should check what's the problem with MySQL. Take a look to the MySQL log file and startup options (although these should not have changed). With access to the server it's not difficult to solve.

 

[Edmund@]

this is the MySQL Log ( /var/lib/mysql/mysqld.log )


080901 13:28:38 mysqld ended

080901 13:28:43 mysqld started
080901 13:28:43 InnoDB: Started; log sequence number 0 32495542
/usr/sbin/mysqld: ready for connections.
Version: '4.1.10a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
080901 14:15:57 [Note] /usr/sbin/mysqld: Normal shutdown

080901 14:15:57 InnoDB: Starting shutdown...
080901 14:16:01 InnoDB: Shutdown completed; log sequence number 0 32499625
080901 14:16:01 [Note] /usr/sbin/mysqld: Shutdown complete

080901 14:16:01 mysqld ended

080901 14:16:01 mysqld started
080901 14:16:01 InnoDB: Started; log sequence number 0 32499625
/usr/sbin/mysqld: ready for connections.
Version: '4.1.10a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM

@hardweb
"With access to the server it's not difficult to solve."

do you will access on the Server? and help me?

 

[Edmund@]

Hi

when i start psa.safe

psa show this

s15224170:/etc/init.d # ./psa.save start
xinetd on
Starting INET services. (xinetd) done
named 3
Starting name server BIND - Warning: named already running! done
mysql 3
Starting service MySQL done
qmail on
Starting qmail: done
apache2 on
Syntax OK
Cannot read ''
/usr/local/psa/admin/bin/httpsdctl start: httpd could not be started
Starting Plesk: failed
s15224170:/etc/init.d # ./psa.save status
psa is stopped
s15224170:/etc/init.d #


i think the Problem is on httpsd

 

[Edmund@]

my Problem is solvd from Parallels Support

-------------------

Plesk manual upgrade generated the following errors:

error: db4 error(22) from db->cursor: Invalid argument
rpmdb: illegal flag specified to DB->cursor
error: db4 error(22) from db->cursor: Invalid argument

It indicates the rpm database corruption.
I have rebuilt it with:
rm -f /var/lib/rpm/__db.00*
rpm -vv --rebuilddb

After that I have launched the manual upgrade, it was necessary because the Plesk database was not properly upgraded:
s15224170:~ # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from misc where param = 'version';"
+---------+------+
| param | val |
+---------+------+
| version | 0840 |
+---------+------+

I have launched the upgrade with:
s15224170:~/psa/PSA_8.6.0/dist-rpm-SuSE-9.3-i386 # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from misc where param = 'version';"

After that the database was upgraded, Plesk CP is up and running.