Service: Mysql

[simbora]

Install

apt-get install mysql-server

Use a password for root from ENV['mysql_root_passwd'].

mysql_secure_installation

OBS: the above is interactive. Can we automate that using default answers?

Update /etc/mysql/my.cnf

- datadir = /var/lib/mysql
+ datadir = /data/mysql

[dzydzany]

Password will be set only during first ansible run. On other runs it will fail and will be ignored.

Question:
Environment variable on remote (provisioned) host or locally from your computer?

[rxaviers]

On Saturday, November 1, 2014, dzydzany [email protected] wrote:

Password will be set only during first ansible run. On other runs it will
fail and will be ignored

Ok

Question:
Environment variable on remote (provisioned) host or locally from your
computer?

Local computer please

—
Reply to this email directly or view it on GitHub
#11 (comment).

+55 (16) 98138-1582, +1 (415) 568-5854, skype: rxaviers
http://rafael.xavier.blog.br

[dzydzany]

All done, please test.

[rxaviers]

I ran it. But, it fails.

$ mysql_root_password=<passwd> ansible-playbook -i hosts site.yml --user root --ask-pass
...
NOTIFIED: [Restart apparmor service] ****************************************** 
failed: [morpheus] => {"failed": true, "item": ""}
msg: service not found: apparmor

FATAL: all hosts have already failed -- aborting

Please, create PRs for each issue you implement.

[dzydzany]

As AppArmor is installed and enabled in almost every Ubuntu installation, I've put a check, so if it is installed, reconfigure it, if not, do nothing.

AppArmor in Ubuntu:
https://wiki.ubuntu.com/AppArmor

[rxaviers]

After your update, AppArmor is getting skipped just fine.

[rxaviers]

On mysql installation, it should require the password environment variable to be set otherwise to abort.
On mysql already installed, it should not require it, therefore it should ignore in case it's not set.

Can that be implemented?

[dzydzany]

Currently it works this way: If you enter password as environemnt variable, it set it during run, if you forgot to create variable, it wont setup password. If you run ansible again and enter variable, and pasword is not set up, it will set it during that second run. I can try to check if variable is defined, and abort or ask for password if you wish.

[rxaviers]

The way you described it currently works is great.