can you run it with -vvv ? On Fri, May 3, 2019 at 3:53 PM <magnan...@gmail.com> wrote:
> Hi, I have to create and populate a DB with Ansible. > I successfully create the db, but when I add the postgresql_query I got > syntax error. > I also tried to add the code from documentation (here > <https://docs.ansible.com/ansible/devel/modules/postgresql_query_module.html>) > but it get the same. > > The *error* is: > >> The offending line appears to be: >> >> - name: Run queries from SQL script >> ^ here > > > > I put here the playbook, I really have any idea what it could be. Is it a > bug? > >> >>> - hosts: vm_database >> >> become: yes >> >> vars: >> >> #usate per il lancio senza Cloudify >> >> an_db_name: db_webserver >> >> #an_db_user: webserver >> >> #an_db_password: webserver >> >> tasks: >> >> - name: PostgreSQL installation... >> >> become_user: root >> >> package: >> >> name: "{{ item }}" >> >> state: present >> >> loop: >> >> - postgresql >> >> #- postgresql-contrib >> >> #- libpq-dev >> >> - python-psycopg2 >> >> >>> - name: Check Cluster dir is empty.. >> >> register: foundFiles >> >> find: >> >> paths: /var/lib/postgres/data >> >> patterns: '*.*' >> >> >>> - name: Launching initdb ... >> >> when: foundFiles.matched == 0 >> >> become_user: postgres >> >> become_flags: -i >> >> shell: initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data' >> >> >>> - name: Set postgresql.conf to allow remote connection... >> >> become_user: root >> >> lineinfile: >> >> path: /var/lib/postgres/data/postgresql.conf >> >> regexp: "^#listen_addresses = 'localhost'" >> >> line: "listen_addresses = '*' " >> >> >>> - name: Set pg_hba.conf to allow remote connection... >> >> become_user: root >> >> lineinfile: >> >> path: /var/lib/postgres/data/pg_hba.conf >> >> regexp: 'host.*all.*all.*0.0.0.0/0.*md5' #da sistemare, non >>> funziona >> >> firstmatch: yes >> >> insertafter: '^# IPv4 local connections:*' >> >> line: "host\tall\t\tall\t\t0.0.0.0/0\t\tmd5" #controllare >>> -> bazooka >> >> >>> - name: Service launch.. >> >> become_user: root >> >> service: >> >> name: postgresql >> >> state: started >> >> enabled: yes >> >> >>> - name:DB creation.. >> >> become_user: postgres >> >> postgresql_db: >> >> name: "{{ an_db_name }}" >> >> encoding: UTF-8 >> >> lc_collate: it_IT.UTF-8 >> >> lc_ctype: it_IT.UTF-8 >> >> template: template0 >> >> state: present >> >> >>> - name: User creation.. >> >> become_user: postgres >> >> postgresql_user: >> >> db: "{{ an_db_name }}" >> >> name: "{{ an_db_user }}" >> >> password: "{{ an_db_password }}" >> >> priv: ALL >> >> role_attr_flags: LOGIN,CREATEDB >> >> state: present >> >> ###EVERYTHING FINE TILL HERE#### >> >> *- name: Run queries from SQL script...* >> >> * become_user: postgres* >> >> * postgresql_query:* >> >> * db: "{{ an_db_name }}"* >> >> * path_to_script: Resource/00-create.sql* >> >> * positional_args: 1* >> >> -- > 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 ansible-project+unsubscr...@googlegroups.com. > To post to this group, send email to ansible-project@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/5d7c4e35-e113-4e0d-a929-905ea73b8d74%40googlegroups.com > <https://groups.google.com/d/msgid/ansible-project/5d7c4e35-e113-4e0d-a929-905ea73b8d74%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Jonathan Cha'gara Lozada De La Matta He / Him / His Automation Practice Senior Automation Consultant & Automation CoP Manager Red Hat <https://www.redhat.com> @redhatjobs <https://twitter.com/redhatjobs> redhatjobs <https://www.facebook.com/redhatjobs> @redhatjobs <https://instagram.com/redhatjobs> <https://www.redhat.com> -- 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 ansible-project+unsubscr...@googlegroups.com. To post to this group, send email to ansible-project@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAFYJA%2BJgm8%2Bjdf_%2BWRp-JH_jmYR-%3D7ht21BkWu2H6qr9T4%3DpzA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.