Jumat, 31 Maret 2017

Onlyoffice

Install ONLYOFFICE – Open-Source Web Based Office Suite

Install ONLYOFFICE
Install ONLYOFFICE
ONLYOFFICE is a free,multifunctional, web-based office suite that enables you to store and co-edit documents, manage projects, view email and customer relations at one place. It is developed for small and mid-size companies for an effective platform for business operations. ONLYOFFICE is current available in 21 languages, comprising viewers and editors for texts, spreadsheets and presentations, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real-time.

Features:

  • Document Editor
  • Spreadsheet Editor
  • Presentation Editor
  • Documents application for iOS
  • Collaborative editing
  • Hieroglyph support
  • Support for all the popular formats: DOC, DOCX, TXT, ODT, RTF, ODP, EPUB, ODS, XLS, XLSX, CSV, PPTX, HTML

Integrating it with Community Server you will be able to:

  • view and edit files stored on Drive, Box, Dropbox, OneDrive, OwnCloud connected to ONLYOFFICE;
  • share files;
  • embed documents on a website;
  • manage access rights to documents.

Flavours:

ONLYOFFICE comes in two flavour,
  • ONLYOFFICE Free Edition, released in GNU Affero General Public License v.3.
  • ONLYOFFICE Enterprise Edition (Supported commercially by ONLYOFFICE).

System requirements:

  • RAM: 2 GB or more
  • CPU: 2 Core or better
  • Swap file: at least 2 GB
  • HDD: at least 40 GB of free space
  • Distributive: Ubuntu 12.04 or later
  • Docker: version 1.4.1 or later (If you are installing ONLYOFFICE on Docker)

Install ONLYOFFICE:

ONLYOFFICE can be installed in two ways,
1. Install ONLYOFFICE using Docker,
2. Install ONLYOFFICE using Repository.

Install ONLYOFFICE using Docker:

This docker installation will help you to set up full featured collaborative suite, instead of just document editor. You can also check what are all included in this suite here.
Before going ahead, you must install docker on your system. You can also go through steps to install docker on Ubuntu here.
Install phython-pip, it requires for installing docker-compose.
sudo apt-get install python-pip
Install docker-compose.
pip install -U docker-compose
Check version.
sudo docker-compose -v
docker-compose version: 1.4.0
Run following command to download latest docker images from official registry.
wget https://raw.githubusercontent.com/ONLYOFFICE/Docker-CommunityServer/master/docker-compose.yml

sudo docker-compose up -d
Excerpt of output.
Starting root_documentserver_1...
Starting root_mailserver_1...
Pulling communityserver (onlyoffice/communityserver:latest)...
latest: Pulling from onlyoffice/communityserver
Once it is downloaded, docker instance will be started automatically. Run the following command to check the status of images.
 docker ps

CONTAINER ID        IMAGE                        COMMAND                  CREATED             STATUS              PORTS                                                                                NAMES
4a664a15561e        onlyoffice/communityserver   "/bin/sh -c 'bash -C "   3 minutes ago       Up 2 minutes        443/tcp, 0.0.0.0:80->80/tcp, 5222/tcp                                                root_communityserver_1
77ec008a9971        onlyoffice/mailserver        "/bin/sh -c 'export C"   33 minutes ago      Up 10 minutes       0.0.0.0:25->25/tcp, 0.0.0.0:143->143/tcp, 3306/tcp, 0.0.0.0:587->587/tcp, 8081/tcp   root_mailserver_1
79c982ecf672        onlyoffice/documentserver    "/bin/sh -c 'bash -C "   46 minutes ago      Up 10 minutes       80/tcp, 443/tcp                                                                      root_documentserver_1

Access ONLYOFFICE Web console:

Open up a web browser and navigate to (http://ip-add-ress) address of your server. Please wait for few minutes to get ONLYOFFICE initialized.
Install Onlyoffice - Initialzing
Install Onlyoffice – Initialzing
Fill up your details, along with password for portal.
Install Onlyoffice - Configuration
Install Onlyoffice – Configuration
You will get below home page, click on respective modules. For example, if you click on Documents, you will be taken to Documents section.
Onlyoffice - Home
Onlyoffice – Home
Here you can upload, create and edit the files. Also, you can connect your Google Drive, Dropbox and Box accounts and have all documents in one place.
Please note that you must activate your email entered while registering to get access to all the portal features.
Onlyoffice - Documents
Onlyoffice – Documents
For demo, i clicked on “ONLYOFFICE Sample Document.docx”; it took me to document editing page. The following screen shot shows how document editor will look like.
Onlyoffice - Documents Editor
Onlyoffice – Documents Editor
Spreadsheet editor;
Install Onlyoffice - Spreadsheet Editor
Install Onlyoffice – Spreadsheet Editor
Other than document editing, you can setup the CRM, Mail server, create, manage projects and people’s etc.
Projects:
Install Onlyoffice - Projects
Install Onlyoffice – Projects
CRM:
Onlyoffice - CRM
Onlyoffice – CRM
Community:
Onlyoffice -Community
Onlyoffice -Community
People:
Onlyoffice - People
Onlyoffice – People
Mail:
Onlyoffice -  Mail
Onlyoffice – Mail
Talk:
Onlyoffice - Talk
Onlyoffice – Talk
Calender:
This is full featured collaborative suite runs on top of Docker, you can also set this up using repository.

Install ONLYOFFICE using Repository:

To install ONLYOFFICE from the official repository, you will need to download ONLYOFFICE GPG signing key:
sudo wget http://download.onlyoffice.com/repo/onlyoffice.key
And add it to the system:
sudo apt-key add onlyoffice.key
Add ONLYOFFICE repository to /etc/apt/sources.list file. Open this file using any available text editor.
sudo nano /etc/apt/sources.list
Add the following entry
deb http://download.onlyoffice.com/repo/debian squeeze main
Add repository to get up-to-date libstdc++6 package versions:
sudo add-apt-repository ppa:ubuntu-toolchain-r/test
Update repository:
sudo apt-get update
Install ONLYOFFICE from the repository execute the following command:
sudo apt-get install onlyoffice-documentserver
During installation, you will be asked to setup MySQL root user password.
Install OnlyOffice - MySQL Password
Install OnlyOffice – MySQL Password
Re-enter the password.
Install OnlyOffice - Repeat MySQL Password
Install OnlyOffice – Repeat MySQL Password
Enter password for ONLYOFFICE Document server database.
Install OnlyOffice - MySQL Password - Document Server
Install OnlyOffice – MySQL Password – Document Server
Accept the license agreement of MS fonts.
Install OnlyOffice - EULA MS Fonts
Install OnlyOffice – EULA MS Fonts
Install OnlyOffice - Agree EULA MS Fonts
Install OnlyOffice – Agree EULA MS Fonts
That’s it. ONLYOFFICE has been installed.
Access ONLYOFFICE Web console:
Open up your web browser and navigate to http://ip-add-ress/. You should see the following screen.
Onlyoffice - Documets Home
Onlyoffice – Documets Home
Now, you can start using the Document server. From now you can use the ONLYOFFICE online editors to create, edit, view, and delete word documents, excel sheets, and presentation files etc.
ONLYOFFICE can be easily integrated into your website or cloud application via API provided. So you get a chance to provide users with the most advanced online document editors for text docs, spreadsheets and presentations.
To upload a new document, click “Choose file” button and select the files on your PC.
Onlyoffice - Documets Upload Files and with conversion
Onlyoffice – Documets Upload Files and with conversion
Now, you can view or edit the uploaded document. The following screen shows how document editor looks like.
Onlyoffice - Documents Editing
Onlyoffice – Documents Editing
To edit the document, click the Edit button in the web console, make the changes and click the save button.
Also, you can integrate the Document server with collaborative system to get a full featured collaborative suite like we set up using the docker. For more details about installing ONLYOFFICE Community Server integrated with Document and Mail Servers, refer the official documentation page.

OnlyOffice Centos7

How to Install ONLYOFFICE on Red Hat Linux (RHEL) and CentOS

Introduction

ONLYOFFICE is a free, open source software that enables teams to manage projects, customer relations and documents in one place. Though Ubuntu is the most well-known Linux distribution, we don't want other distributions users to feel left out in the cold. This guide will show what steps to take to install ONLYOFFICE collaborative system on Red Hat/CentOS.

System requirements

For ONLYOFFICE correct work your machine should meet some system requirements and have some additional components installed:
  • RAM: 2 GB or more
  • Swap file: at least 2 GB
  • HDD: at least 2 GB of free space
  • mono: version 3.2 or later
  • MySQL: version 5.6 or later
  • nginx
Install some prerequisites and enable additional repositories for (For CentOS 7):
yum -y install nano yum-utils
yum -y install epel-release
yum install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
The components found in the system repository will be installed automatically at ONLYOFFICE installation using the yum install command.
If some of these components are missing, follow the instructions from their official websites.
Enable the MySQL service and start mysql:
systemctl enable mysqld.service
systemctl start mysqld.service
Set a MySQL password (the initial password is empty) and remove the test database:
mysql_secure_installation
The command will guide you interactively trough the mysql securing process as described below:
[root@static ~]# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!

By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
... Failed! Not critical, keep moving...
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Cleaning up...

Installing ONLYOFFICE

Step 1. Open Terminal using Ctrl+Alt+T

Step 2. Add the yum ONLYOFFICE repository.

To do that, create the /etc/yum.repos.d/onlyoffice.repo file with the following contents:
nano /etc/yum.repos.d/onlyoffice.repo
[onlyoffice]
name=onlyoffice repo
baseurl=http://download.onlyoffice.com/repo/centos/noarch/
gpgcheck=0
enabled=1
Step 3. Install ONLYOFFICE from the repository
Just execute the following command:
sudo yum install onlyoffice

Configuring ONLYOFFICE

Before you start ONLYOFFICE for the first time it is necessary to create the database and configure connection to it.
To do that, run the configuration script:
chmod +x /var/www/onlyoffice/configure.sh
/var/www/onlyoffice/configure.sh
It will interactively ask you to enter the MySQL connection parameters, create the database, update configuration files and run all services.
Please, note: the script does not create users for the database and does not change passwords for existing users.
[root@static ~]# /var/www/onlyoffice/configure.sh
-bash: /var/www/onlyoffice/configure.sh: Permission denied
[root@static ~]# chmod +x /var/www/onlyoffice/configure.sh
[root@static ~]# /var/www/onlyoffice/configure.sh
Configuring MySQL access...
Host: localhost
Database name: onlyoffice
User: root
Password: <- enter the mysql root password here
Trying to establish MySQL connection... OK
Installing MySQL database... Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
OK
Restarting services... OK
Then change the line
listen       80 default_server;
to
listen       81 default_server;
in the file /etc/nginx/nginx.conf as ONLYOFFICE defines its own default vhost on port 80 and enable and start nginx:
nano /etc/nginx/nginx.conf
Then enable and start nginx:
systemctl enable nginx.service
systemctl start nginx.service

Running ONLYOFFICE

To open your office in the web browser, enter localhost (http://127.0.0.1) or the external IP of your server if you dont have a Desktop installed in the address bar of your browser. The Welcome page will open:
OnlyOffice Login
Enter a password and specify the email address you will use to access your ONLYOFFICE the next time.
Done! You can start working!

Tips and Tricks

  • Tip 1. ONLYOFFICE uses Mono v. 3.2 or later, to install it checkout the official instructions. If it is installed to find out your current version, execute the following command: mono --version.
  • Tip 2. To install the latest version of nginx, follow the official instructions.
  • Tip 3. ONLYOFFICE requires MySQL version 5.6 or later. To install it on your machine, refer to the official instructions.
  • Tip 4. Once ONLYOFFICE is installed, you may need to customize and manage it so that it fitted your needs. All the necessary instructions can be found on the ONLYOFFICE official website.
  • Tip 5. To install ONLYOFFICE using the graphical user interface, download the installation file from SourceForge.
  • Tip 6. If you are looking for simplest and more secure way to install ONLYOFFICE, use the Docker service.

cloudoffice ok

1. Set up the repository

Set up the Docker CE repository on Ubuntu. The lsb_release -cs sub-command prints the name of your Ubuntu version, like xenial or trusty.
sudo apt-get -y install \
  apt-transport-https \
  ca-certificates \
  curl

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

sudo add-apt-repository \
       "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
       $(lsb_release -cs) \
       stable"

sudo apt-get update

2. Get Docker CE

Install the latest version of Docker CE on Ubuntu:
sudo apt-get -y install docker-ce

3. Test your Docker CE installation

Test your installation:
sudo docker run hello-world

Next steps

These installation instructions work for standard installations of Docker CE. For more details or alternative installation procedures, including how to install edge builds, see Get Docker for Ubuntu.


 13  sudo docker run -i -t -d -p 80:80 onlyoffice/communityserver
   14  wget http://download.onlyoffice.com/install/opensource-install.sh
   15  bash opensource-install.sh -md "cloudoffice.yogyagroup.com

Rabu, 29 Maret 2017

Ganti resolusi install centos7


Linux: Ganti instalasi dan resolusi video boot pada CentOS / RHEL 7

Dengan  | 14 Oktober 2016
Di antara semua lonceng baru dan peluit datang dengan rilis utama terbaru platform RedHat Enterprise Linux, bot resolusi kedua proses instalasi dan sistem konsol telah berubah (resolusi yang lebih tinggi dari sebelumnya adalah default).
Sayangnya, sistem server tidak selalu memiliki perangkat layar terbaru atau ILO, iDRAC dan konsol mesin virtual berada di luar jangkauan untuk ini resolusi tinggi.
Hal ini untungnya mungkin untuk menurunkan resolusi yang sesuai dengan konsol Anda atau layar.
1. Untuk menurunkan resolusi pada proses instalasi, cukup tekan “TAB” pada menu installer boot, Anda akan melihat garis muncul di bagian bawah layar dengan berikut:
> Vmlinuz initrd = initrd.img inst.stage2 = hd: LABEL = CentOS \ x207 \ x20x86_64 tenang
Semua harus Anda lakukan adalah menambahkan spasi dan menambahkan “resolusi =” atau “vga =” dengan nilai yang diinginkan sebagai berikut:
Alternatively, you can enter the VGA color code by entering “ vga= ” followed by the colour code (example : vga=785). See the chart below for more informations :
Color depth640×480800×6001024×7681280×10241400×10501600×1200
8 (256)769771773775
15 (32K)784787790793
16 (65K)785788791794834884
24 (16M)786789792795
2. At the boot process of the system, you will need to edit the Grub2 boot loader by pressing “e” at boot at the kernel selection screen and edit the “vmlinuz” line, append at the end of the line “video=” followed by the desired resolution such as :
Then press CTRL + X to boot.
You may make this change permanent by editing the Grub configuration. Follow the instructions of the following article : Edit Grub2 settings on RHEL/CentOS 7
NOTE : The lowest resolution supported by RHEL 7 console and installer is 400 x 375