s/vault/fault/ (Freudian slip?)
On Thu, Jul 17, 2014 at 8:33 AM, Michael DeHaan <[email protected]> wrote: > Minor pet peeve - That's not an idempotency failure, you have trouble > logging into a MySQL database. > > I will stick voodoo pins into those that made use of that word so commonly > confused :) Not your vault of course. > > I do notice you are using horribly dated Ansible syntax with > > "host="$server_hostname"" > > Variables look like {{ server_hostname }} not $server_hostname > > This may be your problem. > > > On Thu, Jul 17, 2014 at 7:40 AM, Chinmaya Patanaik < > [email protected]> wrote: > >> Hi, >> >> I am trying to incorporate mysql secure installation using Ansible >> playbook. I followed the below links. >> >> 1. >> http://stackoverflow.com/questions/16444306/ansible-idempotent-mysql-installation-playbook >> 2. https://groups.google.com/forum/#!topic/ansible-project/-jSfGwpk5J8 >> >> Target Server - Amazon Linux AMI(YUM based distro) >> >> My Playbook looks like this. >> >> --- >> >> - name: Install mysql using yum >> action: yum pkg={{item}} state=latest >> with_items: >> >> - MySQL-python >> >> - mysql >> - mysql-server >> >> - name: Start the mysql server >> >> service: name=mysqld state=running enabled=yes >> >> - name: copy .my.cnf file with root password credentials >> >> template: src=my.cnf.j2 dest=/root/.my.cnf owner=root mode=0600 >> >> >> # 'localhost' needs to be the last item for idempotency, see >> # http://ansible.cc/docs/modules.html#mysql-user >> - name: update mysql root password for all root accounts >> mysql_user: name=root host={{ item }} password={{ mysql_root_password >> }} >> with_items: >> - '{{ ansible_hostname }}' >> - 127.0.0.1 >> - ::1 >> - localhost >> >> - name: delete anonymous MySQL server user for $server_hostname >> action: mysql_user user="" host="$server_hostname" state="absent" >> >> - name: delete anonymous MySQL server user for localhost >> action: mysql_user user="" state="absent" >> >> - name: remove the MySQL test database >> action: mysql_db db=test state=absent >> >> My cnf file is - >> >> $cat roles/database/templates/.my.cnf.j2 >> [client] user=root password={{ mysql_root_password }} >> >> >> >> and My variable file is - >> >> $cat roles/database/vars/main.yml >> user: root mysql_root_password: ******* >> >> >> But when I run the playbook, I am getting the following error. >> >> msg: unable to connect to database, check login_user and login_password >> are correct or ~/.my.cnf has the credentials >> >> I am doing exactly the same as mentioned in the above 2 links. I even >> tried to perform the conf file copy task before root password change task. >> But I am still unable to run it successfully. >> >> >> I would really appreciate any kind of help. >> >> Thanks, >> Chinmaya >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ansible Project" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/ansible-project/cf9ca391-f2b2-4c6f-b342-01df409912e5%40googlegroups.com >> <https://groups.google.com/d/msgid/ansible-project/cf9ca391-f2b2-4c6f-b342-01df409912e5%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CA%2BnsWgxkcH3VG_5%2BBqZQMKWxYve4KiB9rsp7ehcEXzrYbgF56w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
