I checked /var/log/pgsql but nothing was written to the log file. Also reinstalled the pear DB module but it remained the same. Any suggestions?
On Tue, Sep 11, 2012 at 12:49 PM, Sarah Hoffmann <[email protected]> wrote: > 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
