<commit_before>---

## http://nullsecure.org/building-your-own-passivedns-feed/
## OR ? http://stackoverflow.com/questions/16444306/ansible-idempotent-mysql-installation-playbook
## is mysql_install_db necessary? probably not
#- name: setup database
#  command: "{{ item }}"
#  with_items:
#    - mysql_install_db
#    - mysql_secure_installation    ## interactive

- name: check that mysql is running
  service: "name={{ mysql_svc }} state=started"
#- stat: path=/root/.my.cnf
#  register: mycnf
#- debug: var=mycnf
#- stat: path=/var/run/mysqld/mysqld.sock
#  register: mysock
#- debug: var=mysock
#- name: check mysql socket configuration
#  shell: "grep -rin sock {{ mysql_confdir }}/* /etc/my.cnf"
#  register: myconf
#  changed_when: false
#  ignore_errors: true
#- debug: var=myconf.stdout_lines

- name: Set mysql root user password
  mysql_user:
    name: root
    host: "{{ item }}"
    password: "{{ <PASSWORD> }}"
    check_implicit_admin: yes
    login_user: "{{ mysql_user }}"
    login_password: "{{ <PASSWORD> }}"<commit_msg>pdns mysql_old_root_password default omit<commit_after>---

## http://nullsecure.org/building-your-own-passivedns-feed/
## OR ? http://stackoverflow.com/questions/16444306/ansible-idempotent-mysql-installation-playbook
## is mysql_install_db necessary? probably not
#- name: setup database
#  command: "{{ item }}"
#  with_items:
#    - mysql_install_db
#    - mysql_secure_installation    ## interactive

- name: check that mysql is running
  service: "name={{ mysql_svc }} state=started"
#- stat: path=/root/.my.cnf
#  register: mycnf
#- debug: var=mycnf
#- stat: path=/var/run/mysqld/mysqld.sock
#  register: mysock
#- debug: var=mysock
#- name: check mysql socket configuration
#  shell: "grep -rin sock {{ mysql_confdir }}/* /etc/my.cnf"
#  register: myconf
#  changed_when: false
#  ignore_errors: true
#- debug: var=myconf.stdout_lines

- name: Set mysql root user password
  mysql_user:
    name: root
    host: "{{ item }}"
    password: "{{ <PASSWORD> }}"
    check_implicit_admin: yes
    login_user: "{{ mysql_user }}"
    login_password: "{{ <PASSWORD>_old_<PASSWORD>_password | default(omit) }}"
{'fraction_non_alphanumeric': 0.15023255813953487, 'fraction_numerical': 0.0074418604651162795, 'mean_word_length': 4.002325581395349, 'pattern_counts': {'":': 0, '<': 8, '<?xml version=': 0, '>': 8, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '863507', 'n_tokens_mistral': 773, 'n_tokens_neox': 750, 'n_words': 160}