Jumat, 29 September 2017

Onlyoffice jalan

tep 1: Install Docker on Ubuntu 16.04

https://www.linuxbabe.com/linux-server/install-onlyoffice-ubuntu-16-04#disqus_thread
Docker is included in Ubuntu software repository. However, to ensure that we have the latest version, we will have to install it from Docker’s APT repository. Fire up a terminal window (CTRL+ALT+T), then edit sources.list file with your favourite text editor such as nano.
sudo nano /etc/apt/sources.list
Scroll down to the bottom of this file and add the following line.
deb https://apt.dockerproject.org/repo ubuntu-xenial main
install latest docker on Ubuntu
Press CTRL+O to save the file, then CTRL+X to exit. Next, run the following command to import the Docker GPG key to Ubuntu 16.04 system so that APT can verify package integrity during installation.
sudo apt-key adv --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D
And because this repository uses HTTPS connection, which I recommend all software repositories should be using, we also need to install apt-transport-https and ca-certificates package.
sudo apt-get install apt-transport-https ca-certificates
Now finally, update the package index on your Ubuntu 16.04 system and install docker-engine.
sudo apt update

sudo apt install docker-engine
Check Docker version.
docker -v
Sample output
Docker version 17.05.0-ce, build 89658be
Once installed, the Docker daemon should be automatically started. You can check it with:
systemctl status docker
ubuntu start docker daemon
If it’s not running, then start the daemon with this command:
sudo systemctl start docker
And enable auto-start with system boot:
sudo systemctl enable docker

Step 2: Install OnlyOffice Community Edition Using Docke

http://noc-id.blogspot.co.id/2017/09/only-office-few-minutes.html

Installing ONLYOFFICE

Run Docker and execute the following command:
sudo docker run -i -t -d -p 80:80 onlyoffice/communityserver
This command will download the dockerfile from Docker Hub and launch the container running ONLYOFFICE and all the dependencies necessary for its work.

Configuring ONLYOFFICE

If you wish to run ONLYOFFICE on a different port, change the value of the -p command. For example, to run your office on 8080 port, use the following command:
sudo docker run -i -t -d -p 8080:80 onlyoffice/communityserver

Kamis, 28 September 2017

dotproject

instalasi dotproject – software manajemen proyek

install dotproject

tulisan ini membahas bagaimana proses instalasi software manajemen proyek – dotProject, menggunakan web based installation wizard, apa saja yang harus diinstall terlebih dahulu, dan apa saja yang harus diperhatikan pada proses instalasi.

yang harus sudah terinstall sebelum proses install dotProject

  1. web server (direkomendasikan apache versi 1.3.x atau 2.x), download di http://www.apache.org
  2. MySQL database server versi 3.23.x atau yang lebih tinggi, download di http://www.mysql.com
  3. PHP 4.x jika digunakan untuk dotProject versi 2.0.4, PHP 5.2.x jika digunakan untuk dotPtoject 2.1, download di http://www.php.net
  4. source dotProject, download di http://www.dotproject.net, versi terakhir 2.1.2

yang harus diperhatikan sebelum proses install dotProject

  1. user database yang akan digunakan oleh dotProject harus punya hak untuk membuat temporary tables, juga termasuk ALTER dan DROP permission
  2. pada proses install dotProject akan dibuat file config.php, jika pada server dotproject telah memiliki file config.php (misalnya config_dist.php), dotProject mengasumsikan terjadi proses upgrade
  3. PHP anda harus memiliki parameter register_globals dalam keadaan off supaya proses install dotProject berjalan lebih aman. proses install dotProject tetap berjalan pada register_globals dalam kondisi on, namun ini tidak direkomendasikan
  4. dotProject menggunakan CSS dan javascript, sehingga browser yang digunakan minimal internet explorer 5.5 mozilla 1.2 netscape 7.x, terlebih lagi jika menggunakan firefox yang dapat bekerja sangat baik
  5. meski tidak disyaratkan, mail server dapat diinstall untuk keperluan system alert
  6. true type font digunakan dalam JpGraph pada modul gantt chart. tidak semua font disediakan oleh dotProject karena lisensi yang spesifik. jika terjadi error di kemudian hari, maka ada kemungkinan font yang diperlukan belum terinstall pada sistem anda. berdasarkan pengalaman penulis, jika server yang digunakan adalah windows, maka semua font yang diperlukan sudah ada
  7. gantt chart dapat mengkonsumsi memory diatas batas memory yang dialokasikan PHP. jika gantt chart tidak muncul, tetapi tidak terlihat pesan error, boleh jadi gantt chart kekurangan memori. anda dapat mengubah limit memory yang dialokasikan PHP pada php.ini
  8. jika ada telah menginstall database server sebelumnya, maka backup dulu database yang sudah ada untuk berjaga-jaga
jika anda merasa kesulitan untuk mengkonfigurasikan penggunaan web server, database server, dan PHP, anda dapat menggunakan paket WAMP (windows apache mysql PHP), LAMPP (linux apahce mysql PHP perl) yang umum disebut XAMPP. atau, dapat juga menggunakan Apache2Triad yang khusus untuk windows. kesemuanya itu merupakan paket preconfigured server yang mudah digunakan.
anda juga bisa menggunakan windows installer yang dibuat oleh wirabumi software. windows installer ini sudah mencakup XAMPP versi lite dan dotProject yang siap digunakan. namun, konfigurasi dan path apache-MySQl-PHP sudah ditetapkan dan tidak bisa diubah selama proses installasi. windows installer wirabumi software menggunakan C:/xampp sebagai root directory dan C:/xampp/htdocs sebagai document root. anda bisa merubah konfigurasi ini setelah proses instalasi. windows installer dotProject wirabumi software dapat di-download disini. gunakan password instalasi: wirabumisoftware, username dotproject: admin, password dotproject: admin.

install dotProject melalui web based instalation wizard

  • ekstrak file source dotProject pada document root, misalnya C:/xampp/htdocs/dotproject
  • buka browser anda, masuk ke URL http://localhost/dotproject/install (URL dapat berbeda tergantung nama DNS anda dan posisi folder dotProject pada document root)
    cek persiapan instalasi
    cek persiapan instalasi
  • dotProject akan menampilkan halaman installasi. pada bagian check for requirement, semua harus tercentang. pada bagian database connector, mysql harus supported, kemudian klik start installation
    seting database
    seting database
  • pada bagian database settings masukkan parameter database anda. pada database user name dan password isikan username dan password yang sudah ada pada mysql, karena dotProject tidak membuatkannya untuk anda, kemudian klik install db & write cfg
    finishing proses instalasi
    finishing proses instalasi
  • jika instalasi sukses, maka pada database installation feedback tertera pesa database sucessfully setup, pada config file creation feedback tertera pesan config file sucessfully written
  • hapus folder install pada folder dotProject di document root
    login pertama kali
    login pertama kali
  • masuk ke http://localhost/dotprojecct, login dengan username admin dan password passwd
    kondigurasi pasca instalasi
    kondigurasi pasca instalasi
selanjutnya anda akan dibawa menuju halaman konfigurasi sistem. penjelasan detil mengenai konfigurasi sistem akan dijelaskan kemudian, gambar diatas menunjukkan beberapa parameter yang dapat langsung anda tentukan nilainya.
ubah password user admin
ubah password user admin
anda juga dapat mengganti password user admin. klik menu user admin, kemudian akan muncul daftar user (saat ini user yang terdaftar hanya admin saja), klik icon edit (icon paling kiri). kemudian ubah password admin sesuai denga keinginan anda.

Selasa, 26 September 2017

CMS CCTV

Cara Seting Aplikasi CMS Untuk DVR h264

seting DVR h264
Dalam era perkembangan dan kemajuan teknologi sekarang ini tingkat kemudahan dan kenyamanan sangat dibutuhkan. Banyak sekali efek positif dan negatif dari kemajuan teknologi belakangan ini, seperti fenomena Aplikasi Online yang sekarang sedang menjamur.

Satu sisi dari pihak konsumen sangat dimanjakan dengan aplikasi ini misal seperti Ojek Online, Taksi online, Massage Online, Tiket pesawat online dan lain sebagainya. Bahkan sampai ke tingkat pengamanan Rumah, Kantor atau toko sekalipun sekarang semuanya dapat kita nikmati dan pantau secara realtime Online 24 jam non stop.

Nah itu pembahasan kali ini saya mau berbagi tentang Cara Seting Aplikasi CMS Untuk Pantau CCTV. Sobat blogger dan kita semuanya pasti mengetahui apa itu CCTV. Sekarang ini hampir disetiap Mal, perkantoran, hotel, tempat hiburan, rumah dan banyak lagi sudah menggunakan apa itu yang namanya CCTV. Jenis dari produk CCTV pun banyak ragamnya dari yang murah hingga mahal, biasanya bergantung dari tingkat fasilitas dan Kualitasnya ibarat kata Uang membawa Rasa.

Disini saya bahas bagi Sobat yang kesulitan untuk memantau CCTV secara online bagaimana caranya dan menggunakan Aplikasi apa. Biasanya kalau beli satu paket CCTV akan dapat softwarenya dari tempat Sobat beli, tapi bagaimana jika membeli dari Toko Online pasti bagi yang belum paham akan sangat kesulitan mengoperasikannya. nah itu itu mari kita bahas Cara Seting Aplikasi CMS Untuk Pantau CCTV.

Disini saya menggunakan Aplikasi CMS untuk Pantau CCTV secara Online Sobat bisa mendownloadnya secara Gratis dari Vendor merk DVR sobat biasanya disediakan link untuk mendownloadnya atau Sobat bisa Download disini http://www.faps.com/download/.

Langkah Awal Cara Seting Aplikasi CMS Untuk Pantau CCTV sebagai berikut :

1. Siapkan Aplikasi Instaler CMSnya 
Disini saya asumsikan Sobat sudah memasang rapih Camera dan sudah selesai di seting ke DVR Sobat tinggal seting CMSnya Sobat jalankan Aplikasi setupnya ikuti petunjuknya sampai selesai.

2. Cara Seting CMS
Nah setelah instalsi software CMS selesai Sobat restart komputer sobat lalu buka Aplikasi CMS yang tadi di instal, kemudian langsung klik Login saja tanpa memasukan password nah sobat akan dibawa menuju tampilan seperti ini.


3. Setting IP Addres
Setelah masuk ke aplikasi seperti tampilan diatas sobat pilih menu System.
 ini masih kosong Sobat klik Zona list kemudian pilih menu ADD AREA


Sobat isi nama Zona misal Coba, lalu tekan OK setelah itu pilih ADD DEVICE

Klik dua kali pada nama zona yang td sobat buat akan tampil pengisian seperti berikut, Sobat pilih ip address dimana setingan di Router sobat kasih IP adressnya disini saya menggunakan ip 192.168.1.200 untuk portnya 9001

Silahkan isi sesuai yang sobat seting di Router sobat untuk Vendor pilih sesuai merk DVR Sobat lalu tekan OK, Sesudah itu sobat klik dua kali nama zona yang tadi dibuat untuk online CCTVnya tampilannya seperti ini
Nah jika sudah seperti ini Sobat sudah berhasil Cara Seting Aplikasi CMS Untuk Pantau CCTV.

Catatan tambahan pastikan DVR sudah terkoneksi dengan internet agar dapat dipantau secara online melalui SmartPhone Sobat. Bagaimana sobat begitulah Cara Seting Aplikasi CMS Untuk Pantau CCTV, semoga bermanfaat ya

Only office full

How to Install OnlyOffice on Ubuntu 16.04 LTS

https://www.linuxbabe.com/linux-server/install-onlyoffice-ubuntu-16-04
In this tutorial, we will be looking at installing OnlyOffice on Ubuntu 16.04. For those of you who don’t know, OnlyOffice is a web app that provides online office suiteemail server, document management, project management and CRM system all in one place.
OnlyOffice is formerly known as Teamlab Office. Some features are as follows:
  • It combines the best of MS office and Google Docs.
  • Offers more collaborative capabilities than Google Docs, fast real-time co-editing
  • More feature-rich than MS Office Online
  • It offers better support for MS Office formats than any other open source office suite and is fully compatible with OpenDocument formats.
  • Integration with Box, OneDrive, Dropbox, Google Apps, Twitter, Facebook, LinkedIn.
  • Mail and calendar integration, mail autoreply, address book.
OnlyOffice offers all necessary tools for business: mail, document management, CRM, projects, calendar, mail, corporate social network with blogs, forums, and wiki, chat.


Open Source Community Edition vs Enterprise Edition

Just like WordPress, you can sign up OnlyOffice’s service or you can set up a self-hosted OnlyOffice server which means you install OnlyOffice on your own server. The open source community edition is for free whereas the enterprise edition lifetime license costs $1500 per one server.
The free edition includes a full-featured web office and the following features.
  • Online Document Editors
  • Document Management
  • Mail
  • Projects
  • CRM
  • Calendar
  • Community
For more comparison between free and enterprise edition, visit

 this page.  It’s recommend that you use the official OnlyOffice Docker containers to install the free OnlyOffice Community Edition.
The installation process is simple, so let’s get started.

Step 1: Install Docker on Ubuntu 16.04

Docker is included in Ubuntu software repository. However, to ensure that we have the latest version, we will have to install it from Docker’s APT repository. Fire up a terminal window (CTRL+ALT+T), then edit sources.list file with your favourite text editor such as nano.
sudo nano /etc/apt/sources.list
Scroll down to the bottom of this file and add the following line.
deb https://apt.dockerproject.org/repo ubuntu-xenial main
install latest docker on Ubuntu
Press CTRL+O to save the file, then CTRL+X to exit. Next, run the following command to import the Docker GPG key to Ubuntu 16.04 system so that APT can verify package integrity during installation.
sudo apt-key adv --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D
And because this repository uses HTTPS connection, which I recommend all software repositories should be using, we also need to install apt-transport-https and ca-certificates package.
sudo apt-get install apt-transport-https ca-certificates
Now finally, update the package index on your Ubuntu 16.04 system and install docker-engine.
sudo apt update

sudo apt install docker-engine
Check Docker version.
docker -v
Sample output
Docker version 17.05.0-ce, build 89658be
Once installed, the Docker daemon should be automatically started. You can check it with:
systemctl status docker
ubuntu start docker daemon
If it’s not running, then start the daemon with this command:
sudo systemctl start docker
And enable auto-start with system boot:
sudo systemctl enable docker

Step 2: Install OnlyOffice Community Edition Using Docker


OnlyOffice Community edition comprises of the following 3 components.
  • OnlyOffice community server
  • OnlyOffice document server
  • OnlyOffice mail server
To install all of them, follow these steps.
First create a Docker network called onlyoffice.
sudo docker network create --driver bridge onlyoffice
Then install OnlyOffice document server with the below command. Simply copy and paste.
sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-document-server \
    -v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/Data \
    -v /app/onlyoffice/DocumentServer/logs:/var/log/onlyoffice \
    onlyoffice/documentserver
Next, execute the following command to install OnlyOffice mail server. Replace with red-colored text with you own domain name.
sudo docker run --net onlyoffice --privileged -i -t -d --restart=always --name onlyoffice-mail-server \
    -p 25:25 -p 143:143 -p 587:587 \
    -v /app/onlyoffice/MailServer/data:/var/vmail \
    -v /app/onlyoffice/MailServer/data/certs:/etc/pki/tls/mailserver \
    -v /app/onlyoffice/MailServer/logs:/var/log \
    -v /app/onlyoffice/MailServer/mysql:/var/lib/mysql \
    -h your-domain.com \
    onlyoffice/mailserver
After that, issue this command to install OnlyOffice community server.
sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-community-server \
    -p 80:80 -p 5222:5222 -p 443:443 \
    -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
    -v /app/onlyoffice/CommunityServer/mysql:/var/lib/mysql \
    -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
    -v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/DocumentServerData \
    -e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server \
    -e MAIL_SERVER_DB_HOST=onlyoffice-mail-server \
    onlyoffice/communityserver

Step 3: Adding Swap Space

OnlyOffice consumes a whole lot of RAM. 6GB of RAM is required to run OnlyOffice. If your physical memory is small, you can easily add a swap file to increase the available RAM to use. First we use fallocate command to create a file. For example, create a file named swapfile with 4G capacity in root file system:
sudo fallocate -l 4G /swapfile
Then make sure only root can read and write to it.
sudo chmod 600 /swapfile
Format it to swap:
sudo mkswap /swapfile
Output:
Setting up swapspace version 1, size = 4 GiB (4294963200 bytes)
no label, UUID=h32b3e10-0779-4865-9ea0-6e2af8f3kea9
Enable the swap file
sudo swapon /swapfile

Step 4: Finish the Installation in Browser

Once it’s done, enter your server’s IP address in the browser address bar,
your-server-ip
OnlyOffice will start initializing as shown below.
install onlyoffice on ubuntu 16.04 lts
In the next page, enter a password and email address to secure the OnlyOffice Portal. This is the admin account. You will need to confirm this email address.
onlyoffice portal setup
After clicking the continue button, you will be redirected to the home page of your OnlyOffice server. Clicking the big documents icon will take you to the online office suite where you can create and edit word documents, spreadsheets, presentation files. The 5 small icon at the bottom will respectively take you to project management, CRM, Mail, People and community page.
onlyoffice home page
To use a domain name instead of IP address, go to settings (gear icon) > DNS settings. And enter your domain name.
Onlyoffice custom domain name
Once you click the Save button, you can access your OnlyOffice server via your domain name, provided that a correct A record is set in DNS.

Editing Word Documents Online

onlyoffice online office suite

Project Management

onlyoffice project management

Managing Customer Relationships with CRM

manage relationships with customs with CRM

Email Server

Building an email server with OnlyOffice is really a piece of cake! No longer have to worry about esoteric configurations of Postfix and dovecot. The Mail module can be used to host multiple email domains. It also provides a web-based mail client which can aggregate all your email accounts in one place.
onlyoffice email server

Setting Up Nginx Reverse Proxy

It’s highly possible that you want other HTTP server (Apache or Nginx) to run on your server. So we recommend changing the port on which OnlyOffice listens and then set up Nginx reverse proxy. we can also conveniently enable HTTPS with Nginx later on.
First, stop and remove the community server container with the following command:
sudo docker stop container-id
sudo docker rm container-id
container-id can be obtained by running the command below.
sudo docker ps
Then start community server with a port other than 80 like below. Community server will be listening on port 8080.
sudo docker run --net onlyoffice -i -t -d --restart=always --name onlyoffice-community-server \
    -p 8080:80 -p 5222:5222 \
    -v /app/onlyoffice/CommunityServer/data:/var/www/onlyoffice/Data \
    -v /app/onlyoffice/CommunityServer/mysql:/var/lib/mysql \
    -v /app/onlyoffice/CommunityServer/logs:/var/log/onlyoffice \
    -v /app/onlyoffice/DocumentServer/data:/var/www/onlyoffice/DocumentServerData \
    -e DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server \
    -e MAIL_SERVER_DB_HOST=onlyoffice-mail-server \
    onlyoffice/communityserver
Now let’s install Nginx.
sudo apt install nginx
And create a virtual host file.
sudo nano /etc/nginx/conf.d/onlyoffice-proxy.conf
Put the following text into the file. Replace the domain name with your actual domain name. The proxy_pass directive will pass all requests to OnlyOffice community server.
server {
        listen 80;
        server_name office.your-domain.com;

        error_log /var/log/nginx/onlyoffice.error;

        location / {
                proxy_pass http://127.0.0.1:8080;
        }
}
Save and close the file. Then test Nginx config and reload.
sudo nginx -t
sudo systemctl reload nginx
Now enter your domain name in the browser. You should see the OnlyOffice initialization page, which means you can access OnlyOffice via your domain name. Wait for it to finish initializing.

How to Enable HTTPS

Once the initialization is complete, we can obtain a free TLS certificate from Let’s Encrypt. Install Let’s Encrypt (certbot) client with:
sudo apt install letsencrypt
Since we’re using Nginx, it’s best to utilize the webroot plugin to obtain the certificate. We need to add a little configuration to the virtual host file.
sudo nano /etc/nginx/conf.d/onlyoffice-proxy.conf
Add the following directive to the file.
location ~ /.well-known/acme-challenge {
   root /usr/share/nginx/onlyoffice/;
   allow all;
 }
Then create the /usr/share/nginx/onlyoffice/ directory.
sudo mkdir /usr/share/nginx/onlyoffice

sudo chown www-data:www-data /usr/share/nginx/onlyoffice -R
And reload nginx.
sudo systemctl reload nginx
Next, run the following command to obtain a TLS certificate. Replace red text with your actual email address and domain name for OnlyOffice.
sudo letsencrypt certonly --agree-tos --webroot --email your-email-address -d office.your-domain.com -w /usr/share/nginx/onlyoffice/
You should see a congrats message indicating your TLS certificate is successfully obtained. Your certificate and chain have been saved at /etc/letsencrypt/live/office.your-domain.com/fullchain.pem.
Now Let’s install the cert. Open the virtual host file again.
sudo nano /etc/nginx/conf.d/onlyoffice-proxy.conf
Change it to the following. Replace red text accordingly.
server {
        listen 80;
        server_name office.your-domain.com;
        return 301 https://$server_name$request_uri;
}

server {
        listen 443 ssl http2;
        server_name office.your-domain.com;

        ssl_certificate /etc/letsencrypt/live/office.your-domain.com/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/office.your-domain.com/privkey.pem;

        ssl_session_timeout 1d;
        ssl_session_cache shared:SSL:10m;
        ssl_session_tickets off;
        ssl_protocols TLSv1.1 TLSv1.2;

        ssl_ciphers 'ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS';
        ssl_prefer_server_ciphers on;

        error_log /var/log/nginx/onlyoffice.error;
        access_log /var/log/nginx/onlyoffice.access;

        location / {
                proxy_pass http://127.0.0.1:8080;
        }

        location ~ /.well-known/acme-challenge {
            root /usr/share/nginx/onlyoffice/;
            allow all;
        }
}
Save and close the file. Then test Nginx config and reload.
sudo nginx -t

sudo systemctl reload nginx
Now you should be able to access OnlyOffice in HTTPS protocol !

Auto Renew TLS Certificate

Simply edit the crontab file of root user.
sudo crontab -e
Put the following line into the file which will try to renew your cert once per day.
@daily certbot renew --quiet
Save and close the file. That’s it!
As always, if you found this post useful,  subscribe to our free newsletter or follow us on Google+Twitter or like our Facebook page.
Rate this tutorial