ownCloud works perfectly out of the box but there are some advanced features you might miss.
First of all: if you haven’t installed ownCloud yet, please read my installation instructions.
1. MySQL Database
By default ownCloud uses a SQLite database System which works quick and well. However if you want to use a MySQL Database with all of its benefits like the advanced user control features, a remote storage of the database itself or the backup and direct editing features, here is a guide on how to set it up:
1.1 Enable MySQL in DSM if you haven’t done already: Control Panel -> Web Services -> Enable MySQL
1.2 To manage the MySQL database system install phpMyAdmin from Package Management -> Available
1.3 The DSM link created during install leads to the phpMyAdmin login page (http://Your.NAS.I.P/phpMyAdmin/) login with user: root password: <empty>
1.4 Click the “Users” Tab in the top bar and enter a password for all three “root” accounts (I entered the same for all three so I don’t have to care from where I log in)
1.6 The phpMyAdmin configuration is done (more information about phpMyAdmin on Synology devices here), now open ownCloud (click the DSM link), click the “Advanced” link and fill in the db settings just created in phpMyAdmin.
The first two fields are independent, they create the ownCloud admin account.
Do not change the data folder directory.
The rest is filled by the MySQL connection data.
2. LDAP connection
LDAP is a Directory system. The main advantage is that you have to create every user once at the Directory Server so every client uses the data provided by the Directory Server to authorize logins.
2.1 Install the Directory Server via Package Management -> Available
2.3 Create some LDAP user. The user management is very similar to the DSM one. LDAP users can own home directory folders as well. More information about the Synlogy Directory Server can be found in the official user’s guide.
2.4 Enable the php_ldap extension in the DSM at Control Panel -> Web Services -> PHP Settings -> Select PHP Extention
2.5 Login to ownCloud as admin, go to Settings->Apps and enable “LDAP user and group backend”
2.6 In ownCloud go to Settings->Administrator. The LDAP client configuration appears. Fill in the Domain settings like you created them before. The User Login Filter has to be (uid=%uid).
The advanced settings should look like this2.7 After you filled in the LDAP Configuration you can test it. If the Connection couldn’t be established have a look at the ownCloud log below. If it works you can now login to ownCloud with users created at the Directory server.