tklbam-restore cannot restore databases, mysql connection error

Some extra experiments:

• tklbam-restore from hub to fresh local virtualbox vm *or* hub-to-hub.
• 12.1 redmine and wordpress, amd64 and x86.
• All fail to restore databases because mysql has been stopped on the destination, resulting in the "ERROR 2002 (HY000)", mentioned above.
• All have the same passwords set at boot (or hub launch).

This behaviour does not occur with 11.3 appliances - is this a tklbam-restore bug in 12.1 appliances? tklbam is of limited use if it cannot restore the databases.

If it is not a tklbam bug, then does anyone have any idea why this is occuring?

Aaron.

Have the same issue with 12.1-core-x64 with mysql installed there. This is a showstopper bug.

I took the liberty of opening a new issue on the TurnKey Dev Tracker on GitHub:

https://github.com/turnkeylinux/tracker/issues/40

I too feel that this is a showstopper.  I am consistently seeing this with v12.1 appliances that include MySQL, such as LAMP and WordPress.

On a local guest machine, when applying a TKLBAM restore to a freshly created appliance (of the same exact type that was previously restored),

[1] the log shows:

> Restoring databases
> ===================
> SKIPPING MYSQL DATABASE RESTORE: mysql error (1): ERROR 2002 (HY000): Can't connect to local
> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
>
> We're done. You may want to reboot now to restart all services.

[2] WordPress shows: "Error establishing a database connection"

[3] MySQL server is up, but not running properly.  Connecting to MySQL with phpMyAdmin shows
     "Connection for controluser as defined in your configuration failed."

I have verified that the above does not occur with v11.3 or v12.0 appliances.

On the other hand, when the hub is used to "restore a backup to a new cloud server", MySQL server is down and efforts to bring it up do not succeed.  As before, WordPress shows: "Error establishing a database connection"

Works flawlessly for me, even without a reboot (both on the hub and on my VMware guest)!

apt-get update
apt-get install tklbam

And whether it is a TKLBAM issue or one with AWS... Looking at your log, it seems that there was an AWS DHCP issue, although in my experience that shouldn't stop your server from starting. However it may make it uncontactable via normal means.

My suggestion would be to stop it and start it again (assuming that it's a EBS backed server).

Specifically, I installed Redmine (TurnKey 12.1) on a local VM, created a test project, and backed it up to our test Hub account. I then launched a Redmine instance on EC2 and restored the backup.

I suggest you take advantage of the new TKLBAM v1.3 features to try to isolate what is it about your backup that is causing the restore to fail:

tklbam-restore --raw-download=/tmp/mybackup

# take a peek
cd /tmp/mybackup
find
# edit/remove files you suspect may be causing the problem

# now let's try to restore the "edited" backup
tklbam-restore /tmp/mybackup

# doesn't work?
tklbam-restore-rollback

# rinse repeat

Hi JB,

I tested the backup/restore process with Wordpress earlier today (e.g., 12.1 => 12.1 and 12.1 => 13.0) and everything seems to be working perfectly.

Anyhow, your best bet would be to investigate what is actually in your backup with the latest version of TKLBAM. The backup structures are human readable. Try these commands:

apt-get update

apt-get install tklbam

tklbam-restore --raw-download=/tmp/yourbackup your-backup-id

You can use tklbam-restore-rollback to rollback the restore and try again as many times as you like.

PS: FWIW TKLBAM is a free service. Perhaps you meant you are signed up to the Hub's cloud deployment service? In any case you're not actually "forking" any money over to TurnKey for TKLBAM. The service is provided at cost which means you only get charged the regular S3 storage fees. In fact we actually lose a little bit of money providing it to you because Amazon charge us for per-user subscription fees.

Thanks a lot - i will go ahead and do that!

If you are having an intermittent problem with "Error establishing a database connection" on your TKL WordPress site then it is unlikely to be this issue IMO (unless of course that it happens following backup/restore).

Your best bet is to start a new thread and provide details of what version of TKL you are running, where your appliance is running (e.g. AWS, including size and region) and the steps required to reproduce the issue.

An intermittent issue may just be caused by insufficient RAM for the load your server is getting...?

I am also seeing the same issue with wordpress + mysql: "Error establishing a database connection"

I was wondering if there are any ideas how to troubleshoot this error? for me it shows up periodically on the website..