Problem creating postgresql user

Archives Ansible Project
1

I have this stanza:

    - name: Create redmine user
      postgresql_user:
        name: redmine
        password: "ZZZ"
        expires: infinity
      become: true
      become_user: postgres

It runs. The user is created. But regardless of what value I put in the
password field, the md5 hash comes out as

md5bbc5416c08a022eda40297f11f548594

That "bbc5416...." is certainly not what I get when hashing my password, and
like I said, I get that value regardless of what password I use. Even if I set
the password to an md5 hash value starting with "md5," it still ends up as
"md5bbc5416...."

What am I doing wrong? How can I go about debugging this?

Thanks!

j

2

The documentation says this for the password parameter:

3

Yes, I am aware of what the documentation says. I've read it several times
trying to figure out what is wrong. :slight_smile: Please read my question again:
*regardless* of what value I specify for my password, the hash ends up the
same, and I cannot log in using the password I just created for that user.

j

4

Yes, I'm including full passwords.
1) this is vm on local machine; will change before prod
2) You can use them in your debugging so you can use the same username/
password pairs that I do.

    - name: Create redmine user
      postgresql_user:
        name: redmine
        password: "hague9Tendon=table7Narrow6house6"
        expires: infinity
      become: true
      become_user: postgres

postgres=# select rolname,rolpassword from pg_authid;
rolname | rolpassword

5

Yes, I'm including full passwords.
1) this is vm on local machine; will change before prod

I startet a LXC with Postgresql 10.6 and uses Ansible 2.7.8 with psycopg2 2.7.4

2) You can use them in your debugging so you can use the same username/
password pairs that I do.

    - name: Create redmine user
      postgresql_user:
        name: redmine
        password: "hague9Tendon=table7Narrow6house6"
        expires: infinity
      become: true
      become_user: postgres

postgres=# select rolname,rolpassword from pg_authid;
rolname | rolpassword
----------+-------------------------------------
postgres |
redmine | md5bbc5416c08a022eda40297f11f548594
(2 rows)

I run the same task an get this

postgres=# select rolname,rolpassword from pg_authid where rolname='redmine';
  rolname | rolpassword

6

I am running Ansible 2.7.8 as well. :frowning:

Glad to hear it worked for you. If only I could figure out why it's not
working for me.

j

7

Well, here I am...to apologize for wasting everyone's time. I was importing a
DB dump, and I didn't realize it was recreating users from the old server as
well.

We can close this thread. Sorry for the noise.

j