Author Archives: tabcom

Koozali SME Server 10 – OnlyOffice Community Edition on Centos 7 (docker)

Introduction

ONLYOFFICE is a free, open source corporate office suite developed to organize teamwork online. It’s composed of three separate servers:

  • The Document Server provides users with text, spreadsheet and presentation online editors working within a browser and allowing to co-edit documents in real time, comment and interact using the integrated chat.
  • The Community Server offers a complete set of tools for document, project, customer relation and email correspondence management.
  • The Mail Server is used to create mailboxes using your own domain name.

Because ONLYOFFICE has many moving parts and dependencies, it is recommended to simplify the installation process and avoid dependency errors by deploying ONLYOFFICE using Docker containers.

System requirements

RAM: 8 GB or more
CPU: 2 Core or better
Swap file: at least 8 GB

Docker

Docker installations allow you to run OnlyOffice Community Server:
 # docker images
 REPOSITORY                   TAG                 IMAGE ID            CREATED             SIZE
 onlyoffice/documentserver    4.3.4.10            f5ff5f9ec0c4        2 weeks ago         1.41GB
 onlyoffice/documentserver    latest              f5ff5f9ec0c4        2 weeks ago         1.41GB
 onlyoffice/communityserver   9.0.0.300           d70fbb99a6ee        4 weeks ago         1.32GB
 onlyoffice/communityserver   latest              d70fbb99a6ee        4 weeks ago         1.32GB
 onlyoffice/mailserver        1.6.21              05dd11e787af        5 weeks ago         1.77GB

ONLYoffice Community Edition contains 3 ‘virtual machine’ containers using Docker (communityserver, mailserver, documentserver).  This requires 8GB RAM as the docker images generate some overhead as you can understand.  A native installation requires 2 hosts: 1x Community Server and 1x Document Server.  Native installations allow you to upgrade components more easily and will allow you to use *.pem Let’s Encrypt signed certs.  Native installations also only require 2GB RAM for each node and are quite a bit more responsive.

I have used 2x Debian 8 Jessie to install Community Server and Document Server successfully:
https://tablelandscomputers.com/ubuntu-16-tls-debian-8-onlyoffice-no-docker/

I initially preferred to use Koozali as I love the web admin panel and db commands, but having Apache and Nginx on a single host is asking for problems as you can’t use HTTP port 80 and HTTPS port 443 for both.

Conclusion: It is recommended to run onlyoffice on a ‘clean’ operating system as it will pull in all the packages it needs.

Please find the results of my FAILED ATTEMPT below:

Centos 7 (Koozali SME server 10 alpha)

Things to keep in mind:

  • You need to add yum repositories using Koozali commands.
  • You need to remove MariaDB in favour of MySQL server 5.6
  • You will have Apache and nginx web servers run side-by-side (both wanting to use TCP ports 80 / 443)

Getting started

yum -y install nano yum-utils
yum -y install epel-release

https://wiki.contribs.org/Epel

/sbin/e-smith/db yum_repositories set epel repository \
 Name 'Epel - EL7' \
 BaseURL 'http://download.fedoraproject.org/pub/epel/7/$basearch' \
 MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-7&arch=$basearch' \
 EnableGroups no \
 GPGCheck yes \
 GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
 Exclude perl-Razor-Agent \
 Visible no \
 status disabled

signal-event yum-modify

yum install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

ll /etc/yum.repos.d

mysql-community.repo
mysql-community-source.repo

more mysql-community.repo

Note the various yum repositories in this file.

/sbin/e-smith/db yum_repositories set mysql56-community repository \
 Name 'MySQL 5.6 Community Server' \
 BaseURL 'http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/' \
 EnableGroups no \
 GPGCheck yes \
 GPGKey file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql \
 Visible no \
 status disabled

signal-event yum-modify

yum remove smeserver-horde e-smith-mysql mariadb-server

signal-event post-upgrade

yum install mysql-server –enablerepo mysql56-community

signal-event post-upgrade

nano /etc/my.cnf

[mysqld]
pid-file=/var/run/mysqld/mysqld.pid
basedir=/usr
datadir=/var/lib/mysql
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

socket=/var/lib/mysql/mysql.sock
skip-networking
max_allowed_packet=16M
user=mysql

[mysqld_safe]

systemctl enable mysqld.service

systemctl start mysqld.service

mysql_upgrade

mysql
mysql> CREATE database onlyoffice;
mysql> CREATE USER ‘onlyoffice’@’localhost’ IDENTIFIED BY ‘yourpasswordhere’;
mysql> GRANT ALL PRIVILEGES ON onlyoffice.* TO ‘onlyoffice’@’localhost’;
mysql> FLUSH PRIVILEGES;
mysql> exit;

/sbin/e-smith/db yum_repositories set onlyoffice repository \
 Name 'onlyoffice' \
 BaseURL 'http://download.onlyoffice.com/repo/centos/main/noarch/' \
 EnableGroups no \
 GPGCheck no \
 Visible no \
 status disabled

signal-event yum-modify

rpm –import “http://keyserver.ubuntu.com/pks/lookup?op=get&search=0x3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF”

yum-config-manager –add-repo http://download.mono-project.com/repo/centos/

yum install onlyoffice-communityserver –enablerepo=onlyoffice epel

signal-event post-upgrade

For now we aim to run the web services using the following TCP/IP port numbers:
80 HTTP  apache (Koozali)
81 HTTP  nginx  (default page)
82 HTTP  nginx  (onlyoffice)
443 HTTPS apache (Koozali)

systemctl enable nginx.service

systemctl stop nginx.service

nano /etc/nginx/conf/nginx.conf

listen 80 default_server;    –>    listen 81 default_server;

nano /etc/nginx/conf/conf.d/onlyoffice.conf

listen 80;    –>     listen 82;

Now we have to edit our server’s firewall rules to open TCP ports for incoming traffic:

db configuration set onlyoffice service
db configuration setprop onlyoffice TCPPorts 81,82
db configuration setprop onlyoffice status enabled
db configuration setprop onlyoffice access public

signal-event remoteaccess-update

sh /var/www/onlyoffice/configure.sh
Configuring MySQL access…
Host: localhost
Database name: onlyoffice
User: onlyoffice
Password: yourpasswordhere
Trying to establish MySQL connection… OK

systemctl start nginx.service

By starting the nginx web server onlyoffice should now be available.

http://ipaddress:80  -> apache primary ibay

http://ipaddress:81  -> nginx default page

http://ipaddress:82  -> Sorry, portal is on maintenance.  It may take a few minutes.

Long story short; this does not work.

Koozali SME Server 10 – OnlyOffice Community Edition on Centos 7 (docker) was last modified: June 3rd, 2017 by tabcom

Microsoft Windows generic product keys

These keys will not activate your copy of Windows – they will allow you to install the product and prompt for a valid key after installation is complete.

Windows Edition Product Key
Windows 7 Starter 7Q28W-FT9PC-CMMYT-WHMY2-89M6G
Windows 7 Home Basic YGFVB-QTFXQ-3H233-PTWTJ-YRYRV
Windows 7 Home Premium RHPQ2-RMFJH-74XYM-BH4JX-XM76F
Windows 7 Professional HYF8J-CVRMY-CM74G-RPHKF-PW487
Windows 7 Ultimate D4F6K-QK3RD-TMVMJ-BBMRX-3MBMV
Windows 7 Enterprise H7X92-3VPBB-Q799D-Y6JJ3-86WC6
Windows 7 Starter N D4C3G-38HGY-HGQCV-QCWR8-97FFR
Windows 7 Home Basic N MD83G-H98CG-DXPYQ-Q8GCR-HM8X2
Windows 7 Home Premium N D3PVQ-V7M4J-9Q9K3-GG4K3-F99JM
Windows 7 Professional N BKFRB-RTCT3-9HW44-FX3X8-M48M6
Windows 7 Ultimate N HTJK6-DXX8T-TVCR6-KDG67-97J8Q
Windows 7 Enterprise N BQ4TH-BWRRY-424Y9-7PQX2-B4WBD
Windows 7 Starter E BRQCV-K7HGQ-CKXP6-2XP7K-F233B
Windows 7 Home Basic E VTKM9-74GQY-K3W94-47DHV-FTXJY
Windows 7 Home Premium E 76BRM-9Q4K3-QDJ48-FH4F3-9WT2R
Windows 7 Professional E 3YHKG-DVQ27-RYRBX-JMPVM-WG38T
Windows 7 Ultimate E TWMF7-M387V-XKW4Y-PVQQD-RK7C8
Windows 7 Enterprise E H3V6Q-JKQJG-GKVK3-FDDRF-TCKVR
Windows 8 (Retail) FB4WR-32NVD-4RW79-XQFWH-CYQG3
Windows 8 (OEM) 46V6N-VCBYR-KT9KT-6Y4YF-QGJYH
Windows 8 (ARM) 6D4CN-WMGRW-DG8M6-XX8W9-3RPT8
Windows 8 (Country Specific) XYNVP-TW798-F8893-7B89K-8QHDK
Windows 8 (Single Language) XBRND-QDJTG-CQJDB-7DRBW-RX6HB
Windows 8 Professional (Retail) XKY4K-2NRWR-8F6P2-448RF-CRYQH
Windows 8 Professional (OEM) V7C3N-3W6CM-PDKR2-KW8DQ-RJMRD
Windows 8 Professional with WMC RR3BN-3YY9P-9D7FC-7J4YF-QGJXW
Windows 8 Enterprise 32JNW-9KQ84-P47T8-D8GGY-CWCK7
Windows 8 N VDKYM-JNKJ7-DC4X9-BT3QR-JHRDC
Windows 8 Professional N BHHD4-FKNK8-89X83-HTGM4-3C73G
Windows 8 Enterprise N NCVKH-RB9D4-R86X8-GB8WG-4M2K6
Windows 8.1 334NH-RXG76-64THK-C7CKG-D3VPT
Windows 8.1 (ARM) NK2V7-9DWXG-KMTWQ-K9H9M-6VHPJ
Windows 8.1 (Country Specific) TNH8J-KG84C-TRMG4-FFD7J-VH4WX
Windows 8.1 (Single Language) Y9NXP-XT8MV-PT9TG-97CT3-9D6TC
Windows 8.1 Professional GCRJD-8NW9H-F2CDX-CCM8D-9D6T9
Windows 8.1 Professional with WMC GBFNG-2X3TC-8R27F-RMKYB-JK7QT
Windows 8.1 Enterprise FHQNR-XYXYC-8PMHT-TV4PH-DRQ3H
Windows 8.1 N 6NPQ8-PK64X-W4WMM-MF84V-RGB89
Windows 8.1 Professional N JRBBN-4Q997-H4RM2-H3B7W-Q68KC
Windows 8.1 Enterprise N NDRDJ-3YBP2-8WTKD-CK7VB-HT8KW
Windows Server 2008 Standard TM24T-X9RMF-VWXK6-X8JC9-BFGM2
Windows Server 2008 Web WYR28-R7TFJ-3X2YQ-YCY4H-M249D
Windows Server 2008 HPC RCTX3-KWVHP-BR6TB-RB6DM-6X7HP
Windows Server 2008 Enterprise YQGMW-MPWTJ-34KDK-48M3W-X4Q6V
Windows Server 2008 Itanium 7YKJ4-CX8QP-Q23QY-7BYQM-H2893
Windows Server 2008 Datacenter 7M67G-PC374-GR742-YH8V4-TCBY3
Windows SBS 2008 Standard PHYFD-HQ4XW-78PR4-2CXKF-V67KJ
Windows SBS 2008 Premium 4TMY4-8JG4B-VKY8X-6TVDH-J7XFV
Windows Server 2008 R2 Foundation 36RXV-4Y4PJ-B7DWH-XY4VW-KQXDQ
Windows Server 2008 R2 Standard YC6KT-GKW9T-YTKYR-T4X34-R7VHC
Windows Server 2008 R2 Web 6TPJF-RBVHG-WBW2R-86QPH-6RTM4
Windows Server 2008 R2 HPC TT8MH-CG224-D3D7Q-498W2-9QCTX
Windows Server 2008 R2 Enterprise 489J6-VHDMP-X63PK-3K798-CPX3Y
Windows Server 2008 R2 Itanium GT63C-RJFQ3-4GMB6-BRFB9-CB83V
Windows Server 2008 R2 Datacenter 74YFP-3QFB3-KQT8W-PMXWJ-7M648
Windows Hyper-V Server 2008 R2 Q8R8C-T2W6H-7MGPB-4CQ9R-KR36H
Windows MultiPoint Server 2010 736RG-XDKJK-V34PF-BHK87-J6X3K
Windows SBS 2011 Standard YT76W-VD3W9-QDCK4-9QFPX-WQY4J
Windows SBS 2011 Premium BXQQP-Q6Q6D-TR7TR-3YXQW-VFHKM
Windows Home Server 2011 Standard BTMWJ-8KHD9-B9BX8-J7JQ9-7M6J2
Windows Home Server 2011 Premium YQXDR-G2MBV-63VW2-JX8J2-FVTVG
Windows Server 2012 Foundation PN24B-X6THG-274MF-YHM9G-H8MVG
Windows Server 2012 Standard VN93G-8PVT3-W2X3H-F3X87-FJMTW
Windows Server 2012 Datacenter 2GMNX-8K7D2-X968C-7P62F-8B2QK
Windows Server 2012 Storage Server RD9XF-6N3MC-2P2R3-MK2WX-C7GCW
Windows Multipoint Server 2012 Standard 32TNQ-HMFWQ-8R933-X6VYY-WHRFX
Windows Multipoint Server 2012 Premium CBR2N-2HG39-2TGGT-GQB27-46V47;
Windows Server 2012 Standard Core VN93G-8PVT3-W2X3H-F3X87-FJMTW
Windows Server 2012 Datacenter Core 2GMNX-8K7D2-X968C-7P62F-8B2QK
Windows Server 2012 R2 Essentials KNC87-3J2TX-XB4WP-VCPJV-M4FWM
Windows Server 2012 R2 Foundation 7JGXN-BW8X3-DTJCK-WG7XB-YWP26
Windows Server 2012 R2 Standard D2N9P-3P6X9-2R39C-7RTCD-MDVJX
Windows Server 2012 R2 Datacenter W3GGN-FT8W3-Y4M27-J84CP-Q3VJ9
Windows Server 2012 R2 Storage Server Standard H2K4M-QNKQ2-64699-FYQHD-2WDYT
Windows Server 2012 R2 Storage Server Workgroup 8N7PM-D3C64-RQVYF-MX8T7-G6MB2
Microsoft Hyper-V Server 2012 R2 Q8R8C-T2W6H-7MGPB-4CQ9R-KR36H
Windows Server 2012 R2 Essentials Core 326N4-6GMBX-PD2QT-M7HX4-TVHM8
Windows Server 2012 R2 Foundation Core 7JGXN-BW8X3-DTJCK-WG7XB-YWP26
Windows Server 2012 R2 Standard Core NB4WH-BBBYV-3MPPC-9RCMV-46XCB
Windows Server 2012 R2 Datacenter Core BH9T4-4N7CW-67J3M-64J36-WW98Y
Windows Server 2012 R2 Storage Server Standard Core H2K4M-QNKQ2-64699-FYQHD-2WDYT
Windows Server 2012 R2 Storage Server Workgroup Core 8N7PM-D3C64-RQVYF-MX8T7-G6MB2
Microsoft Windows generic product keys was last modified: May 19th, 2017 by tabcom

Outlook cannot log on

Symptoms

I recently uninstalled a previous version of Microsoft Office and installed the latest version of Microsoft Office as part of my Office 365 Premium subscription.  However, I receive the following error message when I try to launch Microsoft Outlook:

“Outlook cannot log on.  Verify you are connected to the network and are using the proper server and mailbox name.  The Microsoft Exchange information service in your profile is missing required information.  Modify your profile to ensure that you are using the correct Microsoft Exchange information service.”

Cause

Parts of your email profile from a previous version of Microsoft Outlook were left behind and prevents the newer version to launch properly.

Solution

Delete all registry keys under HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Outlook\Profiles\Outlook

Outlook cannot log on was last modified: May 17th, 2017 by tabcom