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             
----------+-------------------------------------
 postgres | 
 redmine  | md5bbc5416c08a022eda40297f11f548594
(2 rows)
postgres=# drop database redmine;
DROP DATABASE
postgres=# drop role redmine;
DROP ROLE

re-run playbook with:

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

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

postgres=# drop database redmine;
DROP DATABASE
postgres=# drop role redmine;
DROP ROLE

re-run playbook with:

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

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

Yah...some something is really odd here. Changing the password didn't result 
in any change, but changing the user name did. For now, I guess I'll do a 
shell command, and pipe to psql.

j


On Wednesday, March 13, 2019 10:09:27 AM AKDT [email protected] wrote:
> Can you please check by changing the user name?
> 
> I guess, the hash value changes....
> If it is changed, then the password value given here is not considered and
> we need to find out the reason why, as a second step.
> 
> If the hash value still doesn't change and remains same, then totally we
> need to think in a different way...
> 
> -Mike.
> 
> On Wednesday, 13 March 2019 11:14:02 UTC+5:30, Joshua Kugler wrote:
> > 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
> 
> On Wednesday, 13 March 2019 11:14:02 UTC+5:30, Joshua Kugler wrote:
> > 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

Joshua J. Kugler -- Fairbanks, AK
Blogs: http://jjncj.com/blog/ (Family) -- http://joshuakugler.com (Geek)


-- 
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/2670805.grBe2IEAkz%40hosanna.
For more options, visit https://groups.google.com/d/optout.

Reply via email to