Обсуждение: CREATE ROLE jdbc vs pgadmin
gentlemen,
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'
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'
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;
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.
reguards,
Flávio Granato
reguards,
Flávio Granato
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
2011/11/17 John R Pierce <pierce@hogranch.com>
what is the problem?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.
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
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