---
- name: "generate password for admin"
  set_fact:
     www_pass: "{{ lookup('password', '{{ mikbill.dirs.tmp }}/www_user chars=ascii_letters,digits,hexdigits length=12') }}"
  when: mikbill.database.restore_from_backup.enabled == 0

- name: "update password for admin"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="UPDATE stuff_personal SET pass='{{ www_pass }}' WHERE stuffid=1"
  when: mikbill.database.restore_from_backup.enabled == 0

- name: "update sysopt: restart mysql command"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="UPDATE system_options SET `value`='{{ OS.systemctl }} restart {{ OS.database.percona.name }}' WHERE `key`='mysqld_path'"

- name: "update sysopt: restart radius command"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="UPDATE system_options SET `value`='{{ OS.systemctl }} restart {{ OS.radius.name }}' WHERE `key`='radiusd_path'"

- name: "update sysopt: restart dhcp command"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="UPDATE system_options SET `value`='{{ OS.systemctl }} restart {{ OS.dhcp.name }}' WHERE `key`='DHCPD_RESTART'"
  
- name: "update sysopt: radclient path"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="UPDATE system_options SET `value`='{{ OS.radclient }}' WHERE `key`='exec_radclient'"

- name: "fix services table for percona 8.0"
  command: mysql --defaults-file="{{ mikbill.dirs.tmp }}/root.cnf" {{ mikbill.database.proper.name }} --execute="ALTER TABLE `services` CHANGE `creation_date` `creation_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Дата создания';"
  when: OS.database.percona.version == 80 or OS.database.percona.version == 8.0