On Mon, Sep 10, 2012 at 10:27:18PM -0400, Nyx wrote: > Yup it does, doing `psql postgres` got me in: > > psql (9.1.5) > Type "help" for help. > > postgres=# > > ----
Then it is most likely a problem with php's DB module. Hard to say what exactly the problem is because there is no real error message. Try reinstalling the DB module, sometimes that helps. If not, check the postgres logs for errors, maybe there is a hint in there. Sarah > > > > 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
