PLesk 8.6 failure - can`t login

[Markus K.]

[Solved] PLesk 8.6 failure - can`t login

Sorry, where can I ask for a troubleshooting with Plesk 8.6?
I updated before and now I can`t login to the plesk - control - center .

I got this message with the autoinstaller:

===> Installing psa database
Trying to start MySQL server... Trying to define valid mysql credentials... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection... Trying to establish test connection...
ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/psa_8.6.0_suse10.0.build86080722.01_upgrade.080729.01.09.log), fix and try again

Aborting...

error: %post(psa-8.6.0-suse10.0.build86080722.01) scriptlet failed, exit status 1
Trying to install PAM module... done
Trying to start MySQL server... Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to upgrade persistent database storage... done
ERROR: An error occurred during installation of packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

What can I do?

Markus

 

[Dreamforge]

Can you post the content of /tmp/psa_8.6.0_suse10.0.build86080722.01_upgrade.080729 .01.09.log so we can have an eye on this ?

 

[trevyn]

Same problem ...

Greetings,

I do experience same problem ... here comes the logfile:

START psa-8.6.0-suse10.1.build86080722.00 upgrading AT Tue Jul 29 14:14:27 CEST 2008

Trying to start MySQL server... Checking for service MySQL: ..running

===> 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

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

Trying to start MySQL server... Checking for service MySQL: ..running
Trying to establish test connection... connected
done
`/var/lib/psa/dumps/mysql.preupgrade.dump.gz' -> `/var/lib/psa/dumps/mysql.preupgrade.dump.gz.4'
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.dump.gz
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

STOP psa-8.6.0-suse10.1.build86080722.00 upgrading AT Tue Jul 29 14:14:30 CEST 2008
START psa-8.6.0-suse10.1.build86080722.00 upgrading AT Tue Jul 29 14:14:51 CEST 2008
Trying to register service xinetd... using /sbin/insserv
done
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)


===> 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 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
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...

STOP psa-8.6.0-suse10.1.build86080722.00 upgrading AT Tue Jul 29 14:14:57 CEST 2008

The mysql-server is running fine.

 

[trevyn]

Ok - I checked with a few things that helped in such cases in the past and it looks like it found something - maybe it helps others also:

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

and now plesk works fine again.

Of course: The package depends on the individual system.

 

[Dreamforge]

OK, just to make sure that mysql-server is running fine :

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
You should end connected to the database with the mysql prompt "mysql>"
Just an idea, if you can connect to the database, try to modify this :

$conf['sql']['username'] = 'horde'; to $conf['sql']['username'] = 'admin';
in /usr/share/psa-horde/config/conf.php

I had a problem like this a long time ago..
If it don't work after that...revert back the changes you've made to /usr/share/psa-horde/config/conf.php and try to locate de mysql.sock using :

find / | grep mysql.sock
And compare the path to the one contained in /etc/my.cnf
If different try to fix it either by changing the socket location in my.cnf according to the one the installer needs and restart mysql....or maybe just use a symbolic link to the optimation location

These are just ideas....
Keep us informed

 

[Markus K.]

Ok - I checked with a few things that helped in such cases in the past and it looks like it found something - maybe it helps others also:

and now plesk works fine again.

Of course: The package depends on the individual system.

Thank you very much, this worked.
Now I can login again!

 

[thedust2010]

I am having a similar issue - all services are operating just fine except the psa service won't start. The Plesk control panel is unaccessible. I'm just wondering if using the "rpm -Uvh * --force" command is at all hazardous. Could it potentially screw something up or is it a rather safe operation?