diff options
Diffstat (limited to 'lamp_simple/roles/db/tasks/main.yml')
-rw-r--r-- | lamp_simple/roles/db/tasks/main.yml | 37 |
1 files changed, 29 insertions, 8 deletions
diff --git a/lamp_simple/roles/db/tasks/main.yml b/lamp_simple/roles/db/tasks/main.yml index 7f09ca0..2afc406 100644 --- a/lamp_simple/roles/db/tasks/main.yml +++ b/lamp_simple/roles/db/tasks/main.yml @@ -2,7 +2,9 @@ # This playbook will install mysql and create db user and give permissions. - name: Install Mysql package - yum: name={{ item }} state=installed + yum: + name: "{{ item }}" + state: installed with_items: - mysql-server - MySQL-python @@ -10,24 +12,43 @@ - libsemanage-python - name: Configure SELinux to start mysql on any port - seboolean: name=mysql_connect_any state=true persistent=yes + seboolean: + name: mysql_connect_any + state: true + persistent: yes when: sestatus.rc != 0 - name: Create Mysql configuration file - template: src=my.cnf.j2 dest=/etc/my.cnf + template: + src: my.cnf.j2 + dest: /etc/my.cnf notify: - restart mysql - name: Start Mysql Service - service: name=mysqld state=started enabled=yes + service: + name: mysqld + state: started + enabled: yes - name: insert iptables rule - lineinfile: dest=/etc/sysconfig/iptables state=present regexp="{{ mysql_port }}" - insertafter="^:OUTPUT " line="-A INPUT -p tcp --dport {{ mysql_port }} -j ACCEPT" + lineinfile: + dest: /etc/sysconfig/iptables + state: present + regexp: "{{ mysql_port }}" + insertafter: "^:OUTPUT " + line: "-A INPUT -p tcp --dport {{ mysql_port }} -j ACCEPT" notify: restart iptables - name: Create Application Database - mysql_db: name={{ dbname }} state=present + mysql_db: + name: "{{ dbname }}" + state: present - name: Create Application DB User - mysql_user: name={{ dbuser }} password={{ upassword }} priv=*.*:ALL host='%' state=present + mysql_user: + name: "{{ dbuser }}" + password: "{{ upassword }}" + priv: "*.*:ALL" + host: '%' + state: present |