Bug 551003

Summary: Unnecessary localisation files for myspell and openoffice-thesaurus as recommended packages
Product: [openSUSE] openSUSE 11.2 Reporter: Atri Bhattacharya <badshah400>
Component: OpenOffice.orgAssignee: Petr Mladek <pmladek>
Status: RESOLVED FIXED QA Contact: Chao Wei <cwei>
Severity: Major    
Priority: P2 - High CC: coolo, elchevive68, fisiu, martin.schlander, sbrabec, tlillqvist
Version: RC 2Flags: coolo: SHIP_STOPPER-
Target Milestone: ---   
Hardware: x86-64   
OS: openSUSE 11.2   
Whiteboard: maint:released:sle11-sp1:48242
Found By: --- Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---
Attachments: Output from first run of zypper inr

Description Atri Bhattacharya 2009-10-29 14:20:39 UTC
Created attachment 324693 [details]
Output from first run of zypper inr

User-Agent:       Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.4) Gecko/20091016 SUSE/3.5.4-1.1.2 Firefox/3.5.4

Using RC2 here. Fresh installation using GNOME/KDE Live-CD x86-64 with Language and Keyboard both set to English(US).
First run of yast software manager module pre-selects about 400-500 MiB for installation. A significant chunk of this is localisation files for openoffice-thesaurus and myspell. For example zypper inr attempts to install the following
"...myspell-french 
  myspell-german myspell-italian myspell-polish myspell-russian myspell-spanish 
  nspluginwrapper nss_ldap-32bit nss-mdns-32bit OpenOffice_org-base 
  OpenOffice_org-base-extensions OpenOffice_org-calc-extensions 
  OpenOffice_org-converter OpenOffice_org-draw-extensions 
  OpenOffice_org-filters-optional OpenOffice_org-help-de OpenOffice_org-help-es 
  OpenOffice_org-help-fr OpenOffice_org-help-it OpenOffice_org-help-pl 
  OpenOffice_org-help-ru OpenOffice_org-hyphen 
  OpenOffice_org-impress-extensions OpenOffice_org-mailmerge 
  OpenOffice_org-math OpenOffice_org-pyuno OpenOffice_org-templates-en 
  OpenOffice_org-templates-presentation-layouts OpenOffice_org-thesaurus-de 
  OpenOffice_org-thesaurus-en OpenOffice_org-thesaurus-es 
  OpenOffice_org-thesaurus-fr OpenOffice_org-thesaurus-pl 
  OpenOffice_org-writer-extensions..."

These various languages form the significant chunk of the 488 MiB it tries to download while I am sure the en files are the only ones I am goin to need. This is stopper in my opinion.

Reproducible: Always

Steps to Reproduce:
1.Run zypper inr, or start yast software management module
2.Note packages pre-selected for installation in yast, or the files that zypper inr want sot install.
3.
Actual Results:  
There is an attempt to force openoffice-thesurus and myspell in various languages on the user despite his/her chosen locale.

Expected Results:  
No need to download bogus localisation files.
Comment 1 Stephan Kulow 2009-10-30 07:27:37 UTC
they are not bogus. The locales of Ooo are installed and they recommend the help packages. Nothing bad about it - just that's the live cd has all these languages installed is suprising to people not using them.
Comment 2 Stephan Kulow 2009-10-30 08:10:37 UTC
the way the myspell, thesaurus and help packages recommend and supplement each other, breaks the assumption that you only get what you need for your language.

If they would all just hook into the language, it would be fine. But this is not a ship stopper as you can easily either remove the locale packages or block the others.
Comment 3 Stephan Kulow 2009-10-30 08:57:25 UTC
*** Bug 550875 has been marked as a duplicate of this bug. ***
Comment 4 Atri Bhattacharya 2009-10-30 11:30:29 UTC
(In reply to comment #1)
> they are not bogus. The locales of Ooo are installed and they recommend the

The different locales being already installed is not useful for any one person who will in all probability use only one of these.

> help packages. Nothing bad about it - just that's the live cd has all these
> languages installed is suprising to people not using them.

What is bad is this: I have to pay through my nose for downloading languages I have no use for and about 200-250 MiB's of those. Then I will have to locate these packages in the package manager assuming I have remembered them and remove them. I felt really good that there were a number of languages this time in the live-cd's. I just did not think, that I was going to be affected because of them this badly. Also the DVD's from 11.1 and earlier had various languages, did they not? I never had openoffice_help-de install automatically, never!

I don't understand what a ship_stopper means (even the wiki does not explain it), but installing ~400-500 MiB of packages (including the 32bit packages in unrelated bug 547751) that an user doesn't require, from the internet and paying for it seems like an experience he/she will avoid. i put in a ship_stopper because that is what it is for me. Sorry if that was a mistake.
Comment 5 Luiz Fernando Ranghetti 2009-10-30 12:15:49 UTC
Hi,

Coolo, would be interesting to have some script in the end of installationg to remove the not used languages, to avoid this behaviour (probably for 11.3)

Regards
Comment 6 Martin Schlander 2009-10-30 13:43:50 UTC
Installing the languages first, and then removing them again still sounds hackish and messy to me.

Maybe we should have multiple live cd ISOs instead like Mandriva does (did? - 2-3 languages on each.

Or figure out a way to more easily download and install languages during or immediately after installation.

At least I too think the current situation won't make anyone happy.
Comment 7 Atri Bhattacharya 2009-10-30 17:26:18 UTC
OK, I also had yast-qt-pkg forced on my system even though I want to use pure GNOME. That didn't happen before. Seems to me the list of recommended packages on openSUSE 11.2 is totally broken. Is there nothing bad about that either??
Comment 8 Atri Bhattacharya 2009-10-30 17:48:50 UTC
These are the packages installed on first yast run on a gnome live-cd install

ksmolt
libakonadi
libkdepimlibs
python-kde4
libproxy0-config-kde4
libkde4
libkdecore4
yast2-qt
yast2-qt-pkg
yast2-qt-graph

I understand these are unnecessary because I can remove them without breaking any dependencies. These packages should also be removed from the recommended packages list on a GNOME install.
Comment 9 Atri Bhattacharya 2009-10-30 17:50:57 UTC
Please let me know if should open a new bug for all the generic recommended packages mess in 11.2.
Comment 10 Tor Lillqvist 2009-10-30 19:10:10 UTC
Resetting assignee to default.
Comment 11 Tor Lillqvist 2009-10-30 19:12:06 UTC
So is the problem here in OpenOffice.org, or somewhere else? Somebody please change the component if necessary. Assigning to pmladek in the meantime.
Comment 12 Atri Bhattacharya 2009-10-31 16:57:49 UTC
(In reply to comment #11)
> So is the problem here in OpenOffice.org, or somewhere else? Somebody please
> change the component if necessary. Assigning to pmladek in the meantime.

Yes the big problem is with various openoffice related localisation files (like help, thesaurus, etc) being installed though I have selected US locale for during installation. This inflates the first time download size after fresh installation.
Even if just this is fixed I think it will help a great deal.
Comment 13 Petr Mladek 2009-11-09 17:02:50 UTC
OpenOffice_org-help, OpenOffice_org-thesaurus, myspell packages include:

    Provides:       locale(OpenOffice_org:<lang>)

IMHO, this is the preferred way. It is described at http://en.opensuse.org/Software_Management/Dependencies/Language

I do not know about any better dependency definition => I do not know how to improve this on the package side => I think that the only solution is a postinstall hack, for example the one from the comment #5.

Coolo, what do you think?
Comment 14 Stephan Kulow 2009-11-10 09:23:32 UTC
The provides is perfect, but help-cs does more

Provides:       locale(OpenOffice_org:cs)
Provides:       OpenOffice_org-cs:%_prefix/ooo-2.0/help/cs/default.css
PreReq:         OpenOffice_org-ure = %version
Supplements:    OpenOffice_org-l10n-cs


The supplements pulls it in even for other languages if l10n-cs is installed.
Comment 15 Atri Bhattacharya 2009-11-16 16:41:16 UTC
Upon installation of openSUSE 11.2 from the dvd these 'unnecessary' localisation packages, both for openoffice and myspell are neither installed nor in the recommended group of packages. During installation from the dvd I selected the gnome desktop, and I have not installed the kde patterns. The problem only seems to affect the Live-CD's. Just to let you know if it helps.
Comment 16 Luiz Fernando Ranghetti 2010-01-06 13:59:19 UTC
Hi,

Making some tests:

New installation from 11.2 KDE LiveCD, choosing pt_BR as language (not included in LiveCD)

1st: run of zypper inr with all the localization files included in LiveCD:

http://pastebin.com/f6f1c6979 -> 257 MiB additional

2nd: removing the localizations not used:

http://pastebin.com/f62da0f0 -> 178 MiB free

3rd: run of zypper inr again:

http://pastebin.com/f190c5889 -> 182 additional which is fine

Regards
Comment 17 Mariusz Fik 2010-03-26 15:42:57 UTC
On 11.3 M4 same story. Installation from LiveCD (i586), chosen PL lang. First run of 'zypper inr' or YaST2 Software Management wants to download over 200MB.

If run 'zypper inr' it is ok, I want to do that, but many users are very surprised (in bad mean) when they start YaST2 Software Management for the first time. And they see so many packages are selected to install but they don't know anything about it. Some of this packages are really useless for many users with locale other than en,de,it,ru.
Comment 18 Atri Bhattacharya 2010-04-30 08:28:29 UTC
Same problem with 11.3 M6. Lots of unnecessary localisation files. Seems nothing at all has changed regarding this from the sorry mess in 11.2 :(
Comment 19 Martin Schlander 2010-04-30 08:48:39 UTC
The livecd now only contains the top4 langs, which is much better than  the 10 or so langs that were there before.
Comment 20 Bernhard Wiedemann 2012-04-04 15:00:10 UTC
This is an autogenerated message for OBS integration:
This bug (551003) was mentioned in
https://build.opensuse.org/request/show/112478 Factory / libreoffice-l10n
Comment 21 Petr Mladek 2012-04-05 07:46:06 UTC
I have finally removed the recommend and supplements from the package. I hope that it will work better now.

I close this bug as fixed now. Feel free to reopen it if you still see troubles with further live CDs/DVDs.


PS: I am sorry that it took so long to do this change. There is a lot of work with the libreoffice packages. I newer found time to do it during openSUSE and LibreOffice beta phase. I was not brave enough to o it in an rc phase of any of these two projects.
Comment 22 Swamp Workflow Management 2012-07-29 23:02:15 UTC
Update released for: libreoffice, libreoffice-base, libreoffice-base-drivers-postgresql, libreoffice-base-extensions, libreoffice-branding-upstream, libreoffice-calc, libreoffice-calc-extensions, libreoffice-debuginfo, libreoffice-debugsource, libreoffice-draw, libreoffice-draw-extensions, libreoffice-filters-optional, libreoffice-gnome, libreoffice-help-cs, libreoffice-help-da, libreoffice-help-de, libreoffice-help-en-GB, libreoffice-help-en-US, libreoffice-help-en-ZA, libreoffice-help-es, libreoffice-help-et, libreoffice-help-fr, libreoffice-help-gl, libreoffice-help-group1, libreoffice-help-group2, libreoffice-help-group3, libreoffice-help-group4, libreoffice-help-group5, libreoffice-help-gu-IN, libreoffice-help-hi-IN, libreoffice-help-hu, libreoffice-help-it, libreoffice-help-ja, libreoffice-help-km, libreoffice-help-ko, libreoffice-help-nl, libreoffice-help-pl, libreoffice-help-pt, libreoffice-help-pt-BR, libreoffice-help-ru, libreoffice-help-sl, libreoffice-help-sv, libreoffice-help-zh-CN, libreoffice-help-zh-TW, libreoffice-icon-themes, libreoffice-icon-themes-prebuilt, libreoffice-impress, libreoffice-impress-extensions, libreoffice-kde, libreoffice-kde4, libreoffice-l10n, libreoffice-l10n-af, libreoffice-l10n-ar, libreoffice-l10n-be-BY, libreoffice-l10n-bg, libreoffice-l10n-br, libreoffice-l10n-ca, libreoffice-l10n-cs, libreoffice-l10n-cy, libreoffice-l10n-da, libreoffice-l10n-de, libreoffice-l10n-el, libreoffice-l10n-en-GB, libreoffice-l10n-en-ZA, libreoffice-l10n-es, libreoffice-l10n-et, libreoffice-l10n-fi, libreoffice-l10n-fr, libreoffice-l10n-ga, libreoffice-l10n-gl, libreoffice-l10n-gu-IN, libreoffice-l10n-he, libreoffice-l10n-hi-IN, libreoffice-l10n-hr, libreoffice-l10n-hu, libreoffice-l10n-it, libreoffice-l10n-ja, libreoffice-l10n-ka, libreoffice-l10n-km, libreoffice-l10n-ko, libreoffice-l10n-lt, libreoffice-l10n-mk, libreoffice-l10n-nb, libreoffice-l10n-nl, libreoffice-l10n-nn, libreoffice-l10n-nr, libreoffice-l10n-pa-IN, libreoffice-l10n-pl, libreoffice-l10n-prebuilt, libreoffice-l10n-pt, libreoffice-l10n-pt-BR, libreoffice-l10n-ru, libreoffice-l10n-rw, libreoffice-l10n-sh, libreoffice-l10n-sk, libreoffice-l10n-sl, libreoffice-l10n-sr, libreoffice-l10n-ss, libreoffice-l10n-st, libreoffice-l10n-sv, libreoffice-l10n-tg, libreoffice-l10n-th, libreoffice-l10n-tr, libreoffice-l10n-ts, libreoffice-l10n-uk, libreoffice-l10n-ve, libreoffice-l10n-vi, libreoffice-l10n-xh, libreoffice-l10n-zh-CN, libreoffice-l10n-zh-TW, libreoffice-l10n-zu, libreoffice-languagetool, libreoffice-languagetool-ca, libreoffice-languagetool-de, libreoffice-languagetool-en, libreoffice-languagetool-es, libreoffice-languagetool-fr, libreoffice-languagetool-gl, libreoffice-languagetool-it, libreoffice-languagetool-km, libreoffice-languagetool-nl, libreoffice-languagetool-pl, libreoffice-languagetool-ro, libreoffice-languagetool-ru, libreoffice-languagetool-sk, libreoffice-languagetool-sv, libreoffice-mailmerge, libreoffice-math, libreoffice-mono, libreoffice-officebean, libreoffice-openclipart, libreoffice-pyuno, libreoffice-sdk, libreoffice-sdk-doc, libreoffice-testtool, libreoffice-writer, libreoffice-writer-extensions
Products:
SLE-DESKTOP 11-SP1 (i386, x86_64)
SLE-DESKTOP 11-SP1-FOR-SP2 (i386, x86_64)
SLE-SDK 11-SP1 (i386, x86_64)
SLE-SDK 11-SP1-FOR-SP2 (i386, x86_64)
Comment 23 Swamp Workflow Management 2012-07-30 15:10:57 UTC
openSUSE-RU-2012:0925-1: An update that has 63 recommended fixes can now be installed.

Category: recommended (low)
Bug References: 325936,335643,343673,413560,421559,465252,471280,529233,529404,551003,651964,652364,693238,703032,706138,714787,717947,719989,719997,745873,745930,747461,747471,749960,750255,750258,750838,751028,751077,751573,753458,757118,757419,757609,757651,757840,757844,757885,757905,757910,758575,758883,758914,759178,759212,759982,760029,760294,760764,760997,760999,762542,763168,764005,765942,765998,766477,766481,766487,767452,769162,769593,769793
CVE References: 
Sources used:
openSUSE 12.1 (src):    libreoffice-3.5.4.7-4.8.1, libreoffice-branding-upstream-3.5.4.7-4.8.1, libreoffice-help-en-US-3.5.4.7-4.8.1, libreoffice-help-group1-3.5.4.7-4.8.1, libreoffice-help-group2-3.5.4.7-4.8.1, libreoffice-help-group3-3.5.4.7-4.8.1, libreoffice-help-group4-3.5.4.7-4.8.1, libreoffice-help-group5-3.5.4.7-4.8.1, libreoffice-icon-themes-3.5.4.7-4.8.1, libreoffice-l10n-3.5.4.7-4.8.1, libreoffice-languagetool-1.4-3.4.1, libreoffice-openclipart-3.5-2.4.3