From: Unknown <moritzgeiger91@web.de>
Date: Thu, 28 Jun 2018 09:34:19 +0000 (+0200)
Subject: edited indices an setup file to grant select for table country_osm_grid
X-Git-Tag: v3.2.0~60^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/ec6a427e0a7272445c992f6f046ae8cb5f5a534d

edited indices an setup file to grant select for table country_osm_grid
---

diff --git a/sql/indices.src.sql b/sql/indices.src.sql
index a04bc05d..cd09c9bf 100644
--- a/sql/indices.src.sql
+++ b/sql/indices.src.sql
@@ -21,7 +21,7 @@ CREATE INDEX idx_placex_geometry_reverse_placeNode_rank_search ON placex USING g
 osm_type = 'N' and rank_search > 0 and rank_search <= 25 and class = 'place' and type != 'postcode' and name is not null and indexed_status = 0 and linked_place_id is null;
 CREATE INDEX idx_placex_geometry_reverse_placeNode_rank_address ON placex USING gist (geometry) {ts:search-index} where
 osm_type = 'N' and rank_address > 0 and rank_address <= 25 and type != 'postcode' and name is not null and indexed_status = 0 and linked_place_id is null;
-GRANT SELECT ON Table country_osm_grid to "www-data";
+GRANT SELECT ON Table country_osm_grid to "{www-user}";
 
 CREATE INDEX idx_location_area_country_place_id ON location_area_country USING BTREE (place_id) {ts:address-index};
 
diff --git a/utils/setup.php b/utils/setup.php
index 259ddf2d..4925a4e5 100755
--- a/utils/setup.php
+++ b/utils/setup.php
@@ -596,6 +596,7 @@ if ($aCMDResult['create-search-indices'] || $aCMDResult['all']) {
     $bDidSomething = true;
 
     $sTemplate = file_get_contents(CONST_BasePath.'/sql/indices.src.sql');
+    $sTemplate = str_replace('{www-user}', CONST_Database_Web_User, $sTemplate);
     $sTemplate = replace_tablespace(
         '{ts:address-index}',
         CONST_Tablespace_Address_Index,