Can not use a windows share as datadirectory

Ask all your questions regarding OC 5.x Please read the Support Forum Rules
Forum rules
Version 5 is not supported anymore! Only security issues are fixed. Please upgrade your ownCloud.
Before you post; make sure you are using at least PHP Version 5.3.x - Also read Support Forum - Read this before posting

Can not use a windows share as datadirectory

Postby Tharnas » Mon Nov 04, 2013 9:27 pm

I'm trying to link the datadirectory to the windows share of my fileserver. Mounting the shared folder is working. Also the permissions seems to be correct. But when i try to login the first time to owncloud (complete installation) the webpage seems to freeze and after a view time there is only a white page.
If i unzip the ownlcoud folder again in /var/www and choose the default path everything is working like intent.

Has anyone a idee what the problem could be?

My topology:
* Host:
Windows server 2012 R2 running:
- Windows fileshare
- Hyperv

* In HyperV:
Ubuntu server 12.04.3 running:
- apache
- owncloud (5.0.22)

how i installed the owncloud:
root@ubuntu:/var/www# tar -xjf owncloud-5.0.12.tar.bz2
root@ubuntu:/var/www# chown -R www-data:www-data owncloud
root@ubuntu:/var/www# ls -la
total 14820
drwxr-xr-x 4 root root 4096 Nov 4 19:34 .
drwxr-xr-x 13 root root 4096 Nov 4 19:00 ..
-rw-r--r-- 1 root root 33 Okt 28 22:39 .htaccess
-rw-r--r-- 1 root root 177 Okt 28 21:53 index.html
drwxr-xr-x 13 www-data www-data 4096 Okt 3 14:38 owncloud
-rw-r--r-- 1 root root 15147476 Okt 3 14:40 owncloud-5.0.12.tar.bz2


mountingpoint of the windows share:
root@ubuntu:/var/www# ls -la /srv/owncloudshared/
total 4
drwxrwx--- 2 www-data www-data 0 Nov 4 19:34 .
drwxr-xr-x 4 root root 4096 Nov 4 18:58 ..
root@ubuntu:/var/www# ls -la /srv/
total 12
drwxr-xr-x 4 root root 4096 Nov 4 18:58 .
drwxr-xr-x 23 root root 4096 Okt 30 06:57 ..
drwxrwx--- 2 www-data www-data 0 Nov 4 19:34 owncloudshared


how i mounted the share:
root@ubuntu:/var/www# cat /etc/fstab
# /etc/fstab: static file system information.
# ...
# connect to share from fileserver
//fileserver.domain.local/owc /srv/owncloudshared cifs gid=33,uid=33,domain=domain.local,username=owncloud,password=******,dir_mode=0770,file_mode=0770,sec=ntlm 0 0


Then i connected via FIrefox to the webpage

root@ubuntu:/var/www# ls -la /srv/owncloudshared/
total 8
drwxrwx--- 2 www-data www-data 0 Nov 4 19:39 .
drwxr-xr-x 4 root root 4096 Nov 4 18:58 ..
-rwxrwx--- 0 www-data www-data 0 Nov 4 19:38 owncloud.db
-rwxrwx--- 0 www-data www-data 1014 Nov 4 19:39 owncloud.log

root@ubuntu:/var/www# cat /srv/owncloudshared/owncloud.log
{"app":"PHP","message":"SQLite3::query(): Unable to execute statement: database is locked at \/var\/www\/owncloud\/lib\/MDB2\/Driver\/sqlite3.php#493","level":2,"time":"2013-11-04T18:39:17+00:00"}
{"app":"PHP","message":"Non-static method MDB2_Schema::errorMessage() should not be called statically, assuming $this from incompatible context at \/var\/www\/owncloud\/3rdparty\/MDB2\/Schema.php#2800","level":2,"time":"2013-11-04T18:39:17+00:00"}
{"app":"PHP","message":"SQLite3::prepare(): Unable to prepare statement: 1, no such table: oc_users at \/var\/www\/owncloud\/lib\/MDB2\/Driver\/sqlite3.php#896","level":2,"time":"2013-11-04T18:39:17+00:00"}
{"app":"PHP","message":"Undefined property: MDB2_Driver_sqlite3::$db at \/var\/www\/owncloud\/lib\/MDB2\/Driver\/sqlite3.php#898","level":2,"time":"2013-11-04T18:39:17+00:00"}
{"app":"PHP","message":"Call to a member function raiseError() on a non-object at \/var\/www\/owncloud\/lib\/MDB2\/Driver\/sqlite3.php#898","level":4,"time":"2013-11-04T18:39:17+00:00"}


windows share:
security:
windowsSicherheit.PNG
Windows share - Security
windowsSicherheit.PNG (14.67 KiB) Viewed 1191 times


share
windowsFreigabe.PNG
Windows share - share
windowsFreigabe.PNG (11.9 KiB) Viewed 1191 times
Tharnas
Newbie
 
Posts: 3
Joined: Mon Nov 04, 2013 8:50 pm
Webserver: Apache
OS: Linux

Re: Can not use a windows share as datadirectory

Postby Rancor » Tue Nov 05, 2013 8:51 am

Hi,

a "Unable to execute statement: database is locked at" means that your SQLite database can't handle the current load. It is very likely that this warning here is the reason for this:

Because SQLite handles multiple users very badly SQLite is only recommended for single user ownCloud installations

doc.owncloud.org/server/5.0/admin_manual/configuration/configuration_database.html


Please switch to another database system like MySQL or PostgreSQL and try again.
*inactive*
Rancor
OwnCloud master
 
Posts: 8245
Joined: Sat May 26, 2012 3:00 pm
ownCloud version: 7.0.1
Webserver: nginx
Database: MySQL
OS: Linux
PHP version: 5.5.x

Re: Can not use a windows share as datadirectory

Postby Tharnas » Tue Nov 05, 2013 10:00 am

Hello Rancor,

thanks for this quick answer!

I will try your solution in the afternoon.
Tharnas
Newbie
 
Posts: 3
Joined: Mon Nov 04, 2013 8:50 pm
Webserver: Apache
OS: Linux

Re: Can not use a windows share as datadirectory

Postby Tharnas » Tue Nov 05, 2013 11:54 pm

I tried owncloud with mysql and its working!!
Thanks a lot!

I had a view problems installing mysql to make it work with owncloud.

But how I finally managed it to run:
apt-get install apache2 php5-common php5-gd curl libcurl3 libcurl3-dev php5-curl libapache2-mod-php5 mysql-server libapache2-mod-auth-mysql php5-mysql php5-ldap php5-sqlite

Then follow the description here:
http://doc.owncloud.org/server/5.0/admin_manual/configuration/configuration_database.html#mysql-mariadb-database

(use mysql.default_socket=/var/run/mysqld/mysqld.sock and not the default)
Tharnas
Newbie
 
Posts: 3
Joined: Mon Nov 04, 2013 8:50 pm
Webserver: Apache
OS: Linux

Re: Can not use a windows share as datadirectory

Postby Klownicle » Mon Nov 18, 2013 12:08 am

Thanks for this, this helped me as well!
Klownicle
Newbie
 
Posts: 1
Joined: Sun Nov 17, 2013 11:19 pm
ownCloud version: 5.0.12
Webserver: Apache
Database: SQLite
OS: Linux
PHP version: 5.4.4


Return to ownCloud Community Edition 5.x

Who is online

Users browsing this forum: No registered users and 8 guests