Updating to 3.2.0 from 3.1.2: An exception occurred in the driver: could not find driver

[codaamok]

How Shlink is set up

• Shlink Version: 3.1.2
• PHP Version: 8.1
• How do you serve Shlink: self-hsoted nginx
• Database engine used: MariaDB 10.3.38

Summary

I was running version 3.1.0 so I wanted to upgrade to the latest. I decided to follow a sequential upgrade path as I saw in the docs this is suggested instead of skipping version.

I'm trying to run the update with php 8.1 installed:

root@CODAAMOKAZ01:/var/www/shlink# vendor/bin/shlink-installer update -vvv

I'm received with the following output:

 Welcome to Shlink!!
 This tool will guide you through the installation process.

 Do you want to import configuration from previous installation? (You will still be asked for any new config option that did not exist in previous shlink versions) (yes/no) [yes]:
 >

 Previous shlink installation path from which to import config:
 > /var/www/shlink.old

URL SHORTENER
=============

 Do you want to support short URLs with multi-segment custom slugs? (for example, https://example.com/foo/bar) [Slugs and short codes will support only one segment (https://example.com/foo). Orphan visits will have one of "base_url", "invalid_short_url" or "regular_404" type.]:
  [yes] Custom slugs will support multiple segments (https://example.com/foo/bar/baz). Orphan visits will only have either "base_url" or "invalid_short_url" type.
  [no ] Slugs and short codes will support only one segment (https://example.com/foo). Orphan visits will have one of "base_url", "invalid_short_url" or "regular_404" type.
 > no

 Custom configuration properly generated!

Updating database... [Running "/usr/bin/php8.1 bin/cli db:migrate"]   RUN  '/usr/bin/php8.1' 'bin/cli' 'db:migrate'
  OUT  Migrating database...
  OUT
  ERR    RUN  '/usr/bin/php8.1' 'vendor/doctrine/migrations/bin/doctrine-migrations.php' 'migrations:migrate' '--no-interaction'
  ERR    ERR
  ERR    ERR  In ExceptionConverter.php line 82:
  ERR    ERR
  ERR    ERR    [Doctrine\DBAL\Exception\DriverException]
  ERR    ERR    An exception occurred in the driver: could not find driver
  ERR    ERR
  ERR    ERR
  ERR    ERR  Exception trace:
  ERR    ERR    at /var/www/shlink/vendor/doctrine/dbal/src/Driver/API/SQLite/ExceptionConverter.php:82
  ERR    ERR   Doctrine\DBAL\Driver\API\SQLite\ExceptionConverter->convert() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1814
  ERR    ERR   Doctrine\DBAL\Connection->handleDriverException() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1757
  ERR    ERR   Doctrine\DBAL\Connection->convertException() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:343
  ERR    ERR   Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1531
  ERR    ERR   Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1029
  ERR    ERR   Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:565
  ERR    ERR   Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:237
  ERR    ERR   Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.php:132
  ERR    ERR   Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /var/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR    ERR   Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor/symfony/console/Application.php:998
  ERR    ERR   Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/vendor/symfony/console/Application.php:299
  ERR    ERR   Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/symfony/console/Application.php:171
  ERR    ERR   Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR    ERR   Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR    ERR   Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
  ERR    ERR
  ERR    ERR  In Exception.php line 30:
  ERR    ERR
  ERR    ERR    [Doctrine\DBAL\Driver\PDO\Exception]
  ERR    ERR    could not find driver
  ERR    ERR
  ERR    ERR
  ERR    ERR  Exception trace:
  ERR    ERR    at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
  ERR    ERR   Doctrine\DBAL\Driver\PDO\Exception::new() at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/SQLite/Driver.php:48
  ERR    ERR   Doctrine\DBAL\Driver\PDO\SQLite\Driver->connect() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:341
  ERR    ERR   Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1531
  ERR    ERR   Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1029
  ERR    ERR   Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:565
  ERR    ERR   Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:237
  ERR    ERR   Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.php:132
  ERR    ERR   Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /var/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR    ERR   Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor/symfony/console/Application.php:998
  ERR    ERR   Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/vendor/symfony/console/Application.php:299
  ERR    ERR   Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/symfony/console/Application.php:171
  ERR    ERR   Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR    ERR   Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR    ERR   Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
  ERR    ERR
  ERR    ERR  In Driver.php line 42:
  ERR    ERR
  ERR    ERR    [PDOException]
  ERR    ERR    could not find driver
  ERR    ERR
  ERR    ERR
  ERR    ERR  Exception trace:
  ERR    ERR    at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/SQLite/Driver.php:42
  ERR    ERR   PDO->__construct() at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/SQLite/Driver.php:42
  ERR    ERR   Doctrine\DBAL\Driver\PDO\SQLite\Driver->connect() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:341
  ERR    ERR   Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1531
  ERR    ERR   Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:1029
  ERR    ERR   Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:565
  ERR    ERR   Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/dbal/src/Connection.php:237
  ERR    ERR   Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.php:132
  ERR    ERR   Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /var/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR    ERR   Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor/symfony/console/Application.php:998
  ERR    ERR   Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/vendor/symfony/console/Application.php:299
  ERR    ERR   Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/symfony/console/Application.php:171
  ERR    ERR   Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doctrine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR    ERR   Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR    ERR   Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrations/bin/doctrine-migrations.php:46
  ERR    ERR
  ERR    ERR  migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
  ERR    ERR
  ERR    ERR
  ERR  In Process.php line 267:
  ERR
  ERR    [Symfony\Component\Process\Exception\ProcessFailedException]
  ERR    The command "'/usr/bin/php8.1' 'vendor/doctrine/migrations/bin/doctrine-mig
  ERR    rations.php' 'migrations:migrate' '--no-interaction'" failed.
  ERR
  ERR    Exit Code: 1(General error)
  ERR
  ERR    Working directory: /var/www/shlink
  ERR
  ERR    Output:
  ERR    ================
  ERR
  ERR
  ERR    Error Output:
  ERR    ================
  ERR
  ERR    In ExceptionConverter.php line 82:
  ERR
  ERR      [Doctrine\DBAL\Exception\DriverException]
  ERR      An exception occurred in the driver: could not find driver
  ERR
  ERR
  ERR    Exception trace:
  ERR      at /var/www/shlink/vendor/doctrine/dbal/src/Driver/API/SQLite/ExceptionCo
  ERR    nverter.php:82
  ERR     Doctrine\DBAL\Driver\API\SQLite\ExceptionConverter->convert() at /var/www/
  ERR    shlink/vendor/doctrine/dbal/src/Connection.php:1814
  ERR     Doctrine\DBAL\Connection->handleDriverException() at /var/www/shlink/vendo
  ERR    r/doctrine/dbal/src/Connection.php:1757
  ERR     Doctrine\DBAL\Connection->convertException() at /var/www/shlink/vendor/doc
  ERR    trine/dbal/src/Connection.php:343
  ERR     Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dba
  ERR    l/src/Connection.php:1531
  ERR     Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor
  ERR    /doctrine/dbal/src/Connection.php:1029
  ERR     Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrin
  ERR    e/dbal/src/Connection.php:565
  ERR     Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/db
  ERR    al/src/Connection.php:237
  ERR     Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine
  ERR    /migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.ph
  ERR    p:132
  ERR     Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /va
  ERR    r/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR     Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor
  ERR    /symfony/console/Application.php:998
  ERR     Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/v
  ERR    endor/symfony/console/Application.php:299
  ERR     Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/s
  ERR    ymfony/console/Application.php:171
  ERR     Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doc
  ERR    trine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR     Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/
  ERR    vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR     Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrati
  ERR    ons/bin/doctrine-migrations.php:46
  ERR
  ERR    In Exception.php line 30:
  ERR
  ERR      [Doctrine\DBAL\Driver\PDO\Exception]
  ERR      could not find driver
  ERR
  ERR
  ERR    Exception trace:
  ERR      at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
  ERR     Doctrine\DBAL\Driver\PDO\Exception::new() at /var/www/shlink/vendor/doctri
  ERR    ne/dbal/src/Driver/PDO/SQLite/Driver.php:48
  ERR     Doctrine\DBAL\Driver\PDO\SQLite\Driver->connect() at /var/www/shlink/vendo
  ERR    r/doctrine/dbal/src/Connection.php:341
  ERR     Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dba
  ERR    l/src/Connection.php:1531
  ERR     Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor
  ERR    /doctrine/dbal/src/Connection.php:1029
  ERR     Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrin
  ERR    e/dbal/src/Connection.php:565
  ERR     Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/db
  ERR    al/src/Connection.php:237
  ERR     Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine
  ERR    /migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.ph
  ERR    p:132
  ERR     Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /va
  ERR    r/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR     Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor
  ERR    /symfony/console/Application.php:998
  ERR     Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/v
  ERR    endor/symfony/console/Application.php:299
  ERR     Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/s
  ERR    ymfony/console/Application.php:171
  ERR     Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doc
  ERR    trine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR     Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/
  ERR    vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR     Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrati
  ERR    ons/bin/doctrine-migrations.php:46
  ERR
  ERR    In Driver.php line 42:
  ERR
  ERR      [PDOException]
  ERR      could not find driver
  ERR
  ERR
  ERR    Exception trace:
  ERR      at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/SQLite/Driver.php:
  ERR    42
  ERR     PDO->__construct() at /var/www/shlink/vendor/doctrine/dbal/src/Driver/PDO/
  ERR    SQLite/Driver.php:42
  ERR     Doctrine\DBAL\Driver\PDO\SQLite\Driver->connect() at /var/www/shlink/vendo
  ERR    r/doctrine/dbal/src/Connection.php:341
  ERR     Doctrine\DBAL\Connection->connect() at /var/www/shlink/vendor/doctrine/dba
  ERR    l/src/Connection.php:1531
  ERR     Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/shlink/vendor
  ERR    /doctrine/dbal/src/Connection.php:1029
  ERR     Doctrine\DBAL\Connection->executeQuery() at /var/www/shlink/vendor/doctrin
  ERR    e/dbal/src/Connection.php:565
  ERR     Doctrine\DBAL\Connection->fetchOne() at /var/www/shlink/vendor/doctrine/db
  ERR    al/src/Connection.php:237
  ERR     Doctrine\DBAL\Connection->getDatabase() at /var/www/shlink/vendor/doctrine
  ERR    /migrations/lib/Doctrine/Migrations/Tools/Console/Command/MigrateCommand.ph
  ERR    p:132
  ERR     Doctrine\Migrations\Tools\Console\Command\MigrateCommand->execute() at /va
  ERR    r/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR     Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor
  ERR    /symfony/console/Application.php:998
  ERR     Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/v
  ERR    endor/symfony/console/Application.php:299
  ERR     Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/s
  ERR    ymfony/console/Application.php:171
  ERR     Symfony\Component\Console\Application->run() at /var/www/shlink/vendor/doc
  ERR    trine/migrations/lib/Doctrine/Migrations/Tools/Console/ConsoleRunner.php:95
  ERR     Doctrine\Migrations\Tools\Console\ConsoleRunner::run() at /var/www/shlink/
  ERR    vendor/doctrine/migrations/bin/doctrine-migrations.php:45
  ERR     Doctrine\Migrations\{closure}() at /var/www/shlink/vendor/doctrine/migrati
  ERR    ons/bin/doctrine-migrations.php:46
  ERR
  ERR    migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--
  ERR    allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CO
  ERR    NFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
  ERR
  ERR
  ERR  Exception trace:
  ERR    at /var/www/shlink/vendor/symfony/process/Process.php:267
  ERR   Symfony\Component\Process\Process->mustRun() at /var/www/shlink/module/CLI/src/Util/ProcessRunner.php:48
  ERR   Shlinkio\Shlink\CLI\Util\ProcessRunner->run() at /var/www/shlink/module/CLI/src/Command/Db/AbstractDatabaseCommand.php:30
  ERR   Shlinkio\Shlink\CLI\Command\Db\AbstractDatabaseCommand->runPhpCommand() at /var/www/shlink/module/CLI/src/Command/Db/MigrateDatabaseCommand.php:31
  ERR   Shlinkio\Shlink\CLI\Command\Db\MigrateDatabaseCommand->lockedExecute() at /var/www/shlink/module/CLI/src/Command/Util/AbstractLockedCommand.php:35
  ERR   Shlinkio\Shlink\CLI\Command\Util\AbstractLockedCommand->execute() at /var/www/shlink/vendor/symfony/console/Command/Command.php:308
  ERR   Symfony\Component\Console\Command\Command->run() at /var/www/shlink/vendor/symfony/console/Application.php:998
  ERR   Symfony\Component\Console\Application->doRunCommand() at /var/www/shlink/vendor/symfony/console/Application.php:299
  ERR   Symfony\Component\Console\Application->doRun() at /var/www/shlink/vendor/symfony/console/Application.php:171
  ERR   Symfony\Component\Console\Application->run() at /var/www/shlink/bin/cli:10
  ERR
  ERR  db:migrate
  ERR
  ERR
  RES  1 Command did not run successfully

These are the modules I have installed:

root@CODAAMOKAZ01:/var/www/shlink# php -m
[PHP Modules]
apcu
calendar
Core
ctype
curl
date
dom
exif
FFI
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
intl
json
libxml
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zlib

[Zend Modules]
Zend OPcache

I would appreciate any insight on how to troubleshoot 😄

[acelaya]

Hmm. That is weird 🤔

Based on the stack trace, Shlink is trying to use SQLite instead of MariaDB, and failing because you probably don't have the driver.

The question is why is it not using the proper driver.

Can you share your generated configuration here? It's the config/params/generated_config.php file.

Please, share both the one before trying to migrate, and after trying to migrate. Make sure you redact credentials and sensitive info.

[acelaya]

I know what it is. It's a bug that was introduced in Shlink 3.2.0, but it's fixed on 3.2.1. Skip 3.2.0 and go directly to that version https://github.com/shlinkio/shlink/blob/develop/CHANGELOG.md#321---2022-08-08

After that, try to always pick the most recent patch on every release, as they include fixes that could have been potentially introduced in those feature releases.

So after 3.2.1 go to 3.3.2, then 3.4.0 and finally 3.5.2

[codaamok]

Thank you! I added this detail to the docs in a PR: shlinkio/shlink.io#345

[acelaya]

Thanks for the PR!