Thread: No user can login

No user can login

From
Carlos Bergero
Date:
Hi list,
    I'm running Debian Woody with postgresql 7.2 to suport the web mail
horde/imp. The problem is that today at a sertein moment the web mail
start refiusing conections to the server guiving an login error message.
As far as now i check the apache-ssl the horde and the imp configuration
and all seams to be correct so i'm traying out the postgress config. I
found that the server was running aparently find but couldnt tell any
more apart from that. I need some help to check if the users are right
and could connect to the database and if they have the correct settings
and passwds. I'm acostume to work under MySQL and there you could see
the users by displaying a particular table. As i dont have much
expirience in postgresql  i cant figure out how to do the same. As far
as I had read the docs there is no similar structures in postgresql, nor
could i found any command to perform the task. When i try to connect to
the server with

#psql horde hordemgr

I recive the following message

psql:FATAL 1:   IDENT authentication failed for user "hordemgr"

That leads me to the posibility of having something wrong with the
database. But i lack the tools to check it.
If anyone could lead me in the trail I would be most thankfull

Cheers,
               rak


Re: No user can login

From
Robert Treat
Date:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=client-authentication.html#AUTH-PG-HBA-CONF
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=auth-methods.html#AUTH-IDENT

Robert Treat

On Thu, 2003-03-27 at 17:43, Carlos Bergero wrote:
> Hi list,
>     I'm running Debian Woody with postgresql 7.2 to suport the web mail
> horde/imp. The problem is that today at a sertein moment the web mail
> start refiusing conections to the server guiving an login error message.
> As far as now i check the apache-ssl the horde and the imp configuration
> and all seams to be correct so i'm traying out the postgress config. I
> found that the server was running aparently find but couldnt tell any
> more apart from that. I need some help to check if the users are right
> and could connect to the database and if they have the correct settings
> and passwds. I'm acostume to work under MySQL and there you could see
> the users by displaying a particular table. As i dont have much
> expirience in postgresql  i cant figure out how to do the same. As far
> as I had read the docs there is no similar structures in postgresql, nor
> could i found any command to perform the task. When i try to connect to
> the server with
>
> #psql horde hordemgr
>
> I recive the following message
>
> psql:FATAL 1:   IDENT authentication failed for user "hordemgr"
>
> That leads me to the posibility of having something wrong with the
> database. But i lack the tools to check it.
> If anyone could lead me in the trail I would be most thankfull
>
> Cheers,
>                rak