Обсуждение: odbc failed authentication message

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

Please refer to the check list  cantained in the FAQ at  the psqlodbc web site.


I see two issues.

    Postmaster must start withe -i option.
            man postmaster

    It looks as though you only allow localhost access in pg_hba.conf.   You
will need to open up to some remote host(s)
            man pg_hba.conf

    example of wide open with password required:

        host         all         0.0.0.0    0.0.0.0   password

     example of class C wide open

        host         all         200.100.5.0    255.255.255.0   trust


Dave Thorson wrote:

> 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