xca icon indicating copy to clipboard operation
xca copied to clipboard
verified publisher icon chris2511

Lost remote MySQL connection

Open reetp opened this issue 1 year ago • 2 comments

Just fired up xca 2.5.x and connected to the remote mysql DB but could not see any certificates that I had previously generated.

Thought I would build 2.6.x and test which I did.

Seems that despite putting in the correct DB passwords I get this logged.

Note I can execute the statement on the server without issues.

It seems to think it is connected but not showing anything.

xca --version X Certificate and Key management Version 2.6.45-dev commit: 128f7d957aaea05483436b45432106f7589fefe2


   002 Warning: QSqlDatabase: QODBC driver not loaded
   002 Warning: QSqlDatabase: available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3 QPSQL QPSQL7
   900 Warning: QXcbConnection: XCB error: 3 (BadWindow), sequence: 1258, resource id: 16434918, major code: 40 (TranslateCoords), minor code: 0
  1205 Critical: XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement - db_base.cpp:96 (SELECT * FROM view_public_keys)"
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 3 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 3 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(3) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 5 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 5 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(5) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 7 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 7 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(7) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 10 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 10 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(10) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 12 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 12 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(12) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 14 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 14 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(14) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 16 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 16 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(16) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 20 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 20 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(20) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 22 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 22 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(22) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 24 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 24 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(24) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 26 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 26 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(26) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 28 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 28 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(28) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 30 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 30 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(30) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 32 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 32 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(32) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 43 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 43 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(43) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 50 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 50 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(50) P8pki_base . Expected P7pki_key."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 52 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 52 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(52) P8pki_base . Expected P7pki_key."
  1205 Critical: XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement - db_base.cpp:96 (SELECT * FROM view_requests)"
  1205 Critical: XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement - db_base.cpp:96 (SELECT * FROM view_certs)"
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 6 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 6 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(6) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 9 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 9 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(9) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 11 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 11 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(11) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 13 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 13 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(13) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 15 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 15 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(15) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 17 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 17 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(17) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 21 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 21 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(21) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 23 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 23 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(23) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 25 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 25 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(25) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 27 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 27 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(27) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 29 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 29 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(29) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 31 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 31 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(31) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 34 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 34 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(34) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 4 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(4) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(44) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(44) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 51 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 51 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(51) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(44) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 53 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 53 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(53) P8pki_base . Expected P8pki_x509."
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:30 pki_lookup::get pki_lookup: ID 44 not found
  1205 Critical: pki_lookup.h:99 pki_lookup::lookupPki "Invalid Type of ItemId(44) P8pki_base . Expected P8pki_x509."
  1205 Critical: XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement - db_base.cpp:96 (SELECT * FROM view_crls)"
  1205 Critical: XcaWarning.cpp:65 xcaWarningGui::sqlerror SQL ERROR: "Prepared statement needs to be re-prepared QMYSQL3: Unable to execute statement - db_base.cpp:96 (SELECT * FROM view_templates)"
  1206 Warning: QXcbConnection: XCB error: 3 (BadWindow), sequence: 1452, resource id: 16435882, major code: 40 (TranslateCoords), minor code: 0
 17107 Warning: Help.cpp:98 Help::register_ctxhelp_button Unknown help context:  "remote_db"

reetp avatar Jul 02 '24 16:07 reetp

Bother.

I remember that I appear to have to restart the DB server sometimes. I have absolutely no idea why.

I can see the tables and data via phpmyadmin.

Mystery - interested if you have any thoughts.

reetp avatar Jul 02 '24 16:07 reetp

https://stackoverflow.com/questions/4380813/how-to-get-rid-of-mysql-error-prepared-statement-needs-to-be-re-prepared

chris2511 avatar Sep 01 '24 09:09 chris2511

Hit this again. I ran these:

SET GLOBAL table_definition_cache = 4096;
SET GLOBAL table_open_cache = 4096;

And XCA connected immediately. The defaults were 400.

I need to check setting higher defaults.

Thanks for the clue.

reetp avatar Sep 10 '24 17:09 reetp