[Geocoding] Nominatim data import error: DB Error: connect failed
Nyx
nyxynyx at gmail.com
Tue Sep 11 02:47:57 BST 2012
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.
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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120910/92f26537/attachment.html>
More information about the Geocoding
mailing list