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!

Community Member Monday: Battsengel Ichinnorov

It’s time for another LibreOffice contributor interview! Today we speak to Battsengel Ichinnorov, a new TDF member, who helps to localise LibreOffice for Mongolian users…

Where do you live, and are you active on any social media?

I live in Munich, Germany, and I follow The Document Foundation and LibreOffice on Telegram. You can find some of my work on GitHub.

In which areas of the LibreOffice project are you active?

I am translating the wiki and LibreOffice itself into Mongolian (for instance, I made the keyboard layout for Mongolian for Windows: German and English. After this, I will create them for Linux.)

How did you get involved with LibreOffice?

A friend of mine, Dennis Roczeck is a helper and admin on the wiki.

What was your initial experience of contributing to LibreOffice like? What else do you plan to work on?

Everybody has a goal to reach, and mine is a free office for Mongolian people! Firstly I want to build a team and finish the user interface translation, then maybe get involved in development and/or ops and/or devops 🙂

What tools do you use for your work?

So I know many tools, but the best is for me for programming, to save time and be productive, is IntelliJ IDEA. Other tools which I use: Atom, Notepad++, ConEmu for WSL in Windows.

What do you do when you’re not working on LibreOffice?

Meet my friends and go hiking in the Alps, and study programming languages or test new technologies. At the moment I’m looking at Docker, Kubernetes and Terraform in the cloud.

Thanks to Battsengel for all his contributions! If you’re reading this and also want to join our friendly community, and help to make LibreOffice even better, we’ve made a page just for you. There are lots of ways to get involved – we look forward to meeting you!

Community Member Monday: Sam Tuke

Over the last few years we’ve posted many LibreOffice contributor interviews on this blog. Today, we catch up with Sam Tuke who is a member of the marketing community and helps out with QA too…

Where do you live, and are you active on IRC/social media?

I live in Berlin, Germany. Originally I’m from Suffolk, England. I like Twitter and Mastodon for community news. For my business, which makes Free Software newsletter app phpList, I use Facebook and Telegram too.

In which areas of the LibreOffice project are you active?

The marketing team, and filing occasional bugs.

How did you get involved with LibreOffice?

While in high school I started a small business building computers for local people. They needed an office suite to come with their new PCs, and OpenOffice.org was the perfect fit. I’ve been a user and advocate ever since, following my friends to LibreOffice when it was established.

Later on I became a full time Free Software developer, and after that a campaigner. From 2014 I worked on marketing LibreOffice-related products at Collabora. It was an exiting time and I had the opportunity to announce LibreOffice for Android and LibreOffice Online.

What was your initial experience of contributing to LibreOffice like?

Much like other open source apps: find and use a complicated bug tracker to report an annoying problem. But I was encouraged by quick follow up by a friendly bug triager, and since then several issues that I reported have been fixed and released. Satisfying!

What does LibreOffice need most right now?

Marketing. It’s a brilliant software suite which offers great potential value to most people alive today, particularly when you consider the mobile and web-based products. Reaching all those people who stand to benefit from LibreOffice is hard work, but it’s worth doing. Italo Vignoli and Mike Saunders have been making strides in this direction, and that’s fantastic to see.

Also: focus. With so many different kinds of users out there, LibreOffice can suffer from being too powerful for it’s own good. LibreOffice has had the benefit of contributions from a variety of usability experts and professionals. There’s plenty more to do, but recent releases, and particularly LibreOffice 6.1 include gratifying improvements from Kendy, Heiko, Andreas and others, which I’m eager to see.

What tools do you use for your work?

Markdown everywhere: Gedit, Writer, Nextcloud notes, and Pandoc to convert between them. Sometimes I also use Thorsten’s odpdown to make presentations.

Calc handles internal financial reporting at the firm, with many charts, and a few arcane formulas which LibreOffice fortunately includes. Draw is great for quick colourful diagrams like server infrastructure and organisational charts.

What do you do when you’re not working on LibreOffice?

Since finishing a Master’s degree in spring I’ve become a mentor of startups in West Africa, and had time so speak at more Free Software conferences at home and abroad. In order to keep up with new interns at work I’ve also been reading textbooks on marketing and security – perfect for long sunny evenings in the park.

Thanks Sam! Stay tuned to the blog for more interviews. In the meantime, if you’re new to the LibreOffice project and want to help us make it even better, start here!

LibreOffice interview: Andreas Kainz talks about new icons and the Notebookbar

Andreas Kainz

LibreOffice’s design community works on improving the user interface of the software. Today we talk to Andreas Kainz, who has created new icon themes and made improvements to the Notebookbar, an experimental and alternative user interface layout that will become an option in future releases…

Tell us a bit about yourself!

I live in Vienna, Austria. I have a KDE and LibreOffice-related blog, and a new one only for LibreOffice things, because I started by contributing to KDE, but in the last few years have been doing more and more with LibreOffice.

What have you been working on recently?

Here are some of the changes:

  • New default table styles for LibreOffice 6.0:

  • New area fill gradients for LibreOffice 6.1

And then, in terms of icons:

  • Colibre icon theme (for LibreOffice 6.1). Here’s what it looks like, with the Notebookbar activated:

All icon themes are available in PNG and SVG formats, under a GPL conforming licence, and I also maintain all three icon themes (Elementary, Colibre and Breeze – see below).

Regarding the Notebookbar, I have worked on the groupedbar full and compact, and the tabbedbar full and compact. I think that the Notebookbar is a great (optional) addition to the default toolbars and the sidebar.

(If you’re using LibreOffice 6.0 or 5.4, you can try the Notebookbar by following these steps. Please note that it’s still an experimental feature, though, and not ready for production use! But we’d like to hear your feedback.)

How much time do you spend contributing to LibreOffice?

I contribute in my spare time, between 23:00 – 01:00, when my daughter and wife are sleeping. Since 2014 I have submited 412 commits and 893,810 addition to LibreOffice core, which mean that I’m in second place in terms of additions (see the stats here – my username is DarkknightAK).

How did you get involved with LibreOffice?

I’m the maintainer of the Breeze icons for KDE, and in 2014 the LibreOffice community asked if the Breeze icons could be available for LibreOffice. Four months later, 2,500 breeze icons had been drawn and Breeze become default in LibreOffice 5 for KDE, Unity, macOS and LibreOffice Online. Here’s what Breeze looks like:

What was your initial experience of contributing to LibreOffice like?

LibreOffice is a friendly and structured project. With Gerrit and Jenkins it’s easy to have a good review process, when you’d like to submit a patch.

What does LibreOffice need most right now?

Contributors are always welcome. It would be awesome to have some goals where a team of developers AND designers work on them.

What tools do you use?

Inkscape and Kate.

Anything else you want to mention?

If you like my work, read my blog posts, join the LibreOffice design IRC channel (#libreoffice-design) or become a Patreon.

A big thanks to Andreas for his great work. As mentioned, LibreOffice users can try out the Notebookbar today, and give feedback to our design community, so that we can improve it further and make it available as a standard (optional) feature in the future!

Interview: MK Yadava talks about LibreOffice and FOSS adoption in India

Free and open source software (FOSS), such as LibreOffice, is being adopted by governments and companies around the world. But this doesn’t happen by magic – it takes hard work by local communities to spread the word, advocate the benefits of FOSS, and fight for political change. Today we talk to MK Yadava about his experiences from promoting GNU/Linux and LibreOffice, distributing it on 250,000 computers, and how LibreOffice can improve to become even more widespread…

Tell us a bit about yourself…

I belong to the Indian Forest Service, and am actually a “forester” by profession, which I love very much. Wildlife conservation, climate change, and working plans are my favourite subjects. I have been posted in various parts of Assam, a province in the north eastern India famous for Kaziranga, the abode of the Greater One Horned Rhinoceros, and Assam Tea. I have also been doing GIS (geographic information systems) and RS (remote sensing) since 1993. Even in those days, GIS/RS software was costly and tough to get; and that’s when I decided to code my own software. I realized at the very early point in my career that knowledge cannot be disseminated without “free” software.

In 2005 the Government of Assam decided to give free desktop computers to all students who passed the 10th standard examination in 1st Division (>=60%). The scheme was named after the late Anundoram Borooah, the great Sanskrit Scholar and an Indian Civil Service (ICS) Officer from Assam. To my knowledge, this was the first program providing free computers to students in such large numbers in India, and possibly by any government in the world.

The challenge was how to give 12,500 computers within the budget limits. When I decided to provide GNU/Linux as the operating system, I was told by my political masters that there would be so much ruckus if the students didn’t get popular proprietary software such as Microsoft Office. I convinced them that I would be giving the students the best operating system available. So I decided to banish proprietary software from my life altogether – for I could not be using such things while my dear students would use something else, and if GNU/Linux was the best OS, I should be using that myself too.

Eventually, I destroyed all my proprietary CDs and other software – numbering almost 100. And only then I announced that GNU/Linux would be loaded in the computers. When the students were given the computers, journalists tried to corner me, but I could convince them that if it was good enough OS for me, as the former Managing Director of AMTRON (Assam Electronics Development Corporation Ltd), it was indeed good for the students.

Kaziranga National Park (photo: Diganta Talukdar, CC-BY-SA)

What was your approach for promoting free software, like LibreOffice?

These were my additional arguments in favour of free software:

  1. Students must be able to examine all code loaded in the computers. Any proprietary code would hamper students’ learning.
  2. Students could be “proud owners” of the computers, as every software was licensed and genuine. That would also eliminate the tendency to load pirated software.
  3. GNU/Linux are great pieces of software – in fact these are masterpieces, and make up the essence of computers and computing. Computers without GNU/Linux is like life without oxygen.
  4. Students would cultivate a good habit of using and respecting free software, and would become, over time, proponents of a clean software ecosystem.
  5. It also enforces a possible policy that the education system in India must adopt, which is “all software must be free in the educational curriculum”, and “professional/paid software must only be taught in professional academies outside the educational system, which is to be seen as having an altruistic objective of universal education”
  6. The top 500 fastest computers mostly run on GNU/Linux, so why not expose the students to the best and most versatile OS which powers tiny embedded systems to super computers, rather than making them learn an operating system which is largely confined to desktops and laptops and is closed source?

That’s how I became a die-hard proponent of free software. The Anundoram Borooah Award program still runs GNU/Linux. So far we have distributed around 250,000 computers and laptops to students, all running free software. In my opinion, to develop a sense of freedom in a student is more important than just bundling software that just seems to be “powerful or the best or attractive”.

However, the decision makers in the country are largely unaware of the rich features in GNU/Linux, and so are the “computer teachers” in schools, whether in the public (private) schools or government schools, and to my mind we are doing injustice to the student community in the country and preventing creation of the knowledge society that India could become. India owns very little of IPR (intellectual property rights) or brands in IT software, and we are definitely not an IT super power in that sense. Free software is the way to go, if we seriously eye capturing this arena in future. Promoting free software would ignite young minds.

How popular is free software and LibreOffice in Assam State?

Well, in India, there are two main states where free software and LibreOffice is popular, and used by many: Assam and Kerala. In Assam, you can stumble upon it in the remotest of the government offices or homes of the brilliant students scattered across the state. Some of the largest deployments on GNU/Linux in the country have happened here. AMTRON has played a pivotal role in spreading free software in the region. It has been able to establish itself as an institution par excellence in matters of free software. All of the software that is developed/deployed by it in the government are based on free software and their enterprise versions. We have deployed almost 300 virtual machines in our datacentre that run GNU/Linux. We politely refuse to host any commercial OS-based servers here, because we don’t invest in such proprietary licenses at all.

Assam is one of the few states in the country – and elsewhere in the world – that has its own operating system called “SuperX”, which is now being branded as “AMTRON SuperX”, a distribution of GNU/Linux. So, we are excited a lot about rolling out a large number of deployments of free software. I am also thinking how to take forward the localization of LibreOffice in Assamese and Bodo languages. While we have developed and made available local scalable truetype fonts in Assamese, and made available for Assamese typing “online”, there is a lot left to be done. I am sure these steps would push the cause of LibreOffice to reach out to a larger target of farmers, artisans and women in the state. Of course, bringing all this to the smartphone would be great, but it needs a whole lot of project funding.

What are the challenges? How does LibreOffice need to improve to be more widely used?

There are several key challenges in the adoption of LibreOffice. To my mind, the primary challenge is the lack of clarity of the phrase “power user”. All blogs and reviews talk of power user, and say that if you are a power user, then you may not get full satisfaction from LibreOffice, and it has miles to go before can be adopted by a power user. Now, the question is who is a power user? I am a CEO, and I on my own churn out documents which are pretty complicated even for Microsoft Word to handle, documents which are auto styled and formatted and run into 300-500 pages on an average. I churn out spreadsheets which have almost 50-70,000 rows and 100s of columns. I use LibreOffice Draw extensively to design new mind-maps and ideas and use them in the presentation and documents. I use a lot of Math in my documents. The only challenge that I have actually found is handling a lot of large-sized photographs and images in the documents.

However, while there could be localization issues for LibreOffice in languages such as Assamese, Bodo and Bengali (and our own associated challenges of Unicode, of setting up a separate slot for Assemese), in making LibreOffice a complete local office suite, and very little has been done so far – by and large there are no great local issues. The issues of overall acceptance and the respect that it needs to gain as an office suite, and what percentage of the “power” people use and make others feel that LibreOffice is great is actually what matters. It’s just a perception issue.

Vishnudol temple in Joysagar, Assam (photo: Rofiuddin Ahme, CC-BY-SA)

In terms of the feature list, I would say that while there are great features in LibreOffice such as tables (where you can do almost everything – formulae and inter-table linking), charts and Draw, these need to be enriched further. I won’t go into detail about these and many other features where LibreOffice actually scores over popular commercial office suites, but still a lot more is desirable.

While many people complain about Impress, I actually never found it lacking in what I do. All my presentations are in Impress. However, it needs to improve regarding media handling, and needs to look at better interactivity in terms of the emerging technologies of Augmented Reality, IoT (internet of things) and AI, where there could be more interactive graphical presentations. For instance, let’s say my graph is linked to the IoT system at the back, and updates every second while the presentation is being made in real time to show how the parameter is actually impacting, say, climate.

One feature that I have been always requesting is how to make “digital signing” a document into a visual image in a document, which is clearly displayed when I signed the document and carries my “insignia” not only digitally, but also visually (such as a QR code or image). This also includes a request to add more such signatures on the document, which would make the document more real-world. While LibreOffice has features of multiple digital signing, it’s – to my best of knowledge – all digital, and does not leave a visual print on the document, nor does it offer a mechanism to the user for a visual means of additional digital signing.

My wish list of features also includes a better PDF conversion feature, having optimisations for file size, and a collaborative feature for editing of documents among a group of users.

Thanks to MK Yadava for his insights and experience. If you’re a FOSS supporter and want to help promote LibreOffice in your region, check out our native language communities – we look forward to meeting you!

LibreOffice contributor interview: Edmund Laugasson

Edmund Laugasson

LibreOffice is being used in governments and companies around the world, and this is largely thanks to support and advocacy from local communities and developers. Today we’re talking to Edmund Laugasson, a member of the Estonian LibreOffice community, who is promoting the software and the Open Document Format (ODF) in his country…

How popular is Free, Libre and Open Source Software (FLOSS) and LibreOffice in Estonia?

To be honest, it has not yet been deeply investigated, but the Estonian Ministry of Economic Affairs and Communications has published a “State Information System Interoperability Framework” (in Estonian) where clearly ODF is the main format suggested to use. The status of OOXML is only “allowed”. OOXML should not be confused with the file formats used by MS Office, which differs from OOXML by several proprietary changes. Even LibreOffice offers two different versions to save, e.g. docx – one is OOXML and the another one is used in MS Word. The same applies also to rest of OOXML, MS Office formats that coexist in LibreOffice. As the status of ODF is “suggested”, it is not mandatory. Despite that, ODF is quite widely used – for instance, educational institutions usually have LibreOffice installed, along with some local authorities.

Research is quite challenging as people usually do not respond to questionnaires, and researchers need to meet people directly in order to get reliable answers to questions.

What is your background and involvement in FLOSS?

I live in a small city called Rapla in Estonia, but I work as a lecturer at IT College, which is part of the Tallinn University of Technology. I am involved in FLOSS in many ways. When teaching, I use FLOSS as much as possible: the operating system in university is Ubuntu Linux, and I use derivates like Linux Mint MATE, all 64-bit and the latest LTS (Long Term Support) versions. The office suite is LibreOffice everywhere under GNU/Linux but under MS Windows next to MS Office. It is very important to have LibreOffice installed on every operating system that is used. Also, at least ODF file formats should be opened by LibreOffice by default. Then it would be much easier to deploy ODF in future when the ground is prepared properly. We have a dual-boot system (Microsoft Windows 10 and Ubuntu Linux 16.04.4), and in one classroom also a triple-boot (with macOS 10.12).

In addition I am involved as a board member of the Estonian Free and Open-Source Software Association, taking care of FLOSS in general in Estonia. Also I am involved in the Network of Estonian Teachers of Informatics and Computer Science (NETICS) as a board member. There I promote FLOSS – LibreOffice in particular – to encourage people to use it.
The next involvement is my doctoral studies at Tallinn University, where the current topic is “Technology approval as a factor of adopting a free software ecosystem”.

Further activities will come when I graduate and can focus more on wider deployments of FLOSS, particularly LibreOffice. I have serious plans to arrange all this, but as people in Estonia are not very cooperative, it takes more time – regardless of the fact that Estonia is small. Lots of people just do not believe in better future full of FLOSS, and those few who still believe, will act towards that goal. So to anyone who feels the FLOSS spark inside: do not hesitate to contact me.

What do you think are the biggest obstacles to wider FLOSS and LibreOffice adoption in Estonia?

My first paper in 2013 (published at the IFIP conference) showed that awareness of FLOSS is still relatively low, but interest in getting more information is quite high. Microsoft is doing relatively strong lobbying work, also in Estonia, and the government has quite weak power regarding FLOSS. There is also sometimes controversial behaviour: five state-arranged procurements in the FLOSS field (four state procurements relating to LibreOffice, one state procurement to create an interoperability framework), but weak activities around FLOSS in general. So I decided to start my doctoral studies to fix this situation in a scientific (weighted) way.

Thanks to Edmund for his time and effort helping the FLOSS cause. Click here to see many more interviews from LibreOffice contributors – and why not become one yourself! Build up skills, join a friendly community, and help to make LibreOffice better for everyone.