From owner-freebsd-questions@freebsd.org Mon Jan 22 22:12:59 2018 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id A5167ED8834 for ; Mon, 22 Jan 2018 22:12:59 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mout.kundenserver.de (mout.kundenserver.de [217.72.192.73]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "mout.kundenserver.de", Issuer "TeleSec ServerPass DE-2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 23D3271955 for ; Mon, 22 Jan 2018 22:12:58 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from r56.edvax.de ([92.195.18.98]) by mrelayeu.kundenserver.de (mreue104 [212.227.15.183]) with ESMTPA (Nemesis) id 0Lucpk-1emZvB1mbo-00zmol; Mon, 22 Jan 2018 23:07:33 +0100 Date: Mon, 22 Jan 2018 23:07:32 +0100 From: Polytropon To: Valeri Galtsev Cc: FreeBSD Mailing List Subject: Re: Document/collaboration server advise needed Message-Id: <20180122230732.71a007bb.freebsd@edvax.de> In-Reply-To: References: Reply-To: Polytropon Organization: EDVAX X-Mailer: Sylpheed 3.1.1 (GTK+ 2.24.5; i386-portbld-freebsd8.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:Bk2D0pkXtYDKZUMrEDLCxcRiwT4BpPXaOqywz9dkGJhgEhdDD7e yuzHPmZg5hDH6310tntjXFncILy55jSHHPpeF/wRd0KFTsxZqEqu9qRxir5/av76/fprTR4 vPkTB8Ka/CEvLySXeQyLumlk+ZSdEihK6lqvRfGio5rnFqWSSrqjPKs/FXRqNPfsScX9FNP GJuGHJALzQM1gVHhnzTVg== X-UI-Out-Filterresults: notjunk:1;V01:K0:aS5RUcvpj2Y=:O7T8R7SuEQvqx8DhD+q6+t ivKimFUqEOKSflcp0fPbTkpyuZIJ3f+niypu0Mqg5UmPMFFweLYlZq1E2vtmTNJV3I4WgrnIL Sz3zwTf/KklaZeVcMJFiH2pTu2C1heFU6qFapc+L+fIr5qgyaUqxxiWAZJBRvMr4Nq4mh2GJG eOfqvMVkFsWqAG3zmwfpwpegXZXfiycWG0LS1e9xH8KzZ+7NXtdfzEXMTlqIEyw1AIAMOGVdr Y/7+Kzacmkev4eIqklWvftCIbWww7IodmhJkcLPXzmy0EDWFdn6GCJEYVeObC3OUS9PV1uEyN NEYgBcY/F1V6kCJQYx1sfnnATe4eTjD4y1tmRpNirHTdXoeMXc1m5YLvYtXDwNgYxxNMNQppg /12//DCjCfRfveQrXGcckT/Nju/XFZMBYzz5RjiyneDpd6lyzKg0JQ20vKXkB+tvpFoirIGbQ UGNA2XP3nCklonH8zjHtnSixr6NbWH3q+2GV/LBAt8hcQRN35bQAtp0Af2/fdb+Rvleur0jge vuA7t7JpMBeS+Kw/gXDuvXklUBCa+o9NOXJTmRkek3rNyYtEnXnWgtFu52RFT6YIwANhKZq+h GP9fKm6DeVin8KogaNJ2ZiA9bz1LfEiaZ78Zee0K0w9T8gLonfIjuQSCdgy/wHkV2DIXijjea O7mmkRTm8s3OUQNBGcC4ZcCZTDAUIjBmOYsk+24hZ8r1vpUP8RJ3jUafvAQYEC7qlwdwQvP1L jk0BwOb5X6koxwtlJ07ZijHC5bp0CyndTNNN1HOWLgIEZz8ndhRIYizXDbw= X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.25 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Jan 2018 22:12:59 -0000 On Mon, 22 Jan 2018 14:52:17 -0600, Valeri Galtsev wrote: > Three groups of scientists need to write documents collaboratively. They > are going to use MS PowerPoint, Word, also store PDF files. They want to > be able to add external people from other groups they collaborate with > and give them access to some areas or "projects". In other words, they > want some collaborative work environment, mostly to work on documents. That's a really sad story... > In the past scientists were using TeX, and one of version control > systems (CVS, subversion,...). And all was great, as TeX files (pretty > much like programs software developers write) are ASCII text files, and > diff of two version is rather small... I've been supporting such environments in the past, and users were generally happy with it, especially because they could use the operating systems they wanted (most Linux, some a BSD, a few ones Solaris). With every generation of computers (servers and "endpoints"), the system ran better and faster, something today's users probably cannot even imagine. > Unlike the past scientists I work for plan to use MS PowerPoint, Word, > also store PDF files. All these are effectively binary files for version > control systems, then versions will not be stored as a small diff, but > each version ends up being the whole document. That is correct. Binary diffs are possible, but probably not very efficient. Additionally, MICROS~1 "document" files sometimes keep their own history, which you can observe by altering the file (add "a", save, remove "a", save, "add "b", save, remove "b", save, and always check the file size). Access to this "versioning information" is often not trivial. One single "quick save" can render a file unusable or even unaccessible, and it needs to be opened and re-exported using OpenOffice or LibreOffice. Of course you probably won't convince them to use (Open/Libre)Office because those aren't made by MICROS~1 and don't come with a support contract. Sure, those formats are fully documented (!) compressed archives containing XML and blobs, so in worst case, document recovery is possible with standard means, but who cares... we don't need a backup, we have RAID. :-) > One obvious solution may be: just buy office365.com service, or set up > MS server on our own machine. And these are the two things I am trying > to avoid. This is possible, and nobody got fired for buying ^W licensing MICROS~1 products. Vendor lock-in is such a good thing, it's the fundamental power of the free market and blah blah blah... > Could someone recommend open source software? Some collaborative suite > focused mostly on working on documents, with web based interface. Maybe this list can provide some inspiration? https://en.wikipedia.org/wiki/List_of_collaborative_software In worst case, create a big pile of mud: Databases with binary blobs, lots of servers (but make them virtual, because that's cool and also DevOps), make the CxOs believe that they need to license lots of stuff, and then watch them suffer. In case of complaints, like, "This is soooo slow!" or "Why can't I do {placeholder}?" and especially "It doesn't work on my latest-gen smartphone!", just refer them to the support of the software they approved. If there is no such support, well... NB: Those who decide about the software to use won't be the ones who have to use that software. And whatever you suggest, it will be "insufficient", "lacking essential features" and "not conform to specification", which of course will be noticed after the contracts have been signed and the money has been transfered. So always be sure to document everything in a written form (for your safety) - I'm sure you know why, but I thought it would be useful for future readers who find this comment in the mailing list archive. Sorry to be not more helful than a syringe of acid... ;-) Sidenote: I'm more than lucky _not_ to have to work in such environments anymore. I hope you will find a solution, though, as nobody deserves this kind of bullshit-driven punishment. But I know it _can_ be possible to provide users with what users _need_ (not neccessarily what their managers _want_). With training (and don't tell me it's possible to survive in collaboration environments without training and tested procedures!), everything can be fine. Again, sorry I couldn't provide more help. -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ...