the Apache server is stopped by the Bitnami stack management tool
I can copy the content of the data directory with this:
sudo rsync -avz /var/www/owncloud/data /mnt/owncloud (with my own paths)
I run into problems at the step enable / disable maintenance mode
and
Update the oc_storages Table
and
Update the oc_storages Table
Run the SQL below:
UPDATE oc_storages
SET id=‘local::/mnt/owncloud/data/’
WHERE id=‘local::/var/www/owncloud/data/’;
with my file paths:
UPDATE oc_storages
SET id=‘local::/Volumes/Promise_Raid/P_Owncloud_Data/data/’
WHERE id=‘local::/Volumes/Promise_Raid/P_Owncloud_App/apps/owncloud/data/’;
Error messages:
UPDATE: command not found
SET: Command not found
Server configuration
Operating system: OS X 10.12
Web server:
Database:
PHP version:
ownCloud version: 9.1.4
Updated from an older ownCloud or fresh install: fresh
Where did you install ownCloud from: Bitnami
What did I do wrong?
I am using the terminal occasionally, but I am no expert. So may be I just have a syntax problem?
Or do I have to open files to do those changes? Like the config.php file?
Open a database command line client to enter database commands and activate your ownCloud database.
So for the database statements you’ll require a mysql/mariadb-clien to connect to your database. I am not aware of OsX-packages or tools, but your favorite search engine is your friend.
Then I get hung up here to Update the oc_accounts Table
You next need to update the home column in the oc_accounts table. This column contains the absolute path for user folders, e.g., /mnt/owncloud/data/my_user/files.
If a user does not have the path already set, you have to identify the users id and set the path with the following command, user by user. This example assumes the user name is my_user and their id is 1.
Run the SQL below: UPDATE oc_accounts SET home=’/mnt/owncloud/data/my_user/files’
** WHERE id=1;**
Is the Accounts info stored in a different table in OC 9.1?
How can I change it?
Up to now I only did a test install of Owncloud with two test users.
If I do a NEW installation and change the location before any users log in, do I need to care about the accounts?
In general I’d strongly suggest to upgrade your ownCloud to the latest version before you try to achieve anything. Your current version is absolutely out of date, I do not want to know which security issues your version comes with.