Ubuntu

SRU LibreOffice 3.5.4 for precise (was: Can't open/save document or spreadsheet with password, when mozilla profile has an absolute path)

Reported by Marcelo Terres on 2012-01-21
180
This bug affects 34 people
Affects Status Importance Assigned to Milestone
LibreOffice Productivity Suite
Fix Released
Medium
libreoffice (Debian)
Fix Released
Unknown
libreoffice (Ubuntu)
High
Björn Michaelsen
Precise
High
Björn Michaelsen

Bug Description

 1) lsb_release rd
 Description: Ubuntu 11.10
 Release: 11.10

 2) apt-cache policy libreoffice-calc
 libreoffice-calc:
   Instalado: 1:3.4.5-0ubuntu1
   Candidato: 1:3.4.5-0ubuntu1
   Tabela de versão:
  *** 1:3.4.50ubuntu1 0
         500 http://br.archive.ubuntu.com/ubuntu/ oneiric-proposed/main amd64 Packages
         100 /var/lib/dpkg/status
      1:3.4.40ubuntu1 0
         500 http://br.archive.ubuntu.com/ubuntu/ oneiric-updates/main amd64 Packages
      1:3.4.33ubuntu2 0
         500 http://br.archive.ubuntu.com/ubuntu/ oneiric/main amd64 Packages

3) What is expected to happen in LibreOffice Writer via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919659/+attachment/2700639/+files/test.odt && lowriter nologo test.odt

type in the password:
password

and the file opens successfully, as it does in 3.4.4.

4) What happens instead is that the file does not open and a message pops up:
LibreOffice 3.4
The password is incorrect. The file cannot be opened.

This problem is unreproducible in:
lsb_release rd
Description: Ubuntu precise (development branch)
Release: 12.04

apt cache policy libreoffice-writer
libreoffice-writer:
  Installed: 1:3.5.0~beta2-2ubuntu4
  Candidate: 1:3.5.0~beta2-2ubuntu4
  Version table:
 *** 1:3.5.0~beta2-2ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ precise/main amd64 Packages

== Regression details ==
Discovered in version: 3.4.5-0ubuntu1
Last known good version: 3.4.4-0ubuntu1

Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in libreoffice (Ubuntu):
status: New → Confirmed
10 comments hidden view all 106 comments

After upgrade Libreoffice today

Can't open documents (Calc) created with previous versions of Libreoffice with passwords.
Can't create new documents (Calc, Writer) with password.

When save a new document, enter the password, confirm tha password, then Libreoffice pause for two seconds, and then Message error (Can't save file, general error)

Have Ubuntu 11.10 and Libreoffice 3.4.5, both is Spanish.

9 comments hidden view all 106 comments

Yes. This bug showed up for me when I was unable to open previously saved password protected spreadsheets. Very panic inducing! That'll teach me to have 'proposed' active on a production machine...

tags: added: regression-proposed
tags: added: amd64 oneiric
description: updated
Maximiliano (meilan) wrote :

Have the same problem when upgrade to Libreoffice 3.4.5.
Not only with Calc, have the same problem with Writer too.
Ubuntu 11.10 and Libreoffice 3.4.5 Spanish version

9 comments hidden view all 106 comments

1) Create new Writer or Calc document with Libreoffice 3.4.5
2) Save file, check "Save with password", click "save".
3) Enter a password, confirm it.
4) Close file.
5) Open the file just created.
6) Enter the password to open the file.
7) Libreoffice fails to open the file.

Popup error message. Spreadsheet cannot be opened. Error Message "The password is incorrect. The
file cannot be opened."

*** Bug 45318 has been marked as a duplicate of this bug. ***

*** Bug 45309 has been marked as a duplicate of this bug. ***

*** Bug 45250 has been marked as a duplicate of this bug. ***

Not reproducible with vanilla 3.4.5 version. It is a bug Ubuntu only.
Please follows this bug here : https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919659

Closing as NotOurBug.

Best regards. JBF

12 comments hidden view all 106 comments
Tim Johnson (tim-pteq) wrote :

I also have the problem in both Calc & Writer. I cannot open documents saved with passwords under previous versions of LibreOffice, nor save new documents with passwords.
All passwords are confirmed correct & the old documents can be opened normally in OpenOffice 3.2.

Marcelo Terres, could you please post an example file, with password, that does not open in 3.4.5, but does in 3.4.4?

Changed in libreoffice (Ubuntu):
status: Confirmed → Incomplete
Marcelo Terres (mhterres) wrote :

It is possible to open an existing password protected file (from 3.4.4) in 3.4.5. It works without problems.

The problem is that after I save it in 3.4.5 I can't open it anymore.

Jonathan A. Marshall (j8) wrote :

Attached is a test document that I saved with password="password" using the oneiric-updates (1:3.4.4-0ubuntu1) version of LibreOffice. Opening this document should fail under oneiric-proposed (1:3.4.5-0ubuntu1). See bug #919877 (https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919877) for details.

Jonathan A. Marshall (j8) wrote :

The problem I encountered in #919877 is different from what Marcelo Terres described above in comment #6.

I found that a password-protected .odf document that I previously had saved under 3.4.4 could not be opened under 3.4.5. Downgrading to 3.4.4 allowed me to open the file again.

Also, I found that 3.4.5 LibreOffice Writer in oneiric-proposed failed to save a new document with password. It gave an error message instead.

Should the duplicate status between #919877 and #919659 be removed?

Marcelo Terres wrote:
 > It is possible to open an existing password protected file (from 3.4.4) in 3.4.5. It works without problems.
 > The problem is that after I save it in 3.4.5 I can't open it anymore.

summary: - Can't save spreadsheet with password
+ Can't open spreadsheet with password
description: updated

Marking Triaged High as this Writer password protected files regression:
"Renders essential features or functionality of the application or dependencies broken or ineffective".

Changed in libreoffice (Ubuntu):
importance: Undecided → High
status: Incomplete → Triaged
Maximiliano (meilan) wrote :

It's a UBUNTU bug only, not a LibreOffice bug.
Not reproducible with vanilla 3.4.5 version.
See https://bugs.freedesktop.org/show_bug.cgi?id=45171

tags: added: metabug testcase
Jonathan A. Marshall (j8) wrote :

Hello,

The title of this bug was just changed
from - "Can't save spreadsheet with password"
to + "Can't open spreadsheet with password"

... but I believe that's not correct.
  1. The problem is that BOTH opening AND saving fail with password.
  2. As described in duplicate bug #919877, the failures occur for BOTH LibreOffice Writer AND Calc.

For completeness, I recommend that the title be changed to:
  "Can't open or save document or spreadsheet with password"

OK?

Thanks,
--Jonathan

6 comments hidden view all 106 comments

Thanks very much!

On Sun, Jan 29, 2012 at 11:41 AM, <email address hidden> wrote:

> https://bugs.freedesktop.org/show_bug.cgi?id=45171
>
> Jean-Baptiste Faure <email address hidden> changed:
>
> What |Removed |Added
>
> ----------------------------------------------------------------------------
> Status|UNCONFIRMED |RESOLVED
> Resolution| |NOTOURBUG
> CC| |<email address hidden>
> See Also| |
> https://launchpad.net/bugs/
> | |919659
>
> --- Comment #5 from Jean-Baptiste Faure <email address hidden> 2012-01-29
> 01:41:57 PST ---
> Not reproducible with vanilla 3.4.5 version. It is a bug Ubuntu only.
> Please follows this bug here :
> https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919659
>
> Closing as NotOurBug.
>
> Best regards. JBF
>
> --
> Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are on the CC list for the bug.
>

Maximiliano (meilan) on 2012-02-02
summary: - Can't open spreadsheet with password
+ Can't open/save spreadsheet with password
Changed in df-libreoffice:
importance: Unknown → High
status: Unknown → Won't Fix
summary: - Can't open/save spreadsheet with password
+ [Downstream] Can't open/save spreadsheet with password

- I can not open calc files previously (before 3.4.5 update) saved with a password.
- I can not save a new document with a password. (I tried with Writer)

John Kuang (xiphosurus) wrote :

I also encountered the same problem of being unable to open a previously password protected spreadsheet or save a new password protected spreadsheet. But the problem went away after fully removing libreoffice, purging deb files, reinstalling libreoffice. I suspect that the problem appeared after I cloned my oneiric installation from a HDD to a SSD.

il Davo (il-davo) wrote :

Guys, what does it means the status "Won't fix"? Means that purging libreoffice and reinstall the binary is the (only) solution?

Won't fix is from upstream. Their version, from which the Ubuntu version is derived, doesn't show the bug, so the upstream maintainers won't be fixing it themselves.

So far although rated high in importance the bug isn't assigned to anyone involved in Ubuntu to fix.

How you fix on your system I can't advise as I don't know whether you are running oneiric with the proposed repository active or pangolin...

However, for me I just open my encrypted documents on a machine running a pre-bug version for now.

Changed in libreoffice (Ubuntu):
assignee: nobody → Björn Michaelsen (bjoern-michaelsen)

ehm, I don't think that we should fall back into the old OOo habit as
"this doesn't work in our build using internal libs, thus it's NOTOURBUG"

There's system-libs, you know, and we DO NOT PATCH the password things. (at least not in 3.5.0 rc3, where this was also reported for, see http://bugs.debian.org/659733.

"plain" source uses nss-3.12.8-with-nspr-4.8.6 whereas Debian has
 libnspr4-0d | 4.9~beta5-2 | sid | amd64, armel, armhf, hurd-i386, i386, ia64, kfreebsd-amd64, kfreebsd-i386, mips, mipsel, powerpc,
+s390, s390x, sparc
 libnss3-1d | 3.13.1.with.ckbi.1.88-1 | sid | amd64, armel, hurd-i386, i386, ia64, kfreebsd-amd64, kfreebsd-i386, mips, mipsel, powerpc, s390,
+s390x, sparc
 libnss3-1d | 3.13.1.with.ckbi.1.88-1+b1 | sid | armhf

Some nss incompatibility? (Interestingly, the password unittest *succeeds*)

I have similar report in gentoo:

https://bugs.gentoo.org/show_bug.cgi?id=398599

Note that we do not patch things around this either. But funny enough it really works with 3.5 for us.

in my last comment I of course meant "do work" or "doesn't fail"....

JBF: so as we see here this is not a Ubuntu bug, nor a Debian bug nor some distro-only bug. Will do a build with LibreOffices bundled nss this night to reconfirm, but even if that works, it's still a valid LibreOffice bug.

(No, using internal nss/nspr which missed many security fixes is not an option)

John Talbut (i-jt) on 2012-02-13
summary: - [Downstream] Can't open/save spreadsheet with password
+ [Downstream] Can't open/save document or spreadsheet with password
Changed in libreoffice (Debian):
status: Unknown → Confirmed

Some comments:

Do the failing documents have passwords >= 15 characters?
Are all of them created with <=3.4.4 or >=3.4.5?
Did you try to save the documents in ODF1.1/1.0?

It would be good to collect some more information about the problems because digging in the password code without an idea and a test document is useless.

Changed in df-libreoffice:
status: Won't Fix → Confirmed

The document that brought this problem to my attention was old and had been opened and edited in many versions of Open/LibreOffice. It had an eight character password with upper and lower case letters and numbers.

I created a test document and a spreadsheet with LibreOffice 3.4.3 and saved them with the password "password" in both cases. I copied them to a computer with LibreOffice 3.4.5 installed (all from Debian) and could not open them. The
message was "The password is incorrect"

I tried to save a similar document using LibreOffice 3.4.5 using the password "password" and after inputting the password, the message was "Error saving the document Untitled 1: General Error. General input/output error"

Created attachment 57028
Document saved with password "password"

Created attachment 57029
Spreadsheet saved with password "password"

(In reply to comment #12)
> The document that brought this problem to my attention was old and had been opened and edited in many versions of Open/LibreOffice. It had an eight character
> password with upper and lower case letters and numbers.
>
> I created a test document and a spreadsheet with LibreOffice 3.4.3 and saved them with the password "password" in both cases. I copied them to a computer with
> LibreOffice 3.4.5 installed (all from Debian) and could not open them. The
> message was "The password is incorrect"
>
> I tried to save a similar document using LibreOffice 3.4.5 using the password "password" and after inputting the password, the message was "Error saving the
> document Untitled 1: General Error. General input/output error"

As stated in my original report, my symptoms are identical. I'm running Ubuntu 11.10 with LO3.4.5 and have identical issues.

Both my Calc & Writer documents, saved with 8 alphnumeric passwords under LO 3.4.3 open in Open Office 3.2 with no problem but still will not open under LO 3.4.5.

I can also not password protect any LO 3.4.5 document/spreadsheet and get the same error message quoted in this post.

I am unable to reproduce this with SUSE-specific build based on LO-3.4.5.

It smells like the bug 43868. It was broken in 3.4.5-rc1 but we reverted the problematic change for rc2, see
http://cgit.freedesktop.org/libreoffice/components/commit/?h=libreoffice-3-4-5&id=af45ce4dc9a4b7aea9214b5d74bf60809a4da78d

Bjorn, is it possible that the Ubuntu packages are based on 3.4.5-rc1 or that they still have the problematic change from some reasons?

pmladek: given that it also was reported in Debian (which is based on 3.4.5 final *of course* - 3.4.5.2), and even for 3.5.0 (see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=659733) - no.

Changed in df-libreoffice:
status: Confirmed → Incomplete

So trying it in this bug report too.

Can someone who is able to reproduce this bug report provide me an ods test document with password test and content 2 in cell A1 under the terms of LGPLv3+/MPL?

I would like to add a test case for this to sc/qa/unit/subsequent_filters-test.cxx:testPassword to prevent such bugs in future.

Created attachment 57371
ods test document

ods test document with password "test" and content 2 in cell A1 created with LibreOffice 3.4.3 attached. I release it under the terms of
LGPLv3+/MPL. I cannot open this document or save a document with a password with LibreOffice 3.4.5 OOO340m1 (Build:502)

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=8f82bccf26d14d3ad4a64739edd9ba23c124b8ad

add test case for old password algorithm, related fdo#45171

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=adb293f84d2f7e50ecc8b37ce439fd75c42ad84c&g=libreoffice-3-5

add test case for old password algorithm, related fdo#45171

It will be available in LibreOffice 3.5.1.

(In reply to comment #20)
> ods test document with password "test" and content 2 in cell A1 created with
> LibreOffice 3.4.3 attached. I release it under the terms of
> LGPLv3+/MPL. I cannot open this document or save a document with a password
> with LibreOffice 3.4.5 OOO340m1 (Build:502)

Thanks a lot. We added this test case to master and libreoffice-3-5 so if this is really a build problem and not a problem related to one of the Mozilla profiles we should spot the error already during the test run.

But I still suspect that it is related to the Mozilla profile, either firefox or thunderbird.

summary: - [Downstream] Can't open/save document or spreadsheet with password
+ Can't open/save document or spreadsheet with password

For what it's worth, I've now upgraded to Precise Pangolin Beta 1.

This uses LibreOffice 3.5.0 Build 350m1(Build:13)

This bug does not now affect me. I can now save and open new and legacy password protected files as expected.

papukaija (papukaija) on 2012-04-13
description: updated
description: updated
33 comments hidden view all 106 comments

Closing as NOTOURBUG as 3.4.6 works on a Ubuntu Oneiric install without updates. This is most likely a bug in some of the maintainer scripts for some of the updated packages.

(In reply to comment #35)
> Closing as NOTOURBUG

would have been my interpretation of the comments too. But much safer if you decide this ;-)

Changed in libreoffice (Ubuntu):
status: Triaged → Incomplete
7 comments hidden view all 106 comments

@mohican (jocelyn1b): Could you retry with a new user or after removing ~/.libreoffice and ~/.config/libreoffice?

mohican (mohican) wrote :

Hi,
1. I uninstalled completely libreoffice, then reboot, then reinstall -> same bug
2
. I removed ~/.config/libreoffice (there is no ~/.libreoffice on 12.04), then open new session -> same bug
3
. I created a new normal user -> NO BUG !

mohican (jocelyn1b): Thanks for testing, thats very helpful. Can you try to remove (or move to backup) the ~/.mozilla folder for the user that is still affected? see https://bugs.freedesktop.org/show_bug.cgi?id=45171#c23 for details.

mohican (mohican) wrote :

Yes, this solves the problem ! Thanks a lot !
Do you have more details so I know what to change in my firefox profile ?

mohican (mohican) wrote :

I now tried my firefox profile with ALL extensions and plug-ins unactivated but this doesn't help : the bug is there again.

mohican (mohican) wrote :

My firefox profile was on another disk partition than /home (because it is shared between several OS).
I have copied it into the ~/.mozilla folder and then there's no bug anymore !

So the bug it has nothing to do with the content of the firefox profile but it depends on the path to the firefox profile.

So when working with passwords, libreoffice does read the profile.ini file in ~/.mozilla folder (WHY?), then :
- if the path to the profile is not relative and situated outside the ~/.mozilla folder -> bug
- if the path is relative and inside the ~/.mozilla folder -> NO BUG

3 comments hidden view all 106 comments

Interesting observation from https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919659/comments/72 :
"My firefox profile was on another disk partition than /home (because it is shared between several OS).
I have copied it into the ~/.mozilla folder and then there's no bug anymore !

So the bug it has nothing to do with the content of the firefox profile but it depends on the path to the firefox profile.

So when working with passwords, libreoffice does read the profile.ini file in ~/.mozilla folder (WHY?), then :
- if the path to the profile is not relative and situated outside the ~/.mozilla folder -> bug
- if the path is relative and inside the ~/.mozilla folder -> NO BUG"

@Markus: Since you have investigated this issue quite thoroughly, does this make you see an immediate nice and small fix?

Reopening with normal severity as it only hits a very small subgroup of users.

summary: - Can't open/save document or spreadsheet with password
+ Can't open/save document or spreadsheet with password, when mozilla
+ profile has an absolute path
2 comments hidden view all 106 comments

The problem seems that libreoffice doesn't like path that is not relative to the firefox folder.

When the firefox profile.ini is such :

[Profile1]
Name=user1
IsRelative=1
Path=user1
Default=1

it's OK for libreoffice

But when it is such :

[Profile1]
Name=user1
IsRelative=0
Path=/home/user1/.mozilla/firefox/user1
Default=1

libreoffice fails to open the password protected file !

libreoffice also fails if there is no ~/.mozilla folder at all.

(Firefox has no problem with the not relative path and, in this case, when launched with the second version of profile.ini it rewrites it into the first version (relative).
It cannot transform it when the path is outside of the firefox folder.)

Now the bug seems to be either that :
- libreoffice should not access the firefox profile when opening or saving password protected files ?
- and/or libreoffice cannot follow unrelative path in profile.ini

Remember : my config is not new, and it still works with libreoffice 3.4.4 on Ubuntu 11.10.
So it's some kind of a regression anyway. Affecting libreoffice 3.5.2.2

3 comments hidden view all 106 comments

(In reply to comment #37)
> Interesting observation from
> https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/919659/comments/72 :
> "My firefox profile was on another disk partition than /home (because it is
> shared between several OS).
> I have copied it into the ~/.mozilla folder and then there's no bug anymore !
>
> So the bug it has nothing to do with the content of the firefox profile but it
> depends on the path to the firefox profile.
>
> So when working with passwords, libreoffice does read the profile.ini file in
> ~/.mozilla folder (WHY?), then :
> - if the path to the profile is not relative and situated outside the
> ~/.mozilla folder -> bug
> - if the path is relative and inside the ~/.mozilla folder -> NO BUG"
>
> @Markus: Since you have investigated this issue quite thoroughly, does this
> make you see an immediate nice and small fix?
>
>
> Reopening with normal severity as it only hits a very small subgroup of users.

There are some more interesting observations in the bug report.
I will have a look at this tomorrow and see if it is a bug in our init code, nss or mozilla.

(In reply to comment #38)
> There are some more interesting observations in the bug report.
> I will have a look at this tomorrow and see if it is a bug in our init code,
> nss or mozilla.

Windows_XP_sp2_x64; Windows_7_HP_sp1_x32:
1. An error is confirmed in LOdev_3.5.4rc0+; ID:4506a1b-a73d29c-6845e52-f269e46 (MinGW; Data stamp 2012-04-28_20.20.23)
2. There is no error in LibreOffice_3.5.3rc2 and LOdev_3.6.0alpha0; ID: c0a4c46 {Win-x86@6-fast; Data stamp 2012-04-27_21.25.23)

Changed in df-libreoffice:
importance: High → Medium
status: Incomplete → Confirmed

Marking back to Triaged as testcase is available.

Changed in libreoffice (Ubuntu):
status: Incomplete → Triaged
mohican (mohican) wrote :

Another user found out that in the libreoffice library
libmozabdrvlo.so
there are references to "profiles.ini" ".mozilla/firefox" "password" and also things related to Thunderbird.

As for Thunderbird : I have also a profile with absolute path. This is not buggy since I was able to open/save with password only by changing the profile path of Firefox.

Markus Mohrhard (see upstream bug) is currently investigating a fix for this. You can find his email in the upstream bug or as "moggi" on #libreoffice-dev on freenode IRC, if you want to help out directly. Thanks for everyone doing detective work on this one!

2 comments hidden view all 106 comments

With the help from the ubuntu bug report I think I finally have a point that looks wrong.

http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mozab/bootstrap/MNSProfileDiscover.cxx#174 and following seem to be wrong for the MINIMAL_PROFILEDISCOVER case.

We then just create the path to the profile through regDir + profilePath and we no longer respect if the profile path has been marked as relative or not. I will try to create a debug build with the ubuntu release configuration to confirm this.

If it is really only this point we might get a simple fix for this problem.

(In reply to comment #40)
> With the help from the ubuntu bug report I think I finally have a point that
> looks wrong.
>
> http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mozab/bootstrap/MNSProfileDiscover.cxx#174
> and following seem to be wrong for the MINIMAL_PROFILEDISCOVER case.
>

Seems like this is the problem. The problem is that we add the absolute profile path to the regPath which creates an invalid path and therefore initializing nss fails.

This problems is only visible in distro builds and maybe MacOSX/Windows builds if they use MINIMAL_PROFILEDISCOVER. (I'm quite sure that our windows builds are affected)

Will post a fix to the ML for review after some more manual testing.

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=fff2d18a08a37c0fa6a370e56591117fc08664d2

respect absolute paths for mozilla profile, fdo#45171, lp#919659

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=3ee18325cf8c06c04296173619f4535671e391e9&g=libreoffice-3-5

respect absolute paths for mozilla profile, fdo#45171, lp#919659

It will be available in LibreOffice 3.5.4.

It seems I can no longer reproduce the problem that opening password protected document fails whithout .mozilla dir. If someone can reproduce this behavior please open a new bug report and cc me.

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=7ead068be9f865327da7aef1cdc01614f25fc4a6

more robust nss initialization, related fdo#45171

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=bf9ab0b486ee336bd4fb91e5ad2320d25593d696&g=libreoffice-3-5

more robust nss initialization, related fdo#45171

It will be available in LibreOffice 3.5.4.

7 comments hidden view all 106 comments
Changed in libreoffice (Ubuntu):
status: Triaged → Fix Committed
Garry Trethewey (garrytreth) wrote :

I'm no expert, but here's my workaround
Going from ubuntu 10.04 to 12.04
Old file, made by OOO ver??, used by OOO ver?? and LO ver??, now LO writer v 3.5.2.2 now rejecting password.

Until now I have used the default placement for firefox, ie
/home/garry/.mozilla/firefox/profiles.ini
which said
IsRelative=0
Path=/media/data/mozilla/firefox/Profiles/ubuntu.default

Now I have
/home/garry/.mozilla/(symlink to /media/data/mozilla/firefox)/profiles.ini
which says
IsRelative=1
Path=ubuntu.default

So now password works.
(why on earth LO depends on Ff, who knows?)

Changed in df-libreoffice:
status: Confirmed → Fix Released
Changed in libreoffice (Debian):
status: Confirmed → Fix Released
7 comments hidden view all 106 comments

Use the 3.5.4 from the libreoffice ppa, which has the fix. SRU is struck in ubuntu processes, so might take a while.

Download full text (6.1 KiB)

SRU boilerplate for 3.5.4 SRU:

== rationale ==
This is a release regression. Along with it 3.5.4 fixes a long list of bugs and regressions including some serious crashers with possible data loss:
* upstream bugfix release, fixes for rc1:
    - (Does not recognize VBA macro in JAPANESE...) fdo#49324 [Julien Nabet]
    - enable caching of grammar checker properties fdo#35270 [Michael Meeks]
    - special-case appending items to autocorrect lists fdo#46805 [Michael Meeks]
    - Changing spelling preferences requires application restart fdo#39999 [Szabolcs Dezsi]
    - add+use SwDoc::containsUpdatableFields fdo#49897 [Caolán McNamara]
    - allow keyword Append to be used as a variable. bnc#745930 [Noel Power]
    - allow zwj, etc. in metric unit text fdo#42390 [Caolán McNamara]
    - avoid recursion that can mess up DND setup fdo#41996 [Luboš Luňák]
    - clamp mnFillOpacity to 1 fdo#48065 [Chr. Rossmanith]
    - comparing empty document with attached one crashes LO fdo#43424 [Szabolcs Dezsi]
    - compound storage backend is poor at knowing stream size fdo#47644 [Caolán McNamara]
    - correctly map monitor index back to screen fdo#49365 [David Tardon]
    - count mirrored monitors as one rhbz#809019 [David Tardon]
    - crash on "connect to existing database" wizard fdo#45580 [Lionel Elie Mamane]
    - dmapper: fix import of titlepg top/bottom margin fdo#44176 [Miklos Vajna]
    - dmapper: handle m_bTitlePage when m_nBreakType is zero fdo#49940 [Miklos Vajna]
    - do not prepend \n twice, it confuses KFileDialog rhbz#820439 [Luboš Luňák]
    - drawinglayer: fix double hairline borders: fdo#48647 [Michael Stahl]
    - fix Presenter Console help screen layout fdo#46223 [Gábor Stefanik]
    - fix RTF export of empty paragraph numbering rules fdo#49692 [Miklos Vajna]
    - fix RTF export of non-breaking space/hyphen/optional hyphen fdo#38176 [Miklos Vajna]
    - fix RTF import of Russian characters without an encoding specified fdo#48023 [Miklos Vajna]
    - fix RTF import of \sl without \slmult fdo#48876 [Miklos Vajna]
    - fix RTF import of automatic paragraph background color fdo#47764 [Miklos Vajna]
    - fix RTF import of fields without a result fdo#48193 [Miklos Vajna]
    - fix RTF import of localized fields fdo#48037 [Miklos Vajna]
    - fix bean after gbuild'ification fdo#49580 [Stephan Bergmann]
    - fix incorrect square gradients in slideshow. fdo#49508 [Thorsten Behrens]
    - fix parsing of arc paths fdo#48070 [Chr. Rossmanith]
    - fix property type for printoptions fdo#45592 [Noel Power]
    - fix vertical text frame borders: fdo#44010 [Michael Stahl]
    - fixed crash while opening odt file. fdo#47436 [Dezsi Szabolcs]
    - implement RTF_CHPGN fdo#38786 [Miklos Vajna]
    - implement RTF_KEYWORDS fdo#49683 [Miklos Vajna]
    - merge consecutive border lines: fdo#38215 [Michael Stahl]
    - more robust nss initialization, related fdo#45171 [Markus Mohrhard] (LP: #919659)
    - overwrite incorrect font table entry with the correct one fdo#47347 [Caolán McNamara]
    - PPTX import crashes. fdo#48778 [Muthu Subramanian]
    - parse rgb(%,%,%) correctly fdo#47447 [Chr. Rossmanith]
    - performance problems with very long paragraph...

Read more...

summary: - Can't open/save document or spreadsheet with password, when mozilla
- profile has an absolute path
+ SRU LibreOffice 3.5.4 for precise (was: Can't open/save document or
+ spreadsheet with password, when mozilla profile has an absolute path)

Hello Marcelo, or anyone else affected,

Accepted libreoffice into precise-proposed. The package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in advance!

Changed in libreoffice (Ubuntu):
status: Fix Committed → Triaged
Changed in libreoffice (Ubuntu Precise):
status: New → In Progress
importance: Undecided → High
assignee: nobody → Björn Michaelsen (bjoern-michaelsen)
status: In Progress → Fix Committed
tags: added: verification-needed
Clint Byrum (clint-fewbar) wrote :

Note that this has been accepted on the basis of the +1 to the micro release exception request in this thread:

https://lists.ubuntu.com/archives/technical-board/2012-June/001283.html

Once this is built, we need to see reports of at least smoke testing on all architectures.

verified, no known regressions.

tags: added: verification-done
removed: verification-needed
Chris Halse Rogers (raof) wrote :

Björn - what architectures have you tested this SRU on?

amd64, i386 are extensively tested (identical source package in the LibreOffice PPA since 2012-05-24. I havent tested ARM more than in build tests.

John Bingham (john-ukmail) wrote :

I've just done a clean install of Linux Mint Maya 64 bit. I dual boot this with Windows Vista Business 32 bit on my Dell D630. I like to keep the same environment, so in Linux, I have two profiles for Firefox: the default Linux, which I rarely use and the Windows which I select most of the time.

In the course of my investigations, I managed to lose my old Windows profile, so both are now new. I find that if I start up Firefox using the Windows profile, Libre Office has the encryption problems noted in this thread: i.e. won't save and says the password is incorrect on opening. If I open Firefox with the Linux profile then Libre Office works fine.

Seems very odd that a Firefox profile should affect a separate encryption programme, but clearly it does. I'm also very annoyed to have lost my Windows Firefox profile, but then I should have backed it up.

John Bingham (john-ukmail) wrote :

I forgot to mention that I updated L O by adding the 3.5.4 ppa to Synaptic. I now have 3.5.4.2 and that's still broken.

Markus Mohrhard (moggi) wrote :

Hey John,

can you tell me what your profiles.ini contains? Normally 3.5.4 should fall back to initializing nss without mozilla if the with mozilla case fails. Normally the without mozilla case should succeed everywhere and should be able to open any encrypted files.

John Bingham (john-ukmail) wrote :

Sorry for the delay Markus, I wish I had more time to spend on interesting things ;-)

Here's ~/.mozilla/firefox/profiles.ini

[General]
StartWithLastProfile=0

[Profile0]
Name=default
IsRelative=1
Path=gsljspgu.default

[Profile1]
Name=Windows
IsRelative=0
Path=/media/Windows/Users/John/AppData/Roaming/Mozilla/Firefox/Profiles/q6kiiqff.default
Default=1

Micah Gersten (micahg) wrote :

Marking this bug as verification-failed due to Bug #1021946 which seems to be related to libreoffice 3.5.4

tags: added: verification-failed
removed: verification-done
Gini (ginigrace) on 2012-07-10
Changed in libreoffice (Ubuntu Precise):
status: Fix Committed → Fix Released
Micah Gersten (micahg) on 2012-07-10
Changed in libreoffice (Ubuntu Precise):
status: Fix Released → Fix Committed
Sebastien Bacher (seb128) wrote :

Ok, so the submitter of bug #1021946 wrote

"yes, I tested it and thought I put the result but actually not... exactly the same thing happened to me in libreoffice 3.5.3. "

which means it's not a regression from the libreoffice update ... can we put that bug back to verification-done and get the SRU moving to updates?

Micah Gersten (micahg) on 2012-07-17
tags: added: verification-done
removed: verification-failed
Clint Byrum (clint-fewbar) wrote :

According to the bug status here, this bug is not fixed in Quantal. But I see that Quantal has 3.6.0rc2.

Can somebody please verify that this is fixed in 3.6.0, and set the bug task status to 'Fix Released' if so? Once thats done 3.5.4 should be able to move forward to precise-updates.

Is fixed upstream on 3.6.x.

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Released
Launchpad Janitor (janitor) wrote :
Download full text (6.1 KiB)

This bug was fixed in the package libreoffice - 1:3.5.4-0ubuntu1

---------------
libreoffice (1:3.5.4-0ubuntu1) precise-proposed; urgency=low

  [ Bjoern Michaelsen ]
  * removed upstreamed lp-818761-Remove-SalDisplay-GetKeyboardName.diff
  * upstream bugfix release, fixes for rc1:
    - (Does not recognize VBA macro in JAPANESE...) fdo#49324 [Julien Nabet]
    - enable caching of grammar checker properties fdo#35270 [Michael Meeks]
    - special-case appending items to autocorrect lists fdo#46805 [Michael Meeks]
    - Changing spelling preferences requires application restart fdo#39999 [Szabolcs Dezsi]
    - add+use SwDoc::containsUpdatableFields fdo#49897 [Caolán McNamara]
    - allow keyword Append to be used as a variable. bnc#745930 [Noel Power]
    - allow zwj, etc. in metric unit text fdo#42390 [Caolán McNamara]
    - avoid recursion that can mess up DND setup fdo#41996 [Luboš Luňák]
    - clamp mnFillOpacity to 1 fdo#48065 [Chr. Rossmanith]
    - comparing empty document with attached one crashes LO fdo#43424 [Szabolcs Dezsi]
    - compound storage backend is poor at knowing stream size fdo#47644 [Caolán McNamara]
    - correctly map monitor index back to screen fdo#49365 [David Tardon]
    - count mirrored monitors as one rhbz#809019 [David Tardon]
    - crash on "connect to existing database" wizard fdo#45580 [Lionel Elie Mamane]
    - dmapper: fix import of titlepg top/bottom margin fdo#44176 [Miklos Vajna]
    - dmapper: handle m_bTitlePage when m_nBreakType is zero fdo#49940 [Miklos Vajna]
    - do not prepend \n twice, it confuses KFileDialog rhbz#820439 [Luboš Luňák]
    - drawinglayer: fix double hairline borders: fdo#48647 [Michael Stahl]
    - fix Presenter Console help screen layout fdo#46223 [Gábor Stefanik]
    - fix RTF export of empty paragraph numbering rules fdo#49692 [Miklos Vajna]
    - fix RTF export of non-breaking space/hyphen/optional hyphen fdo#38176 [Miklos Vajna]
    - fix RTF import of Russian characters without an encoding specified fdo#48023 [Miklos Vajna]
    - fix RTF import of \sl without \slmult fdo#48876 [Miklos Vajna]
    - fix RTF import of automatic paragraph background color fdo#47764 [Miklos Vajna]
    - fix RTF import of fields without a result fdo#48193 [Miklos Vajna]
    - fix RTF import of localized fields fdo#48037 [Miklos Vajna]
    - fix bean after gbuild'ification fdo#49580 [Stephan Bergmann]
    - fix incorrect square gradients in slideshow. fdo#49508 [Thorsten Behrens]
    - fix parsing of arc paths fdo#48070 [Chr. Rossmanith]
    - fix property type for printoptions fdo#45592 [Noel Power]
    - fix vertical text frame borders: fdo#44010 [Michael Stahl]
    - fixed crash while opening odt file. fdo#47436 [Dezsi Szabolcs]
    - implement RTF_CHPGN fdo#38786 [Miklos Vajna]
    - implement RTF_KEYWORDS fdo#49683 [Miklos Vajna]
    - merge consecutive border lines: fdo#38215 [Michael Stahl]
    - more robust nss initialization, related fdo#45171 [Markus Mohrhard] (LP: #919659)
    - overwrite incorrect font table entry with the correct one fdo#47347 [Caolán McNamara]
    - PPTX import crashes. fdo#48778 [Muthu Subramanian]
    - parse rgb(%,%,%) correctly fdo#47447 [Chr. Rossmanith]
    - ...

Read more...

Changed in libreoffice (Ubuntu Precise):
status: Fix Committed → Fix Released
Displaying first 40 and last 40 comments. View all 106 comments or add a comment.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.