[Geocoding] nominatim installation

[Sarah Hoffmann]

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