Can no longer install with Doctrine DBAL 2.5

[leofeyer]

Doctrine DBAL 2.5 has added the server_version parameter. It it is not given, Doctrine tries to read it from the MySQL server, thus enabling a database connection, which leads to an Access denied for user ''@'localhost' exception.

Related issue: kriswallsmith/assetic#681

[leofeyer]

@contao/developers @fritzmg /cc

[aschempp]

Doctrine tries to read it from the MySQL server

Who's Doctrine? The bundle? The bundle extension?

[Toflar]

When does that error happen? When you call the install tool? The screenshot does not include the whole stack trace :)

[leofeyer]

The problem is not limited to the install tool. It occurs everywhere.

[leofeyer]

See: doctrine/dbal#990
See: doctrine/DoctrineBundle#351

[aschempp]

The quickest solution would be to add a conflict with 2.5?

[aschempp]

The solution is fairly simple. We cannot assume a complete installation without a working DB connection. Adjust to the following:

// class Contao\Config
public static function isComplete()
{
	if (static::$blnHasLcf === null || !static::has('licenseAccepted'))
	{
		return false;
	}

	try
	{
		\Database::getInstance()->listTables();
	}
	catch (\Exception $e)
	{
		return false;
	}

	return true;
}

[fritzmg]

@aschempp but this would introduce two additional database queries on each request.

[aschempp]

True, we should probably perform the DB check only when we're in the install tool.

Another option would be to store isComplete in the container, but that's rather strange imho.

[leofeyer]

This does not fix the issue, because the problem originates somewhere else.

https://github.com/doctrine/dbal/blob/master/lib/Doctrine/DBAL/Connection.php#L429

As you can see in the stack trace, the detectDatabasePlatform() method is causing the issue, because it tries to connect to the database before the database credentials have been set.

[aschempp]

It does fix the issue in my installation. detectDatabasePlatform is only called because someone tries to connect, in my case it's the cron job listener checking if table tl_cron exists.

[leofeyer]

Nope, sorry. Your fix is not working.

[leofeyer]

And just so you see that the issue is not at all related to the install tool:

[aschempp]

Well to me the install tool must work without DB, everything else cannot work. Idk why the command tries to connect to the database?

[leofeyer]

Because Doctrine DBAL tries to connect to the database to retrieve the version number.

https://github.com/doctrine/dbal/blob/master/lib/Doctrine/DBAL/Connection.php#L429

And this already happens in ConnectionFactory::createConnection(), which is executed upon $container->get('doctrine.dbal.default_connection');.

And all of this happens way before the installation controller is even constructed!

[aschempp]

In my case no connection to the database was made if noone queried something…

[fritzmg]

This error will probably only occur, if you do not allow anonymous connections to your database server (see also contao/core-bundle#736).

[leofeyer]

Yes, that's true. If anonymous connections are allowed, the issue does not occur. But that's rarely the case fortunately.

[leofeyer]

I have commented here to document the issue.

[leofeyer]

BTW, this issue also affects the managed edition:

[leofeyer]

It seems that our BinaryStringType is the reason why the getDatabasePlatform() method is called in the ConnectionFactory class. We might be able to register it in an compiler path to work around it.

[mattjanssen]

Sounds like your GUI config bundle needs to be able to handle when the DB credentials are missing or are no longer valid? Perhaps you could register a kernel.exception event listener that disables the doctrine config section once a DB ConnectionException is thrown. It could do this by either editing config.yml or switching to the "install" environment which would load config_install.yml. Finally it redirects the user with a RedirectResponse to the GUI admin login page with a nice error.

This is assuming your GUI config bundle is in the business of editing config.yml, which seems like a possibility :)

[leofeyer]

@mattjanssen Thanks a lot for your input. Much appreciated.

[leofeyer]

We are now dynamically adding server_version: 5.1 in the Contao managed edition, if there is no database connection: contao/manager-bundle@06f1f29

[aschempp]

@leofeyer should we add an is_array check in contao/manager-bundle@fd465bc#diff-e3375107bffc209723fa127bb186d8c6R146 ?

[leofeyer]

If $extensionConfig['dbal']['connections']['default'] is set, it should always be an array, shouldn't it?

[Toflar]

Unit tests would tell you :P

[leofeyer]

No true in this case. If $extensionConfig['dbal']['connections']['default'] is not an array, the user has misconfigured the application.

doctrine:
    dbal:
        connections:
            default: 'string'  <--  this is wrong!

[aschempp]

Unit tests would tell you :P

Not really, because the data is coming from other bundles. I think the unifying of TreeBuilder is only done after our method. According to https://github.com/doctrine/DoctrineBundle/blob/master/DependencyInjection/Configuration.php#L69 it's actually possible to set the connection details directly in doctrine.dbal but I think that's just an unsupported case for us then, especially because we know that the config loaded by manager-bundle will not be like that.

[fritzmg]

Is this actually fixed in Contao 4.4.0? I am unable to open the Install Tool once I have removed the anonymous user accounts from my SQL database. Stack trace seems to be the same as posted by @leofeyer

// nvm, suddenly it worked after clearing the dev cache