![]() ![]() SSLCipherSuite !ADH:!EXPORT:!SSLv2:EECDH+aRSA+AESGCM:RC4+R For this tutorial, we will only add ownCloud to the HTTPS virtual host of our default configuration file, which will now look like this: ĮrrorLog “/var/log/http-default-error_log”ĬustomLog “/var/log/http-default-access_log” combined Mysql> grant all on owncloud.* to OK, 0 rows affected (0.00 sec) Conclusionįinally, the Apache virtual host configuration can be updated. Other names may be trademarks of their respective developers. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. ![]() Server version: 5.5.40 Source distributionĬopyright (c) 2000, 2014, Oracle and/or its affiliates. To do this, simply run “mysql” as the root user and run the create database and grant commands at its prompt: # mysql The next step is to create the MySQL database which will be used by ownCloud. Php5-pdo php5-pdo_mysql mp3info php5-session Php5-fileinfo pecl-APC php5-mbstring php5-iconv Php5-zip php5-zlib php5-bz2 php5-curl php5-mcrypt peclintl Php5-ctype php5-dom php5-json php5-xml php5-simplexml # pkg install php5-exif php5-openssl php5-mysql php5-gd It also requires some dependency packages: We can adjust the permissions like this: # cd /srv/www/owncloud OwnCloud requires that use which executes its code (the PHP interpreted, started by mod_fcgid in Apache as the “www” user) can write to some of its directories. It can be downloaded from, for example with the following commands: # cd /srv/www OwnCloud is a PHP application whose source needs to be downloaded and unpacked in an appropriate directory on the server. The first time MySQL is started it will create its required files. After the configuration file is created, the database can be started by issuing: # service mysql-server start The last line specifies that individual tables in the database will be saved as individual files in the database directory, which is extremely useful for backups and maintenance. All of these settings are useful for increasing the database performance, but the official MySQL documentation should be studied to understand their full effects. The options in the above example specify the key buffer size of 128 MiB, that 4 threads will be used to serve queries, activate the query cache and set its size to also 128 MiB (the settings are unrelated). MySQL is very customisable and supports a huge number of configuration options. This file can contain lines such as these: It is also useful at this point to create a MySQL configuration file, name my.cnf and located in /usr/local/etc. 8 MB to be downloaded.Īfter the installation, it simply needs to be configured and enabled in /etc/rc.conf, by adding lines such as the following: mysql_enable=”YES”īefore MySQL can be started, the database directory specified above needs to be created and appropriate permission given: # mkdir /srv/mysql The process will require 105 MB more space. New packages to be INSTALLED: mysql55-server: 5.5.40 The following 2 packages will be affected (of 0 checked). For this article, we will install MySQL version 5.5: # pkg install mysql55-server mysql55-client MySQL has a reputation for being simple, and it actually is. This article will use MySQL for its database for this and other applications, primarily because FreeBSD still has problems with UTF-8 collation required by PostgreSQL. ![]() Depending on the type and frequency of its users, it could require approximately between 10 MB and 100 MB of database data per user per year. OwnCloud requires a database which it will use to store metadata such as version information, and also system data and content for some types of resources. In practice, its main selling point is the DropBox-like functionality with client applications available for Windows, Linux, Android and iPhone devices.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |