Running role on ubuntu 15.04/16.04 fails about ansible-role-mysql HOT 9 CLOSED

I had a similar issue on CentOS 7.1. If I manually create the /var/log/mysql.err file and chown it to mysql:mysql, then I am able to start the service.

from ansible-role-mysql.

According to the README, the default value for mysql_log_error is /var/log/mysqld.log, but in the defaults/main.yml file, it's /var/log/mysql.err.

from ansible-role-mysql.

Exactly the same here, with Ubuntu 15.04. Manually creating mysql.err and chown to mysql didn't fix it for me.

from ansible-role-mysql.

I'll hopefully have some time to test 15.04 soon; I have only tested the role (with MariaDB) on CentOS 7.x/6.x, and Ubuntu 14.04/12.04 so far.

from ansible-role-mysql.

hello, wondering if anyone's had luck on this. I got stuck on this step as well.

TASK: [geerlingguy.mysql | Ensure MySQL is started and enabled on boot.] ******

from ansible-role-mysql.

I was able to get past it by removing the Logging configuration section from templates/my.cnf.j2 and changing the value of mysql_log_error in defaults/main.yml from /var/log/mysql.err to /var/log/mysqld. I also had to make some other changes to get the role to work for me on CentOS 7.1 which are here: master...loc-rdc:master

from ansible-role-mysql.

thank you for the information. appreciate this role, very well thought out.

from ansible-role-mysql.

I'm still hoping to get to further testing for this soon... Ubuntu 16.04 will be out soon and I'll be making sure everything works well there.

from ansible-role-mysql.

Working on 16.04 testing with my new Vagrant minimal base box for Drupal VM here: geerlingguy/drupal-vm#573 — and I can get MySQL running, now I'm just making sure it's easy to duplicate the setup in this role.

Aside: Yet again, Ubuntu has decided they should add yet more config directories and paradigms all over the place for their system packages. GAAAH!

from ansible-role-mysql.