Hi,
When I try to upload the Let’s Encrypt Authority X3 certificate (https://letsencrypt.org/certificates/) into Certificate Authority, it gives me a generic error saying "Certificate Authority could not be uploaded".
Looking at /log/postgres.log, there seems to be a problem with the apostrophe ( ' ) inside the .PEM or .DER file. Clearly Sophos is not handling these very well.
Will there be a fix on this any soon? Bugfix NC6557 (Unable to import Certificate in Certificate Authority) in SFOS 15.01.0 MR-3 doesn't seem to fix the problem.
Inside certificate
CN = Let's Encrypt Authority X3
O = Let's Encrypt
Output /log/postgres.log
10563 2016-07-01 00:33:16.635 GMTERROR: syntax error at or near "s" at character 190
10563 2016-07-01 00:33:16.635 GMTSTATEMENT: select substr(mergetext(caname || ','),0,length(mergetext(caname || ','))) from tblrootcainfo where companyid in (select caid from tblrootcadetail where rtrim(subject,chr(10))='/C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X1') and caname || '.pem' != 'test.pem';
4000 2016-07-01 00:33:16.652 GMTERROR: syntax error at or near "s" at character 53
4000 2016-07-01 00:33:16.652 GMTSTATEMENT: insert into tblrootcadetail values(240,'/C=US/O=Let's Encrypt/CN=Let's Encrypt Authority X1')
4000 2016-07-01 00:33:16.653 GMTERROR: current transaction is aborted, commands ignored until end of transaction block
4000 2016-07-01 00:33:16.653 GMTSTATEMENT: SELECT txid_current()
This thread was automatically locked due to age.