<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Thanks Sarah,</div><div>rerun of </div><div><pre style="font-family: monospace, Courier; padding: 1em; border: 1px solid rgb(221, 221, 221); line-height: 1.3em; font-size: 1.2em; background-color: rgb(249, 249, 249); ">./utils/specialphrases.php --wiki-import > specialphrases.sql</pre><div><pre style="font-family: monospace, Courier; padding: 1em; border: 1px solid rgb(221, 221, 221); line-height: 1.3em; font-size: 1.2em; background-color: rgb(249, 249, 249); ">psql -d nominatim -f specialphrases.sql</pre><div>seems not work and I receive this kind of error for each table:</div></div></div><div><div>psql:specialphrases.sql:58387: ERROR: relation "place_classtype_natural_islet" already exists</div><div>psql:specialphrases.sql:58388: ERROR: relation "idx_place_classtype_natural_islet_centroid" already exists</div><div>psql:specialphrases.sql:58389: ERROR: relation "idx_place_classtype_natural_islet_place_id" already exists</div><div>GRANT</div></div><div><br></div><div>After rerun tables place_classtype_%, search_name and placex are empty.</div><div><br></div><div>What about to drop table place_classtype_% and to drop indexes idx_place_classtype_% before to run it?</div></div></span></div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br></div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Alessandra</div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br></div></span></span><br class="Apple-interchange-newline">
</div>
<br><div><div>Il giorno 05/giu/2014, alle ore 08:38, Sarah Hoffmann <<a href="mailto:lonvia@denofr.de">lonvia@denofr.de</a>> ha scritto:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi,<br><br>On Thu, Jun 05, 2014 at 06:34:05AM +0200, Alessandra Donnini wrote:<br><blockquote type="cite">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.<br>I tried to install Italy data. <br>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. <br></blockquote><br>Indeed, that needs fixing.<br><br>Check if the place_classtype_* tables have been created. If not, simply<br>replace 'www-data' with 'apache' in utils/specialphrases.php and repeat<br>the creation of special places. <br><br>If the tables are there, the following should fix the rights:<br><br>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<br><br><blockquote type="cite">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". <br>How can I verify that data are loaded? <br></blockquote><br>Check that there are more than 40k entries in the tables placex and <br>search_name. You can also try to list the details for specific OSM<br>objects (get the OSM id by searching via <a href="http://osm.org">osm.org</a>) by using the<br>details page as described here:<br><a href="http://wiki.openstreetmap.org/wiki/Nominatim/FAQ#My_data_is_still_missing_and_it.27s_been_several_days">http://wiki.openstreetmap.org/wiki/Nominatim/FAQ#My_data_is_still_missing_and_it.27s_been_several_days</a><br><br><blockquote type="cite">I have no error in access_log and error_log from httpd.<br>Is there a nominatim log?<br></blockquote><br>Nominatim logs its requests in the DB itself in the table query_log<br>or new_query_log. But that won't help much at this stage. Check if<br>there are any errors in the postgresql log.<br><br>Sarah<br></blockquote></div><br></body></html>