Thread: ODBC driver

ODBC driver

From
Peter Cordone
Date:
I downloaded and installed the ODBC driver for Postgres.  I have a linux
box on the network and the postgres server is running on it.  I am
trying to connect to the sample database mydb from a Windows NT ver 4.0
machine though ODBC with C++ Builders BDE.

I get the following errors:

Unknown user name or password.

Failed to authenticate client as Postgres user 'pcordone' using <unknown
authentication type>: be_recvauth: unrecognized

message type: 65536

Alias: PostgreSQL

Can anyone help me?


Re: [GENERAL] ODBC driver

From
"Brett W. McCoy"
Date:
On Tue, 2 Jun 1998, Peter Cordone wrote:

> I downloaded and installed the ODBC driver for Postgres.  I have a linux
> box on the network and the postgres server is running on it.  I am
> trying to connect to the sample database mydb from a Windows NT ver 4.0
> machine though ODBC with C++ Builders BDE.
>
> I get the following errors:
>
> Unknown user name or password.
>
> Failed to authenticate client as Postgres user 'pcordone' using <unknown
> authentication type>: be_recvauth: unrecognized

Did you create a Postgres user with the 'createuser' tool (usually run by
the postgres superuser (but not root))?  This allows designated users to
use postgresql databases, and in some cases, create and destroy and even
set database permissions for other users.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
   -- The UNIX Programmer's Manual, 2nd Edition, June, 1972


Re: [GENERAL] ODBC driver

From
Kevin Heflin
Date:
On Tue, 2 Jun 1998, Brett W. McCoy wrote:

> Did you create a Postgres user with the 'createuser' tool (usually run by
> the postgres superuser (but not root))?  This allows designated users to
> use postgresql databases, and in some cases, create and destroy and even
> set database permissions for other users.

Also, don't you have to set up Postgres to accept users from another
machine.. I forget exactly where you do that.

Kevin


--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------


Re: [GENERAL] ODBC driver

From
"Brett W. McCoy"
Date:
On Tue, 2 Jun 1998, Kevin Heflin wrote:

> > Did you create a Postgres user with the 'createuser' tool (usually run by
> > the postgres superuser (but not root))?  This allows designated users to
> > use postgresql databases, and in some cases, create and destroy and even
> > set database permissions for other users.
>
> Also, don't you have to set up Postgres to accept users from another
> machine.. I forget exactly where you do that.

That'd be the pg_hba.conf file, and you can set up everything from IP
based authentication to password authentication.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
   -- The UNIX Programmer's Manual, 2nd Edition, June, 1972


Re: [GENERAL] ODBC driver

From
David Hartwig
Date:

                                      ODBC Connection Checklist

     ODBC Driver Data Source Checks
        1.Valid and resolvable hostname.
        2.Valid port number.  (default is 5432)
        3.Valid and existing database name.
        4.Valid user name.
        5.Valid password for the specified user.  (Required iff
pg_hba.config is set to password authenticate your client.)
     PostgreSQL Server Checks
        1.Postmaster must be running.
        2.Postmaster must run with the -i option to allow remote
connections.
        3.The pg_hba.conf file in $PGPATH/data directory must be configured
to allow your remote host to connect.

Peter Cordone wrote:

> I downloaded and installed the ODBC driver for Postgres.  I have a linux
> box on the network and the postgres server is running on it.  I am
> trying to connect to the sample database mydb from a Windows NT ver 4.0
> machine though ODBC with C++ Builders BDE.
>
> I get the following errors:
>
> Unknown user name or password.
>
> Failed to authenticate client as Postgres user 'pcordone' using <unknown
> authentication type>: be_recvauth: unrecognized
>
> message type: 65536
>
> Alias: PostgreSQL
>
> Can anyone help me?