Convertion from SQL Lite to MySQL fails

ℹ️ Support
,
1

Can anyone help me?

php occ db:convert-type --password=“secret” --all-apps mysql db1018122-2 localhost db1018122-2
The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see PHP: PCNTL - Manual
Additionally the function ‘pcntl_signal’ and ‘pcntl_signal_dispatch’ need to be enabled in your php.ini.
The current PHP memory limit is below the recommended value of 512MB.
Creating schema in new database

In Connection.php line 140:

Failed to connect to the database: An exception occurred in the driver: SQL
STATE[HY000] [2002] No such file or directory

2

Well, you’ve got a couple things going on there. But I presume the one you’re most interested in is:

There is a problem accessing your SQLite database file in your data directory (data/nextcloud.db). Please check the permissions of this folder/file or if it exists at all.

It’s either in data or whatever you have your datadirectory configured to be. Make sure you’re running occ as your web server (or FPM, if applicable) user.

P.S. This is from the manual:

https://docs.nextcloud.com/server/latest/admin_manual/issues/general_troubleshooting.html#common-problems-error-messages

P.P.S. If you’re still stuck please post the output of php occ config:list system

3

Thank you for the tips.

  1. There ist no nextcloud.db in the data dir, but there is an owncloud.db. I used standard installation settings.

Content of the data directory:

drwxr-x— 1 wp1018122 wp1018122 4096 Aug 16 08:25 .
drwxr-x— 1 wp1018122 wp1018122 4096 Aug 15 20:01 …
drwxr-xr-x 1 wp1018122 wp1018122 26 Aug 15 20:01 admin
drwxr-xr-x 1 wp1018122 wp1018122 76 Aug 15 20:04 appdata_ocros48wmo7u
drwxr-xr-x 1 wp1018122 wp1018122 34 Aug 15 20:27 files_external
-rw-r----- 1 wp1018122 wp1018122 542 Aug 15 20:01 .htaccess
-rw-r----- 1 wp1018122 wp1018122 0 Aug 15 20:01 index.html
-rw-r----- 1 wp1018122 wp1018122 0 Aug 15 20:01 nextcloud.log
-rw-r----- 1 wp1018122 wp1018122 0 Aug 15 20:01 .ocdata
-rw-r----- 1 wp1018122 wp1018122 1392640 Aug 15 21:45 owncloud.db

  1. Here is the output of the command:
    php occ config:list system

The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see PHP: PCNTL - Manual
Additionally the function ‘pcntl_signal’ and ‘pcntl_signal_dispatch’ need to be enabled in your php.ini.
The current PHP memory limit is below the recommended value of 512MB.
{
“system”: {
“instanceid”: “REMOVED SENSITIVE VALUE”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“ugs-it.de”
],
“datadirectory”: “REMOVED SENSITIVE VALUE”,
“dbtype”: “sqlite3”,
“version”: “27.0.2.1”,
“overwrite.cli.url”: “https://ugs-it.de/nextcloud”,
“installed”: true
}
}

4

I get another errormessage I dont understand …

Qhe I process this command …

php occ db:convert-type mysql db1018122-2 127.0.0.1 db1018122-2

I get …

The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see PHP: PCNTL - Manual
Additionally the function ‘pcntl_signal’ and ‘pcntl_signal_dispatch’ need to be enabled in your php.ini.
The current PHP memory limit is below the recommended value of 512MB.
What is the database password?

Unable to hide the response.

What does that mean?

Unable to hide the response.

5

And this is in a working NC installation? You can access via via https://ugs-it.de/nextcloud? You didn’t recently move it to a new server or something?

Can you provide the output of:

  • php -i | grep -i sqlite
  • id

Other errors:

  • PCNTL: It means you don’t have php-pcntl installed (which isn’t required but is recommended)
  • Memory below 512MB: Means your php.ini (at least for the CLI mode of PHP) doesn’t have the memory_limit set to >=512M
  • Unable to hide the response: occ wasn’t able to turn off echoing to your terminal so that you could enter your password