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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Feng Chen | 2007-08-27 17:39:37 | Re: [SPAM] Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index |
Previous Message | Alvaro Herrera | 2007-08-27 01:49:32 | Re: BUG #3581: Ale |