Topic: OnlyOffice on Koozali SME 10 (Centos 7) native (no docker)

[countzero]

https://tablelandscomputers.com/koozali-sme-server-10-onlyoffice-community-edition-centos-7/

I got this far:  "Sorry, portal is on maintenance.  It may take a few minutes."

# tail /var/log/onlyoffice/web.06-01.log

2017-06-01 23:15:04,413 ERROR [Threadpool worker] ASC.Resources - ReplaceLogo
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
2017-06-01 23:15:04,459 ERROR [Threadpool worker] ASC.Web - Warmup error
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.

+ I have requested wiki access using this forum > Profile > Group Membership.  It is still "Pending Approval"

[Jean-Philippe Pialasse]

Hi ,

have you raise a bug in bugzilla to ask for wiki privileges ? Can you point it ?

your issue seems related to trying to replace mariadb to mysql-community

a few comments :
1- this is too soon to try integrating crontribs on SME 10 as it is still alpha, a lot of things will change.

2- have you actually tried using MariaDB 5.5 ? https://mariadb.com/kb/en/mariadb/what-is-mariadb-55/
It should offer all the required elements offered by mysql5.5 ( requirement of OnlyOffice community)

a lot of changes have been done to integrate MariaDB in place of Mysql, you are far from reverting all of them in your how to and this is not the best approach.

3- alternatively if mariadDB doe snot fit you should rather opt for a software collection of mysql. give a try at the SME9 contrib to configure it on SME10, but not tested yet and I can not guarantee it will work

4- you did edit the my.cnf directly this is templated and will be overwrite on a few SME events.

5- why haven't you tried on SME9 ? I know requirement is kernel version 3.10 or later, while SME 9 has 2.6.32-696 but a few patch are applied on Red Hat kernel quite often the version number will not match with what it can actually do... further more you would be able to user mysql 5.6 if you want as a contrib.

6- mono : mono-core-4.2.4-9 is available from epel for centos 7 and 6, maybe not necessary to get the external repo of mono.

[countzero]

I tried using mariadb but onlyoffice has a dependency for 'mysql-server' that --skip-broken does not allow me to bypass.  I understand the importance of mariadb and hope to use that eventually.  I have wiped my VPS and started from scratch using SME 9 as suggested:

SME 9.2
+ Epel EL6 repo
+ nginx repo
+ onlyoffice repo

yum update

signal-event post-upgrade ; signal-event-reboot

/sbin/e-smith/db yum_repositories set epel6 repository \
Name 'Epel - EL6' \
BaseURL 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&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

/sbin/e-smith/db yum_repositories set nginx repository \
Name 'nginx repo' \
BaseURL 'http://nginx.org/packages/centos/$releasever/$basearch/' \
EnableGroups no \
GPGCheck no \
Visible no \
status disabled

/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

/sbin/e-smith/db yum_repositories set epel7 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 repolist all

repo id                                               repo name                                                        status
base                                                  CentOS - os                                                      enabled: 6,703+3
centosplus                                            CentOS - centosplus                                              disabled
contrib                                               CentOS - contrib                                                 disabled
epel6                                                 Epel - EL6                                                       disabled
epel7                                                 Epel - EL7                                                       disabled
extras                                                CentOS - extras                                                  disabled
fasttrack                                             CentOS - fasttrack                                               disabled
nginx                                                 nginx repo                                                       disabled
onlyoffice                                            onlyoffice                                                       disabled
smeaddons                                             SME Server - addons                                              enabled:       0
smecontribs                                           SME Server - contribs                                            disabled
smedev                                                SME Server - dev                                                 disabled
smeextras                                             SME Server - extras                                              enabled:     165
smeos                                                 SME Server - os                                                  enabled:     907
smetest                                               SME Server - test                                                disabled
smeupdates                                            SME Server - updates                                             enabled:      11
smeupdates-testing                                    SME Server - updates testing                                     disabled
updates                                               CentOS - updates                                                 enabled:   353+1

yum install onlyoffice-communityserver --enablerepo=onlyoffice,epel6,nginx

Error: Package: onlyoffice-communityserver-9.0.1-37.noarch (onlyoffice)
           Requires: mono >= 4.2.0
Error: Package: onlyoffice-communityserver-9.0.1-37.noarch (onlyoffice)
           Requires: xsp
Error: Package: mono-webserver-hyperfastcgi-0.4-4.noarch (onlyoffice)
           Requires: libc.so.6(GLIBC_2.14)(64bit)

So it looks like I need mono, which opens up a whole new can of worms.

Using SME8 instructions from the wiki:

/sbin/e-smith/db yum_repositories set mono repository \
Name 'Mono 2.x for rhel-5-i386 (stable)' \
BaseURL 'http://ftp.novell.com/pub/mono/download-stable/RHEL_5/' \
EnableGroups no \
GPGCheck yes \
GPGKey http://ftp.novell.com/pub/mono/download-stable/RHEL_5/repodata/repomd.xml.key \
Visible yes \
status disabled

signal-event yum-modify

yum install onlyoffice-communityserver --enablerepo=onlyoffice,epel6,nginx,mono

--> Finished Dependency Resolution
Error: Package: libgdiplus0-4.2-0.xamarin.2.epel7.x86_64 (mono)
           Requires: libpng15.so.15(PNG15_0)(64bit)
Error: Package: libgdiplus0-4.2-0.xamarin.2.epel7.x86_64 (mono)
           Requires: libpng15.so.15()(64bit)
Error: Package: libmonoboehm-2_0-1-5.0.1.1-0.xamarin.3.epel7.x86_64 (mono)
           Requires: libc.so.6(GLIBC_2.15)(64bit)
Error: Package: mono-webserver-hyperfastcgi-0.4-4.noarch (onlyoffice)
           Requires: libc.so.6(GLIBC_2.14)(64bit)
Error: Package: mono-core-5.0.1.1-0.xamarin.3.epel7.x86_64 (mono)
           Requires: libc.so.6(GLIBC_2.16)(64bit)
Error: Package: mono-devel-5.0.1.1-0.xamarin.3.epel7.x86_64 (mono)
           Requires: libc.so.6(GLIBC_2.15)(64bit)
Error: Package: libgdiplus0-4.2-0.xamarin.2.epel7.x86_64 (mono)
           Requires: libtiff.so.5()(64bit)
Error: Package: libmonosgen-2_0-1-5.0.1.1-0.xamarin.3.epel7.x86_64 (mono)
           Requires: libc.so.6(GLIBC_2.15)(64bit)
Error: Package: libgdiplus0-4.2-0.xamarin.2.epel7.x86_64 (mono)
           Requires: libc.so.6(GLIBC_2.14)(64bit)
Error: Package: libgdiplus0-4.2-0.xamarin.2.epel7.x86_64 (mono)
           Requires: libtiff.so.5(LIBTIFF_4.0)(64bit)


yum install onlyoffice-communityserver --enablerepo=onlyoffice,epel6,nginx,mono,epel7
Error: xz compression not available

Please advise next steps.  Shall I format the disk and fire up SME10?

[Jean-Philippe Pialasse]

As i told mono is available from epel. No need for third repo designed for rhel 5 when you use a rhel 6 derivative.

Plus looks like you are using a rhel 7 repo as per your last errors.

Stick to rhel 6/ centos 6 / sme 9

[Jean-Philippe Pialasse]

In other word remove epel7 and mono repo.

[guest22]

The Mono repo *IS* required for ONLYOFFICE requires a specific mono version that is not available via EPEL.

[guest22]

I tried using mariadb but onlyoffice has a dependency for 'mysql-server' that --skip-broken does not allow me to bypass. 

MariaDB will not work with ONLYOFFICE. MySQL is currently hardcoded in the ONLYOFFICE code. You will need to install a higher version of MySQL via Software Collections or remove all existing MySQL stuff and do a clean install for a higher version from the MySQL official repo.

The existing SCL contribs for MySQL are faulty and misleading for you can not call for 'mysql' as a drop in replacement. Somehow the design of the contrib forgot about the PURPOSE of Software Collections. A drop in replacement when called for, not along side. So none of any application that need for e.g. MySQL 5.7 can call the contrib for the contrib only responds to e.g. 'mysql57', not to default 'mysql' commands. Very bad 'design' and worthless.

[Jean-Philippe Pialasse]

MariaDB will not work with ONLYOFFICE. MySQL is currently hardcoded in the ONLYOFFICE code. You will need to install a higher version of MySQL via Software Collections or remove all existing MySQL stuff and do a clean install for a higher version from the MySQL official repo.

The existing SCL contribs for MySQL are faulty and misleading for you can not call for 'mysql' as a drop in replacement. Somehow the design of the contrib forgot about the PURPOSE of Software Collections. A drop in replacement when called for, not along side. So none of any application that need for e.g. MySQL 5.7 can call the contrib for the contrib only responds to e.g. 'mysql57', not to default 'mysql' commands. Very bad 'design' and worthless.

Well you can simply specify the port or socker still using the standard mysql command. This is basic stuff for any app to let you specify the  servr adress and port or socket.


For mono epel gives  4.2.4 , and it needs 4.2 or later https://helpcenter.onlyoffice.com/server/linux/community/system-requirements.aspx

[guest22]

2 x wrong. But let's focus on the question and topic at hand.

[TerryF]

2 x wrong. But let's focus on the question and topic at hand.

Easy solution HF you take OP by the hand and lead on.

[countzero]

Some advice that may help others save time:

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.

[DanB35]

Just what's in this thread, and some of the stuff on their web site, gives some major red flags on this system:

1.  Why is it hardcoded to require a specific version of MySQL, and to refuse to work with another ABI-compatible DMBS?
2.  Why does it use hardcoded DNS servers?
3.  Why do the official installation instructions direct you to download and execute, with root privileges, a script from an insecure web site?

The last, especially, is a security hole big enough to drive a truck through.

[guest22]

Just what's in this thread, and some of the stuff on their web site, gives some major red flags on this system:

1.  Why is it hardcoded to require a specific version of MySQL, and to refuse to work with another ABI-compatible DMBS?
2.  Why does it use hardcoded DNS servers?
3.  Why do the official installation instructions direct you to download and execute, with root privileges, a script from an insecure web site?

The last, especially, is a security hole big enough to drive a truck through.

Run by Russians in Latvia....

[countzero]

I have been unable to figure out the exact conditions of use.

https://helpcenter.onlyoffice.com/faq/server-opensource.aspx

• GNU AGPL v.3 - looks good.
• Opensource - looks good.

https://www.onlyoffice.com/license-faq.aspx

• Rebranding not allowed - understandable.

But then there is this:

https://www.onlyoffice.com/compare-server-editions.aspx
"ONLYOFFICE offers different versions of its self-hosted solution: Community Edition and Enterprise Edition (Start, Standard and Standard+)."
"The table below will help you to make the right choice."
"Number of users: Up to 20 maximum"

The native installation consisting of Community Server + Document Server on 2 hosts probably has the same restrictions as Community Edition (= 3x docker images running on a single host)

When I search the forums it suggests that Document Server (= the document editing module) has a limitation of one CPU core and 20 simultaneous connections (= 20 users limit) supposedly. It means that Document Sever may work with 20 simultaneous documents (connections) opened by you or someone else. The 21st connection will be able to connect to documents in view mode only.

+ downloading Debian packages (*.deb files) from a vendor server exclusively ('http://download.onlyoffice.com') does not give me that warm fuzzy open source feeling I'd have to agree.