Help! Latest yum upgrade broke plesk & site. Wont start. Donation for help!

[jayvin]

Please help, ran a 'yum upgrade' via ssh, which ive done many times before without issue (last 'yum upgrade' was about a week ago), im running on plesk 9.5.2 and it wont start after the latest yum upgrade (& site is down). yum reported it updated successfully. Psa wont restart.

I cant even connect via ssh. Please help, I need my vps. Willing to donate for help.

Fri Nov 19 06:25:23 2010 Operation start with the VPS(s) VEIDXXXXX service "psa" is started. Completed
Fri Nov 19 06:25:23 2010 Starting xinetd service... done Completed
Fri Nov 19 06:25:23 2010 Starting named service... done Completed
Fri Nov 19 06:25:23 2010 Starting mysqld service... done Completed
Fri Nov 19 06:25:23 2010 Starting postgresql service... not installed Completed
Fri Nov 19 06:25:23 2010 Starting psa-spamassassin service... not installed Completed
Fri Nov 19 06:25:25 2010 Plesk: Starting Mail Server... failed Completed
Fri Nov 19 06:25:25 2010 Starting mail handlers tmpfs storage Completed
Fri Nov 19 06:25:26 2010 Starting Plesk... failed Completed
Fri Nov 19 06:25:27 2010 Starting drwebd service... not installed Completed
Fri Nov 19 06:25:31 2010 Operation start with the VPS(s) VEIDXXXXX service "psa" is finished with errors: #703 Can not start/stop/restart service: service "psa" status is not "running" after command "start". Failed

Some info from the error logs:

[Fri Nov 19 04:36:21 2010] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations
pipelog: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
pipelog: Unable to connect to the mysql database

System error 25: Inappropriate ioctl for device
[Fri Nov 19 04:52:54 2010] [notice] caught SIGTERM, shutting down
[Fri Nov 19 04:53:11 2010] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Nov 19 04:53:11 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Fri Nov 19 04:53:11 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?

Error log:

[Fri Nov 19 04:35:50 2010] [notice] caught SIGTERM, shutting down
[Fri Nov 19 04:35:50 2010] [notice] mod_fcgid: process /var/www/vhosts/domain1.com/httpdocs/test/fcgi/test.fcgi(17680) exit(shutting down), get stop signal 15
[Fri Nov 19 04:36:21 2010] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Nov 19 04:36:21 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Fri Nov 19 04:36:21 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: domain1.com:443 (/var/www/vhosts/domain1.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: domain2.com:443 (/var/www/vhosts/domain2.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: default-87-106-100-128:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:79) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[Fri Nov 19 04:36:21 2010] [warn] module ssl_module is already loaded, skipping
[Fri Nov 19 04:36:21 2010] [notice] Digest: generating secret for digest authentication ...
[Fri Nov 19 04:36:21 2010] [notice] Digest: done
[Fri Nov 19 04:36:21 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Fri Nov 19 04:36:21 2010] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: domain1.com:443 (/var/www/vhosts/domain1.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: domain2.com:443 (/var/www/vhosts/domain2.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: SSL server IP/port conflict: default-87-106-100-128:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:79) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Fri Nov 19 04:36:21 2010] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[Fri Nov 19 04:36:21 2010] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations
pipelog: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
pipelog: Unable to connect to the mysql database

/var/log/sw-cp-server/error_log

2010-11-19 04:36:00: (log.c.135) server stopped
2010-11-19 04:36:19: (log.c.75) server started
2010-11-19 04:52:54: (log.c.135) server stopped
2010-11-19 04:53:09: (log.c.75) server started
2010-11-19 04:53:09: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:53:09: (log.c.75) server started
2010-11-19 04:53:09: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:53:17: (log.c.75) server started
2010-11-19 04:53:17: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:53:17: (log.c.75) server started
2010-11-19 04:53:17: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:57:28: (log.c.75) server started
2010-11-19 04:57:28: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:57:28: (log.c.75) server started
2010-11-19 04:57:28: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:57:35: (log.c.75) server started
2010-11-19 04:57:35: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:57:35: (log.c.75) server started
2010-11-19 04:57:35: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:59:04: (log.c.75) server started
2010-11-19 04:59:04: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address
2010-11-19 04:59:04: (log.c.75) server started
2010-11-19 04:59:04: (network.c.300) can't bind to port: 127.0.0.1 10001 Cannot assign requested address

mysql log file:

101119 4:36:02 [Note] /usr/libexec/mysqld: Normal shutdown

101119 4:36:02 [Note] Event Scheduler: Purging the queue. 0 events
101119 4:36:02 InnoDB: Starting shutdown...
101119 4:36:05 InnoDB: Shutdown completed; log sequence number 0 17965459
101119 4:36:05 [Note] /usr/libexec/mysqld: Shutdown complete

101119 04:36:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
101119 04:36:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101119 4:36:21 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
101119 4:36:22 [Note] Plugin 'ndbcluster' is disabled.
101119 4:36:22 InnoDB: Started; log sequence number 0 17965459
101119 4:36:22 [Note] Event Scheduler: Loaded 0 events
101119 4:36:22 [Note] /usr/libexec/mysqld: ready for connections.

Am desperate to get the site back, please help.

 

[jayvin]

Please im willing to pay for assistance.

I cant login via normal SSH but if I put virtuozzo into repair mode I can login to the root of the server via SSH (virtuozzo puts data into /repair directory).

I'm self employed and need it back online

 

[IgorG]

Please provide me OS version and output of 'rpm -q psa' command.
BTW, you should update VPS with 'vzpkg update VPS_ID' command from Virtuozzo node instead yum update inside VPS.

 

[jayvin]

Please provide me OS version and output of 'rpm -q psa' command.
BTW, you should update VPS with 'vzpkg update VPS_ID' command from Virtuozzo node instead yum update inside VPS.

Linux CentOS 5 with Plesk 9 (64-bit)

Are you saying I shouldnt be running the 'yum upgrade' command frequently?

and how do I:

update VPS with 'vzpkg update VPS_ID' command from Virtuozzo node instead yum update inside VPS.

I had to re-image server then apply backup. Im stuck on 9.5.2. If I run any more upgrades via 'yum upgrade' or via the plesk panel admin updater it breaks everything.

so now im stuck on a build I cannot update via 'yum upgrade' and cannot update via the plesk admin software updater.

I ran rpm -q psa and got this: psa-9.5.2-cos5.build95100504.10

Issue I detailed here along with other users having the same issue, support havent responded.

http://forum.parallels.com/showthread.php?p=429021

and

http://forum.parallels.com/showthread.php?t=105658

I also asked for help at the atomic forums here: http://www.atomicorp.com/forum/viewtopic.php?f=18&t=4549&start=0

 

[NorbertH]

Experienced the Same Problem

I had exactly the same problem on November 21st after a yum update on CentOS 5 (Virtual Private Server). Since this forum seems very quiet, I have posted details to http://atomicorp.com/forums/viewtopic.php?f=18&t=4549&p=26641#p26641.