From: "Andreas Brunner" <andreas.brunner@rubner.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Error connecting to database
Date: Tue, 5 Dec 2000 11:12:12 +0100
Message-ID: <NDBBIMIKJFFAKJHLAFLHAEGCCEAA.andreas.brunner@rubner.com>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_NextPart_000_000C_01C05EAC.37A8D050"
Importance: Normal

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C05EAC.37A8D050
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

hello,
here´s my system configuration:
host os: 		Suse Linux 6.2
postgres version: 	6.4
client os:		Windows NT 4.0 SP 5
client application:	MS Access 97
odbc driver version:	6.50.00.00

The problem:
when i attempt to connect to database, and i give
a username and password (both existing), i get the
error message [authentication failed].
if i don´t give any username or password, i don´t get
any errormessage, but then nothing happens, so
i am also not connected to the database, although
i don´t recieve any errormessage.
i´ve sent you also 2 log-files, one (325) containing the
try with username and password, the other (299) without.
i also sent you my pg_hba.conf, the one from the
path, where my testdb is installed.

i hope you can help me somehow.
bye
andreas

mailto: andreas.brunner@rubner.com

------=_NextPart_000_000C_01C05EAC.37A8D050
Content-Type: application/octet-stream; name="psqlodbc_325.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="psqlodbc_325.log"

conn=3D51918072, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;', fDriverComple=
tion=3D1
DSN info: DSN=3D'PostgreSQL',server=3D'10.0.10.123',port=3D'5432',dbase=3D'=
testdb',user=3D'',passwd=3D''
          onlyread=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',=
showsystable=3D'0'
          conn_settings=3D''
          translation_dll=3D'',translation_option=3D''
Global Options: Version=3D'06.50.0000', fetch=3D100, socket=3D4096, unknown=
_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D8190
                disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, use_decl=
arefetch=3D0
                text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, bools=
_as_char=3D1
                extra_systable_prefixes=3D'dd_;', conn_settings=3D''
ERROR from backend during authentication: 'User authentication failed'
CONN ERROR: func=3DSQLDriverConnect, desc=3D'Error from CC_Connect', errnum=
=3D210, errmsg=3D'User authentication failed'
            ------------------------------------------------------------
            henv=3D51912264, conn=3D51918072, status=3D0, num_stmts=3D16
            sock=3D51912280, stmts=3D51912328, lobj_type=3D-999
            ---------------- Socket Info -------------------------------
            socket=3D408, reverse=3D0, errornumber=3D0, errormsg=3D'(NULL)'
            buffer_in=3D51924408, buffer_out=3D51928512
            buffer_filled_in=3D28, buffer_filled_out=3D0, buffer_read_in=3D=
28

------=_NextPart_000_000C_01C05EAC.37A8D050
Content-Type: application/octet-stream; name="psqlodbc_299.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="psqlodbc_299.log"

conn=3D51918072, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;', fDriverComple=
tion=3D1
DSN info: DSN=3D'PostgreSQL',server=3D'10.0.10.123',port=3D'5432',dbase=3D'=
testdb',user=3D'',passwd=3D''
          onlyread=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',=
showsystable=3D'0'
          conn_settings=3D''
          translation_dll=3D'',translation_option=3D''

------=_NextPart_000_000C_01C05EAC.37A8D050
Content-Type: application/octet-stream; name="pg_hba.conf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="pg_hba.conf"

#
# Example PostgreSQL host access control file.
#
#=20
# This file controls what hosts are allowed to connect to what databases
# and specifies some options on how users on a particular host are identifi=
ed.
# It is read each time a host tries to make a connection to a database.
#=20
# Each line (terminated by a newline character) is a record.  A record cann=
ot
# be continued across two lines.
#=20
# There are 3 kinds of records:
#=20
#   1) comment:  Starts with #.
#=20
#   2) empty:  Contains nothing excepting spaces and tabs.
#=20
#   3) content: anything else.=20=20
#=20
# Unless specified otherwise, "record" from here on means a content
# record.
#=20
# A record consists of tokens separated by spaces or tabs.  Spaces and
# tabs at the beginning and end of a record are ignored as are extra
# spaces and tabs between two tokens.
#=20
# The first token in a record is the record type.  The interpretation of the
# rest of the record depends on the record type.
#=20
# Record type "host"
# ------------------
#=20
# This record identifies a set of network hosts that are permitted to conne=
ct
# to databases.  No network hosts are permitted to connect except as specif=
ied
# by a "host" record.  See the record type "local" to specify permitted
# connections using UNIX sockets.
#
# Format:
#
#   host DBNAME IP_ADDRESS ADDRESS_MASK USERAUTH [AUTH_ARGUMENT]
#=20
# DBNAME is the name of a PostgreSQL database, "all" to indicate all=20
# databases, or "sameuser" to restrict a user's access to a database
# with the same user name.
#=20
# IP_ADDRESS and ADDRESS_MASK are a standard dotted decimal IP address and
# mask to identify a set of hosts.  These hosts are allowed to connect to=
=20
# Database DBNAME.=20
#=20
# USERAUTH is a keyword indicating the method used to authenticate the=20
# user, i.e. to determine that the principal is authorized to connect
# under the PostgreSQL username he supplies in his connection parameters.
#
#   ident:  Authentication is done by the ident server on the remote
#           host, via the ident (RFC 1413) protocol.  AUTH_ARGUMENT, if
#           specified, is a map name to be found in the pg_ident.conf file.
#           That table maps from ident usernames to PostgreSQL usernames.  =
The
#           special map name "sameuser" indicates an implied map (not found
#           in pg_ident.conf) that maps every ident username to the identic=
al
#           PostgreSQL username.
#
#   trust:  No authentication is done.  Trust that the user has the=20
#           authority to use whatever username he specifies.  Before=20
#           PostgreSQL version 6, all authentication was done this way.
#
#   reject: Reject the connection.
#
#   password:  Authentication is done by matching a password supplied in cl=
ear
#	       by the host.  If AUTH_ARGUMENT is specified then the password
#              is compared with the user's entry in that file (in the $PGDA=
TA
#	       directory).  See pg_passwd(1).  If it is omitted then the
#	       password is compared with the user's entry in the pg_shadow
#	       table.
#
#   crypt:  Authentication is done by matching an encrypted password suppli=
ed
#	    by the host with that held for the user in the pg_shadow table.
#
#   krb4:   Kerberos V4 authentication is used.
#
#   krb5:   Kerberos V5 authentication is used.

# Record type "local"
# ------------------
#=20
# This record identifies the authentication to use when connecting to a
# particular database via a local UNIX socket.
#
# Format:
#=20
#   local DBNAME USERAUTH [AUTH_ARGUMENT]
#
# The format is the same as that of the "host" record type except that the
# IP_ADDRESS and ADDRESS_MASK are omitted and the "ident", "krb4" and "krb5"
# values of USERAUTH are not allowed.

# For backwards compatibility, PostgreSQL also accepts pre-version 6 record=
s,
# which look like:
#=20
#   all         127.0.0.1    0.0.0.0

# TYPE       DATABASE    IP_ADDRESS    MASK              USERAUTH  MAP
=20
#host         all         127.0.0.1     255.255.255.255   trust=20=20=20=20=
=20
=20
# The above allows any user on the local system to connect to any database
# under any username.
=20
#host         template1   192.168.0.0   255.255.255.0     ident     sameuser
=20
# The above allows any user from any host with IP address 192.168.0.x to
# connect to database template1 as the same username that ident on that host
# identifies him as (typically his Unix username).=20=20

#host         all        192.168.0.1   255.255.255.255   reject
#host         all        0.0.0.0       0.0.0.0           trust

# The above would allow anyone anywhere except from 192.168.0.1 to connect =
to
# any database under any username.

#host         all        192.168.0.0  255.255.255.0      ident     omicron
#
# The above would allow users from 192.168.0.x hosts to connect to any
# database, but if Ident says the user is "bryanh" and he requests to
# connect as PostgreSQL user "guest1", the connection is only allowed if
# there is an entry for map "omicron" in pg_ident.conf that says "bryanh" i=
s=20
# allowed to connect as "guest1".

# By default, allow anything over UNIX domain sockets and localhost.

local        all                                         trust
host         all         127.0.0.1     255.255.255.255   trust
host	     testdb      10.0.10.0     255.255.255.0 	 trust


------=_NextPart_000_000C_01C05EAC.37A8D050--