Bug 132361 - Missing keyt in certificate window.
Summary: Missing keyt in certificate window.
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.3.3.2 release
Hardware: ARM Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-23 18:38 UTC by dima
Modified: 2020-05-10 14:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
empty cert window (82.65 KB, image/png)
2020-04-23 18:41 UTC, dima
Details
version (15.00 KB, image/png)
2020-04-23 18:42 UTC, dima
Details
Screenshot for Julien Nabet. (84.39 KB, image/png)
2020-04-30 13:54 UTC, dima
Details
screenshot with Start Certificate Manager (30.00 KB, image/png)
2020-04-30 16:25 UTC, Julien Nabet
Details
Screenshot after having clicked "Sign Document..." (26.09 KB, image/png)
2020-04-30 16:26 UTC, Julien Nabet
Details
gpgkey (23.92 KB, image/png)
2020-04-30 16:28 UTC, Julien Nabet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description dima 2020-04-23 18:38:22 UTC
Description:
I need to sign file with GnuPG key. The problem is there is empty certificate window.

Steps to Reproduce:
1.open libreoffice writer
2.open odt file
3.select "File" in menu, select digital signature in context window.

Actual Results:
Empty certificate window

Expected Results:
GPG key ID


Reproducible: Always


User Profile Reset: No



Additional Info:
version 4.3.3.2
Comment 1 dima 2020-04-23 18:41:28 UTC
Created attachment 159867 [details]
empty cert window

empty cert window
Comment 2 dima 2020-04-23 18:42:03 UTC
Created attachment 159868 [details]
version

version
Comment 3 Julien Nabet 2020-04-24 07:44:36 UTC
4.3.3 is very old
Please give a try at last stable LO version 6.4.3
Comment 4 dima 2020-04-24 08:02:18 UTC
This is most fresh version in raspbian repository.
Comment 5 Julien Nabet 2020-04-24 08:14:13 UTC
Raspbian derives from Debian.
I use Debian testing, what Raspbian version do you use?
Comment 6 dima 2020-04-24 19:33:39 UTC
"jessie" I think.
cat debian_version 
8.0
Linux xyz 4.9.35-v7+ #1014 SMP Fri Jun 30 14:47:43 BST 2017 armv7l GNU/Linux
Comment 7 Julien Nabet 2020-04-24 20:54:56 UTC
Stable Debian is more for servers and Jessie is not even the last stable Debian.
See https://en.wikipedia.org/wiki/Debian_version_history

So if you can't install a more recent LO version, I don't know what can be done.
Comment 8 dima 2020-04-25 17:51:08 UTC
(In reply to Julien Nabet from comment #7)
> Stable Debian is more for servers and Jessie is not even the last stable
> Debian.
> See https://en.wikipedia.org/wiki/Debian_version_history
> 
> So if you can't install a more recent LO version, I don't know what can be
> done.

I've got 9.11 OS version (stretch) and Libreoffice 5.2.7.2. The problem can be reproduced yet.
Comment 9 Julien Nabet 2020-04-25 18:41:28 UTC
(In reply to dima from comment #8)
> ...
> I've got 9.11 OS version (stretch) and Libreoffice 5.2.7.2. The problem can
> be reproduced yet.

Could you try directly Debian testing?
5.2.7 branch was on 2017 (see https://wiki.documentfoundation.org/ReleasePlan/5.2)

Last one is 6.4.3.
Comment 10 dima 2020-04-26 08:39:29 UTC
(In reply to Julien Nabet from comment #9)
> (In reply to dima from comment #8)
> > ...
> > I've got 9.11 OS version (stretch) and Libreoffice 5.2.7.2. The problem can
> > be reproduced yet.
> 
> Could you try directly Debian testing?
> 5.2.7 branch was on 2017 (see
> https://wiki.documentfoundation.org/ReleasePlan/5.2)
> 
> Last one is 6.4.3.

I can't.
Comment 11 Julien Nabet 2020-04-26 08:41:39 UTC
Why?
Comment 12 dima 2020-04-26 12:03:06 UTC
(In reply to Julien Nabet from comment #11)
> Why?

Because I'm raspbian user.(In reply to Julien Nabet from comment #11)
> Why?

1. There is no hyperlink on offered version.
2. Offered version may require some missing dependecies.

However, I will try to install if someone will port offered version to raspbian.
Comment 13 Julien Nabet 2020-04-26 13:31:27 UTC
I know very few about signature and GnuPG.
I had to create a pair of keys so I used this tuto:
https://help.github.com/en/github/authenticating-to-github/generating-a-new-gpg-key

When trying "gpg --list-secret-keys --keyid-format LONG"
I got a non empty result.

Then I followed these steps on LO Debian testing package 6.4.3.2:
- launch Writer
- File/Digital Signatures/Digital Signatures...
=> a dialog window opens and main pane is empty

- Click on "Sign Document..." button
=> existing Certificate appears
or:
- Click on "Start Certificate Manager..." button
=> GnuPGKeys dialog appears


Could you first confirm that you've got non empty result when trying:
gpg --list-secret-keys --keyid-format LONG
?

If ok, do you also confirm you got nothing for both buttons?
Comment 14 Julien Nabet 2020-04-26 13:33:00 UTC
Rene: I put you in cc since you might be interested in this one (Raspbian being a derivated from Debian). If Dima has indeed a gpg key but sees nothing for both buttons, I'd put NOTOURBUG since he uses old LO 5.2.7
Comment 15 dima 2020-04-30 13:51:57 UTC
(In reply to Julien Nabet from comment #13)
> I know very few about signature and GnuPG.
> I had to create a pair of keys so I used this tuto:
> https://help.github.com/en/github/authenticating-to-github/generating-a-new-
> gpg-key
> 
> When trying "gpg --list-secret-keys --keyid-format LONG"
> I got a non empty result.
> 
> Then I followed these steps on LO Debian testing package 6.4.3.2:
> - launch Writer
> - File/Digital Signatures/Digital Signatures...
> => a dialog window opens and main pane is empty
> 
> - Click on "Sign Document..." button
> => existing Certificate appears
> or:
> - Click on "Start Certificate Manager..." button
> => GnuPGKeys dialog appears
> 
> 
> Could you first confirm that you've got non empty result when trying:
> gpg --list-secret-keys --keyid-format LONG
> ?
> 
> If ok, do you also confirm you got nothing for both buttons?

gpg displays secret keys.
Dialog window is empty.
Where is "Start Certificate Manager" button?
Comment 16 dima 2020-04-30 13:54:26 UTC
Created attachment 160134 [details]
Screenshot for Julien Nabet.

certificate window is empty.
Comment 17 Julien Nabet 2020-04-30 16:25:31 UTC
Created attachment 160139 [details]
screenshot with Start Certificate Manager
Comment 18 Julien Nabet 2020-04-30 16:26:56 UTC
Created attachment 160140 [details]
Screenshot after having clicked "Sign Document..."
Comment 19 Julien Nabet 2020-04-30 16:28:01 UTC
Created attachment 160141 [details]
gpgkey
Comment 20 Julien Nabet 2020-04-30 16:30:14 UTC
Xisco: any thoughts here? Personally, I'd put NOTOURBUG. Indeed if Raspbian only proposes LO 5.2.7, what can we do?
Comment 21 dima 2020-05-01 13:32:02 UTC
(In reply to Julien Nabet from comment #20)
> Xisco: any thoughts here? Personally, I'd put NOTOURBUG. Indeed if Raspbian
> only proposes LO 5.2.7, what can we do?

Do not forget to update documentation for reported version - feature does not work in raspbian.
Comment 22 Julien Nabet 2020-05-01 13:46:17 UTC
(In reply to dima from comment #21)
> (In reply to Julien Nabet from comment #20)
> > Xisco: any thoughts here? Personally, I'd put NOTOURBUG. Indeed if Raspbian
> > only proposes LO 5.2.7, what can we do?
> 
> Do not forget to update documentation for reported version - feature does
> not work in raspbian.

LO current doc is for current LO version not EOL LO versions. Perhaps you should submit a bug on Raspbian bugtracker if exists.
Comment 23 Rene Engelhard 2020-05-01 14:32:50 UTC
yeah, and debian stretch (which the used raspbian seems to be based on, thus having 5.2.7 as official version) is soon (this year) to be EOL, too.

There's no point in documenting that 5.2.7 hasn't that feature when it's clear from release notes etc. that 6.0 got that feature only: https://wiki.documentfoundation.org/ReleaseNotes/6.0#OpenPGP_document_signing_and_encryption

(and Debian has a 6.1.5 backport for stretch - though afaicr armhf is is armv6 in raspbian[1] and armhf in debian wants armv7: https://packages.debian.org/search?keywords=libreoffice-core).

For rpi3, you can even just use pure Debian (where you get 6.1.5 as officially in stable and 6.4.3 as backport.) I happily use a rpi3 with stock Debian buster (thus 6.1.5 if I had GUI there - it's my "home server")

[1] At least the rpi1 (not sure about 2) has only a armv6 processor, that's raspbians existence point. See also https://wiki.debian.org/RaspberryPi
Comment 24 dima 2020-05-10 13:43:39 UTC
Problem cannot be reproduced on arch linux arm on the same hardware. I have libreoffice version  6.4.3.2.
Comment 25 Rene Engelhard 2020-05-10 14:29:40 UTC
can people actually read? 

Of course it works in 6.x SINCE THIS FEATURE IS ADDED SINCE 6.X and of course doesn't in 5.2.7 or even 4.3.3 SINCE THAT FEATURE IS NOT PRESENT IN SAID VERSION AT ALL.

Closing this as RESOLVED - INVALID.
Comment 26 Rene Engelhard 2020-05-10 14:35:41 UTC
(and as I said, Debian has 6.1.5 in stable. 6.3.4 also available. Which has that feature - also for arm*. Ask Raspbian when they wanted to update to a sane release, it is available.)
Comment 27 Rene Engelhard 2020-05-10 14:36:30 UTC
sorry, "6.4.3 also available"