Yup it does, doing `psql postgres` got me in:<div><br></div><div><div>psql (9.1.5)</div><div>Type "help" for help.</div><div><br></div><div>postgres=#</div><div><br></div><div>----</div><div><br></div><div><br><br>
<div class="gmail_quote">On Mon, Sep 10, 2012 at 10:01 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 09:47:57PM -0400, Nyx wrote:<br>
> Hey all,<br>
><br>
> I just installed PostgreSQL 9.1, PostGIS 2 and Nominatim cloned 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 try<br>
> to import the planet file using ./setup.php --osm-file us-northeast.osm.pbf<br>
> --all, I get the error ` DB Error: connect failed `. I'm running on CentOS<br>
> 6.3.<br>
<br>
</div>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>
<div><div class="h5"><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>
</div></div>> _______________________________________________<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>
</blockquote></div><br></div></div>