I'm trying to read the database password on a remote host from the file /etc/mysql/debian.cnf. Format of the file is below. Is there a way to parse out the password field so I can drop a mysql user via Ansible?

# Automatically generated for Debian scripts. DO NOT TOUCH!
host     = localhost
user     = root
password = 5unnyv4l3
socket   = /var/run/mysqld/mysqld.sock
host     = localhost
user     = root
password = 5unnyv4l3
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

If the file is local to the ansible system you can use the ini lookup which will read in values from a ini style file. If your file is remote you can use fetch/slurp to pull a copy to the local system.

I would guess the lookup would be something like

- debug: msg="Password is {{ lookup('ini', 'password section=client file=my.cnf') }}"
  • Thanks, this is really close. It's printing "msg": "Password is vRkfmDfYX2g3wXYt" which isn't actually the password. Tried | b64decode on it but made it worse. Any thoughts? – Server Fault Feb 8 at 14:57
  • Hrm, I might try using the lookup against a different attribute to see if you can look up the user/host or something. – Zoredache Feb 8 at 17:38
  • Try {{ lookup('ini', 'password section=client file=my.cnf') | password_hash('sha512') }} for input into the user module. The password from the file is not encoded, it's plaintext. – Gothrek Feb 13 at 19:35

It looks like the 'slurp' module will work for your requirements: https://docs.ansible.com/ansible/latest/modules/slurp_module.html

- name: extract password from file
    src: /etc/mysql/debian.cnf
register: mypasswordfile

- name: Set User Password
  user: name=newUser
    password="{{ passwordfile['content'] | b64decode | regex_findall('\bpassword\b') }}"

note: i have not tested this myself :)

  • Uh..That second task actually creates a new user account (typo with passwordfile too), but I think I see what you're trying to do.. working on it. I've got this task: msg: "Password is {{ mypasswordfile['content'] | b64decode | regex_findall('\bpassword\b') }}". It printsPassword is [] – Server Fault Feb 8 at 14:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.