Misleading documentation when using docer + postgresql

🚧 Installation
#1

Hello! I am trying to use nextcloud in docker (with apache) and to connect with a postgres sql server on the host. Postgres is accepting remote connections and nextcloud user is added in the host (i have tested

![image|690x43](upload://tMbzuFln9vDxheVMB2QnwSWCrZW.png)

This is the image from a windows computer

hence, with this established I have the following docker-compose file

version: '3.7'

services:
  app:
    container_name: nextcloud
    image: nextcloud
    restart: always
    volumes:
      - /var/lib/nextcloud/app:/var/www/html:rw
      - /media/storage/srv/nextcloud:/var/www/html/data:rw
      - /var/log/nextcloud:/var/log
    ports:
      - 8084:80
    environment:
      - NEXTCLOUD_ADMIN_USER=
      - NEXTCLOUD_ADMIN_PASSWORD=
      - POSTGRES_DB=nextcloud
      - POSTGRES_USER=nextcloud
      - POSTGRES_PASSWORD=
      - POSTGRES_HOST=192.168.10.100


    env_file:
      - .env

With this, I get the error in the apache root (whith is /media/storage/srv/nextcloud)
{“reqId”:“TWK0LMn0j24hrEXSjiIR”,“level”:3,“time”:“2020-12-22T10:37:17+00:00”,“remoteAddr”:“86.121.173.219”,“user”:"–",“app”:“core”,“method”:“GET”,“url”:"/",“message”:{“Exception”:“Doctrine\DBAL\DBALException”,“Message”:“Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution”,“Code”:0,“Trace”:[{“file”:"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:1449,“function”:“connect”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[]},{“file”:"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:892,“function”:“getWrappedConnection”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/DB/Connection.php",“line”:202,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“SELECT * FROM oc_appconfig“,[],[],null]},{“file”:”/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php”,“line”:206,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“SELECT * FROM oc_appconfig“,[],[]]},{“file”:”/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:217,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:345,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:110,“function”:“loadConfigValues”,“class”:“OC\AppConfig”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:301,“function”:“getApps”,“class”:“OC\AppConfig”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/legacy/OC_App.php",“line”:949,“function”:“getValues”,“class”:“OC\AppConfig”,“type”:"->",“args”:[false,“installed_version”]},{“file”:"/var/www/html/lib/private/Server.php",“line”:668,“function”:“getAppVersions”,“class”:“OC_App”,“type”:"::",“args”:[]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:155,“function”:“OC\{closure}”,“class”:“OC\Server”,“type”:"->",“args”:["*** sensitive parameters replaced "]},{“file”:"/var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php",“line”:118,“function”:“OC\AppFramework\Utility\{closure}”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:122,“function”:“offsetGet”,“class”:“Pimple\Container”,“type”:"->",“args”:[“OC\Memcache\Factory”]},{“file”:"/var/www/html/lib/private/ServerContainer.php",“line”:156,“function”:“query”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[“OC\Memcache\Factory”,true]},{“file”:"/var/www/html/lib/private/Server.php",“line”:1677,“function”:“query”,“class”:“OC\ServerContainer”,“type”:"->",“args”:[“OC\Memcache\Factory”]},{“file”:"/var/www/html/lib/private/Server.php",“line”:1017,“function”:“getMemCacheFactory”,“class”:“OC\Server”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:155,“function”:“OC\{closure}”,“class”:“OC\Server”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php",“line”:118,“function”:“OC\AppFramework\Utility\{closure}”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:122,“function”:“offsetGet”,“class”:“Pimple\Container”,“type”:"->",“args”:[“OCP\Lock\ILockingProvider”]},{“file”:"/var/www/html/lib/private/ServerContainer.php",“line”:156,“function”:“query”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[“OCP\Lock\ILockingProvider”,true]},{“file”:"/var/www/html/lib/private/Server.php",“line”:1977,“function”:“query”,“class”:“OC\ServerContainer”,“type”:"->",“args”:[“OCP\Lock\ILockingProvider”]},{“file”:"/var/www/html/lib/private/Files/View.php",“line”:118,“function”:“getLockingProvider”,“class”:“OC\Server”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/Server.php",“line”:395,“function”:"__construct",“class”:“OC\Files\View”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:155,“function”:“OC\{closure}”,“class”:“OC\Server”,“type”:"->",“args”:[" sensitive parameters replaced "]},{“file”:"/var/www/html/3rdparty/pimple/pimple/src/Pimple/Container.php",“line”:118,“function”:“OC\AppFramework\Utility\{closure}”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[" sensitive parameters replaced ***"]},{“file”:"/var/www/html/lib/private/AppFramework/Utility/SimpleContainer.php",“line”:122,“function”:“offsetGet”,“class”:“Pimple\Container”,“type”:"->",“args”:[“OC\Files\Node\HookConnector”]},{“file”:"/var/www/html/lib/private/ServerContainer.php",“line”:156,“function”:“query”,“class”:“OC\AppFramework\Utility\SimpleContainer”,“type”:"->",“args”:[“OC\Files\Node\HookConnector”,true]},{“file”:"/var/www/html/lib/private/Server.php",“line”:1324,“function”:“query”,“class”:“OC\ServerContainer”,“type”:"->",“args”:[“OC\Files\Node\HookConnector”]},{“file”:"/var/www/html/lib/base.php",“line”:595,“function”:“boot”,“class”:“OC\Server”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/base.php",“line”:1091,“function”:“init”,“class”:“OC”,“type”:"::",“args”:[]},{“file”:"/var/www/html/index.php",“line”:35,“args”:["/var/www/html/lib/base.php"],“function”:“require_once”}],“File”:"/var/www/html/lib/private/DB/Connection.php",“Line”:72,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36”,“version”:“16.0.3.0”}
{“reqId”:“TWK0LMn0j24hrEXSjiIR”,“level”:3,“time”:“2020-12-22T10:37:17+00:00”,“remoteAddr”:“86.121.173.219”,“user”:"–",“app”:“core”,“method”:“GET”,“url”:"/",“message”:{“Exception”:“Doctrine\DBAL\DBALException”,“Message”:“Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution”,“Code”:0,“Trace”:[{“file”:"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:1449,“function”:“connect”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[]},{“file”:"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",“line”:892,“function”:“getWrappedConnection”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/DB/Connection.php",“line”:202,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->",“args”:[“SELECT * FROM oc_appconfig“,[],[],null]},{“file”:”/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php”,“line”:206,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->",“args”:[“SELECT * FROM oc_appconfig“,[],[]]},{“file”:”/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:217,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:345,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:110,“function”:“loadConfigValues”,“class”:“OC\AppConfig”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/AppConfig.php",“line”:301,“function”:“getApps”,“class”:“OC\AppConfig”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/legacy/OC_App.php",“line”:949,“function”:“getValues”,“class”:“OC\AppConfig”,“type”:"->",“args”:[false,“installed_version”]},{“file”:"/var/www/html/lib/private/TemplateLayout.php",“line”:185,“function”:“getAppVersions”,“class”:“OC_App”,“type”:"::",“args”:[]},{“file”:"/var/www/html/lib/private/legacy/OC_Template.php",“line”:183,“function”:"__construct",“class”:“OC\TemplateLayout”,“type”:"->",“args”:[“error”,""]},{“file”:"/var/www/html/lib/private/Template/Base.php",“line”:132,“function”:“fetchPage”,“class”:“OC_Template”,“type”:"->",“args”:[]},{“file”:"/var/www/html/lib/private/legacy/OC_Template.php",“line”:332,“function”:“printPage”,“class”:“OC\Template\Base”,“type”:"->",“args”:[]},{“file”:"/var/www/html/index.php",“line”:63,“function”:“printExceptionErrorPage”,“class”:“OC_Template”,“type”:"::",“args”:[{“class”:“Doctrine\DBAL\DBALException”},500]}],“File”:"/var/www/html/lib/private/DB/Connection.php",“Line”:72,“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36”,“version”:“16.0.3.0”}

I have tried a few options in the docker compose, but per my understanding this is a documentatioon bug or I am missing something. I hope my issue will help others as well and I am offering to write a post or some clarification.

Regards,
Daniel

#2

your postgres db is on another host?