Koozali.org: home of the SME Server
Contribs.org Forums => General Discussion => Topic started by: countzero on June 01, 2017, 02:25:30 PM
-
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"
-
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.
-
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?
-
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
-
In other word remove epel7 and mono repo.
-
The Mono repo *IS* required for ONLYOFFICE requires a specific mono version that is not available via EPEL.
-
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.
-
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
-
2 x wrong. But let's focus on the question and topic at hand.
-
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.
-
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.
-
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.
-
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....
-
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.