From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 9 Jun 2019 09:04:47 +0000 (+0200)
Subject: Merge pull request #1381 from mtmail/faq-entry-about-managed-database-services
X-Git-Tag: v3.4.0~38
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/a09f2a698707c366a0e93a81c84268a83bf7d7ea?hp=-c

Merge pull request #1381 from mtmail/faq-entry-about-managed-database-services

FAQ entry about managed database services
---

a09f2a698707c366a0e93a81c84268a83bf7d7ea
diff --combined docs/admin/Faq.md
index f06694c6,36a6c45e..485ba25b
--- a/docs/admin/Faq.md
+++ b/docs/admin/Faq.md
@@@ -24,14 -24,14 +24,14 @@@ If the reported rank is 26 or higher, y
  
  ### PHP "open_basedir restriction in effect" warnings
  
 -    `PHP Warning:  file_get_contents(): open_basedir restriction in effect.`
 +    PHP Warning:  file_get_contents(): open_basedir restriction in effect.
  
 -You need to adjust the [open_basedir](http://www.php.net/manual/en/ini.core.php#ini.open-basedir) setting
 +You need to adjust the [open_basedir](https://www.php.net/manual/en/ini.core.php#ini.open-basedir) setting
  in your PHP configuration (`php.ini file`). By default this setting may look like this:
  
      open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/
  
 -Either add reported directories to the list or disable this setting temporarily by 
 +Either add reported directories to the list or disable this setting temporarily by
  dding ";" at the beginning of the line. Don't forget to enable this setting again
  once you are done with the PHP command line operations.
  
@@@ -44,9 -44,9 +44,9 @@@ The Apache log may contain lots of PHP 
  You should set the default time zone as instructed in the warning in
  your `php.ini` file. Find the entry about timezone and set it to
  something like this:
 -  
 +
      ; Defines the default timezone used by the date functions
 -    ; http://php.net/date.timezone
 +    ; https://php.net/date.timezone
      date.timezone = 'America/Denver'
  
  Or
@@@ -66,6 -66,14 +66,14 @@@ server development libraries (`postgres
  and recompile (`cmake .. && make`).
  
  
+ ## I see the error "ERROR: permission denied for language c"
+ 
+ `nominatim.so`, written in C, is required to be installed on the database
+ server. Some managed database (cloud) services like Amazon RDS do not allow
+ this. There is currently no work-around other than installing a database
+ on a non-managed machine.
+ 
+ 
  ### I see the error: "function transliteration(text) does not exist"
  
  Reinstall the nominatim functions with `setup.php --create--functions`
@@@ -83,11 -91,11 +91,11 @@@ vboxfs
  
  ### nominatim UPDATE failed: ERROR: buffer 179261 is not owned by resource owner Portal
  
 -Several users [reported this](https://github.com/openstreetmap/Nominatim/issues/1168) during the initial import of the database. It's 
 -something Postgresql internal Nominatim doesn't control. And Postgresql forums
 +Several users [reported this](https://github.com/openstreetmap/Nominatim/issues/1168) during the initial import of the database. It's
 +something PostgreSQL internal Nominatim doesn't control. And PostgreSQL forums
  suggest it's threading related but definitely some kind of crash of a process.
  Users reported either rebooting the server, different hardware or just trying
 -the import again worked. 
 +the import again worked.
  
  ### The website shows: "Could not get word tokens"
  
@@@ -140,7 -148,7 +148,7 @@@ Example error messag
     CONTEXT: PL/pgSQL function make_standard_name(text) line 5 at assignment]
  ```
  
 -The Postgresql database, i.e. user postgres, needs to have access to that file.
 +The PostgreSQL database, i.e. user `postgres`, needs to have access to that file.
  
  The permission need to be read & executable by everybody, e.g.
  
@@@ -155,7 -163,7 +163,7 @@@ When running SELinux, make sure that th
  
  ### Setup.php fails with "DB Error: extension not found"
  
 -Make sure you have the Postgres extensions hstore and postgis installed.
 +Make sure you have the PostgreSQL extensions "hstore" and "postgis" installed.
  See the installation instruction for a full list of required packages.
  
  
@@@ -165,7 -173,7 +173,7 @@@
  
  The message is a bit misleading as PHP needs to load the file `DB.php` and
  instead re-loads Nominatim's `db.php`. To solve this make sure you
 -have the [Pear module 'DB'](http://pear.php.net/package/DB/) installed.
 +have the [Pear module 'DB'](https://pear.php.net/package/DB/) installed.
  
      sudo pear install DB
  
@@@ -190,7 -198,7 +198,7 @@@ For updates you need to download the ch
  once per day and apply them **separately** using
  
      ./utils/update.php --import-diff <filename> --index
 -    
 +
  See [this issue](https://github.com/openstreetmap/Nominatim/issues/60#issuecomment-18679446)
  for a script that runs the updates using osmosis.