[isf-wifidog] Facing a problem when I try to create the postgres database

[Proulx François]

This appears to be a typical pg_hba.conf configuration issue. What  
version of Postgresql are you using ? Look for a file called  
pg_hba.conf you'll have to change the security settings and restart  
your postgres daemon. Simplest, but most unsecure way to test if it  
works is to add a line like this.

local all all trust

This will allow all local users ( connected by shell ) to connect to  
any database without the need to enter a password. Read the  
instructions in pg_hba to find a suitable security level for your  
environnment...

Hope this helps

On 8-Aug-2005, at 23:51 , Bassam A. Al-Khaffaf wrote:

> Dear All,
>    I have reached to the point where I have to create the "wifidog- 
> auth"
> database on my Fedora Core 4 machine as described in the "INSTALL"  
> file in
> the source directory of "wifidog-auth". Unfortunately I getting  
> this error:
> (psql: FATAL:  Ident authentication failed for user "wifidog")
>
> Here are the steps that I have done so far for creating the  
> database and as
> illustrated in the "INSTALL" file:
>
> -Create the user wifidog (both in postgres and on your system).
>
> [root at amg ~]# adduser wifidog
> [root at amg ~]# su - postgres
> -bash-3.00$ createuser -a -d -e wifidog
> -bash-3.00$ psql -d template1 -U wifidog -W -f
> /root/wifidog-auth/sql/wifidog-postgres-schema.sql
> Password:         ## Here I just pressed enter because there is no  
> password
> supplied when I created the wifidog
>
> After the password step I got this error: (psql: FATAL:  Ident
> authentication failed for user "wifidog")
>
> I tried to use the same command without the -W switch to avoid  
> prompting me
> for a password, but again I got the same problem.
>
> Would you please help and direct me on how to avoid this problem. I  
> am will
> be thankful for your help.
>
>
> Regards
> Bassam A. Al-Khaffaf
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog