Hi Robert, this is a known issue which has not been fixed yet: https://github.com/openxpki/openxpki/issues/642
There is no known workaround at the moment, I am sorry. Oliver Am 06.01.20 um 21:06 schrieb Robert Müller: > > Hi, > > > > I'm new to openxpki and installed the current stable on Buster via the > debian repo. > > After several beginner-issues everything works fine now, except if I'm > entering a IPv4 address as SAN field. The approval will then be paused > because of a "backend communication error". > > > > Digging into this, the error comes from this: > > > > 2020/01/06 20:38:21 openxpki.system.ERRORDatabase error: execution of > SQL query failed; __dbi_error__ => Incorrect string value: > '\xC0\xA8c\xF0' for column `openxpki`.`certificate_attribut > es`.`attribute_value` at row 1, __dsn__ => > dbi:mysql:port=3306;host=localhost;database=openxpki, __query__ => > INSERT INTO certificate_attributes ( attribute_contentkey, > attribute_key, attri > bute_value, identifier) VALUES ( ?, ?, ?, ? ), __source__ => > DBD::mysql::st::execute, __user__ => openxpki > [pid=692|sid=KXQc|wftype=certificate_signing_request_v2|wfid=1535] > > > > To further evaluate, I switched on the mysql query log: > > > > 16 Query INSERT INTO seq_certificate_attributes ( > dummy) VALUES ( '0' ) > 16 Query select last_insert_id() > 16 Query INSERT INTO certificate_attributes ( > attribute_contentkey, attribute_key, attribute_value, identifier) VALUES > ( 'subject_alt_name', '1791', 'IP:<C0><A8>c<F0> > ', 'p5JdEdhIEdk4yDHzLUvAoOjaEho' ) > 17 Query INSERT INTO seq_application_log ( dummy) > VALUES ( '0' ) > > Seems that the IP to insert is somehow not valid UTF8 anymore. If I > 'select from csr_attributes' in database, it looks like this: > > > > 3071 | RMITC | 767 | subject_alt_name | > OXJSF1:["IP","192.168.99.240"] | PROFILE | > > So everything fine, I think. > > > > Any suggestions greatly appreciated! > > > > Thanks, > > Robert > > > > > > > > > _______________________________________________ > OpenXPKI-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/openxpki-users > -- Protect your environment - close windows and adopt a penguin!
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
