problem with installation on Domain Factory #27

fritzmg · 2017-09-08T20:43:59Z

In the Managed Edition, the database credentials are created by the Contao Install Tool. This leads to a problem on Domain Factory if you are using the Contao Manager for installation (presumably) or composer create-project during the post-install/update-cmds:

> Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication

  [Doctrine\DBAL\Exception\DriverException]
  An exception occured in driver: SQLSTATE[HY000] [2054] Connecting to 3.22,
  3.23 & 4.0 servers is not supported

  [Doctrine\DBAL\Driver\PDOException]
  SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not supported

  [PDOException]
  SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not supported

  [PDOException]
  PDO::__construct(): Connecting to 3.22, 3.23 & 4.0  is not supported. Server is 3.23.58-log


Script Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication handling the post-install-cmd event terminated with an exception


  [RuntimeException]
  An error occurred while executing the "contao:install-web-dir" command:

    [Doctrine\DBAL\Exception\DriverException]
    An exception occured in driver: SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not supported

    [Doctrine\DBAL\Driver\PDOException]
    SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not supported

    [PDOException]
    SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not supported

    [PDOException]
    PDO::__construct(): Connecting to 3.22, 3.23 & 4.0  is not supported. Server is 3.23.58-log

As we know, Doctrine (unfortunately) always tries to make a connection to a MySQL server no matter what when initialized, even if the database credentials haven't been defined yet. It uses its default values, which includes localhost as the hostname for the MySQL server.

This is a problem on Domain Factory, because the MySQL server that is reachable under localhost is of version 3 ... See https://www.df.eu/at/support/df-faq/webhosting/datenbanken/mysql-datenbanken/

The MySQL 5.x server is behind mysql5.example.org.

The text was updated successfully, but these errors were encountered:

fritzmg · 2017-09-08T23:06:22Z

Full stack traces:

> post-install-cmd: Contao\ManagerBundle\Composer\ScriptHandler::initializeApplication


  [Doctrine\DBAL\Exception\DriverException]
  An exception occured in driver: SQLSTATE[HY000] [2054] Connecting to 3.22,
  3.23 & 4.0 servers is not supported


Exception trace:
 () at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:145
 Doctrine\DBAL\DBALException::driverException() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:47
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
 Doctrine\DBAL\Connection->connect() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/src/ContaoManager/Plugin.php:169
 Contao\ManagerBundle\ContaoManager\Plugin->getExtensionConfig() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-plugin/src/Config/ContainerBuilder.php:65
 Contao\ManagerPlugin\Config\ContainerBuilder->getExtensionConfig() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/MergeExtensionConfigurationPass.php:34
 Symfony\Component\HttpKernel\DependencyInjection\MergeExtensionConfigurationPass->process() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php:143
 Symfony\Component\DependencyInjection\Compiler\Compiler->compile() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php:746
 Symfony\Component\DependencyInjection\ContainerBuilder->compile() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:577
 Symfony\Component\HttpKernel\Kernel->initializeContainer() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/src/HttpKernel/ContaoKernel.php:213
 Contao\ManagerBundle\HttpKernel\ContaoKernel->initializeContainer() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:119
 Symfony\Component\HttpKernel\Kernel->boot() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:69
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:125
 Symfony\Component\Console\Application->run() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/bin/contao-console:44


  [Doctrine\DBAL\Driver\PDOException (2054)]
  SQLSTATE[HY000] [2054] Connecting to 3.22, 3.23 & 4.0 servers is not suppor
  ted


Exception trace:
 () at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47
 Doctrine\DBAL\Driver\PDOConnection->__construct() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:44
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:360
 Doctrine\DBAL\Connection->connect() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/src/ContaoManager/Plugin.php:169
 Contao\ManagerBundle\ContaoManager\Plugin->getExtensionConfig() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-plugin/src/Config/ContainerBuilder.php:65
 Contao\ManagerPlugin\Config\ContainerBuilder->getExtensionConfig() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/DependencyInjection/MergeExtensionConfigurationPass.php:34
 Symfony\Component\HttpKernel\DependencyInjection\MergeExtensionConfigurationPass->process() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Compiler/Compiler.php:143
 Symfony\Component\DependencyInjection\Compiler\Compiler->compile() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerBuilder.php:746
 Symfony\Component\DependencyInjection\ContainerBuilder->compile() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:577
 Symfony\Component\HttpKernel\Kernel->initializeContainer() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/src/HttpKernel/ContaoKernel.php:213
 Contao\ManagerBundle\HttpKernel\ContaoKernel->initializeContainer() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:119
 Symfony\Component\HttpKernel\Kernel->boot() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:69
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:125
 Symfony\Component\Console\Application->run() at /kunden/xxx/htdocs/projektfolder/contao/v44x/me/vendor/contao/manager-bundle/bin/contao-console:44

The problem is actually that the manager-bundle only catches Doctrine\DBAL\Exception\ConnectionException here during the MySQL connection test: https://github.com/contao/manager-bundle/blob/4.4.4/src/ContaoManager/Plugin.php#L171 .

So this problem was probably introduced in Contao 4.4.0(-RC2) with contao/manager-bundle@06f1f29#diff-e3375107bffc209723fa127bb186d8c6 .

leofeyer · 2017-09-12T13:45:10Z

As we know, Doctrine (unfortunately) always tries to make a connection to a MySQL server no matter what when initialized

This is not true. If you set dbal.connections.default.server_version, there will be no connection attempt. And we are already doing this:

https://github.com/contao/manager-bundle/blob/30240eecaab46a86c3a1d040fbeede105ea443aa/src/ContaoManager/Plugin.php#L176

fritzmg · 2017-09-12T14:10:50Z

Yeah the problem seems to be the manager-bundle's own connection test. It connects to the localhost (since at this point no database has been configured yet), but on Domain Factory, localhost is an old MySQL 3 server, which leads to the aforementioned exceptions.

leofeyer · 2017-09-12T14:34:09Z

Yeah the problem seems to be the manager-bundle's own connection test.

Can you point me to the code please?

but on Domain Factory, localhost is an old MySQL 3 server

😧

fritzmg · 2017-09-12T14:57:43Z

See my second comment. The exception occurs here: https://github.com/contao/manager-bundle/blob/4.4.4/src/ContaoManager/Plugin.php#L167-L181
This connection test only catches as Doctrine\DBAL\Exception\ConnectionException. However, if the localhost is an old MySQL 3 server, it throws a Doctrine\DBAL\Exception\DriverException (and a Doctrine\DBAL\Driver\PDOException?).

fritzmg · 2017-09-12T14:58:32Z

😧

It's fine, they still provide MySQL 5 servers, but with mysql5.example.org as the host name ;). But yeah... it's stupid that the default localhost one is MySQL 3 ... probably for legacy reasons.

leofeyer · 2017-09-12T15:51:14Z

This connection test only catches as Doctrine\DBAL\Exception\ConnectionException. However, if the localhost is an old MySQL 3 server, it throws a Doctrine\DBAL\Exception\DriverException (and a Doctrine\DBAL\Driver\PDOException?).

This should be fixed.

…o/managed-edition#27).

leofeyer · 2017-09-15T11:47:18Z

Fixed in contao/manager-bundle@9a14ef8 and contao/core-bundle@2eb52f3.

fritzmg · 2017-09-15T12:18:12Z

@leofeyer wouldn't this change not catch the connection exception that would occur on servers where anyonymous users are allowed (or not allowed... don't remember for which case this was done)?

leofeyer · 2017-09-15T13:11:28Z

What exactly are you referring to?

fritzmg · 2017-09-16T09:42:13Z

What exactly are you referring to?

contao/installation-bundle#54

leofeyer · 2017-09-16T15:42:07Z

The connection exception is a subclass of the driver exception:

https://github.com/doctrine/dbal/blob/2.5/lib/Doctrine/DBAL/Exception/ConnectionException.php#L29

fritzmg · 2017-09-16T15:49:28Z

Ah I see, I missed that, sorry.

leofeyer added bug unconfirmed labels Sep 12, 2017

leofeyer removed the unconfirmed label Sep 12, 2017

leofeyer added this to the 4.4.5 milestone Sep 14, 2017

leofeyer added a commit to contao/manager-bundle that referenced this issue Sep 15, 2017

Catch the DriverException if the database connection fails (see conta…

0b89e0a

…o/managed-edition#27).

leofeyer added a commit to contao/manager-bundle that referenced this issue Sep 15, 2017

Catch the DriverException if the database connection fails (see conta…

9a14ef8

…o/managed-edition#27).

leofeyer self-assigned this Sep 15, 2017

leofeyer added a commit to contao/core-bundle that referenced this issue Sep 15, 2017

Catch the DriverException if the database connection fails (see conta…

2eb52f3

…o/managed-edition#27).

leofeyer closed this as completed Sep 15, 2017

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

problem with installation on Domain Factory #27

problem with installation on Domain Factory #27

fritzmg commented Sep 8, 2017 •

edited

Loading

fritzmg commented Sep 8, 2017 •

edited

Loading

leofeyer commented Sep 12, 2017

fritzmg commented Sep 12, 2017 •

edited

Loading

leofeyer commented Sep 12, 2017

fritzmg commented Sep 12, 2017

fritzmg commented Sep 12, 2017

leofeyer commented Sep 12, 2017

leofeyer commented Sep 15, 2017

fritzmg commented Sep 15, 2017

leofeyer commented Sep 15, 2017

fritzmg commented Sep 16, 2017

leofeyer commented Sep 16, 2017

fritzmg commented Sep 16, 2017

problem with installation on Domain Factory #27

problem with installation on Domain Factory #27

Comments

fritzmg commented Sep 8, 2017 • edited Loading

fritzmg commented Sep 8, 2017 • edited Loading

leofeyer commented Sep 12, 2017

fritzmg commented Sep 12, 2017 • edited Loading

leofeyer commented Sep 12, 2017

fritzmg commented Sep 12, 2017

fritzmg commented Sep 12, 2017

leofeyer commented Sep 12, 2017

leofeyer commented Sep 15, 2017

fritzmg commented Sep 15, 2017

leofeyer commented Sep 15, 2017

fritzmg commented Sep 16, 2017

leofeyer commented Sep 16, 2017

fritzmg commented Sep 16, 2017

fritzmg commented Sep 8, 2017 •

edited

Loading

fritzmg commented Sep 8, 2017 •

edited

Loading

fritzmg commented Sep 12, 2017 •

edited

Loading