From: Dave Thorson <dthorson@grwolf.com>
To: pgsql-interfaces@postgresql.org
Subject: odbc failed authentication message
Date: Tue, 08 Sep 1998 21:04:13 -0500
Message-ID: <19980908211100.82353ae7.in@grwolf.com> (raw)
I receive a "failed authentication" message when I attempt to make and ODBC
connection. My server is fir, database name is foo, name is dave with a
password of dave. I have set up the user using psql with a create user
command.
Any help for a poor novice would be greatly appreciated!
I have attempted an ODBC connection with the Insite driver (6.30.0249). I
am using Red Hat Linux 5.1 which included postgres. I have been able to
make pgaccess and psql work. ODBC is alluding me.
The postgres .bash_profile looks like this:
#!/bin/sh
#This Script changes the term type
TERM=vt100
export TERM
echo $TERM
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
PGLIB=/usr/lib/pgsql
PGDATA=/usr/local/pgsql/data
export PATH MANPATH PGLIB PGDATA
The pg_hba.conf file located in /usr/local/pgsql/data contains the following.
# By default, allow anything over UNIX domain sockets and localhost.
local all trust
host all 127.0.0.1 255.255.255.255 trust
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: dthorson@grwolf.com
Subject: Re: odbc failed authentication message
In-Reply-To: <19980908211100.82353ae7.in@grwolf.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox