----- Le 16 Avr 20, à 14:21, Jefferson Dümes <[email protected]> a écrit :
> Hi There, > I am trying a the current dockerized version of OpenXPKI. When I try to > revocate > a cert. I get this "Database error: execution of SQL query failed" > From Workflow history by > Action/Descrition=NICE_DISPATCH_REVOKE/global_nice_revoke_certificate > EXCEPTION: Database error: execution of SQL query failed; __dbi_error__ => You > can't specify target table 'certificate' for update in FROM clause, __dsn__ => > dbi:mysql:host=db;database=openxpki;port=3306, __query__ => UPDATE certificate > SET revocation_id = (SELECT coalesce(max(revocation_id)+1, 1) FROM > certificate) > , status = ? WHERE ( ( identifier = ? AND revocation_id IS NULL ) ), > __source__ > => DBD::mysql::st::execute, __user__ => openxpki > System Version 3.4.0 > Config Version config 3.4 > Regards, > Jeff You need to apply this change to your SQL DB : [ https://github.com/openxpki/openxpki-config/commit/51f269908ee2fe46fc5af961c7221bc96d57a931 | https://github.com/openxpki/openxpki-config/commit/51f269908ee2fe46fc5af961c7221bc96d57a931 ] which, in SQL code translates to this : [ https://git.fws.fr/fws/ansible-roles/src/branch/master/roles/openxpki/files/upgrade_to_v3.4.sql | https://git.fws.fr/fws/ansible-roles/src/branch/master/roles/openxpki/files/upgrade_to_v3.4.sql ] Cheers, Daniel -- [ https://www.firewall-services.com/ ] Daniel Berteaud FIREWALL-SERVICES SAS, La sécurité des réseaux Société de Services en Logiciels Libres Tél : +33.5 56 64 15 32 Matrix: @dani:fws.fr [ https://www.firewall-services.com/ | https://www.firewall-services.com ]
_______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
