Thanks Sarah, rerun of ./utils/specialphrases.php --wiki-import > specialphrases.sql psql -d nominatim -f specialphrases.sql seems not work and I receive this kind of error for each table: psql:specialphrases.sql:58387: ERROR: relation "place_classtype_natural_islet" already exists psql:specialphrases.sql:58388: ERROR: relation "idx_place_classtype_natural_islet_centroid" already exists psql:specialphrases.sql:58389: ERROR: relation "idx_place_classtype_natural_islet_place_id" already exists GRANT
After rerun tables place_classtype_%, search_name and placex are empty. What about to drop table place_classtype_% and to drop indexes idx_place_classtype_% before to run it? Alessandra Il giorno 05/giu/2014, alle ore 08:38, Sarah Hoffmann <[email protected]> ha scritto: > Hi, > > On Thu, Jun 05, 2014 at 06:34:05AM +0200, Alessandra Donnini wrote: >> I'm trying to install nominatim on centos, I had some problems (also with >> selinux) but now population seems ok, I see a lot of table in postggres, >> but most seems to be empty. >> I tried to install Italy data. >> The last command to install special phrases goes wrong because I set >> database user name from www-data to apache before to execute the command and >> and the sql refers www-data user. > > Indeed, that needs fixing. > > Check if the place_classtype_* tables have been created. If not, simply > replace 'www-data' with 'apache' in utils/specialphrases.php and repeat > the creation of special places. > > If the tables are there, the following should fix the rights: > > for tab in `psql -t -d nominatim -c "select tablename from pg_tables where > tablename like 'place_classtype_%'"`; do psql -d nominatim -c "GRANT SELECT > ON $tab TO \"apache\""; done > >> My problem is that nominatim doesn't work: the site is available, but if I >> search something like Roma or Rome it answers "no search results found". >> How can I verify that data are loaded? > > Check that there are more than 40k entries in the tables placex and > search_name. You can also try to list the details for specific OSM > objects (get the OSM id by searching via osm.org) by using the > details page as described here: > http://wiki.openstreetmap.org/wiki/Nominatim/FAQ#My_data_is_still_missing_and_it.27s_been_several_days > >> I have no error in access_log and error_log from httpd. >> Is there a nominatim log? > > Nominatim logs its requests in the DB itself in the table query_log > or new_query_log. But that won't help much at this stage. Check if > there are any errors in the postgresql log. > > Sarah
_______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
