OwncloudX Cent7/red7

How to install OwnCloud 10 on CentOS 7 and RHEL 7

http://www.linuxbuzz.com/install-owncloud-10-centos-7-rhel-7/

OwnCloud is like having a personal cloud only for your storage requirements. It is much more like Dropbox like system that allows you to store and sync all your files over the network. You can use either a standalone client or a simple web interface to access your files on your cloud. You can access your files anytime you need and from anywhere you want. OwnCloud is available for free but includes all the features that you may find on commercial cloud storage systems. And there is even a commercial version available. In this article, we’ll take a look about how to install OwnCloud 10 on Cent OS 7 and RHEL 7.

Important Features

• Great alternative to Dropbox in terms of file storage
• Access files using web interface or standalone interface
• Versioning of files is maintained, so you can even get the first version of the file uploaded
• Easily synchronize your local folders with OwnCloud
• Download the Owncloud standalone client freely for Windows, Linux and Mac OSX
• Apps for Android and iOS also available to access OwnCloud from your mobile phone
• Supports multiple users
• Share files with other users on the same server
• Encryption and Security
• Activity Feed
• Calendars and Contacts
• Collaborative Editing

Prerequisites to Install OwnCloud

To install OwnCloud 10 on CentsOS 7 and RHEL 7, you need to have the following prerequisites:

• Redhat software collection repository enabled (only for RHEL 7)
• EPEL repository enabled
• Apache server and PHP extensions installed
• MariaDB installed

Note: in this tutorial, IP address of my machine is 192.168.0.107 and Hostname is set as “ownlcoud10.linuxbuzz.com”  and for local dns entry I have update the below entry in /etc/hosts file,

192.168.0.107   owncloud10.linuxbuzz.com       owncloud10

Now let’s see how to enable / install these,

To enable Redhat software collection repository in RHEL7, use the following command:

[root@owncloud10 ~]# subscription-manager repos --enable rhel-server-rhscl-7-eus-rpms

Note : If you have Centos 7 server then no need to run above subscription-manager command,

Use below command to enable EPEL repository and yum utils ,

[root@owncloud10 ~]# yum install epel-release yum-utils -y

Owncloud is only compatible with PHP 5.6 and above so we will be using latest version of PHP 7.2, refer below commands to install it along with its core-components

[root@owncloud10 ~]# yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm -y
[root@owncloud10 ~]# yum-config-manager --enable remi-php72

Now Install Apache Web Server along with PHP 7.2 using following yum command

[root@owncloud10 ~]# yum install httpd php php-mysql php-dom php-mbstring php-gd php-pdo php-json php-xml php-zip php-curl php-mcrypt php-pear php-intl setroubleshoot-server -y

Let’s install the database server as “MariaDB”, use the following command:

[root@owncloud10 ~]# yum install wget mariadb-server mariadb -y

Setup ownCloud 10 Repository

Import the Owncloud Signing Key

Here, we will use Linux installer for the installation of ownCloud. Import the ownCloud signing key using the rpm command.

Use the following command to download the signing key on CentOS 7

[root@owncloud10 ~]# rpm --import https://download.owncloud.org/download/repositories/production/CentOS_7/repodata/repomd.xml.key

Use the following code to download the signing key on RHEL 7

[root@owncloud10 ~]# rpm --import https://download.owncloud.org/download/repositories/production/RHEL_7/repodata/repomd.xml.key

Add the Owncloud 10 Repository in your system

Use the following commands to add it on CentOS 7

[root@owncloud10 ~]# cd /etc/yum.repos.d/
[root@owncloud10 yum.repos.d]# wget http://download.owncloud.org/download/repositories/production/CentOS_7/ce:stable.repo

Use the following code to add it on RHEL 7

[root@owncloud10 ~]# cd /etc/yum.repos.d/
[root@owncloud10 ~]# wget http://download.owncloud.org/download/repositories/production/RHEL_7/ce:stable.repo

Install Owncloud 10 in your system

Now we’ll be using the yum command to install the OwnCloud Package

[root@owncloud10 ~]# yum install owncloud -y

Set the required permissions on  ownCloud directory

[root@owncloud10 ~]# chown -R apache.apache /var/www/html/owncloud/

Use the following commands to start and enable Apache and database service,

[root@owncloud10 ~]# systemctl start httpd
[root@owncloud10 ~]# systemctl start mariadb
[root@owncloud10 ~]# systemctl enable httpd
[root@owncloud10 ~]# systemctl enable mariadb

Create Database for ownCloud

As of now we have freshly installed mariadb server and did not set its root password, run beneath command to set root password, remove test database, Remove anonymous users and disable remote root login,

[root@owncloud10 ~]# mysql_secure_installation

Now you need to create a database, so login to your MYSQL server and run the following command first:

[root@owncloud10 ~]# mysql -u root -p

Now use the following command to create a database called as “owncloud10db”

MariaDB [(none)]> create database owncloud10db;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]>

Now grant the “clouddbuser” permission to access the “owncloud10db” database with a password you specify on localhost

MariaDB [(none)]> grant all on owncloud10db.* to 'clouddbuser'@'localhost' identified by '{Passwd-here}';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]>

Now flush all privileges and time to exit from the MYSQL

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit
Bye
[root@owncloud10 ~]#

SELinux and Firewall Rules for OwnCloud

Security Enhanced Linux or SELinux is a kernel security module that supports access control mechanism. If SELinux is enabled on you server then write the following selinux rules for owncloud, else you can skip this step

[root@owncloud10 ~]# semanage fcontext -a -t httpd_sys_rw_content_t '/var/www/html/owncloud/data'
[root@owncloud10 ~]# restorecon '/var/www/html/owncloud/data'
[root@owncloud10 ~]# semanage fcontext -a -t httpd_sys_rw_content_t '/var/www/html/owncloud/config'
[root@owncloud10 ~]# restorecon '/var/www/html/owncloud/config'
[root@owncloud10 ~]# semanage fcontext -a -t httpd_sys_rw_content_t '/var/www/html/owncloud/apps'
[root@owncloud10 ~]# restorecon '/var/www/html/owncloud/apps'

In Case OS Firewall is enabled and configured on your server then allow http and https ports using following firewall-cmd command,

[root@owncloud10 ~]# firewall-cmd --permanent --add-service=http
success
[root@owncloud10 ~]# firewall-cmd --permanent --add-service=https
success
[root@owncloud10 ~]# firewall-cmd --reload
success
[root@owncloud10 ~]#

Now Setup ownCloud using Installation wizard

Now it is time to configure your Owncloud. To do that go to the following URL

http://<Your-Server-Ip-address>/owncloud

Provide your user name, password, database information and the Owncloud folder details. Once you provide all the details required, Click on “Finish Setup” and then installer will automatically redirects you to OwnCloud Login Page

Once you are authenticated successfully you will get owncloud dashboard something like below

This confirms that our owncloud has been installed successfully and now start sharing files whenever you need. Please share your feedback and comments in the comments section below

Setting remote DB OwncloudX

Granting User Connections From Remote Hosts¶

Now that your MariaDB server installation is setup to accept connections from remote hosts, we have to add a user that is allowed to connect from something other than 'localhost' (Users in MariaDB are defined as 'user'@'host', so 'chadmaynard'@'localhost' and 'chadmaynard'@'1.1.1.1' (or 'chadmaynard'@'server.domain.local') are different users that can have completely different permissions and/or passwords.

To create a new user:

• log into the mysql command line client (or your favorite graphical client if you wish)

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 5.5.28-MariaDB-mariadb1~lucid mariadb.org binary distribution

Copyright (c) 2000, 2012, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

• if you are interested in viewing any existing remote users, issue the following SQL statement on the mysql.user table:

SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';
+--------+-----------+
| User   | Host      |
+--------+-----------+
| daniel | %         |
| root   | 127.0.0.1 |
| root   | ::1       |
| root   | gandalf   |
+--------+-----------+
4 rows in set (0.00 sec)

(If you have a fresh install, it is normal for no rows to be returned)

Now you have some decisions to make. At the heart of every grant statement you have these things:

• list of allowed privileges
• what database/tables these privileges apply to
• username
• host this user can connect from
• and optionally a password

It is common for people to want to create a "root" user that can connect from anywhere, so as an example, we'll do just that, but to improve on it we'll create a root user that can connect from anywhere on my local area network (LAN), which has addresses in the subnet 192.168.100.0/24. This is an improvement because opening a MariaDB server up to the Internet and granting access to all hosts is bad practice.

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.100.%' IDENTIFIED BY 'my-new-password' WITH GRANT OPTION;

(% is a wildcard)

For more information about how to use GRANT, please see the GRANT page.

At this point we have accomplished our goal and we have a user 'root' that can connect from anywhere on the 192.168.100.0/24 LAN.

Port 3306 is Configured in Firewall

One more point to consider whether the firwall is configured to allow incoming request from remote clients:

On RHEL and CentOS 7, it may be necessary to configure the firewall to allow TCP access to MySQL from remote hosts. To do so, execute both of these commands:

firewall-cmd --add-port=3306/tcp 
firewall-cmd --permanent --add-port=3306/tcp

Caveats

• if your system is running a software firewall (or behind a hardware firewall or NAT) you must allow connections destined to TCP port that MariaDB runs on (by default and almost always 3306).

OpenKM DMS

Instalasi OpenKM

OpenKM sebagai DMS juga cukup lumayan. Beberapa feature yg dibutuhkan juga visa diperoleh dengan version gratis nya seperti versioning, revision history, dll.

Instalasi
Untuk instalasi cukup mudah jika sudah tahu trik nya. Untuk case saya, environment yg digunakan adalah Ubuntu 14.04 LTS Desktop. Pastikan sebelum nya system sudah up to date.
$ sudo apt-get update
$ sudo apt-get upgrade

Java
Sebelum install, pastikan jika sudah terinstall java.
$ java -version
Jika java belum terinstall, silahkan install dulu.
$ sudo apt-get install openjdk7-jdk
(Kalo saya nggak salah command nya but install Open Java 7 adalah itu)
Berhubung saya install nya pake synaptic, ya tinggal masukkan kata java aja di box search nya, maka akan keluar pilihannya. Tinggal pilih openjdk7-jdk dan install.
Cara install synaptic
$ sudo apt-get install synaptic

Imagemagick
Berikutnya yg dibutuhkan adalah aplikasi pengolah image
$ sudo apt-get install imagemagick
Atau kalo dari synaptic tinggal masukkan kata imagemagick, install.

Swftools
Juga termasuk pengolah grafis.
$ sudo apt-get install swftools
Atau jika pake synaptic tinggal ketik swftools, setelah keluar, tinggal install

Pdftk
Ini untuk manipulasi PDF
$ sudo apt-get install pdftk
Atau ketik pdftk di synaptic dan install

Libreoffice
Jika kita menggunakan desktop version, libre office sudah ada. Cuma nggak ada salahnya jika kita lakukan juga.
$ sudo apt-get install libreoffice

Berikutnya, download installer OpenKM.
Setelah selesai, installer harus dijadikan executable dulu
$ chmod +x [installer]
Terus install
$ sudo ./[installer]

Setelah selesai, jalankan OpenKM nya
$ sudo /opt/openkm.../tomcat/bin/catalina.sh start
Akses lewat browser
http://[server]:8080/OpenKM
Untuk diingat, jika OpenKM itu case sensitif.
Login awal okmAdmin dan passwordnya admin.

Selesai sudah kita install OpenKM nya.

Setting remote database Full

Cara Setting Akses Remote Database MariaDB di Ubuntu

Instalasi database MariaDB secara default hanya bisa diakses oleh komputer lokal saja (localhost / 127.0.0.1) demi alasan keamanan. Tapi dalam beberapa kasus kadang programer membutuhkan akses database MariaDB dapat dilakukan secara remote dari komputer lain (IP address lain).

Setting MariaDB Server

Buka file konfigurasi MariaDB menggunakan nano.

1	$ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Cari bind-address ganti nilainya dari 127.0.0.1 menjadi 0.0.0.0 atau langsung menggunakan IP address dari server.

• bind-address = 127.0.0.1, server hanya menerima koneksi TCP/IP yang masuk melalui 127.0.0.1.
• bind-address = 149.28.159.140, server hanya menerima koneksi TCP/IP yang masuk melalui IPv4 yang diisikan.
• bind-address = 0.0.0.0, server menerima koneksi TCP/IP yang masuk melalui semua IPv4 yang ada pada interface jaringan.
• Dapat memasang lebih dari satu bind-address seperti gambar di bawah ini.

Kemudian restart service

1	sudo systemctl restart mysql

Membuat user dan database jika belum ada.

1 2 3 4 5

$ mysql -u root -p MariaDB [(none)]> CREATE DATABASE mydb; MariaDB [(none)]> CREATE USER 'musa'@'%' IDENTIFIED BY 'rahasia'; MariaDB [(none)]> GRANT ALL PRIVILEGES ON mydb.* TO 'musa'@'%'; MariaDB [(none)]> FLUSH PRIVILEGES;

1. Login ke database dengan user root.
2. Membuat database mydb.
3. Membuat user musa@ip-address-apapun dengan password rahasia.
4. Memberikan semua hak akses untuk database mydb dengan semua tabel yang ada kepada user musa@ip-address-apapun.
5. Reload hak akses.

Pengujian Akses Remote MariaDB dengan Aplikasi Client

Remote MariaDB dengan menggunakan aplikasi MariaDB client berbasis CLI di Linux terminal.

Login dengan user musa pada database server 149.28.159.140 dengan memakai password. Cek dengan menampilkan database dan status server.

1	mysql -u musa -h 149.28.159.140 -p

Pengujian Akses Remote MariaDB dengan PHP

Selanjutnya melakukan pengujian dengan membuat file PHP di komputer lokal yang berisi login ke database server.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

<?php   $hostname = "149.28.159.140"; $username = "musa"; $password = "rahasia"; $database = "mydb";   $con = new mysqli($hostname, $username, $password, $database);   if(!$con){   echo "Database Error ".mysqli_error();   exit; } else {   echo "Sukses terhubung ke server database ".$hostname; }   mysqli_close($con); ?>

Hasilnya jika login database sukses.

Selamat mencoba