Error 500, database conversion step

[M4vrick]

Hello

I have a owncloud server hosted on debian, you can find the information below.
Since a few days I could not synchronize some data, the windows client is displaying 500 errors.

After a few search it seems the default SQLite database is the source of the issue.
I’ve read the documentation about the database conversion : https://doc.owncloud.org/server/8.1/admin_manual/configuration_database/db_conversion.html

But it seems a little too easy.
I’m not a great sysadmin and not a dbadmin so I have a few questions about the conversion process:

• Do I need to create a database on MySQL before the conversion ? if yes where can I find the corresponding command ?
• I know my Owncloud version is old, is it better to do the update before or after converting to MySQL database ?
• Is there any step by step tutorial or blog or something about the database conversion ?

Thanks for your help

Server configuration

Operating system: Debian 7.11

Web server: Apache

Database: SQLite

PHP version: PHP 5.4.45-0+deb7u5

ownCloud version: (see ownCloud admin page) 8.1.9

Updated from an older ownCloud or fresh install: Fresh

Where did you install ownCloud from: Owncloud official source

[alfredb]

Is there any step by step tutorial or blog or something about the database conversion ?

You could use the search function, you’ll find

Convert database, sqlite to mysql

Hi there! I encountered a problem while converting from sqlite3 to mysql, any help is appreciated The admin manual at: https://doc.owncloud.org/server/9.0/admin_manual/configuration_database/db_conversion.html states how to convert the db via occ command. php occ db:convert-type --all-apps mysql oc_mysql_user 127.0.0.1 new_db_name for me: php occ db:convert-type --all-apps mysql owncloud 127.0.0.1 owncloud_db (Btw. it does state, that one has to add the user 'oc_mysql_user…

[M4vrick]

Hi Alfred,

Thanks for your help.
I used the search function but didnt find this particular topic.

Seems I could use the convert command line directly. I’ll try this and let you know the result.

[alfredb]

Good luck! I’m so happy using mysql from the beginning.

[M4vrick]

It seems I have another problem, I cant use any commande with occ.

For example

root@owncloud:/# sudo -u www-data php occ maintenance:mode --on
Could not open input file: occ

[alfredb]

You have to be in the ownCloud base directory, eg /var/www/owncloud.

[M4vrick]

thanks … I feel stupid now !

[tom42]

Hey, from what i have read in the past this “conversion” doesn’t work starting with ownCloud 10 so i think its a good idea that you have chosen to first convert the database before upgrading the installation.

[M4vrick]

I didnt have this information, thanks for it

For now I have an issue with securing the VM before trying the upgrade…

[tom42]

Hey,

i also only have found it some time ago in the Release Notes of ownCloud 10.