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

[Nyx]

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 <lonvia at denofr.de> 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
> > Geocoding at openstreetmap.org
> > http://lists.openstreetmap.org/listinfo/geocoding
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120910/ce655a85/attachment-0001.html>