[Geocoding] nominatim installation

[Alessandra Donnini]

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 <lonvia at denofr.de> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20140605/55bbdb24/attachment-0001.html>