Hello
I'm newbie to OpenXPKI and installed it to Trusty.
Everything looks working properly except listing certificates.
Installed Packages:
ii libopenxpki-perl 2.0.3-a16e540
amd64 OpenXPKI Perl core modules
ii openxpki-i18n 2.0.3-a16e540
amd64 Translations for OpenXPKI
How to reproduce:
Home -> My Certificates
Displayed Message:
"Unknown application error"
Logs:
webui.log
2018/06/07 10:46:00 check for cgi session, fcgi pid 15570
2018/06/07 10:46:00
I18N_OPENXPKI_CLIENT_SEND_RECEIVE_SERVICE_MSG_ERROR_DURING_COLLECT;
__EVAL_ERROR__ =>
I18N_OPENXPKI_TRANSPORT_SIMPLE_CLIENT_READ_CLOSED_CONNECTION at
/usr/lib/perl5/OpenXPKI/Client.pm line 148.
; __STATE__ => can_send
2018/06/07 10:46:00 Backend client session id Z/YZEHKRR+iVEvdC9DudEA==
2018/06/07 10:46:00 session id (front) is Z/YZEHKRR+iVEvdC9DudEA==
2018/06/07 10:46:00 Use provided client instance
2018/06/07 10:46:00 Backend session already loaded
2018/06/07 10:46:00 Resume backend session with id Z/YZEHKRR+iVEvdC9DudEA==
2018/06/07 10:46:00 current session status SERVICE_READY
2018/06/07 10:46:00 Loading handler class certificate
2018/06/07 10:46:00 Method is init_mine
2018/06/07 10:46:00 command search_cert failed (ERROR)
2018/06/07 10:46:00 Database error: execution of SQL query failed
2018/06/07 10:46:00 error while handling request
2018/06/07 10:46:00 Can't use an undefined value as an ARRAY reference at
/usr/lib/perl5/OpenXPKI/Client/UI/Certificate.pm line 475.
2018/06/07 10:46:00 Session store with id Z/YZEHKRR+iVEvdC9DudEA==
2018/06/07 10:46:00 Skipping session store for id Z/YZEHKRR+iVEvdC9DudEA==
- backend already gone
catchall.log
2018/06/07 10:38:47 openxpki.system.ERROR Database error: execution of SQL
query failed; __dbi_error__ => You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near ''system_cert_owner' AND certificate.identifier =
certattr0.identifier ) ) WHERE ' at line 1; __user__ => openxpki;
__source__ => DBD::mysql::st::execute; __query__ => SELECT certificate.*
FROM certificate INNER JOIN certificate_attributes AS certattr0 ON ( (
certattr0.attribute_contentkey = certattr0.'system_cert_owner' AND
certificate.identifier = certattr0.identifier ) ) WHERE ( (
certattr0.attribute_value = ? AND certificate.pki_realm = ? ) ) ORDER BY
certificate.notbefore DESC LIMIT ? OFFSET ?; __dsn__ =>
dbi:mysql:port=3306;host=my-db;database=openxpki [pid=4753|sid=Z/YZ]
>From catchall.log,
certattr0.attribute_contentkey = certattr0.'system_cert_owner'
looks actually wrong and
certattr0.attribute_contentkey = 'system_cert_owner'
should be correct.
It looks a bug in SQL query construction. Could someone fix it?
Thanks in advance,
Tomoya
--
<https://about.me/tomoya.kabe?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>
Tomoya Kabe
about.me/tomoya.kabe
<https://about.me/tomoya.kabe?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users
