Bug 146322 - IDE: sign macro
Summary: IDE: sign macro
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
7.2.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-19 22:55 UTC by documentfoundation@pelly.co
Modified: 2023-07-03 03:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
signed macro security warning (32.06 KB, image/png)
2021-12-30 19:37 UTC, documentfoundation@pelly.co
Details

Note You need to log in before you can comment on or make changes to this bug.
Description documentfoundation@pelly.co 2021-12-19 22:55:07 UTC
I have a few macros that run or are available for everything. I'd like to sign them and trust my signature so that I don't have to allow macros every time I open a document. These macros are saved in My Macros & Dialogs > Standard > Module1.

I can sign spreadsheets, and my signature is trusted, but the BASIC IDE does nothing when I click on File > Digital Signatures...

I expect a dialog to appear inviting me to select a signature.

I don't have much interest in simply trusting their location, because everything I do can write there.



Version: 7.2.3.2 / LibreOffice Community
Build ID: 20(Build:2)
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 1:7.2.3-0ubuntu0.21.10.1
Calc: threaded
Comment 2 documentfoundation@pelly.co 2021-12-30 19:37:36 UTC
Created attachment 177214 [details]
signed macro security warning
Comment 3 documentfoundation@pelly.co 2021-12-30 19:55:13 UTC
From the tools > macro menu I do have access to digitally sign the macros in the document.

After the macro is signed, when I open the IDE, the file > digital signatures... option opens the signature dialog as expected.

When opening the document the "security warning" dialog appears telling me the macros are signed by: <blank>. See attachment. Clicking on the view signatures button causes LO to hang until it is killed.

Selecting "always trust macros from this source..." seems to do nothing.

Other Information:
Something seems to have broken for me recently. When I look at Tools > Options > LibreOffice > Security > Macro Security... I have a large error dialog titled "Macro security problem!" The content starts with "Broken certificate data: mQIN..." and ends with "Vs= / com.sun.star.uno.RuntimeException message: ./xmlsecurity/source/xmlsec/nss/x590certificate_nssimpl.cxx:326"

Copy & paste wasn't available so I had to type that... please excuse mistakes.
Comment 4 documentfoundation@pelly.co 2021-12-30 23:17:00 UTC
gah! 

./xmlsecurity/source/xmlsec/nss/x509certificate_nssimpl.cxx
Comment 5 sockseight 2022-12-03 07:34:04 UTC
Please clarify: signing only works with x509 certificates


kindly confirm if x509 certificates were used.

more info: https://bugs.documentfoundation.org/show_bug.cgi?id=115884



Hello,

Thank you for reporting the bug. Can you please confirm if the issue still exists in the latest build?


Could you please try to reproduce it with a master build from https://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build.
Comment 6 QA Administrators 2023-06-02 03:17:01 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2023-07-03 03:12:06 UTC
Dear documentfoundation@pelly.co,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp