Error during upgrade process (SQLSTATE[HY000] [2002])

Hello,

I currently want to upgrade my Neos from 2.2 to 2.3, so I followed the instructions from https://www.neos.io/download-and-extend/upgrade-instructions-2-2-2-2-3.html. This worked pretty fine up to:

Run database migrations

./flow doctrine:migrate

Then I got the error “An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory” with the error log:

Exception in line 145 of /var/www/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory

32 Doctrine\DBAL\Driver\AbstractMySQLDriver::convertException("An exception occured in driver: SQLSTATE[HY000] [2002] No such file or directory", Doctrine\DBAL\Driver\PDOException)
31 Doctrine\DBAL\DBALException::driverException(Doctrine\DBAL\Driver\PDOMySql\Driver, Doctrine\DBAL\Driver\PDOException)
30 Doctrine\DBAL\Driver\PDOMySql\Driver::connect(array|7|, NULL, NULL, array|0|)
29 Doctrine\DBAL\Connection::connect()
28 Doctrine\DBAL\Connection::executeQuery("SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'", array|0|, array|0|)
27 Doctrine\DBAL\Connection::fetchAll("SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'")
26 Doctrine\DBAL\Schema\AbstractSchemaManager::listTableNames()
25 Doctrine\DBAL\Schema\AbstractSchemaManager::tablesExist(array|1|)
24 TYPO3\Flow\Persistence\Doctrine\Service_Original::getMigrationConfiguration()
23 TYPO3\Flow\Persistence\Doctrine\Service_Original::executeMigrations(NULL, NULL, FALSE, FALSE)
22 call_user_func_array(array|2|, array|4|)
21 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("executeMigrations", array|4|)
20 TYPO3\Flow\Command\DoctrineCommandController_Original::migrateCommand(NULL, NULL, FALSE, FALSE)
19 call_user_func_array(array|2|, array|4|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/var/www/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Does anyone had the same problems and know an solution.

Regards

Some more information after some debugging:

the PDOConnection.php don’t get empty parameter for:

public function __construct($dsn, $user = null, $password = null, array $options = null)

So I set them manuell and then I got a new error: “An exception occured in driver: could not find driver”. So I added some extensions to php.ini:
extension=php_pdo_mysql.dll
extension=pdo_mysql.so
and reload the apache service, but still getting the same error.

Regards

Hi,

do you get the correct DB options when you execute

./flow configuration:show --type Settings --path TYPO3.Flow.persistence.backendOptions

on the CLI, including driver: pdo_mysql?