Yup it does, doing `psql postgres` got me in: psql (9.1.5) Type "help" for help.
postgres=# ---- On Mon, Sep 10, 2012 at 10:01 PM, Sarah Hoffmann <[email protected]> wrote: > On Mon, Sep 10, 2012 at 09:47:57PM -0400, Nyx wrote: > > Hey all, > > > > I just installed PostgreSQL 9.1, PostGIS 2 and Nominatim cloned > recursively > > from github using the instructions at > > http://wiki.openstreetmap.org/wiki/Nominatim/Installation. 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. > > You may not have sufficient rights to read from postgres' socket. Does it > work, when you connect to postgres directly like this: > > psql postgres > > Sarah > > > > > > I have enabled trust authentication for everyone. My pg_hba.conf is as > > follows: > > > > # TYPE DATABASE USER ADDRESS METHOD > > > > # "local" is for Unix domain socket connections only > > local all all trust > > # IPv4 local connections: > > host all all 127.0.0.1/32 trust > > # IPv6 local connections: > > host all all ::1/128 trust > > ---- > > > > and in postgresql.conf I have: > > > > # - Connection Settings - > > > > listen_addresses = '*' > > ---- > > > > Here is part of the ouput: > > > > [4]=> > > array(7) { > > ["file"]=> > > string(41) "/usr/local/cpanel/3rdparty/lib/php/DB.php" > > ["line"]=> > > int(556) > > ["function"]=> > > string(7) "connect" > > ["class"]=> > > string(8) "DB_pgsql" > > ["object"]=> > > object(DB_pgsql)#3 (28) { > > ["phptype"]=> > > string(5) "pgsql" > > ["dbsyntax"]=> > > string(5) "pgsql" > > ["features"]=> > > array(7) { > > ["limit"]=> > > string(5) "alter" > > ["new_link"]=> > > string(5) "4.3.0" > > ["numrows"]=> > > bool(true) > > ["pconnect"]=> > > bool(true) > > ["prepare"]=> > > bool(false) > > ["ssl"]=> > > bool(true) > > ["transactions"]=> > > bool(true) > > } > > ["errorcode_map"]=> > > array(0) { > > } > > ["connection"]=> > > bool(false) > > ["dsn"]=> > > array(9) { > > ["phptype"]=> > > string(5) "pgsql" > > ["dbsyntax"]=> > > string(5) "pgsql" > > ["username"]=> > > string(0) "" > > ["password"]=> > > bool(false) > > ["protocol"]=> > > string(3) "tcp" > > ["hostspec"]=> > > string(0) "" > > ["port"]=> > > bool(false) > > ["socket"]=> > > bool(false) > > ["database"]=> > > string(9) "nominatim" > > } > > ["autocommit"]=> > > bool(true) > > ["transaction_opcount"]=> > > int(0) > > ["affected"]=> > > int(0) > > ["row"]=> > > array(0) { > > } > > ["_num_rows"]=> > > array(0) { > > } > > ["fetchmode"]=> > > int(1) > > ["fetchmode_object_class"]=> > > string(8) "stdClass" > > ["was_connected"]=> > > NULL > > ["last_query"]=> > > string(0) "" > > ["options"]=> > > array(8) { > > ["result_buffering"]=> > > int(500) > > ["persistent"]=> > > bool(false) > > ["ssl"]=> > > bool(false) > > ["debug"]=> > > int(0) > > ["seqname_format"]=> > > string(6) "%s_seq" > > ["autofree"]=> > > bool(false) > > ["portability"]=> > > int(0) > > ["optimize"]=> > > string(11) "performance" > > } > > ["last_parameters"]=> > > array(0) { > > } > > ["prepare_tokens"]=> > > array(0) { > > } > > ["prepare_types"]=> > > array(0) { > > } > > ["prepared_queries"]=> > > array(0) { > > } > > ["_last_query_manip"]=> > > bool(false) > > ["_next_query_manip"]=> > > bool(false) > > ["_debug"]=> > > bool(false) > > ["_default_error_mode"]=> > > NULL > > ["_default_error_options"]=> > > NULL > > ["_default_error_handler"]=> > > string(0) "" > > ["_error_class"]=> > > string(8) "DB_Error" > > ["_expected_errors"]=> > > array(0) { > > } > > } > > ["type"]=> > > string(2) "->" > > ["args"]=> > > array(2) { > > [0]=> > > array(9) { > > ["phptype"]=> > > string(5) "pgsql" > > ["dbsyntax"]=> > > string(5) "pgsql" > > ["username"]=> > > string(0) "" > > ["password"]=> > > bool(false) > > ["protocol"]=> > > string(3) "tcp" > > ["hostspec"]=> > > string(0) "" > > ["port"]=> > > bool(false) > > ["socket"]=> > > bool(false) > > ["database"]=> > > string(9) "nominatim" > > } > > [1]=> > > bool(false) > > } > > } > > [5]=> > > array(6) { > > ["file"]=> > > string(35) "/home/myusername/Nominatim/lib/db.php" > > ["line"]=> > > int(7) > > ["function"]=> > > string(7) "connect" > > ["class"]=> > > string(2) "DB" > > ["type"]=> > > string(2) "::" > > ["args"]=> > > array(2) { > > [0]=> > > string(19) "pgsql://@/nominatim" > > [1]=> > > bool(false) > > } > > } > > [6]=> > > array(4) { > > ["file"]=> > > string(40) "/home/ myusername/Nominatim/utils/setup.php" > > ["line"]=> > > int(118) > > ["function"]=> > > string(5) "getDB" > > ["args"]=> > > array(0) { > > } > > } > > } > > ["callback"]=> > > NULL > > } > > DB Error: connect failed > > > > ---- > > > > Any suggestions how this can be fixed? Thanks! > > > _______________________________________________ > > Geocoding mailing list > > [email protected] > > http://lists.openstreetmap.org/listinfo/geocoding > >
_______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
