Re: Strange. I can logon with an invalid or no password atall - Mailing list pgsql-general

From Chris
Subject Re: Strange. I can logon with an invalid or no password atall
Date
Msg-id 4B174B89.7060304@gmail.com
Whole thread Raw
In response to Strange. I can logon with an invalid or no password atall  (Daniel <danwgrace@gmail.com>)
List pgsql-general
> void TBClientFrame::Login(const wxString &user, const wxString &pass)
> {
>   std::string host("127.0.0.1");
>   std::string user_str = std::string(user.mb_str(*wxConvCurrent));
>   std::string pass_str = std::string(pass.mb_str(*wxConvCurrent));
>   if (db_conn.Connect(host, user_str, pass_str))
>     wxMessageBox(wxT("Logged on."), wxT("Client Info."));
>   else
>   {
>      fprintf(stderr, "%s", db_conn.ErrorMsg());
>   }
> }
>
> It does report an error if the user name is invalid.  What could cause
> this strange behaviour.

What is in your pg_hba.conf file?

Seems like you've got it set to 'trust' for (at least) 127.0.0.1 - try
changing that to 'md5' and restarting postgres.

--
Postgresql & php tutorials
http://www.designmagick.com/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange. I can logon with an invalid or no password atall
Next
From: Craig Ringer
Date:
Subject: Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4