I checked /var/log/pgsql but nothing was written to the log file.<div><br></div><div>Also reinstalled the pear DB module but it remained the same. Any suggestions?<br><div><br><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 12:49 PM, Sarah Hoffmann <span dir="ltr"><<a href="mailto:lonvia@denofr.de" target="_blank">lonvia@denofr.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Mon, Sep 10, 2012 at 10:27:18PM -0400, Nyx wrote:<br>
> Yup it does, doing `psql postgres` got me in:<br>
><br>
> psql (9.1.5)<br>
> Type "help" for help.<br>
><br>
> postgres=#<br>
><br>
> ----<br>
<br>
</div>Then it is most likely a problem with php's DB module. Hard to say what<br>
exactly the problem is because there is no real error message. Try reinstalling<br>
the DB module, sometimes that helps. If not, check the postgres logs for<br>
errors, maybe there is a hint in there.<br>
<span class="HOEnZb"><font color="#888888"><br>
Sarah<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
><br>
><br>
><br>
> On Mon, Sep 10, 2012 at 10:01 PM, Sarah Hoffmann <<a href="mailto:lonvia@denofr.de">lonvia@denofr.de</a>> wrote:<br>
><br>
> > On Mon, Sep 10, 2012 at 09:47:57PM -0400, Nyx wrote:<br>
> > > Hey all,<br>
> > ><br>
> > > I just installed PostgreSQL 9.1, PostGIS 2 and Nominatim cloned<br>
> > recursively<br>
> > > from github using the instructions at<br>
> > > <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation" target="_blank">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a>. Now when I<br>
> > try<br>
> > > to import the planet file using ./setup.php --osm-file<br>
> > us-northeast.osm.pbf<br>
> > > --all, I get the error ` DB Error: connect failed `. I'm running on<br>
> > CentOS<br>
> > > 6.3.<br>
> ><br>
> > You may not have sufficient rights to read from postgres' socket. Does it<br>
> > work, when you connect to postgres directly like this:<br>
> ><br>
> > psql postgres<br>
> ><br>
> > Sarah<br>
> ><br>
> ><br>
> > ><br>
> > > I have enabled trust authentication for everyone. My pg_hba.conf is as<br>
> > > follows:<br>
> > ><br>
> > > # TYPE DATABASE USER ADDRESS METHOD<br>
> > ><br>
> > > # "local" is for Unix domain socket connections only<br>
> > > local all all trust<br>
> > > # IPv4 local connections:<br>
> > > host all all <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a> trust<br>
> > > # IPv6 local connections:<br>
> > > host all all ::1/128 trust<br>
> > > ----<br>
> > ><br>
> > > and in postgresql.conf I have:<br>
> > ><br>
> > > # - Connection Settings -<br>
> > ><br>
> > > listen_addresses = '*'<br>
> > > ----<br>
> > ><br>
> > > Here is part of the ouput:<br>
> > ><br>
> > > [4]=><br>
> > > array(7) {<br>
> > > ["file"]=><br>
> > > string(41) "/usr/local/cpanel/3rdparty/lib/php/DB.php"<br>
> > > ["line"]=><br>
> > > int(556)<br>
> > > ["function"]=><br>
> > > string(7) "connect"<br>
> > > ["class"]=><br>
> > > string(8) "DB_pgsql"<br>
> > > ["object"]=><br>
> > > object(DB_pgsql)#3 (28) {<br>
> > > ["phptype"]=><br>
> > > string(5) "pgsql"<br>
> > > ["dbsyntax"]=><br>
> > > string(5) "pgsql"<br>
> > > ["features"]=><br>
> > > array(7) {<br>
> > > ["limit"]=><br>
> > > string(5) "alter"<br>
> > > ["new_link"]=><br>
> > > string(5) "4.3.0"<br>
> > > ["numrows"]=><br>
> > > bool(true)<br>
> > > ["pconnect"]=><br>
> > > bool(true)<br>
> > > ["prepare"]=><br>
> > > bool(false)<br>
> > > ["ssl"]=><br>
> > > bool(true)<br>
> > > ["transactions"]=><br>
> > > bool(true)<br>
> > > }<br>
> > > ["errorcode_map"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["connection"]=><br>
> > > bool(false)<br>
> > > ["dsn"]=><br>
> > > array(9) {<br>
> > > ["phptype"]=><br>
> > > string(5) "pgsql"<br>
> > > ["dbsyntax"]=><br>
> > > string(5) "pgsql"<br>
> > > ["username"]=><br>
> > > string(0) ""<br>
> > > ["password"]=><br>
> > > bool(false)<br>
> > > ["protocol"]=><br>
> > > string(3) "tcp"<br>
> > > ["hostspec"]=><br>
> > > string(0) ""<br>
> > > ["port"]=><br>
> > > bool(false)<br>
> > > ["socket"]=><br>
> > > bool(false)<br>
> > > ["database"]=><br>
> > > string(9) "nominatim"<br>
> > > }<br>
> > > ["autocommit"]=><br>
> > > bool(true)<br>
> > > ["transaction_opcount"]=><br>
> > > int(0)<br>
> > > ["affected"]=><br>
> > > int(0)<br>
> > > ["row"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["_num_rows"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["fetchmode"]=><br>
> > > int(1)<br>
> > > ["fetchmode_object_class"]=><br>
> > > string(8) "stdClass"<br>
> > > ["was_connected"]=><br>
> > > NULL<br>
> > > ["last_query"]=><br>
> > > string(0) ""<br>
> > > ["options"]=><br>
> > > array(8) {<br>
> > > ["result_buffering"]=><br>
> > > int(500)<br>
> > > ["persistent"]=><br>
> > > bool(false)<br>
> > > ["ssl"]=><br>
> > > bool(false)<br>
> > > ["debug"]=><br>
> > > int(0)<br>
> > > ["seqname_format"]=><br>
> > > string(6) "%s_seq"<br>
> > > ["autofree"]=><br>
> > > bool(false)<br>
> > > ["portability"]=><br>
> > > int(0)<br>
> > > ["optimize"]=><br>
> > > string(11) "performance"<br>
> > > }<br>
> > > ["last_parameters"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["prepare_tokens"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["prepare_types"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["prepared_queries"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > ["_last_query_manip"]=><br>
> > > bool(false)<br>
> > > ["_next_query_manip"]=><br>
> > > bool(false)<br>
> > > ["_debug"]=><br>
> > > bool(false)<br>
> > > ["_default_error_mode"]=><br>
> > > NULL<br>
> > > ["_default_error_options"]=><br>
> > > NULL<br>
> > > ["_default_error_handler"]=><br>
> > > string(0) ""<br>
> > > ["_error_class"]=><br>
> > > string(8) "DB_Error"<br>
> > > ["_expected_errors"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > }<br>
> > > ["type"]=><br>
> > > string(2) "->"<br>
> > > ["args"]=><br>
> > > array(2) {<br>
> > > [0]=><br>
> > > array(9) {<br>
> > > ["phptype"]=><br>
> > > string(5) "pgsql"<br>
> > > ["dbsyntax"]=><br>
> > > string(5) "pgsql"<br>
> > > ["username"]=><br>
> > > string(0) ""<br>
> > > ["password"]=><br>
> > > bool(false)<br>
> > > ["protocol"]=><br>
> > > string(3) "tcp"<br>
> > > ["hostspec"]=><br>
> > > string(0) ""<br>
> > > ["port"]=><br>
> > > bool(false)<br>
> > > ["socket"]=><br>
> > > bool(false)<br>
> > > ["database"]=><br>
> > > string(9) "nominatim"<br>
> > > }<br>
> > > [1]=><br>
> > > bool(false)<br>
> > > }<br>
> > > }<br>
> > > [5]=><br>
> > > array(6) {<br>
> > > ["file"]=><br>
> > > string(35) "/home/myusername/Nominatim/lib/db.php"<br>
> > > ["line"]=><br>
> > > int(7)<br>
> > > ["function"]=><br>
> > > string(7) "connect"<br>
> > > ["class"]=><br>
> > > string(2) "DB"<br>
> > > ["type"]=><br>
> > > string(2) "::"<br>
> > > ["args"]=><br>
> > > array(2) {<br>
> > > [0]=><br>
> > > string(19) "pgsql://@/nominatim"<br>
> > > [1]=><br>
> > > bool(false)<br>
> > > }<br>
> > > }<br>
> > > [6]=><br>
> > > array(4) {<br>
> > > ["file"]=><br>
> > > string(40) "/home/ myusername/Nominatim/utils/setup.php"<br>
> > > ["line"]=><br>
> > > int(118)<br>
> > > ["function"]=><br>
> > > string(5) "getDB"<br>
> > > ["args"]=><br>
> > > array(0) {<br>
> > > }<br>
> > > }<br>
> > > }<br>
> > > ["callback"]=><br>
> > > NULL<br>
> > > }<br>
> > > DB Error: connect failed<br>
> > ><br>
> > > ----<br>
> > ><br>
> > > Any suggestions how this can be fixed? Thanks!<br>
> ><br>
> > > _______________________________________________<br>
> > > Geocoding mailing list<br>
> > > <a href="mailto:Geocoding@openstreetmap.org">Geocoding@openstreetmap.org</a><br>
> > > <a href="http://lists.openstreetmap.org/listinfo/geocoding" target="_blank">http://lists.openstreetmap.org/listinfo/geocoding</a><br>
> ><br>
> ><br>
</div></div></blockquote></div><br></div></div>