Arch Linux User Repository

oh nooo I had a poco-git pkg before, ver 1.7. Now I don't have the pacman cache and no old version of poco 1.9.0-2 :( Its too bad, I can't find the version in google.

Please help me! ...compile compile

Please, include poco<=1.9.0 as a dependency, it breaks with furthure versions!

@Ybalrid: Just install the hunspell packages for the languages you need.

This package breaks with poco>=1.9.2 (I had to downgrade it to 1.9.0-2) because it looks for libPocoNet.so.60 (moved to libPocoNet.so.62 after poco upgrade).

Hey, this package looks great! After messing around with my SSL proxy under Apache, I got it working inside a manually deployed Nextcloud instance!

Any information on how to install spellcheck dictionaries on top of it? The only thing I'm missing here is to be able to spellcheck english and french. (I don't care about the UI language, english is fine).

kousu, toco: It took some time because I’ve been busy, and my configuration is… weird :-D for security reasons.

Anyway, to the point: with latest updates, I could verify that all works well! Better than ever actually, perfect! And (maybe as a consequence of the issue I reported) memory requirements are back to normal, and I can enjoy the full improved experience of LOOL with only 2GB :-)

Cheers

its working fine with Nextlcoud 16.0.1.1 =) cheers

Do you tried already with the new Nextcloud 16.0.0-1 pkg? This would be realy intresting...

@kousu I can edit xlsx sheets

everything works fine, so never touch a running system, but updates... =)

Hello kousu,

I think, that indeed you may have hit some regression in the software !

Unfortunately, I am not able to test any more on my server, because a couple of releases ago, CollaboraOnline started to have memory needs bigger than I could afford. I still have it enabled to create the documents’ thumbnails, and at least that works…

Since there are some users of the package, I continue to keep it up-to-date, but I am not able to verify the full integration with Nextcloud any more :-( However, last commit, I re-did a full perusing of all Ubuntu “control” files, and all Docker files on GitHub, and I can assure you, this package delivers the equivalent of what the upstream Ubuntu packages do. Still, I will try again on my server and see if I can open a document… I’ll let you know.

It cleared up when I edited loolwsd.xml to add my server's FQDN hostname in <wopi>, which got erased during the upgrade, and did systemctl stop loolwsd; sleep 30; systemctl start loolwsd -- systemctl restart loolwsd appears to not actually reload the config properly, or maybe not regenerate the javascript properly, or something. But now I can view documents but not edit them; attempting an edit crashes something and resets my websocket connection!!

Mar 22 16:12:55 server.example.com loolwsd[4229]: kit-04348-04350 2019-03-22 20:12:55.852714 [ lo_startmain ] SIG   Fatal signal received: SIGABRT
Mar 22 16:12:55 server.example.com loolwsd[4229]: Backtrace 4348:
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/bin/loolforkit(_ZN7SigUtil13dumpBacktraceEv+0x5f) [0x4b3d1f]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/bin/loolforkit() [0x4b4e60]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/lib/libpthread.so.0(+0x123c0) [0x7f4cf37963c0]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/lib/libc.so.6(gsignal+0x10f) [0x7f4cf35f7d7f]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/lib/libc.so.6(abort+0x125) [0x7f4cf35e2672]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(_ZN16SalUserEventList18DispatchUserEventsEb+0x39c) [0x7f4cf186b33c]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(_ZN14SvpSalInstance7DoYieldEbb+0x39) [0x7f4cf1917239]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(_ZN11Application5YieldEv+0x2e) [0x7f4cf187c51e]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(_ZN11Application7ExecuteEv+0x45) [0x7f4cf187de15]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(+0x1f0f70c) [0x7f4cf084c70c]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(+0x2f467c6) [0x7f4cf18837c6]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(_Z6SVMainv+0x22) [0x7f4cf18838b2]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(soffice_main+0x8a) [0x7f4cf086c0ea]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libmergedlo.so(+0x1f3edd1) [0x7f4cf087bdd1]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /opt/collaboraoffice6.0/program/libuno_sal.so.3(+0x40ea7) [0x7f4ceb247ea7]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/lib/libpthread.so.0(+0x7a9d) [0x7f4cf378ba9d]
Mar 22 16:12:55 server.example.com loolwsd[4229]: /usr/lib/libc.so.6(clone+0x43) [0x7f4cf36bbb23]
Mar 22 16:12:55 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:55.868923 [ docbroker_003 ] DBG  Closing DocumentBroker for docKey [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5] with reason: docisdisconnected| wsd/DocumentBroker.cpp:439
Mar 22 16:12:55 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:55.869309 [ docbroker_003 ] DBG  Removing socket #23 (of 2) from docbroker_003| ./net/Socket.hpp:577
Mar 22 16:12:55 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:55.869442 [ docbroker_003 ] INF  Finished polling doc [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5]. stop: true, continuePolling: true, ShutdownRequestFlag: false, TerminationFlag: false, closeReason: docisdisconnected. Flushing socket.| wsd/DocumentBroker.cpp:356
Mar 22 16:12:55 server.example.com loolwsd[4229]: frk-04232-04232 2019-03-22 20:12:55.914597 [ forkit ] INF  Child 4348 has exited, will remove its jail [/opt/lool/child-roots/k29DD91ot6bcj5iy].| kit/ForKit.cpp:221
Mar 22 16:12:55 server.example.com loolwsd[4229]: frk-04232-04232 2019-03-22 20:12:55.915117 [ forkit ] INF  Removing jail [/opt/lool/child-roots/k29DD91ot6bcj5iy].| kit/ForKit.cpp:239
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.870672 [ docbroker_003 ] INF  Finished flushing socket for doc [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5]. stop: true, continuePolling: true, ShutdownRequestFlag: false, TerminationFlag: false. Terminating child with reason: [docisdisconnected].| wsd/DocumentBroker.cpp:380
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.872042 [ docbroker_003 ] INF  Terminating doc [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5] with reason: docisdisconnected| wsd/DocumentBroker.cpp:1834
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.872317 [ docbroker_003 ] INF  Terminating 1 clients of doc [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5] with reason: docisdisconnected| wsd/DocumentBroker.cpp:1792
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.872837 [ docbroker_003 ] INF  Removing session [0042] on docKey [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5]. Have 1 sessions. markToDestroy: true, LastEditableSession: true| wsd/DocumentBroker.cpp:1170
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873157 [ docbroker_003 ] INF  Terminating child [4348] of doc [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5].| wsd/DocumentBroker.cpp:1841
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873317 [ docbroker_003 ] DBG  Closing ChildProcess [4348].| wsd/DocumentBroker.hpp:105
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873437 [ docbroker_003 ] DBG  Closing DocumentBroker for docKey [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5] with reason: docisdisconnected| wsd/DocumentBroker.cpp:439
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873568 [ docbroker_003 ] DBG  Stopping docbroker_003.| ./net/Socket.hpp:402
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873723 [ docbroker_003 ] DBG  Removing all sockets from docbroker_003.| ./net/Socket.hpp:421
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.873960 [ docbroker_003 ] DBG  Removing socket #15 from docbroker_003| ./net/Socket.hpp:429
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874168 [ docbroker_003 ] DBG  #15 Thread affinity set to 0 (was 0x7f75337fe700).| ./net/Socket.hpp:279
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874361 [ docbroker_003 ] DBG  StreamSocket dtor #15| ./net/Socket.hpp:796
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874512 [ docbroker_003 ] INF  ToClient-0042 Disconnected, current number of connections: 1| wsd/ClientSession.cpp:1158
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874643 [ docbroker_003 ] DBG  ToClient-0042 on docKey [/apps/richdocuments/wopi/files/9305_ocyg0juhjpc5] terminated. Cleaning up.| wsd/ClientSession.cpp:1168
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874766 [ docbroker_003 ] ERR  Invalid or unknown session [0042] to remove.| wsd/DocumentBroker.cpp:1159
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.874784 [ docbroker_003 ] ERR  No socket associated with WebSocketHandler 0x7f7524008490| ./net/WebSocketHandler.hpp:108
Mar 22 16:12:56 server.example.com loolwsd[4229]: wsd-04229-04358 2019-03-22 20:12:56.875557 [ docbroker_003 ] INF  ~ClientSession dtor [ToClient-0042], current number of connections: 0| wsd/ClientSession.cpp:64

My understanding is that this installs binaries from Debian onto Arch? Would that explain a crash like that?

I also think the nginx config on the wiki (https://wiki.archlinux.org/index.php/Nextcloud#Collabora_Online_Office_integration) needs updating. There's rare requests to /hosting/capabilities, as well as /hosting/discovery!