• 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.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

problems with MySQL server (MariaDB)

f6n5i4qweuf

New Pleskian
Hi,

on the weekend I started renting a VPS from 1&1 and I now try to configure and update it. I chose openSUSE 13.1 with Plesk 12 (I can chose images from my provider to restore).

Unfortunately, I encounter problems with the MySQL server (MariaDB), when I try to update Plesk via
Code:
/usr/local/psa/admin/sbin/autoinstaller
, I get the following error:
Code:
===> Upgrading database

 Trying to start service mysql... done
 Trying to establish test connection... connected
done
 Trying to find psa database... version is 012000018
Version is OK, no need to create psa database.
 Trying to backup MySQL database... Warning: Not dumping MySQL database 'horde' as it doesn't exist
Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
 MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.12.0.18-12.0.18.20140812-154146.dump.gz
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
 Trying to allow INNODB engine... done
Restarting mysql Trying to restart service mysql... Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

WARNING!
Some problems are found during restart(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log)

Continue...


ERROR while trying to restart MySQL
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again

Even if I just enter
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
and then try to run
Code:
status
in MariaDB, I already receive an error:
Code:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: psa

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)
ERROR: Can't connect to the server
However, Plesk works fine if I don't try to update it (update via Plesk Panel also fails, respectively hangs and doesn't continue).

It's probably just a little thing to do but it I've googled so much and I still can't get it work.

Can you help me?

Thank you very much in advance!
 
Back
Top