---
################# upgrade mysql and php for installation
# 1. create backup for databases in found sites
# 2. configure remi repository,  enable default 
# 3. upgrade configuration files for php 
# 4. upgrade mysql (mysql_upgrade)
- name: upgrade mysql and php
  hosts: bitrix-hosts
  vars:
    cluster_enabled: disable
  gather_facts: True
  tasks:
    - include_vars: /etc/ansible/roles/common/vars/default.yml

    - include_vars: /etc/ansible/group_vars/bitrix-mysql.yml

    - include_vars: /etc/ansible/group_vars/bitrix-web.yml

    - fail:

    - name: get host info
      bx_vat:

    - name: change cluster mark if web cluster configured
      set_fact: cluster_enabled=enable
      when: "cluster_web_configure == 'enable'"
      tags: sites

    - name: change cluster mark if mysql cluster configured
      set_fact: cluster_enabled=enable
      when: "cluster_mysql_configure == 'enable'"
      tags: configure_site

    - name: gathering facts about installed sites
      delegate_to: "{{ monitoring_server }}"
      bx_facts:
        name=list
        password=0
        install='(kernel|ext_kernel)'
      tags: sites

    - name: create variable bx_sites_info
      set_fact:
        bx_sites_info: "{{ hostvars[inventory_hostname]['bx_sites'] }}"
      tags: sites

    - name: create backup folder
      delegate_to: "{{ monitoring_server }}"
      file:
        path={{ item }}
        state=directory
        owner=bitrix
        group=bitrix
        mode=0770
      tags: backup
      with_items:
        - "/home/bitrix/backup"
        - "/home/bitrix/backup/archive"
      when: "inventory_hostname == master_server"

    - name: test default my.cnf file exist in the system
      delegate_to: "{{ monitoring_server }}"
      stat:
        path=/root/.my.cnf
        get_md5=no
      register: my_cfg_stat

    - name: create /root/.my.cnf
      delegate_to: "{{ monitoring_server }}"
      template:
        src=templates/upgrade-my.cnf.j2
        dest=/root/.my.cnf
        owner=root
        group=root
        mode=0600
      when: "inventory_hostname == master_server and not {{ my_cfg_stat.stat.exists }}"

    - name: create backup files general case
      delegate_to: "{{ monitoring_server }}"
      with_items: "{{ bx_sites_info }}"
      mysql_db:
        name="{{ item.DBName }}"
        state=dump
        target="/home/bitrix/backup/archive/update_{{ item.DBName }}.sql.bz2"
        login_unix_socket="{{ mysql_socket }}"
      when: "cluster_enabled == 'disable' and inventory_hostname == master_server"
      tags: backup

    - name: create backup files cluster case
      delegate_to: "{{ monitoring_server }}"
      with_items: "{{ bx_sites_info }}"
      mysql_db:
        name="{{ item.DBName }}"
        state=dump
        target="/home/bitrix/backup/archive/update_{{ item.DBName }}.sql.bz2"
        login_host="{{ master_server }}"
      when: "cluster_enabled == 'enable' and inventory_hostname == master_server"
      tags: backup

    - name: save list php disabled modules
      bx_php: action=safe

    - name: upgrade bitrix-env
      yum:
        name={{ bx_package_name }}
        state=latest
      tags: bitrix

    - name: import gpg-keys
      shell: rpm --import "http://rpms.famillecollet.com/RPM-GPG-KEY-remi"
        creates=/etc/pki/rpm-gpg/RPM-GPG-KEY-remi
      tags: php54

    - name: install Remi repository
      yum:
        name="http://rpms.famillecollet.com/enterprise/remi-release-6.rpm"
        state=present
      tags: php54

    - name: enable remi main repository
      ini_file:
        dest=/etc/yum.repos.d/remi.repo
        section=remi
        option=enabled
        value=1
      tags: php54

    - name: update system by remi repository
      yum:
        name=*
        state=latest
      tags: php54

    - name: install opcache for new version
      yum:
        name=php-pecl-zendopcache
        state=latest
      tags: php54

    - name: test apcu module in php
      shell: /usr/bin/php -m
      register: phpmodules
      always_run: yes 

    - name: delete apc configuration file
      file:
        path=/etc/php.d/apc.ini
        state=absent
      when: phpmodules.stdout.find("apcu") != -1
      tags: php54

    - name: create apcu php54 configuration file
      template:
        src=templates/{{ item }}.j2
        dest=/etc/php.d/{{ item }}
        mode=0644
        owner=root
        group=root
      with_items:
        - "apcu.ini"
      when: phpmodules.stdout.find("apcu") != -1
      tags: php54

    - name: replace max_input_vars in bitrixenv.ini
      lineinfile:
        dest=/etc/php.d/bitrixenv.ini
        regexp='^max_input_vars '
        line='max_input_vars = 10000'
        mode=0644
        owner=root
        group=root
      tags: php54

    - name: restore list php disabled modules
      bx_php: action=restore

    - name: disable new unused modules
      shell: mv /etc/php.d/{{ item }} /etc/php.d/{{ item }}.disabled
        creates=/etc/php.d/{{ item }}.disabled
      with_items:
        - gmp.ini
        - posix.ini
        - sybase_ct.ini
        - sysvmsg.ini 
        - sysvsem.ini
        - sysvshm.ini
        - wddx.ini
        - xsl.ini

    - name: create terminator for next update
      file:
        path=/etc/php.d/{{ item }}
        state=touch
      with_items:
        - gmp.ini
        - posix.ini
        - sybase_ct.ini
        - sysvmsg.ini 
        - sysvsem.ini
        - sysvshm.ini
        - wddx.ini
        - xsl.ini

    - name: add configuration options in mysql service for upgrade time
      template:
        src=templates/upgrade_mysql.cnf.j2
        dest=/etc/mysql/conf.d/upgrade_mysql.cnf
        owner=root
        group=mysql
        mode=0664
      tags: mysql55

    - name: restarted mysql service
      service:
        name=mysqld
        state=restarted
      tags: mysql55

    - name: disable sql_log_bin for upgrade
      mysql_variables:
        variable=sql_log_bin
        value=0
        login_unix_socket={{ mysql_socket }}
      tags: mysql55
      when: "cluster_mysql_configure == 'enable' and inventory_hostname == master_server"

    - name: upgrade mysql data
      shell: /usr/bin/mysql_upgrade
      tags: mysql55
      ignore_errors: true

    - name: delete temporary mysql config file
      file:
        path=/etc/mysql/conf.d/upgrade_mysql.cnf
        state=absent
      tags: mysql55

    - name: bitrix settings
      shell: /etc/init.d/bvat start

    - name: restarted mysql service
      service:
        name=mysqld
        state=restarted
      tags: mysql55

    - name: restart httpd service
      service:
        name=httpd
        state=restarted
      tags: php54