Restoring from backup fails "Access denied for user 'debian-sys-maint'@'localhost'"

[Sam Morrison]

When I restore from a backup the instance goes to FAILED state. Upon investigating I see that mysql fails to start with the error:

ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

We are using Trusty as the Image and mysql-server-5.5 as the DB.

[Denis M. (dmakogon)]

This happens because of incorrect upstart script for guesagent.

[Sam Morrison (sorrison)]

Hi Denis,

Could explain a bit further as this comment doesn't help me fix the problem at all.

I can't see how the upstart script would be at fault here. The issue is the backup file has the debian-sys-maint user but the password is different to the newly created server as set in /etc/mysql/debian.conf (I may be missing something though? )

[Denis M. (dmakogon)]

Please take a look at http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-debian-sys-maintlocalhost/

[Sam Morrison (sorrison)]

HI Denis,

Yeah I'm well aware of what this user is for. The problem is though that trove fails to launch an instance that is restored from a backup. I am only guessing that it has something to do with this user as I log into the affected instance and see mysql isn't running. I try and start it and get this error. So either trove doesn't like this and it is a bug or I'm on the wrong track and the bug is due to something else. I've applied the patches that affects https://bugs.launchpad.net/trove/+bug/1343344 but still no luck.

[Amrith Kumar (amrith)]

Sam, I'm reverting this to Incomplete. Please update with additional information if and when it becomes available.

[Sam Morrison (sorrison)]

Here are full logs for the guest agent

http://paste.openstack.org/show/114031/

[Sam Morrison (sorrison)]

The one thing I notice is that the mysql config is wrong, it's just the default and not the one that is in the message that trove guestagent gets

[Sam Morrison (sorrison)]

Logs provided

[Amrith Kumar (amrith)]

Sam, thank you.

[Sam Morrison (sorrison)]

So do we know what is wrong here? Does restoring from backup work for other people?
Let me know how I can help more as currently I'm trying to roll out trove to our production cloud but it's useless without this working.

[Nikhil Manchanda (slicknik)]

Yes, restoring from backup works for us, as it does in the int-tests gate.
I'm not sure what exactly is causing you to hit this issue, but I suspect it's configuration of some sort. What version of mysql are you using, and what version of xtrabackup for the backup (and restore)?

[Launchpad Janitor (janitor)]

[Expired for OpenStack DBaaS (Trove) because there has been no activity for 60 days.]