[Geocoding] Nominatim data import error: DB Error: connect failed

[Sarah Hoffmann]

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
> Geocoding at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/geocoding