admin→backup failed Can't connect to mysql server localhost

[Graham]

Hi All,

I've noticed in the last few servers I've built that I'm constantly getting the following error via email:

admin → backup failed Can't connect to mysql server localhost

I only use Ubuntu so I'm not sure if this issue is related to that specific O/S, version is either 12.04 or 14.04 hosted at Digital Ocean.

With the intention of troubleshooting the issue, I built a clean server last night. Here's my install routing:
Ubuntu 14.04 install, standard Digital Ocean image 1GB RAM server.
Installed Vesta
Removed bind9 and exim4.
Diasbled Dovecot upstart job.
Removed DNS domains.
Removed mail domains.
rebooted server.

It was getting late so I stopped there, no sites defined, no users, no databases etc other than the our of the box Admin user and database.

This morning when I got up, an email waiting for me "admin→backup failed Can't connect to mysql server localhost". Tried creating a new backup from the control panel, same error.

Power cycled the server and tried creating another backup from the control panel, backup completed.

If the previous servers are anything to go by, this will happen again in the next couple of days.

Anyone any suggestions as to the cause of this or which log files I can check to investigate further. Or better yet, anyone else had this and found a fix?

[Graham]

I'm not sure if this is related but I got another error this morning. I have made no changes to the server since my post yesterday.

Error: Connection failed
/usr/local/vesta/func/main.sh: line 55: [: 15 2014-05-27 02:15:01 v-update-database-disk admin admin_default : integer expression expected

I just completed a 'rebuild db' for the admin user, follower by a general 'rebuild'.

Attempted a backup from the panel and received the usual email:

admin → backup failed Can't connect to mysql server localhost

[Graham]

Just to add, I managed to run the failed task successfully directly from the server command line:

sudo /usr/local/vesta/bin/v-update-sys-queue disk

[dezagus]

I have the some problem. But in my case is about I have changed the root password of mysql, cuz I can't acces like root with the default values.

Any admin have idea?

Thanks!

[Graham]

Hmm, this is getting weirder.

The same VM, still no changes made to it from clean build (other than those above) and now I got this error by email this morning:

/usr/local/vesta/bin/v-update-sys-vesta-all: line 13: /func/main.sh: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 14: /conf/vesta.conf: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory

The really strange thing is when I run "sudo /usr/local/vesta/bin/v-update-sys-vesta-all" it runs without problem.

[imperio]

/usr/local/vesta/bin/v-update-sys-vesta-all: line 13: /func/main.sh: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 14: /conf/vesta.conf: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory
/usr/local/vesta/bin/v-update-sys-vesta-all: line 23: /v-update-sys-vesta: No such file or directory

We already know about this problem

[fedekrum]

The mysql tends to stop on vesta installations on digital ocean ubuntu droplets at least.
This causes a user backup to fail when trying to get the databases for the backup.
Take a look at Vesta and Digital Ocean (MySQL stops frequently)viewtopic.php?f=10&t=5222 for a possible solution.

[Graham]

The mysql tends to stop on vesta installations on digital ocean ubuntu droplets at least.
This causes a user backup to fail when trying to get the databases for the backup.
Take a look at Vesta and Digital Ocean (MySQL stops frequently)viewtopic.php?f=10&t=5222 for a possible solution.

Thanks fedekrum, I see you've had no issues in 20 hours. Would you mind reporting back over the next few days and sharing with us again.

[fedekrum]

After other 26 hours (46 total), mysql database did not stop.
I consider "service mysql stop && service mysql start && dpkg-reconfigure mysql-server-5.5" the definitive solution.

Have a wonderful Vesta experience !!

[spelot]

Excuse me, but how to solve the same problem on Centos 6.5 ? Many thanks!