Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

Data import fails with Nominatim 2.2 #5137

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment
Closed

Data import fails with Nominatim 2.2 #5137

openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment

Comments

@openstreetmap-trac
Copy link

Reporter: skalinin
[Submitted to the original trac issue database at 6.56am, Saturday, 8th March 2014]

Hi there,

I would like to install Nominatim 2.2 with maps of Germany but fail due to many reasons. Following the instructions(http://wiki.openstreetmap.org/wiki/Nominatim/Installation) the first error I got was due to the encoding. The default encoding for PostgreSQL 9.1 is SQL_ASCII, while german maps taken from Geofabrik(http://download.geofabrik.de/europe/germany-latest.osm.pbf) requires UTF8. I have fixed that by changing ./utils/setup.php:100 to

'' passthruCheckReturn('createdb -E UTF-8 -T template0 -p '.$aDSNInfo['port'].' '.$aDSNInfo['database']);''

(e.g. using template0 instead template1 which is SQL-ASCII). After that data import started to work but I got post-import errors:

''user@mycomputer:/opt/nominatim# ./utils/setup.php --create-functions --enable-diff-updates[[BR]]
Functions[[BR]]
...[[BR]]
ERROR: type wordscore[] does not exist[[BR]]
ERROR: type "place_boundingbox" does not exist[[BR]]
ERROR: type "place_boundingbox" does not exist[[BR]]
ERROR: type "place_boundingbox" does not exist[[BR]]
ROW 4: result place_boundingbox;''[[BR]]
...[[BR]]

Finally, if I try to search for a city using my Firefox, I get the following:[[BR]]

''
Internal Server Error[[BR]]
Nominatim has encountered an internal error while processing your request. This is most likely because of a bug in the software.[[BR]]
Details: Could not get word tokens.''[[BR]]

Any help would be appreciated.

Nominatim Version: 2.2[[BR]]
Server: Debian Wheezy[[BR]]
DB: PostgreSQL 9.1 with the following packages:[[BR]]
user@mycomputer:/opt/nominatim# dpkg -l | grep postgres[[BR]]
pi libpostgresql-jdbc-java 9.1-901-2[[BR]]
ii postgresql 9.1+134wheezy4[[BR]]
ii postgresql-9.1 9.1.12-0wheezy1[[BR]]
ii postgresql-9.1-postgis 1.5.3-2[[BR]]
ii postgresql-client-9.1 9.1.12-0wheezy1[[BR]]
ii postgresql-client-common 134wheezy4[[BR]]
ii postgresql-common 134wheezy4[[BR]]
ii postgresql-contrib-9.1 9.1.12-0wheezy1[[BR]]
ii postgresql-server-dev-9.1 9.1.12-0wheezy1[[BR]]

Best regards,[[BR]]
Sergey

@openstreetmap-trac
Copy link
Author

Author: lonvia
[Added to the original trac issue at 5.47pm, Monday, 10th March 2014]

Using Nominatim with a database with ASCII encoding is likely to cause trouble. You should recreate your database cluster with UTF8-encoding and also otherwise switch the configuration to UTF-8.

The errors about place_boundingbox can be safely ignored.

For the internal server error, rerun the query with a parameter debug=1. You will get a lot more information including the error that the database returned. It's likely that you have an encoding or permission problem.

Also, please, don't use the bug tracker for questions about the installation. There is a [https://lists.openstreetmap.org/listinfo/geocoding mailinglist] which is much better suited.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant