uoi-io / ansible-galera Goto Github PK

Hi,

The playbook fail on Debian 8.5 with the following error message:

WARNING: The following packages cannot be authenticated! :  percona-toolkit percona-xtrabackup xtrabackup

You need to launch a apt-get update in your playbook before trying to install these packages.

This task: https://github.com/uoi-io/ansible-galera/blob/master/tasks/secure.yml#L9 actually does nothing.

It's either wrongly named (it does not actually disable anything) or does not what the author intended to write (remove all records for root except those three?)

FYI: the default mysql.user table on a fresh mariadb-server package installation on Ubuntu (xenial) looks this way:

MariaDB [mysql]> select Host,User,Password from user;
+-------------------+------------------+-------------------------------------------+
| Host              | User             | Password                                  |
+-------------------+------------------+-------------------------------------------+
| localhost         | root             | *D7DBCE5AF4004B1307B9E6D1F2DDBA11783B0D16 |
| mmedvecky-mariadb | root             | *D7DBCE5AF4004B1307B9E6D1F2DDBA11783B0D16 |
| 127.0.0.1         | root             | *D7DBCE5AF4004B1307B9E6D1F2DDBA11783B0D16 |
| ::1               | root             | *D7DBCE5AF4004B1307B9E6D1F2DDBA11783B0D16 |
| localhost         | debian-sys-maint | *F31116F9F769AA4B256569F15C7843E81AF1D5C7 |
+-------------------+------------------+-------------------------------------------+

(mmedvecky-mariadb is the name of my test host)

and playing the task on such host results in

TASK [Disabling remote access for root] ****************************************
ok: [db] => (item=localhost)
ok: [db] => (item=127.0.0.1)
ok: [db] => (item=::1)

I am actually looking for a correct way to add root access permitted from my own admin host.

Hello, Thanks very much for your playbook. I find some problems though. Would you like to help me fix them?

• We need to update percona_package: https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-3.noarch.rpm to percona_package: https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-6.noarch.rpm
• Then, I get the following: “The conditional check 'galera_sst_method' failed”. Maybe because I am quite new with ansible, but I do not understand what you want to check when you call galera_sst_method. Do you want to simply check if the program xtrabackup is installed? Or is it something else?
• Do you want a program called “xtrabackup-v2”? Or, are you trying to check the version of xtrabackup? There is no program called xtrabackup-v2, but I can use “xtrabackup -v2”.

Your help would be much appreciated ;)