Bug 3830 - New version of Libreoffice (was: libreoffice spellchecking isn't working without hunspell)
Summary: New version of Libreoffice (was: libreoffice spellchecking isn't working with...
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 1
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL: https://bugs.mageia.org/show_bug.cgi?...
Whiteboard:
Keywords: validated_update
: 3957 (view as bug list)
Depends on: 2317
Blocks: 3672
  Show dependency treegraph
 
Reported: 2011-12-20 16:51 CET by claire robinson
Modified: 2012-01-04 21:56 CET (History)
6 users (show)

See Also:
Source RPM: libreoffice
CVE:
Status comment:


Attachments

Description claire robinson 2011-12-20 16:51:06 CET
Please see bug 2942 where this was discovered in testing.

This bug has been created to allow a security update to proceed. It is not a regression.

Whilst testing libreoffice x86_64 it was noticed that spellchecking or spelling auto correction was not working.

After investigation it seems to require hunspell and it's relevant language pack. (In my case hunspell-en but will be different for other languages.)

libreoffice gives no error that the package is missing and appears to complete spell checks but doesn't actually do anything without hunspell and language pack installed.
Comment 1 claire robinson 2011-12-20 16:53:47 CET
Changing arch as this bug applies to both architectures really, although it was discovered on an x86_64 system initially.

Assigning dmorgan

Hardware: x86_64 => All
Assignee: bugsquad => dmorganec

Comment 2 D Morgan 2011-12-20 17:00:51 CET
i will look for cauldron first as this seems valid on both versions

Status: NEW => ASSIGNED

Comment 3 claire robinson 2011-12-20 17:04:37 CET
Thankyou :)

Status: ASSIGNED => NEW

D Morgan 2011-12-20 17:31:51 CET

Status: NEW => ASSIGNED

Comment 4 D Morgan 2011-12-20 18:06:39 CET
Seems OK in cauldron btw : 

urpmi libreoffice-langpack-en
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release (distrib1)")
  hunspell-en                    0.20110318.1 1.mga2        noarch  
  libreoffice-langpack-en        3.4.3.2      2.mga2        i586    
  mythes-en                      3.0          9.mga1        noarch
Comment 5 D Morgan 2011-12-22 08:01:59 CET
please test new packages in updates_testing
Comment 6 claire robinson 2011-12-22 15:58:07 CET
I'll test tomorrow, thanks dmorgan.
Comment 7 claire robinson 2011-12-23 12:39:37 CET
I think the problem has been I've not had libreoffice-langpack-* installed on this one.

To be honest I didn't know it existed or was necessary.

When I manually install one..

The following 3 packages are going to be installed:

- hunspell-en-0.20110112.1-4.mga1.noarch
- libreoffice-langpack-en-3.4.4.2-0.1.mga1.x86_64
- mythes-en-3.0-9.mga1.noarch


Shouldn't a langpack be automatically installed to match the locale settings or the user be prompted to choose one? 

On my i586 laptop it is already installed, I've no idea how, but it was upgraded from Mdv and is the most used so maybe that would account for it.

Testing x86_64 all seems Ok once the langpack was manually installed.
Comment 8 D Morgan 2011-12-27 03:01:02 CET
please test : libreoffice-3.4.4.2-0.3.mga1
Comment 9 claire robinson 2011-12-28 19:32:09 CET
This will be affected by bug 2317, with having requires from Release media, so adding a "Depends on" until linking is done when this is pushed. It will require all libreoffice-langpack-*, hunspell-*, mythes-*, postgresql-jdbc and hsqldb as apparent from urpmi but will have to check it with our script too.

# urpmi libreoffice
In order to satisfy the 'libreoffice-langpack' dependency, one of the following packages is needed:
 1- libreoffice-langpack-fi-3.4.4.2-0.3.mga1.x86_64: Finnish language pack for LibreOffice (to install)
 2- libreoffice-langpack-en-3.4.4.2-0.3.mga1.x86_64: English language pack for LibreOffice (to install)
 3- libreoffice-langpack-nso-3.4.4.2-0.3.mga1.x86_64: Northern Sotho language pack for LibreOffice (to install)
What is your choice? (1-3) 2
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release")
  hunspell-en                    0.20110112.1 4.mga1        noarch  
(medium "Core Updates Testing")
  libreoffice                    3.4.4.2      0.3.mga1      x86_64  
  libreoffice-base               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-calc               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-core               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-draw               3.4.4.2      0.3.mga1      x86_64
  libreoffice-graphicfilter      3.4.4.2      0.3.mga1      x86_64
  libreoffice-impress            3.4.4.2      0.3.mga1      x86_64
  libreoffice-java-common        3.4.4.2      0.3.mga1      x86_64
  libreoffice-langpack-en        3.4.4.2      0.3.mga1      x86_64
  libreoffice-math               3.4.4.2      0.3.mga1      x86_64
  libreoffice-opensymbol-fonts   3.4.4.2      0.3.mga1      noarch
  libreoffice-pdfimport          3.4.4.2      0.3.mga1      x86_64
  libreoffice-presentation-mini> 3.4.4.2      0.3.mga1      x86_64
  libreoffice-presenter-screen   3.4.4.2      0.3.mga1      x86_64
  libreoffice-ure                3.4.4.2      0.3.mga1      x86_64
  libreoffice-wiki-publisher     3.4.4.2      0.3.mga1      x86_64
  libreoffice-writer             3.4.4.2      0.3.mga1      x86_64
(medium "Core 32bit Release")
  mythes-en                      3.0          9.mga1        noarch
  postgresql-jdbc                8.3.603      2.0.2.mga1    noarch
(medium "Core 32bit Updates")
  hsqldb                         1.8.1.3      4.1.mga1      noarch
29MB of additional disk space will be used.
92MB of packages will be retrieved.
Proceed with the installation of the 21 packages? (Y/n) y

It adds postgresql-jdbc and hsqldb too, is that intentional?

All seems to be Ok once installed.

Depends on: (none) => 2317

Comment 10 claire robinson 2011-12-28 19:38:39 CET
It's maybe because I wasn't able to use MageiaUpdate and installed with urpmi that it pulled in the two sql packages,thinking about it.
Comment 11 claire robinson 2011-12-28 19:48:51 CET
Going to remove libreoffice and install from Updates then test again from Testing as I think much of the linking above may not be required.
Comment 12 claire robinson 2011-12-28 20:31:08 CET
Removed completely and removed orphans.

Installed again from Updates with:

# urpmi libreoffice
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release")
  hunspell-en                    0.20110112.1 4.mga1        noarch  (suggested)
  hyphen                         2.7          2.mga1        x86_64  
  hyphen-en                      2.7          2.mga1        noarch  (suggested)
  lib64wpd0.9_9                  0.9.0        1.mga1        x86_64  
  lib64wpg-0.2_2                 0.2.0        5.mga1        x86_64  
  lib64wps0.2_2                  0.2.0        5.mga1        x86_64  
  libtextcat                     2.2          11.mga1       x86_64  
  lpsolve                        5.5.2.0      2.mga1        x86_64  
  mythes                         1.2.1        3.mga1        x86_64  
  silgraphite                    2.3.1        3.mga1        x86_64  
(medium "Core Updates")
  hsqldb                         1.8.1.3      4.1.mga1      noarch  
  hunspell                       1.2.15       1.1.mga1      x86_64  
  libreoffice                    3.3.4.1      1.3.mga1      x86_64  
  libreoffice-base               3.3.4.1      1.3.mga1      x86_64  
  libreoffice-calc               3.3.4.1      1.3.mga1      x86_64  
  libreoffice-core               3.3.4.1      1.3.mga1      x86_64  
  libreoffice-draw               3.3.4.1      1.3.mga1      x86_64  
  libreoffice-graphicfilter      3.3.4.1      1.3.mga1      x86_64  
  libreoffice-impress            3.3.4.1      1.3.mga1      x86_64  
  libreoffice-java-common        3.3.4.1      1.3.mga1      x86_64  (suggested)
  libreoffice-math               3.3.4.1      1.3.mga1      x86_64  
  libreoffice-pdfimport          3.3.4.1      1.3.mga1      x86_64  
  libreoffice-presenter-screen   3.3.4.1      1.3.mga1      x86_64  
  libreoffice-ure                3.3.4.1      1.3.mga1      x86_64  
  libreoffice-writer             3.3.4.1      1.3.mga1      x86_64  
(medium "Core 32bit Release")
  fontpackages-filesystem        1.44         4.mga1        noarch  
  postgresql-jdbc                8.3.603      2.0.2.mga1    noarch  
(medium "Core 32bit Updates")
  libreoffice-opensymbol-fonts   3.3.4.1      1.3.mga1      noarch  
319MB of additional disk space will be used.
91MB of packages will be retrieved.
Proceed with the installation of the 28 packages? (Y/n) y

Spellcheck and autocorrect work Ok.

Removed hunspell-en as thats how the system was before, also hyphen-en as an experiment as it was only suggested before.


Enabled Testing media

MageiaUpdate says:

Sorry, the following packages cannot be selected:

- libreoffice-3.4.4.2-0.3.mga1.x86_64
- libreoffice-base-3.4.4.2-0.3.mga1.x86_64
- libreoffice-calc-3.4.4.2-0.3.mga1.x86_64
- libreoffice-core-3.4.4.2-0.3.mga1.x86_64
- libreoffice-draw-3.4.4.2-0.3.mga1.x86_64
- libreoffice-graphicfilter-3.4.4.2-0.3.mga1.x86_64
- libreoffice-impress-3.4.4.2-0.3.mga1.x86_64
- libreoffice-java-common-3.4.4.2-0.3.mga1.x86_64
- libreoffice-math-3.4.4.2-0.3.mga1.x86_64
- libreoffice-pdfimport-3.4.4.2-0.3.mga1.x86_64
- libreoffice-presenter-screen-3.4.4.2-0.3.mga1.x86_64
- libreoffice-writer-3.4.4.2-0.3.mga1.x86_64


Ticking libreoffice, it says:

Sorry, the following package cannot be selected:

- libreoffice-3.4.4.2-0.3.mga1.x86_64 (due to conflicts with libreoffice-langpack-fi-3.4.4.2-0.3.mga1.x86_64)


Installing from Testing media with urpmi:


# urpmi libreoffice
In order to satisfy the 'libreoffice-langpack' dependency, one of the following packages is needed:
 1- libreoffice-langpack-fi-3.4.4.2-0.3.mga1.x86_64: Finnish language pack for LibreOffice (to install)
 2- libreoffice-langpack-en-3.4.4.2-0.3.mga1.x86_64: English language pack for LibreOffice (to install)
 3- libreoffice-langpack-nso-3.4.4.2-0.3.mga1.x86_64: Northern Sotho language pack for LibreOffice (to install)
What is your choice? (1-3) 2
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release")
  hunspell-en                    0.20110112.1 4.mga1        noarch  
(medium "Core Updates Testing")
  lib64graphite2_2               1.0.3        0.1.mga1      x86_64  
  libreoffice                    3.4.4.2      0.3.mga1      x86_64  
  libreoffice-base               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-calc               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-core               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-draw               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-graphicfilter      3.4.4.2      0.3.mga1      x86_64  
  libreoffice-impress            3.4.4.2      0.3.mga1      x86_64  
  libreoffice-java-common        3.4.4.2      0.3.mga1      x86_64  
  libreoffice-langpack-en        3.4.4.2      0.3.mga1      x86_64  
  libreoffice-math               3.4.4.2      0.3.mga1      x86_64  
  libreoffice-opensymbol-fonts   3.4.4.2      0.3.mga1      noarch  
  libreoffice-pdfimport          3.4.4.2      0.3.mga1      x86_64  
  libreoffice-presenter-screen   3.4.4.2      0.3.mga1      x86_64  
  libreoffice-ure                3.4.4.2      0.3.mga1      x86_64  
  libreoffice-writer             3.4.4.2      0.3.mga1      x86_64  
(medium "Core 32bit Release")
  hyphen-en                      2.7          2.mga1        noarch  
  mythes-en                      3.0          9.mga1        noarch  
11MB of additional disk space will be used.
90MB of packages will be retrieved.
Proceed with the installation of the 19 packages? (Y/n) y


Spellchecking and autocorrect both Ok and everything appears to work as expected.

Required linking as far as I can see with urpmi will be mythes-* hunspell-* hyphen-* and I would imagine autocorr-* language packs. Basically the requires of libreoffice-langpack which is now a require of libreoffice.

autocorr-en wasn't orphaned when removing libreoffice and so wasn't removed with auto-orphans.
Comment 13 claire robinson 2011-12-28 20:35:53 CET
Is lib64graphite2_2 part of this update?
Comment 14 D Morgan 2011-12-28 20:53:58 CET
yes graphite2 is part of this update ( this is a new package )
Comment 15 claire robinson 2011-12-29 13:10:27 CET
Thankyou for fixing this :)

Is this ready for QA or do you want to wait for other fixes?
Comment 16 David Walser 2011-12-31 00:18:45 CET
*** Bug 3957 has been marked as a duplicate of this bug. ***

CC: (none) => luigiwalser

Comment 17 David Walser 2011-12-31 00:19:28 CET
As a bonus, when this update gets pushed it will fix a security issue (see Bug 3957).
Comment 18 David Walser 2011-12-31 02:29:29 CET
It appears to be working fine.  I think this can be pushed to QA.
Comment 19 David Walser 2011-12-31 04:52:25 CET
Let's send this to QA.

CC: (none) => dmorganec
Assignee: dmorganec => qa-bugs

Comment 20 claire robinson 2011-12-31 13:12:40 CET
I was waiting to hear from dmorgan, it is better to allow maintainers to say whether their package is ready for QA David. We have had instances, recently with firefox, where it has caused confusion and mistakes when the decision is made without them.

If this is really ready for QA'ing then I was testing it x86_64 and the problem did seem to be fixed.
Comment 21 D Morgan 2011-12-31 13:41:37 CET
soory i forgot :)


this is ready for QA: 



src.rpm:    libreoffice
            graphite2
Comment 22 Dave Hodgins 2012-01-01 01:47:42 CET
Testing complete on i586 for the srpms
libreoffice-3.4.4.2-0.3.mga1.src.rpm
graphite2-1.0.3-0.1.mga1.src.rpm

Testing includes showing this fixes bug 3672.

CC: (none) => davidwhodgins

Comment 23 Manuel Hiebel 2012-01-02 02:07:15 CET
In the about I see:

"Copyright © 2000, 2010 LibreOffice contributors and/or their affiliates. All rights reserved.
This product was created by Mageia, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
Mageia acknowledges all community members, please find more info at the link below:"

Is the "Mageia" string a blocker or not ?

If not, its ok for me. (x86_64)


and as this bug is affecting by bug 2317, what should the admins link in updates ?
postgresql-jdbc  ? (hsqldb is in updates)

Blocks: (none) => 3672

Comment 24 Manuel Hiebel 2012-01-02 02:52:37 CET
Not a blocker for dmorgan

So testing complete

Suggested Advisory:
-------------
This update fixes the following problems in LibreOffice :

* LibreOffice spellcheking not working (#3830).

* LibreOffice crashes when open and text file (#3672).

https://bugs.mageia.org/show_bug.cgi?id=3830
-------------

SRPMs: 	libreoffice-3.4.4.2-0.3.mga1.src.rpm
        graphite2-1.0.3-0.1.mga1.src.rpm

not sure: add a link for postgresql-jdbc (an hsqldb ?)

Could sysadmin please push from core/updates_testing to core/updates

Thankyou!

Keywords: (none) => validated_update
CC: (none) => sysadmin-bugs
Summary: libreoffice spellchecking isn't working without hunspell => New version of Libreoffice (was: libreoffice spellchecking isn't working without hunspell)

Comment 25 David Walser 2012-01-02 03:01:30 CET
Advisory should also mention CVE-2011-2713 fixed (Bug 3957)
Comment 26 claire robinson 2012-01-02 13:33:53 CET
As far as I can tell it will need the dependencies of the libreoffice-langpack-* packages linking which is a new require but provided in the update, not the postgresql-jdbc or hsqldb.

Those are hunspell-*, mythes-*, hyphen-* and autocorr-* language packs
Comment 27 D Morgan 2012-01-02 13:39:44 CET
(In reply to comment #26)
> As far as I can tell it will need the dependencies of the
> libreoffice-langpack-* packages linking which is a new require but provided in
> the update, not the postgresql-jdbc or hsqldb.
> 
> Those are hunspell-*, mythes-*, hyphen-* and autocorr-* language packs

yes the copy of this will be needed if i understand correctly how it works.
Comment 28 Dave Hodgins 2012-01-03 00:05:26 CET
I just ran a test starting with a clean install.  Installed libreoffice
with urpmi libreoffice.

I then enabled core updates testing as a update media.  Using urpmi --auto-selct,
it does not pick select any hunspell or hyphen packages.

The only package it's picking from Core Release is the mythes-* package
corresponding to the language pack I selected.

For this update, as it is linking all of the mythes rpm packages from
core release to core update should satisfy bug 2317.

Why weren't the hunspell or hyphen packages selected?
Comment 29 claire robinson 2012-01-03 11:46:01 CET
Do you already have them installed Dave?

If you check the requires of the libreoffice-langpack- you chose you should find hunspell- hyphen- and autocorr- are also requires.
Comment 30 David GEIGER 2012-01-03 16:59:19 CET
Tested complete on Mageia release 1 (Official) for x86_64 ,for me nothing to report ,everything seems to be OK.

CC: (none) => geiger.david68210

Comment 31 Dave Hodgins 2012-01-03 18:18:23 CET
(In reply to comment #29)
> Do you already have them installed Dave?
> 
> If you check the requires of the libreoffice-langpack- you chose you should
> find hunspell- hyphen- and autocorr- are also requires.

Ah. Yes, sorry.  Looks like they were pulled in during the initial install
from Core Updates.

Looks like the mythes* packages are the only ones that will have to be
linked for bug 2317.
Comment 32 claire robinson 2012-01-03 18:38:42 CET
Its actually all of them as it is the libreoffice-langpack- itself which is the new require. 

As it is being provided in updates but all of it's requires are in release then all of it's requires need to be linked.

No libreoffice-langpack-* was installed by default previously but on one system I do have one installed, the other I don't so we have to assume the worst and link everything.

hunspell-*, mythes-*, hyphen-* and autocorr-* language packs
Comment 33 Dave Hodgins 2012-01-03 20:31:04 CET
urpmq --media "Core Release" --whatrequires hunspell|grep libre
libreoffice-core
# urpmq --media "Core Release" --whatrequires hyphen|grep libre
libreoffice-core
# rpm -q -i autocorr-en|grep Source
Group       : Text tools                    Source RPM: libreoffice-3.3.4.1-1.3.mga1.src.rpm

Installing libreoffice from core release will install hunspell and hyphen.
The autocorr packages are part of libreoffice, so they'll be in updates.

The mythes packages are the only newly required dependencies.
Comment 34 claire robinson 2012-01-03 22:13:51 CET
Despite that though Dave, the reason this bug exists is because it wasn't and, as a result, spellchecking wasn't working.

If you read through the comments up to this point it will become evident.
Comment 35 claire robinson 2012-01-03 22:39:27 CET
Thinking about it Dave, it was not hunspell itself which was the problem, it was the specific language packs for hunspell etc. (hunspell-en mythes-en hyphen-en and autocorr-en for me) hence the hunspell-* requires and linking along with the others.
Comment 36 David GEIGER 2012-01-04 15:05:18 CET
(In reply to comment #24)
> Not a blocker for dmorgan
> 
> So testing complete
> 
> Suggested Advisory:
> -------------
> This update fixes the following problems in LibreOffice :
> 
> * LibreOffice spellcheking not working (#3830).
> 
> * LibreOffice crashes when open and text file (#3672).
> 
> https://bugs.mageia.org/show_bug.cgi?id=3830
> -------------
> 
> SRPMs:     libreoffice-3.4.4.2-0.3.mga1.src.rpm
>         graphite2-1.0.3-0.1.mga1.src.rpm
> 
> not sure: add a link for postgresql-jdbc (an hsqldb ?)
> 
> Could sysadmin please push from core/updates_testing to core/updates
> 
> Thankyou!
 
This update is now validate.
Comment 37 Thomas Backlund 2012-01-04 15:22:24 CET
Eh.
So what is supposed to be linked ?

CC: (none) => tmb

Comment 38 claire robinson 2012-01-04 15:27:09 CET
hunspell-*, mythes-*, hyphen-* and autocorr-* language packs
Comment 39 Thomas Backlund 2012-01-04 21:56:23 CET
hunspell-*, mythes-* and hyphen-* linked

autocorr-* comes with libreoffice.

Update pushed.

Status: ASSIGNED => RESOLVED
Resolution: (none) => FIXED


Note You need to log in before you can comment on or make changes to this bug.