Postgres Pro
Downloads
Home   >   mailing lists

Thread: CREATE ROLE jdbc vs pgadmin

CREATE ROLE jdbc vs pgadmin

From
Flávio Alves Granato
Date:
<span class="long_text" id="result_box" lang="en"><span class="hps">gentlemen,</span><br /><br /><span class="hps">I
have</span><span class="hps">a</span> <span class="hps">problem with the</span> <span class="hps atn">query
'</span><span>CREATEROLE</span><span>' being</span> <span class="hps">executed</span> <span class="hps">via</span>
<spanclass="hps">jdbc</span> <span class="hps">and via</span> <span class="hps">pgadmin</span><span>.</span> <span
class="hps">WhenI run</span> <span class="hps">it</span> <span class="hps">via</span> <span
class="hps">pgadmin</span><spanclass="">:<br /><br /></span></span>CREATE ROLE flavio LOGIN<br />  ENCRYPTED PASSWORD
'cd6a0065e497a3c20b3c639df7d56b0d'<br/><div id=":2ui">  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;<br
/><br/>and via jdbc:<br /><br />CREATE ROLE flavio LOGIN<br />   ENCRYPTED PASSWORD
'md5bf5a1a18f98fd6debde92560c933d2d9'<br/><div id=":2ui">  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE
NOREPLICATION;<br/><br /><span class="long_text" id="result_box" lang="en"><span class="hps">I did</span> <span
class="hps">update</span><span class="hps">to the</span> <span class="hps">newest</span> <span class="hps">jdbc:<br
/><br/></span></span><span class="long_text" id="result_box" lang="en"><span class="hps"></span><span
class="hps"></span><spanclass="hps"></span><span class="hps"></span><span class="hps"></span></span>CREATE ROLE flavio
LOGIN<br/>   ENCRYPTED PASSWORD 'md50eb617ecacedd0cfae723bbe53c75918' <br /> NOSUPERUSER INHERIT NOCREATEDB
NOCREATEROLENOREPLICATION; <br /><br /><div class="almost_half_cell" id="gt-res-content"><div dir="ltr"
style="zoom:1"><spanclass="long_text short_text" id="result_box" lang="en"><span class="hps">It would be</span> <span
class="hps">a</span><span class="hps">bug in</span> <span class="hps">jdbc</span><span class="">? </span></span><span
class="long_textshort_text" id="result_box" lang="en"><span class="hps">I am using</span> <span
class="hps">PostgreSQL</span><span class="hps">9.1 and linux.<br /><br />reguards,<br /><br /><br />Flávio Granato<br
/></span></span></div></div><br/></div><br /></div><br />

Re: CREATE ROLE jdbc vs pgadmin

From
John R Pierce
Date:
On 11/17/11 11:56 AM, Fl=C3=A1vio Alves Granato wrote:
>
> I have a problem with the query 'CREATE ROLE' being executed via jdbc=20
> and via pgadmin. When I run it via pgadmin:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'cd6a0065e497a3c20b3c639df7d56b0d'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> and via jdbc:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'md5bf5a1a18f98fd6debde92560c933d2d9'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> I did update to the newest jdbc:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'md50eb617ecacedd0cfae723bbe53c75918'
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> It would be a bug in jdbc? I am using PostgreSQL 9.1 and linux.

what is the problem?



--=20
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

Re: CREATE ROLE jdbc vs pgadmin

From
Flávio Alves Granato
Date:
2011/11/17 John R Pierce <pierce@hogranch.com>
On 11/17/11 11:56 AM, Flávio Alves Granato wrote:

I have a problem with the query 'CREATE ROLE' being executed via jdbc and via pgadmin. When I run it via pgadmin:

CREATE ROLE flavio LOGIN
 ENCRYPTED PASSWORD 'cd6a0065e497a3c20b3c639df7d56b0d'
 NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

and via jdbc:

CREATE ROLE flavio LOGIN
 ENCRYPTED PASSWORD 'md5bf5a1a18f98fd6debde92560c933d2d9'
 NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

I did update to the newest jdbc:

CREATE ROLE flavio LOGIN
 ENCRYPTED PASSWORD 'md50eb617ecacedd0cfae723bbe53c75918'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

It would be a bug in jdbc? I am using PostgreSQL 9.1 and linux.

what is the problem?


sorry

the problem was me, that between the chair and keyboard, just generating a hash of the password before creating the ROLE and login time did not generate the hash of the password. Fix the code of my application and have no more problem.

thank you,


Flavio

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs