Postgres Pro
Downloads
Home   >   mailing lists

Thread: User authentification failed

User authentification failed

From
Dmitry Samersoff
Date:
Dear All,

When my Postgres 6.2.1 has upgraded to 6.3.2
(hba enabled, pg_hba.conf contain to lines:
 local    all   trust
 host     piter   195.242.10.174     255.255.255.255   trust
 )


I have trouble to connect it by my MS Access through ODBC
(postodbc package 0.31 from postodbc.magenet.com)

Postgres report error "User authentification failed"

It message is result missing result of
  old_be_recvauth in backend/libpq/auth.c

To resolve problem immediatly, i just modyfy this function
to return always true.
  IT IS TERRIBLE!

Is there a normal way to correct this problem?

Thank you !


---
   DM\S               dms@dux.ru
   http://www.piter-press.ru/webmaster

Re: [HACKERS] User authentification failed

From
Byron Nikolaidis
Date:
The postodbc you mention is way out of date and is no longer being
supported.

Go to http://www.insightdist.com/psqlodbc for the latest (updated Jun
13th) odbc driver.
Available as self-extracting install (postdrv.exe) OR source code
(postsrc.zip).

Also, you should use the "interfaces" mailing list when it concerns the
odbc driver.

Byron


Dmitry Samersoff wrote:

> Dear All,
>
> When my Postgres 6.2.1 has upgraded to 6.3.2
> (hba enabled, pg_hba.conf contain to lines:
>  local    all   trust
>  host     piter   195.242.10.174     255.255.255.255   trust
>  )
>
> I have trouble to connect it by my MS Access through ODBC
> (postodbc package 0.31 from postodbc.magenet.com)
>
> Postgres report error "User authentification failed"
>
> It message is result missing result of
>   old_be_recvauth in backend/libpq/auth.c
>
> To resolve problem immediatly, i just modyfy this function
> to return always true.
>   IT IS TERRIBLE!
>
> Is there a normal way to correct this problem?
>
> Thank you !
>
> ---
>    DM\S               dms@dux.ru
>    http://www.piter-press.ru/webmaster

Re: [HACKERS] User authentification failed

From
"Jose' Soares Da Silva"
Date:
On Tue, 16 Jun 1998, Dmitry Samersoff wrote:

Is your postmaster running with -i parameter ?
> Dear All,
>
> When my Postgres 6.2.1 has upgraded to 6.3.2
> (hba enabled, pg_hba.conf contain to lines:
>  local    all   trust
>  host     piter   195.242.10.174     255.255.255.255   trust
>  )
>
>
> I have trouble to connect it by my MS Access through ODBC
> (postodbc package 0.31 from postodbc.magenet.com)
>
> Postgres report error "User authentification failed"
>
> It message is result missing result of
>   old_be_recvauth in backend/libpq/auth.c
>
> To resolve problem immediatly, i just modyfy this function
> to return always true.
>   IT IS TERRIBLE!
>
> Is there a normal way to correct this problem?
>
> Thank you !
>
>
> ---
>    DM\S               dms@dux.ru
>    http://www.piter-press.ru/webmaster
>
>
>
>

                               |  |
~~~~~~~~~~~~~~~~~~~~~~~~       |  |         ~~~~~~~~~~~~~~~~~~~~~~~~
          Progetto HYGEA   ----    ----     www.sferacarta.com
    Sfera Carta Software   ----    ----     sferac@bo.nettuno.it
       Via Bazzanese, 69       |  |         Fax. ++39 51 6131537
Casalecchio R.(BO) Italy       |  |         Tel. ++39 51  591054