[isf-wifidog] Trouble with Wifi Install

[V Patel]

yes as Benoit mentioned your installation is somehow messed up, you should
be able to start postgresqld service by typing service postgresqld start.
But since you can still start pgsql by pointing out where the conf filess
try this: try editing pg_hba.conf located at /var/lib/pgsql/data/ add or
edit following line to read

if you want to use md5 put this

host         all         all         127.0.0.1/32       md5

or you can put this to enable localhost to access without any encryption.

host         all         all         127.0.0.1/32       trust

the default format is this

host      database    user    IP-address     IP-mask
Authentication-method     [authentication-option]

then restart postgresql and apache service.
If you want more information on editing that file take a look at the
documentation at pgsql site
http://www.postgresql.org/docs/7.3/static/client-authentication.html


On 8/25/06, Benoit Gregoire <bock at step.polymtl.ca> wrote:
>
> On Friday 25 August 2006 03:16, Rajendra Jagad wrote:
> > When I try to start the postgres service from
> > system>admin>serversetting>service It never starts
> > when I open xterm and type >postgres on it says it cannot find the
> > configuraiton file If I start manually using option -D
> > /usr/local/pgsql/data it drops me into the backend if I specife DB name
> and
> > user I am in the database I can create tables etc but install.php is
> still
> > unable to connect and I am still unable to start the service postgres
> > I try editing .bashrc and $PATH=/usr/local/pgsql/data but still no luck
> > So I can manually start the data base but not automatic.
> >
> > ANy ideas..
>
> You have two different problems.  First you did not install your
> distributions, hence it doesn't start properly and with the right
> permissions
> from your distribution's init subsystem.  You should only install and run
> postgres from source if you really know what you are doing.
>
> Once you fix that, you need to add permission in pg_hba.conf to use md5
> password based authentication, at least for the wifidog user on localhost.
>
> > Bye the way the user who logs into the Linux Box must have ownership of
> > pgsql dir and all it child otherwise it compains about the permission.
>
> Off course, but the user who logs in the linux box should normally never
> be
> the one who runs postgres.
>
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20060825/d0a0805c/attachment.htm