Skip site navigation (1) Skip section navigation (2)

BUG #3582: CREATE USER via ODBC

From: "Zoltan Szmutku" <szmutku(dot)zoltan(at)freemail(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3582: CREATE USER via ODBC
Date: 2007-08-27 16:34:55
Message-ID: 200708271634.l7RGYtRD012430@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3582
Logged by:          Zoltan Szmutku
Email address:      szmutku(dot)zoltan(at)freemail(dot)hu
PostgreSQL version: 8.2
Operating system:   Win XP
Description:        CREATE USER via ODBC
Details: 

Hi ,

I use VFoxpro 9 client program via Postgre ODBC driver.
I see a problem with CREATE USER command.


See bellow:
1.
SQLSTRINGCONNECT("DRIVER=Postgresql
ANSI;Database=postgres;PWD=nincsen;PORT=5432;SERVER=localhost;UID=root;;CA=d
;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;CX=1b503bb;A1=7.4")

It is a root account , then I get a handle. 

I try save a new account:
?SQLEXEC(1,"CREATE ROLE TESZT LOGIN ENCRYPTED PASSWORD 'nincsen' SUPERUSER
CREATEDB NOCREATEROLE")

I get a 1  value of return , it is ok the new account is saved.
Now I try connect with my new account.

?SQLSTRINGCONNECT("DRIVER=Postgresql
ANSI;Database=postgres;PWD=nincsen;PORT=5432;SERVER=localhost;UID=TESZT;;CA=
d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;CX=1b503bb;A1=7.4")

Unfortunately I get a -1  value of return , and the error message is :
'..password autenthication failed'

Then I drop the new account :
?SQLEXEC(1,"drop role TESZT")
Return 1, it's ok. 

Try again, now with lower characters:

?SQLEXEC(1,"CREATE ROLE teszt LOGIN ENCRYPTED PASSWORD 'nincsen' SUPERUSER
CREATEDB NOCREATEROLE")

Return 1, it's ok. 

Now I try connect again with my new account.

?SQLSTRINGCONNECT("DRIVER=Postgresql
ANSI;Database=postgres;PWD=nincsen;PORT=5432;SERVER=localhost;UID=teszt;;CA=
d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;CX=1b503bb;A1=7.4")

and bingo , I get return 1 ! Connection succesfull.

Thanks your patiente 
with best regards : Zoltan

Responses

pgsql-bugs by date

Next:From: Feng ChenDate: 2007-08-27 17:39:37
Subject: Re: [SPAM] Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Previous:From: Alvaro HerreraDate: 2007-08-27 01:49:32
Subject: Re: BUG #3581: Ale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group