DDEV & Contao 5.3

[Merlin]

Hallo zusammen,

kann mir bitte jemand mal auf die Sprünge helfen. Aufgrund das meine alte Entwicklungsumgebung scheinbar eingestellt ist, habe ich mich für ddev & docker entschieden.

Ich habe alles so gemacht wie in der Doku, bekomme aber die Verbindung zur Database nicht zustande.

Server Läuft, (ddiv Adminer hat zugriff)

DATABASE_URL='mysql://db:db@db/db?serverVersion=mariadb-10.7'
#MAILER_DSN=
APP_ENV=dev

ich bekomme nur

An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory


ODER


An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: nodename nor servname provided, or not known

[Ainschy]

Hallo Merlin,

wie sieht den deine ddev config aus? Die Server Version habe ich nicht extra mit angegeben:

DATABASE_URL='mysql://db:db@db/db 

Meine ddev config.yaml sieht wie folgt aus:

name: contao53
type: php
docroot: public
php_version: "8.3"
webserver_type: apache-fpm
xdebug_enabled: false
additional_hostnames: []
additional_fqdns: []
database:    
   type: mariadb
   version: "10.4"
use_dns_when_possible: true
composer_version: "2"
web_environment: []
default_container_timeout: "240"
timezone: Europe/Berlin 

[Merlin]

Hallo Ainschy,

vielen Dank für deine Nachricht

so sieht meine aus

name: contao-ddev
type: php
docroot: "contao/public"
php_version: "8.2"
webserver_type: apache-fpm
xdebug_enabled: false
additional_hostnames: []
additional_fqdns: []
database:
    type: mariadb
    version: "10.7"
use_dns_when_possible: true
default_container_timeout: "240"
timezone: Europe/Berlin
composer_version: "2"
web_environment: []

[Spooky]

Laut Fehlermeldung existiert der Hostname für die Datenbank nicht.

[Merlin]

Laut Fehlermeldung existiert der Hostname für die Datenbank nicht.

Hi Spooky,

ja da geb ich dir recht, der Server Läuft aber und ich kann mit Ohne Probleme mit ddev Adminer auf die DB zugreifen.

ich finde aber das problem nicht

[Adnan]

bin auch gerade dabei, die 5.3er per ddev zu installieren und bekomme folgende Meldungen:

[2024-03-09T12:28:04.821394+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" at ExceptionConverter.php line 101 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/","request_method":"GET"}
[2024-03-09T12:28:04.827642+00:00] php.CRITICAL: Uncaught Exception: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/","request_method":"GET"}
[2024-03-09T12:28:04.827870+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" at ExceptionConverter.php line 101 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/","request_method":"GET"}
[2024-03-09T12:28:04.889428+00:00] request.INFO: Matched route "contao_core_favicon__invoke". {"route":"contao_core_favicon__invoke","route_parameters":{"_route":"contao_core_favicon__invoke","_scope":"frontend","_controller":"Contao\\CoreBundle\\Controller\\FaviconController"},"request_uri":"https://test.ddev.site/favicon.ico","method":"GET"} {"request_uri":"https://test.ddev.site/favicon.ico","request_method":"GET"}
[2024-03-09T12:28:04.903655+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" at ExceptionConverter.php line 101 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/favicon.ico","request_method":"GET"}
[2024-03-09T12:28:04.907939+00:00] php.CRITICAL: Uncaught Exception: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/favicon.ico","request_method":"GET"}
[2024-03-09T12:28:04.908189+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused" at ExceptionConverter.php line 101 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/favicon.ico","request_method":"GET"}
[2024-03-09T12:28:04.909469+00:00] php.CRITICAL: Uncaught Exception: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 2002): An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/html/contao/vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:33)"} {"request_uri":"https://test.ddev.site/favicon.ico","request_method":"GET"}

meine .env und config.yml sehen nahezu identisch aus, wie oben.

nutze heidisql und kann da die datenbanken (auch die 'db') sehen.

danke im voraus.

[Spooky]

Laut Fehlermeldung hast du keine Datenbank Zugangsdaten in deiner parameters.yml oder .env.local

[Adnan]

Danke für den Tipp, hatte die .env statt der .env.local befüllt. allerdings werden andere fehler angezeigt.
und zwar wird die tabelle tl_page nicht gefunden. heisst, die db muss vorher angelegt werden. hatte das wohl überlesen. man muss
php vendor/bin/contao-console contao:migrate
auf dem container ausführen.

[Spooky]

Nachdem du die Datenbankverbindungsdaten eingetragen hast, musst du

bin/console contao:migrate --no-interaction

ausführen. Danach kannst du dir mit

bin/console contao:user:create

einen Backend User Account anlegen.

[Adnan]

danke.