Errors with X509 SSL Certificate Module

Icinga Web Modules
1

I encounter the following error when I try to execute a job:

[root@basbicinga ~]# icingacli x509 scan --job Daily
PHP Fatal error:  Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '1729773335000' for column `x509`.`x509_job_run`.`start_time` at row 1 in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php:402
Stack trace:
#0 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(402): PDOStatement->execute()
#1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(438): ipl\Sql\Connection->prepexec()
#2 /usr/share/icingaweb2/modules/x509/library/X509/Job.php(588): ipl\Sql\Connection->insert()
#3 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/Tick/FutureTickQueue.php(46): Icinga\Module\X509\Job->Icinga\Module\X509\{closure}()
#4 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/StreamSelectLoop.php(183): React\EventLoop\Tick\FutureTickQueue->tick()
#5 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/Loop.php(55): React\EventLoop\StreamSelectLoop->run()
#6 [internal function]: React\EventLoop\Loop::React\EventLoop\{closure}()
#7 {main}
  thrown in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php on line 402

Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '1729773335000' for column `x509`.`x509_job_run`.`start_time` at row 1 in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php:402
Stack trace:
#0 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(402): PDOStatement->execute()
#1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(438): ipl\Sql\Connection->prepexec()
#2 /usr/share/icingaweb2/modules/x509/library/X509/Job.php(588): ipl\Sql\Connection->insert()
#3 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/Tick/FutureTickQueue.php(46): Icinga\Module\X509\Job->Icinga\Module\X509\{closure}()
#4 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/StreamSelectLoop.php(183): React\EventLoop\Tick\FutureTickQueue->tick()
#5 /usr/share/icinga-php/vendor/vendor/react/event-loop/src/Loop.php(55): React\EventLoop\StreamSelectLoop->run()
#6 [internal function]: React\EventLoop\Loop::React\EventLoop\{closure}()
#7 {main}
  thrown in /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php on line 402

I upgraded the module and applied the new database schema from here

grafik

grafik

Additionally I get this error message when I open “Certificate Usage” in icingaweb:

grafik
grafik1364×533 56.4 KB

Here is my about:

grafik
grafik446×866 23.9 KB

2

I guess, it’s a version miss match as it works for me with this versions.

image
image434×792 19.9 KB

3

looks like some missing sql migration

2 Likes
4

Yes something broke with my installation.
I dropped the database for the module and created it again and now it works like it should :+1: