LibreOffice Conference 2018: Opening session and sponsor videos

We’ve started to edit and upload videos from the LibreOffice Conference 2018 which was held in Tirana in September. Here’s the first batch – more presentations to come. (Tip: use headphones for the best audio.)

First, the opening session, including a special welcome from the mayor of Tirana:

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

Then a presentation from Collabora, one of the conference’s sponsors:

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

And CIB, another sponsor:

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

Interview: Guilhem Moulin on LibreOffice infrastructure and services

A large free and open source software project like LibreOffice requires a lot of infrastructure, to support our users, developers and worldwide community. Today we speak to Guilhem Moulin, who is in charge of TDF’s infrastructure and services, about new developments and how others can get involved…

To start, please give us a quick overview of TDF’s public infrastructure.

The public infrastructure is powered by about 50 Kernel-based Virtual Machines (KVM) spread across 4 hypervisors plugged to an internal 10Gbps switch and hosted at Manitu in St. Wendel (Germany), and managed with libvirt and its KVM/QEMU driver. The virtual disk images are typically stored in GlusterFS volumes — distributed across the hypervisors — except for some transient disks (such as cache) where the IOPS need is higher and the redundancy less important.

All our public VMs run Debian GNU/Linux (currently a mix of Jessie — which are to be upgraded — and Stretch), each typically hosting a single service for better isolation. The rest of the stack is fairly usual: systemd as PID 1 & service manager, a mix of MySQL and PostgreSQL as RDMS, and nginx as SSL/TLS endpoint & reverse HTTP proxy. All of this is orchestrated and managed using saltstack.

About half of our Virtual Machines host public-facing websites; the other half are used for test instances, various production backends and internal services, as well as for tinderboxes and other hacking VMs. Some of these websites are mostly useful for developers, such our Bugzilla or gerrit instances — an overview of the development-focused sites can be found at https://devcentral.libreoffice.org. The remaining sites include the main LibreOffice website, the download page, the Wiki, Askbot, and of course the blog.

Beside these VMs, we also operate a handful of other machines for backups, monitoring, and mail systems, which are hosted offsite for obvious reasons.

What have been the most significant infra developments in the last six months?

Single Sign On (SSO) is probably what’s been the most visible to the community. Traditionally each frontend (Wiki, Bugzilla, Askbot, etc.) has its own private authentication backend, so once someone sign in to multiple services, they would have to remember multiple sets of credentials, which is cumbersome and makes password & email rotation difficult.

We now have a central authentication system (which uses an LDAP DIT as backend), but aren’t pointing individual services to it, as it would 1/ expose the shared credentials to all services hence increase the attack surface; and 2/ doesn’t solve the fact that users would have to enter their password to each service individually. Instead we’re deploying a solution using the SAML 2.0 protocol: unauthenticated users are redirected to an authentication portal against which they can authenticate, and they are redirected to the protected page afterwards.

Not all services have been migrated to SSO yet. An issue is that we have to unify accounts (people use different usernames in different services); and while we want a “critical mass” of active user accounts in LDAP before migrating a service, it’s been rather difficult to reach out to people — even among TDF officials! — and convince them to create an account in the new system. Fortunately since we migrated the authentication system of our wiki, more and more people (among whom a lot of dormant accounts, probably spammers unfortunately) started using the new system.

While it’s only visible to infra team members, we also replaced our Graphite (+ Carbon + Icinga2) based monitoring system with Prometheus (+ data exporters + alert manager). Furthermore, still on the monitoring front but public this time, we just deployed a new service, CachetHQ, to show a quick overview of TDF’s infra status:
https://status.documentfoundation.org.

Last but not least, earlier this spring we were fairly busy with GDPR compliance.

What are you working on at the moment, and what are your plans for the next six months?

Aside from daily maintenance and occasional emergencies (system crashes, hardware hiccups, performances issues, etc.), infra team members still spends quite a lot of time on the above, as this is not completely finished yet. Projects for next year include working on a better backup solution, in particular regarding database snapshots. The data collection system for download metrics needs some improvement, too.

Finally, what cool things can new volunteer admins do to get involved and help the project?

We have a wide variety of systems, ranging for highly sensitive (election, internal mail, LDAP DIT, whitebox monitoring) to pretty much fully public beside the access logs (bitergia dashboard, blackbox monitoring). We can’t give upfront access to the sensitive side of the spectrum to everyone, but there are things to help with on the other side too (developer-focused services are typically less sensitive, since development is open anyway).

Sometimes we also start fresh and replace a service with something equivalent on a brand new box; in that case there is no sensitive data at stake, and it’s a great way for new volunteer admins to gain trust. I mentioned the monitoring migration earlier; we could also imagine replacing our ageing MirrorBrain deployment with a more modern solution like Mirrorbits, for instance.

Thanks to Guilhem for his time and help. If you’re interested in joining our infra community and gaining valuable experience in a large FOSS project, see here to get started!

LibreOffice monthly recap: September 2018

Here’s our regular recap of events and updates in the last month!

  • From 25 to 28 September, our Albanian community organised the LibreOffice Conference 2018 in Tirana. They did an excellent job, so we’d like to give a special thanks to all the organisers for their help! The conference brought together developers, users and supporters from across the world – see the conference website for full details and the programme. Talks and presentations were filmed, so we’ll work on editing and uploading them in the next couple of weeks – keep an eye on the blog!

  • Throughout the event, we posted regular updates on the blog, including photos from day 1, day 2 and day 3. We’ll post a recap video soon, but in the meantime check out the group photo shot of over 100 of the attendees who were present on day 3:

  • During the conference, we also announced LibreOffice 6.1.2, the second minor release of the LibreOffice 6.1 family, targeted at early adopters, technology enthusiasts and power users. A big thanks to all our community members and certified developers who contributed to this release.
  • Meanwhile, LibreOffice release engineer Christian Lohmaier gave a talk at droidcon Vienna about LibreOffice Viewer for Android. We’re always looking for more help to improve the app and make the experimental editing mode a standard feature, so if you’re familiar with coding Android apps and want to give us a hand, get started here.

  • On September 18, we celebrated the International Day Against DRM. Digital “Rights” Management (which could also be called “Restrictions” Management) is a set of technologies to limit and control users. The Document Foundation supports the International Day Against DRM as part of its daily fight to make content sharing available to all individuals, and to educate them to adopt open standards to foster innovation.
  • Our documentation community released the Getting Started Guide 6.0, an introductory text covering all of the main components in LibreOffice. If you want to learn more about the suite and discover some features you may not have come across, check it out! It’s available in digital and printed formats.

  • Finally, as part of our regular “Community Member Monday” posts, we talked to Battsengel Ichinnorov, a new TDF member, who helps to localise LibreOffice for Mongolian users.

Keep in touch – follow us on Twitter, Facebook and Google+. Like what we do? Support our community with a donation – or join us and help us to make LibreOffice even better!

LibOCon 2019

LibOCon 2019 will be in Almería, a sunny, lovely city on the south-east coast of Spain. On the shores of the Mediterranean sea, the city was founded in 955 by Abd-ar-Rahman III, who ordered the construction of the famous Alcazaba (the Citadel), one of the largest moorish castles in Europe. The modern city has grown over the hills that surround the Alcazaba, staying true to its visual and architectural tradition.

Almería is also the administrative capital of the homonymous province and part of the Autonomous Community of Andalusia. The region is famous for its prolific production of vegetables, having over 100,000 acres of greenhouses in the Poniente province. The city has about 195,000 inhabitants who are welcoming to visitors and always happy to enjoy the city’s excellent weather with a vibrant day and night life.

LibOCon 2019 dates will be communicated as soon as possible.

LibreOffice Conference 2018: Day 3 in pictures

We started the day with presentations – such as LibreOffice’s user experience advantages:

Meanwhile, the Engineering Steering Committee met in person:

Relaxing with pasta for lunch!

And then time for the group photo…

Having fun at the hackfest in the evening:

Now we’re into the final day! Stay tuned…

Announcement of LibreOffice 6.1.2 at LibreOffice Conference

Tirana (Albania), September 27, 2018 – The Document Foundation announces LibreOffice 6.1.2, the second minor release of the LibreOffice 6.1 family, targeted at early adopters, technology enthusiasts and power users. The new release was launched during the LibreOffice Conference 2018, in Tirana, the capital city of Albania. LibreOffice 6.1.2 provides around 70 bug and regression fixes over the previous version.

LibreOffice 6.1.2 bug and regression fixes are described in the change log page: https://wiki.documentfoundation.org/Releases/6.1.2/RC1 (changed in RC1).

Enterprise deployments

LibreOffice 6.1.2 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users.

For any enterprise class deployment, TDF maintains the more mature LibreOffice 6.0.6, which should be sourced from a company providing a Long Term Supported version of the suite (they are all members of TDF Advisory Board, and are listed here: https://www.documentfoundation.org/governance/advisory-board/).

Also, value-added services for migrations and trainings, to support enterprise class deployments in large organizations, should be sourced from certified professionals (list available here: https://www.libreoffice.org/get-help/professional-support/).

LibreOffice is deployed by large organizations in every continent. A list of some large or significant migrations announced in the media is available on the TDF wiki: https://wiki.documentfoundation.org/LibreOffice_Migrations.

Availability of LibreOffice 6.1.2

LibreOffice 6.1.2 is immediately available from the following link: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.9. Builds of the latest LibreOffice Online source code are available as Docker images: https://hub.docker.com/r/libreoffice/online/.

LibreOffice Online is fundamentally a server service, and should be installed and configured by adding cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud services offered by ISPs or the private cloud of enterprises and large organizations.

LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at https://www.libreoffice.org/donate.

LibreOffice 6.1.2 is built with document conversion libraries from the Document Liberation Project: https://www.documentliberation.org.