Hello Patel and Benoit, You guys were right on the the dot. I removed Postgresql and re-install it and now the service starts like It should.<br>I ran a find command to grep any 'unable to connect to database' that shows when I pull up the
index.php however that comment is only in the install.php file. So I am not sure if index.php does check on install.php before it starts. <br>Line 810 and 849 are the two places where the unable to connect to database shows in the
install.php script. the problem is 810 is commented out. and If I remove those comments '#" the script will not display in firefox. what is the reason of commting out the following script lines in install.php does anybody remember ?
<br><br> print "Success<BR>"; <br> #}<br># } else {<br># print "Unable to connect to database on $CONF_DATABASE_HOST<BR>The database must be online to continue.<BR>Please go back and retry with correct values";
<br># navigation(array(array("title" => "Back", "page" => "database")));<br># }<br><br> $postgresql_info = pg_version();<br># $postgresql_info['server'];
<br># if ($postgresql_info['server'] > $requiredPostgeSQLVersion) { Todo : Do something }<br><br> Apprecaite the help ---------------------------------I am making progress.....slowly...<br><br>Raj<br><br><div>
<span class="gmail_quote">On 8/25/06, <b class="gmail_sendername">V Patel</b> <<a href="mailto:sgrlogs@gmail.com">sgrlogs@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>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
<br><br>if you want to use md5 put this<br><br><span style="font-style: italic; font-weight: bold;">host all all <a href="http://127.0.0.1/32" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
127.0.0.1/32</a> md5 </span><br><br>or you can put this to enable localhost to access without any encryption.
<br><br style="font-weight: bold;"><span style="font-style: italic; font-weight: bold;">host all all <a href="http://127.0.0.1/32" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
127.0.0.1/32</a> trust<br><br></span>the default format is this
<br><br>host database user IP-address IP-mask Authentication-method [authentication-option]<br><br>then restart postgresql and apache service. <br>If you want more information on editing that file take a look at the documentation at pgsql site
<br><a href="http://www.postgresql.org/docs/7.3/static/client-authentication.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.postgresql.org/docs/7.3/static/client-authentication.html
</a><br><br><br><div></div><div><span class="e" id="q_10d46a62c7f97205_1"><span class="gmail_quote">On 8/25/06, <b class="gmail_sendername">
Benoit Gregoire</b> <<a href="mailto:bock@step.polymtl.ca" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">bock@step.polymtl.ca</a>> wrote:</span></span></div><div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
</blockquote></div><div><span class="e" id="q_10d46a62c7f97205_3">
On Friday 25 August 2006 03:16, Rajendra Jagad wrote:<br>> When I try to start the postgres service from<br>> system>admin>serversetting>service It never starts<br>> when I open xterm and type >postgres on it says it cannot find the
<br>> configuraiton file If I start manually using option -D<br>> /usr/local/pgsql/data it drops me into the backend if I specife DB name and<br>> user I am in the database I can create tables etc but install.php
is still<br>> unable to connect and I am still unable to start the service postgres<br>> I try editing .bashrc and $PATH=/usr/local/pgsql/data but still no luck<br>> So I can manually start the data base but not automatic.
<br>><br>> ANy ideas..<br><br>You have two different problems. First you did not install your<br>distributions, hence it doesn't start properly and with the right permissions<br>from your distribution's init subsystem. You should only install and run
<br>postgres from source if you really know what you are doing.<br><br>Once you fix that, you need to add permission in pg_hba.conf to use md5<br>password based authentication, at least for the wifidog user on localhost.
<br>
<br>> Bye the way the user who logs into the Linux Box must have ownership of<br>> pgsql dir and all it child otherwise it compains about the permission.<br><br>Off course, but the user who logs in the linux box should normally never be
<br>the one who runs postgres.<br><br><br></span></div><div>_______________________________________________</div><div><span class="q"><br>WiFiDog mailing list<br><a href="mailto:WiFiDog@listes.ilesansfil.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
WiFiDog@listes.ilesansfil.org</a><br><a href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><br><br></span></div><div></div><br>
</div><br>_______________________________________________<br>WiFiDog mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:WiFiDog@listes.ilesansfil.org">WiFiDog@listes.ilesansfil.org</a>
<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog" target="_blank">http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><br><br></blockquote>
</div><br>