When I try to sign a document with a digital certificate the dialog comes up empty. caolan over at #libreoffice on freenode pointed me towards http://wiki.services.openoffice.org/wiki/Certificate_Detection which mentions "export MOZILLA_CERTIFICATE_FOLDER=~/.mozilla/firefox/<profile>" and this workaround works. It's a rather annoying issue tho, and I'm not sure if it's down to packaging (cant find anything on Launchpad/Ubuntu) but this should work properly for all distros by default imo. Since I'm not a coder I don't know how the detection is done, but the info is at least accessible in ~/.mozilla/firefox/profiles.ini so it seems like LibreOffice should be able to just look that up and everything should work fine :)
note I've a vague memory of making this work for the system-mozilla case with the stripped down simple profile finder. If I'm right there then we could use that code for all cases, and reduce dependency on that internal mozilla as a very good side effect.
ob question, what LibreOffice are you using ?, i.e. from where
Ugh, that was silly of me to forget. This is on Ubuntu 11.04 using LibreOffice 3.3.2 that comes with the distro.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I just found the problem on my system. I had at some point installed Thinderbird, although I removed that later (Kubuntu). The .thunderbird folder still existed and there were no certificates there. I will attach a document with script that can help debug which certificate store is used by LO. Of course it would e useful if LO would select the correct store for the Tools Settings menu (similar to selecting the correct JRE). Ferry
Created attachment 60415 [details] Contains macro to verify the certificate path - don't be alarmed.
Caolan McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=207313157688d79cb0d53e920a03423c81a7bc23 Resolves: fdo#39825 Make detection of certificate folder ui-configurable
Created attachment 60657 [details] picture of new options and dialog
Added some ui stuff to let you pick the right one, or add one, if for some reason the auto-detection doesn't work out. If there's some other bug still hidden here, that should help flush it out.
This great, thanks so much. For completeness: LibO for windows uses windows certificate store always. The macro in the attached document does not know this and reports the wrong certificate store.