Re: Password setting having somewhat bizarre results. - Mailing list pgadmin-support

<div class="WordSection1"><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Apologiesthat this got sent to Dinesh rather
thanthe mailing list.  </span><span style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">L</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">HiDinesh, </span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Sorry,I reread my original request for help
andit was extremely unclear as I wrote it.</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Basically,I was using the PGAdmin interface
toset passwords, and the interface reported that I had set them successfully, but when I attempted to login using those
passwords,I was not allowed to do so.</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">ThepsqlODBC migration went more or less as
plannedonce I stopped using the created logins and used a connection to the default user postgres.</span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><p
class="MsoNormal"><spanstyle="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">After this had been
completed,I started experimenting with the created logins to see what had gone wrong, and this experimentation included
resettingthe password on the default postgres user using the same interface.  I then logged out and logged back in with
thatnew password and was locked out with zero working logins.</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Sothe problem is that pgAdmin is changing my
passwords,it’s just setting them to something other than what I tell it to.  I suspect this is a misunderstanding on my
partof how the process is supposed to work based on my Microsoft product background specifically related to the MD5
encryptionsystem.  I used the ALTER ROLE SQL command to do the same thing and it appears to have had the same
behavior. The data is certainly secure, at any rate, no one can login.  </span><span
style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">J</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Iswapped the authentication method to “trust”
soI could at least get some work done locally while my collaborators are waiting for the security to work.  Of course I
alsoseem not to have set up the public service properly…</span><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Idid mention that I was an Analyst and a bit
outof my depth in the DBA role, right?  </span><span
style="font-size:11.0pt;font-family:Wingdings;color:#1F497D">J</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif""> </span></div>