On 5/19/20 1:08 PM, Ikhsan Faruqi wrote:
> Hi stefan, sorry I forgot to put my playbook, here what it looks like
>
> |
> - name: PostgreSQL | Add new HBA records.
> become: yes
> postgresql_pg_hba:
> dest: "{{ postgresql_hba_file_path }}"
> contype: "{{ item.hba_connection_type }}"
> users: "{{ item.hba_users }}"
> source: "{{ item.hba_source }}"
> databases: "{{ item.hba_database | default(omit) }}"
> method: "{{ item.hba_method }} "
> notify: restart postgresql
> loop: "{{ hba_records }}"
> when: setup_hba == true
> |
Maybe the trailing space in
method: "{{ item.hba_method }} "
causes the problem ?
Regards
Racke
>
> so basically I want to add multiple records, so I create some loops.
>
> On Tuesday, May 19, 2020 at 5:49:38 PM UTC+7, Stefan Hornburg (Racke) wrote:
>
> On 5/19/20 12:44 PM, Ikhsan Faruqi wrote:
> > Hi, I trying to add new hba_records using pg_hba_module
> >
> <https://docs.ansible.com/ansible/latest/modules/postgresql_pg_hba_module.html
>
> <https://docs.ansible.com/ansible/latest/modules/postgresql_pg_hba_module.html>>
> but got this error:
> >
> > |
> >
>
> failed:[pg-12](item={'hba_database':'test-db','hba_users':'johndoe','hba_connection_type':'host','hba_source':'0.0.0.0/0
>
> <http://0.0.0.0/0>','hba_method':'trust'})=>{"ansible_loop_var":"item","changed":false,"item":{"hba_connection_type":"host","hba_database":"test-db","hba_method":"trust","hba_source":"0.0.0.0/0
> <http://0.0.0.0/0>","hba_users":"johndoe"},"msg":"value
> > of method must be one of: trust, reject, md5, password, gss, sspi,
> krb5, ident, peer, ldap, radius, cert, pam,
> > scram-sha-256, got: trust "}
> >
> >
> > |
> >
> > this is what my vars.yml looks like:
> >
> > |
> > -hba_records:
> > -hba_database:test-db
> > hba_users:johndoe
> > hba_connection_type:host
> > hba_source:0.0.0.0/0 <http://0.0.0.0/0>
> > hba_method:trust
> > -hba_database:test-db
> > hba_users:alexsong
> > hba_connection_type:host
> > hba_source:0.0.0.0/0 <http://0.0.0.0/0>
> > hba_method:trust
> > |
> >
> > my ansible info:
> >
>
> Hello Ikshan,
>
> the module expects the parameters without the hba_ prefix as clearly
> stated in the documentation and shown in the
> examples.
>
> Regards
> Racke
>
> > |
> > ➜ ~ ansible --version
> > ansible 2.9.5
> > config file = None
> > configured module search path =
> ['/Users/MASKED/.ansible/plugins/modules',
> '/usr/share/ansible/plugins/modules']
> > ansible python module location =
> /Users/MASKEd/Library/Python/3.7/lib/python/site-packages/ansible
> > executable location = /Users/MASKED/Library/Python/3.7/bin/ansible
> > python version = 3.7.5 (default, Nov 1 2019, 02:16:23) [Clang 11.0.0
> (clang-1100.0.33.8)]
> > |
> >
> >
> > --
> > 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] <javascript:>
> <mailto:[email protected] <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/cc058c2d-6c30-48ad-972c-a4e7343eeed2%40googlegroups.com
>
> <https://groups.google.com/d/msgid/ansible-project/cc058c2d-6c30-48ad-972c-a4e7343eeed2%40googlegroups.com>
> >
>
> <https://groups.google.com/d/msgid/ansible-project/cc058c2d-6c30-48ad-972c-a4e7343eeed2%40googlegroups.com?utm_medium=email&utm_source=footer
>
> <https://groups.google.com/d/msgid/ansible-project/cc058c2d-6c30-48ad-972c-a4e7343eeed2%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/e6f2c61e-cba5-44cd-90f8-7bb1c3ebc3c9%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/e6f2c61e-cba5-44cd-90f8-7bb1c3ebc3c9%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/97fbcdaa-340b-8138-18d6-832a6029b642%40linuxia.de.
signature.asc
Description: OpenPGP digital signature
