xenial guest agent broke mysql

[Ronan Lanore]

On Xenial when install trove-guestagent

agent make rsync of /var/lib/mysql on volume attached device but in a new sub directory named 'data'

So the mysql database directory is

/var/lib/mysql/data/mysql

instead of

/var/lib/mysql/mysql

This process break systemd pre exec because of

  if [ ! -d /var/lib/mysql/mysql ] && [ ! -L /var/lib/mysql/mysql ]; then
    echo "MySQL system database not found. Please run mysql_install_db tool."
    exit 1
  fi

[Amrith Kumar (amrith)]

given the little information provided in the bug it is hard to tell whether these are statements of facts, opinions, specific to some guest that the person used, a current or archaic version of mysql, what version of trove ...

fwiw, xenial support for mysql does exist in master (soon Ocata).

[Amrith Kumar (amrith)]

Not supported in that version, try master or wait for Ocata.

[Mark Kirkwood (mark-kirkwood)]

If you really want to get it going in Newton on Xenial, consider some minor hackery of the mysql guest agent:

trove/datastore/mysql_common/manager.py

and make a change at approx line 216 where the 'data'
 target directory is specified.

[Mark Kirkwood (mark-kirkwood)]

...alternatively commenting out the check for /var/lib/mysql/mysql in the systemd pre start seems to work (and is much less code to change)!