Hello Tomoya, I can confirm the problem but I am unable to find the root cause at the moment. It seems to work on debian but not on ubuntu and only for some kinds of paramaters.
I will come back once we have a solution. best regards Oliver Am 07.06.2018 um 03:51 schrieb Tomoya Kabe: > 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 > -- Protect your environment - close windows and adopt a penguin!
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
