# Errors with X509 SSL Certificate Module

**URL:** <https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231>\
**Category:** Icinga Web Modules\
**Created:** [October 24, 2024, 12:41pm UTC](https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231 "2024-10-24T12:41:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![FK1985](https://community.icinga.com/user_avatar/community.icinga.com/fk1985/32/8097_2.png) [@FK1985](https://community.icinga.com/u/FK1985)\
**Post date:** [October 24, 2024, 12:41pm UTC](https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231/1 "2024-10-24T12:41:30Z")

</div>

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

```auto
[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](https://icinga.com/docs/icinga-certificate-monitoring/latest/doc/80-Upgrading/)

![grafik](https://community.icinga.com/uploads/default/original/2X/b/b4b24ee1147dae8890b42bdc3579d2ec7d36f86c.png)

![grafik](https://community.icinga.com/uploads/default/original/2X/1/12bdf066e47542cd536c9af77267089c9c8366eb.png)

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

 ![grafik](https://community.icinga.com/uploads/default/original/2X/0/09d9777d6dd025c2e39942949140d06da060f18a.png)

Here is my about:

 ![grafik](https://community.icinga.com/uploads/default/original/2X/3/3f8fb465f6968079ecb42986961b37a9198cac6f.png)

---

<div class="post-metadata">

**Author:** ![rivad](https://community.icinga.com/user_avatar/community.icinga.com/rivad/32/5852_2.png) [@rivad](https://community.icinga.com/u/rivad)\
**Post date:** [October 25, 2024, 7:09am UTC](https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231/2 "2024-10-25T07:09:20Z")

</div>

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

 ![image](https://community.icinga.com/uploads/default/original/2X/e/e09d3069baf546a6b62e240809b8996eca81884c.png)

---

<div class="post-metadata">

**Author:** ![moreamazingnick](https://community.icinga.com/user_avatar/community.icinga.com/moreamazingnick/32/7725_2.png) [@moreamazingnick](https://community.icinga.com/u/moreamazingnick)\
**Post date:** [October 25, 2024, 7:53am UTC](https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231/3 "2024-10-25T07:53:12Z")

</div>

looks like some missing sql migration

---

<div class="post-metadata">

**Author:** ![FK1985](https://community.icinga.com/user_avatar/community.icinga.com/fk1985/32/8097_2.png) [@FK1985](https://community.icinga.com/u/FK1985)\
**Post date:** [October 26, 2024, 2:10pm UTC](https://community.icinga.com/t/errors-with-x509-ssl-certificate-module/14231/4 "2024-10-26T14:10:16Z")

</div>

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