Problem converting database type from mysql to postgres

ℹ️ Support
, ,
1

I’m running a small nextcloud instance 28.0.2.5 on Debian GNU/Linux 12 in a docker container
and want to convert the existing mysql database to postgres.
The mysql database running on 192.168.7.44:13306 has no ssl configuration and can be reached via cli without problems.
from config.php:

 'datadirectory' => '/var/www/html/data',
  'dbtype' => 'mysql',
  'version' => '28.0.2.5',
  'overwriteprotocol' => 'https',
  'overwrite.cli.url' => 'http://mycloud.de',
  'dbname' => 'nextcloud',
  'dbhost' => '192.168.7.44:13306',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud_db_user',
  'dbpassword' => 'password',

Unfortunately:

php occ db:convert-type --password='password' --clear-schema pgsql nextcloud_db_user 192.168.7.44 nextcloud_db -v

This command gives me the error:

In Connection.php line 139:
        ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙
  [Doctrine\DBAL\Exception (7)]
  Failed to connect to the database: An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "192.168.7.44", port 13306 failed
  : received invalid response to SSL negotiation: q
        ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙       ⦙

Exception trace:
  at /var/www/html/lib/private/DB/Connection.php:139
 OC\DB\Connection->connect() at /var/www/html/3rdparty/doctrine/dbal/src/Connection.php:452
 Doctrine\DBAL\Connection->getDatabasePlatformVersion() at /var/www/html/3rdparty/doctrine/dbal/src/Connection.php:410
 Doctrine\DBAL\Connection->detectDatabasePlatform() at /var/www/html/3rdparty/doctrine/dbal/src/Connection.php:317
 Doctrine\DBAL\Connection->getDatabasePlatform() at /var/www/html/3rdparty/doctrine/dbal/src/Schema/LegacySchemaManagerFactory.php:16
 Doctrine\DBAL\Schema\LegacySchemaManagerFactory->createSchemaManager() at /var/www/html/3rdparty/doctrine/dbal/src/Connection.php:1682
 Doctrine\DBAL\Connection->createSchemaManager() at /var/www/html/3rdparty/doctrine/dbal/src/Connection.php:1703
 Doctrine\DBAL\Connection->getSchemaManager() at /var/www/html/core/Command/Db/ConvertType.php:279
 OC\Core\Command\Db\ConvertType->getTables() at /var/www/html/core/Command/Db/ConvertType.php:261
 OC\Core\Command\Db\ConvertType->clearSchema() at /var/www/html/core/Command/Db/ConvertType.php:188
 OC\Core\Command\Db\ConvertType->execute() at /var/www/html/3rdparty/symfony/console/Command/Command.php:298
 Symfony\Component\Console\Command\Command->run() at /var/www/html/3rdparty/symfony/console/Application.php:1040
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/3rdparty/symfony/console/Application.php:301
 Symfony\Component\Console\Application->doRun() at /var/www/html/3rdparty/symfony/console/Application.php:171
 Symfony\Component\Console\Application->run() at /var/www/html/lib/private/Console/Application.php:206
 OC\Console\Application->run() at /var/www/html/console.php:100
 require_once() at /var/www/html/occ:11

The logs from the mysql says:

2024-02-18 17:03:28 101153 [Warning] Aborted connection 101153 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.1' (This connection closed normally without authentication)

Any idea?

2

The command line parameters should be for the new (target) database. You don’t specify the existing database info, because it already knows that from your Nextcloud config.

[1] Converting database type — Nextcloud latest Administration Manual latest documentation

3

The parameters are for the new target database - they are the same as for the old mysql database.