Hey all,<div><br></div><div>I just installed PostgreSQL 9.1, PostGIS 2 and Nominatim cloned recursively from github using the instructions at <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Installation">http://wiki.openstreetmap.org/wiki/Nominatim/Installation</a>. Now when I try to import the planet file using ./setup.php --osm-file us-northeast.osm.pbf --all, I get the error ` DB Error: connect failed `. I'm running on CentOS 6.3.</div>
<div><br></div><div>I have enabled trust authentication for everyone. My pg_hba.conf is as follows:</div><div><br></div><div><div># TYPE DATABASE USER ADDRESS METHOD</div><div><br></div>
<div># "local" is for Unix domain socket connections only</div><div>local all all trust</div><div># IPv4 local connections:</div><div>host all all <a href="http://127.0.0.1/32">127.0.0.1/32</a> trust</div>
<div># IPv6 local connections:</div><div>host all all ::1/128 trust</div></div><div>----</div><div><br></div><div>and in postgresql.conf I have:</div><div><br></div><div><div># - Connection Settings -</div>
<div><br></div><div>listen_addresses = '*'</div></div><div>----</div><div><br></div><div>Here is part of the ouput:</div><div><br></div><div><div> [4]=></div><div> array(7) {</div><div> ["file"]=></div>
<div> string(41) "/usr/local/cpanel/3rdparty/lib/php/DB.php"</div><div> ["line"]=></div><div> int(556)</div><div> ["function"]=></div><div> string(7) "connect"</div>
<div> ["class"]=></div><div> string(8) "DB_pgsql"</div><div> ["object"]=></div><div> object(DB_pgsql)#3 (28) {</div><div> ["phptype"]=></div><div>
string(5) "pgsql"</div><div> ["dbsyntax"]=></div><div> string(5) "pgsql"</div><div> ["features"]=></div><div> array(7) {</div><div> ["limit"]=></div>
<div> string(5) "alter"</div><div> ["new_link"]=></div><div> string(5) "4.3.0"</div><div> ["numrows"]=></div><div> bool(true)</div>
<div> ["pconnect"]=></div><div> bool(true)</div><div> ["prepare"]=></div><div> bool(false)</div><div> ["ssl"]=></div><div> bool(true)</div>
<div> ["transactions"]=></div><div> bool(true)</div><div> }</div><div> ["errorcode_map"]=></div><div> array(0) {</div><div> }</div><div> ["connection"]=></div>
<div> bool(false)</div><div> ["dsn"]=></div><div> array(9) {</div><div> ["phptype"]=></div><div> string(5) "pgsql"</div><div> ["dbsyntax"]=></div>
<div> string(5) "pgsql"</div><div> ["username"]=></div><div> string(0) ""</div><div> ["password"]=></div><div> bool(false)</div><div>
["protocol"]=></div><div> string(3) "tcp"</div><div> ["hostspec"]=></div><div> string(0) ""</div><div> ["port"]=></div>
<div> bool(false)</div><div> ["socket"]=></div><div> bool(false)</div><div> ["database"]=></div><div> string(9) "nominatim"</div><div> }</div>
<div> ["autocommit"]=></div><div> bool(true)</div><div> ["transaction_opcount"]=></div><div> int(0)</div><div> ["affected"]=></div><div> int(0)</div>
<div> ["row"]=></div><div> array(0) {</div><div> }</div><div> ["_num_rows"]=></div><div> array(0) {</div><div> }</div><div> ["fetchmode"]=></div>
<div> int(1)</div><div> ["fetchmode_object_class"]=></div><div> string(8) "stdClass"</div><div> ["was_connected"]=></div><div> NULL</div><div> ["last_query"]=></div>
<div> string(0) ""</div><div> ["options"]=></div><div> array(8) {</div><div> ["result_buffering"]=></div><div> int(500)</div><div> ["persistent"]=></div>
<div> bool(false)</div><div> ["ssl"]=></div><div> bool(false)</div><div> ["debug"]=></div><div> int(0)</div><div> ["seqname_format"]=></div>
<div> string(6) "%s_seq"</div><div> ["autofree"]=></div><div> bool(false)</div><div> ["portability"]=></div><div> int(0)</div><div> ["optimize"]=></div>
<div> string(11) "performance"</div><div> }</div><div> ["last_parameters"]=></div><div> array(0) {</div><div> }</div><div> ["prepare_tokens"]=></div>
<div> array(0) {</div><div> }</div><div> ["prepare_types"]=></div><div> array(0) {</div><div> }</div><div> ["prepared_queries"]=></div><div> array(0) {</div>
<div> }</div><div> ["_last_query_manip"]=></div><div> bool(false)</div><div> ["_next_query_manip"]=></div><div> bool(false)</div><div> ["_debug"]=></div>
<div> bool(false)</div><div> ["_default_error_mode"]=></div><div> NULL</div><div> ["_default_error_options"]=></div><div> NULL</div><div> ["_default_error_handler"]=></div>
<div> string(0) ""</div><div> ["_error_class"]=></div><div> string(8) "DB_Error"</div><div> ["_expected_errors"]=></div><div> array(0) {</div>
<div> }</div><div> }</div><div> ["type"]=></div><div> string(2) "->"</div><div> ["args"]=></div><div> array(2) {</div><div> [0]=></div><div>
array(9) {</div><div> ["phptype"]=></div><div> string(5) "pgsql"</div><div> ["dbsyntax"]=></div><div> string(5) "pgsql"</div><div> ["username"]=></div>
<div> string(0) ""</div><div> ["password"]=></div><div> bool(false)</div><div> ["protocol"]=></div><div> string(3) "tcp"</div><div>
["hostspec"]=></div><div> string(0) ""</div><div> ["port"]=></div><div> bool(false)</div><div> ["socket"]=></div><div> bool(false)</div>
<div> ["database"]=></div><div> string(9) "nominatim"</div><div> }</div><div> [1]=></div><div> bool(false)</div><div> }</div><div> }</div><div> [5]=></div>
<div> array(6) {</div><div> ["file"]=></div><div> string(35) "/home/myusername/Nominatim/lib/db.php"</div><div> ["line"]=></div><div> int(7)</div><div> ["function"]=></div>
<div> string(7) "connect"</div><div> ["class"]=></div><div> string(2) "DB"</div><div> ["type"]=></div><div> string(2) "::"</div><div> ["args"]=></div>
<div> array(2) {</div><div> [0]=></div><div> string(19) "pgsql://@/nominatim"</div><div> [1]=></div><div> bool(false)</div><div> }</div><div> }</div><div> [6]=></div>
<div> array(4) {</div><div> ["file"]=></div><div> string(40) "/home/
myusername/Nominatim/utils/setup.php"</div><div> ["line"]=></div><div> int(118)</div><div> ["function"]=></div><div> string(5) "getDB"</div><div> ["args"]=></div>
<div> array(0) {</div><div> }</div><div> }</div><div> }</div><div> ["callback"]=></div><div> NULL</div><div>}</div><div>DB Error: connect failed</div></div><div><br></div><div>----</div><div><br>
</div><div>Any suggestions how this can be fixed? Thanks!</div><div><br></div><div><br></div>