admin→backup failed Can't connect to mysql server localhost
admin→backup failed Can't connect to mysql server localhost
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?
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?
Re: admin→backup failed Can't connect to mysql server localh
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
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
Re: admin→backup failed Can't connect to mysql server localh
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
sudo /usr/local/vesta/bin/v-update-sys-queue disk
Re: admin→backup failed Can't connect to mysql server localh
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!
Any admin have idea?
Thanks!
Re: admin→backup failed Can't connect to mysql server localh
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.
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.
Re: admin→backup failed Can't connect to mysql server localh
We already know about this problem/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
Re: admin→backup failed Can't connect to mysql server localh
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.
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.
Re: admin→backup failed Can't connect to mysql server localh
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 wrote: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.
Re: admin→backup failed Can't connect to mysql server localh
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 !!
I consider "service mysql stop && service mysql start && dpkg-reconfigure mysql-server-5.5" the definitive solution.
Have a wonderful Vesta experience !!
Re: admin→backup failed Can't connect to mysql server localh
Excuse me, but how to solve the same problem on Centos 6.5 ? Many thanks!