I’ve just finished adding reporting to my Icinga2 installation. Works well - even manually triggering an email to send the report as a PDF attachment works a treat.
I’m now trying to schedule the SLA reports to be sent out at the beginning of every month but was unable to save the form. It returned the General error below when I clicked the Create Schedule button. I searched for this specific error via Google, Github, and the forums here to no avail.
Anyone else seen this and was able to resolve?
SQLSTATE[HY000]: General error: 1364 Field 'start' doesn't have a default value
icinga2 - The Icinga 2 network monitoring daemon (version: r2.14.0-1)
Copyright (c) 2012-2023 Icinga GmbH (https://icinga.com/)
License GPLv2+: GNU GPL version 2 or later <https://gnu.org/licenses/gpl2.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
System information:
Platform: Ubuntu
Platform version: 22.04.2 LTS (Jammy Jellyfish)
Kernel: Linux
Kernel version: 5.19.0-1029-aws
Architecture: x86_64
Build information:
Compiler: GNU 11.3.0
Build host: runner-hh8q3bz2-project-575-concurrent-0
OpenSSL version: OpenSSL 3.0.2 15 Mar 2022
Application information:
General paths:
Config directory: /etc/icinga2
Data directory: /var/lib/icinga2
Log directory: /var/log/icinga2
Cache directory: /var/cache/icinga2
Spool directory: /var/spool/icinga2
Run directory: /run/icinga2
Old paths (deprecated):
Installation root: /usr
Sysconf directory: /etc
Run directory (base): /run
Local state directory: /var
Internal paths:
Package data directory: /usr/share/icinga2
State path: /var/lib/icinga2/icinga2.state
Modified attributes path: /var/lib/icinga2/modified-attributes.conf
Objects path: /var/cache/icinga2/icinga2.debug
Vars path: /var/cache/icinga2/icinga2.vars
PID path: /run/icinga2/icinga2.pid
PHP version used (`php --version`)
PHP 8.1.2-1ubuntu2.13 (cli) (built: Jun 28 2023 14:01:49) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.2, Copyright (c) Zend Technologies
with Zend OPcache v8.1.2-1ubuntu2.13, Copyright (c), by Zend Technologies
Server operating system and version: Ubuntu 22.04.2 LTS
Interestingly, I restarted the old server - Icinga v2.9.3 - and there I’m able to save the schedule and after running the schedule I found the report in my inbox.
So, it looks like the latest version has broken something
# icinga2 --version
icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.1-1)
Copyright (c) 2012-2023 Icinga GmbH (https://icinga.com/)
License GPLv2+: GNU GPL version 2 or later <https://gnu.org/licenses/gpl2.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
System information:
Platform: Ubuntu
Platform version: 20.04.6 LTS (Focal Fossa)
Kernel: Linux
Kernel version: 5.4.0-155-generic
Architecture: x86_64
Build information:
Compiler: GNU 8.4.0
Build host: runner-hh8q3bz2-project-508-concurrent-0
OpenSSL version: OpenSSL 1.1.1f 31 Mar 2020
Application information:
General paths:
Config directory: /etc/icinga2
Data directory: /var/lib/icinga2
Log directory: /var/log/icinga2
Cache directory: /var/cache/icinga2
Spool directory: /var/spool/icinga2
Run directory: /run/icinga2
Old paths (deprecated):
Installation root: /usr
Sysconf directory: /etc
Run directory (base): /run
Local state directory: /var
Internal paths:
Package data directory: /usr/share/icinga2
State path: /var/lib/icinga2/icinga2.state
Modified attributes path: /var/lib/icinga2/modified-attributes.conf
Objects path: /var/cache/icinga2/icinga2.debug
Vars path: /var/cache/icinga2/icinga2.vars
PID path: /run/icinga2/icinga2.pid
# php --version
PHP 7.4.3-4ubuntu2.19 (cli) (built: Jun 27 2023 15:49:59) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.3-4ubuntu2.19, Copyright (c), by Zend Technologies
The latest version you’re talking about is the default branch of the repository. This isn’t a release and as such you’re using it at your own risk. There’s probably a database upgrade necessary, but mind you, don’t apply it if you’re not in the mood to revert it once the next release is out.
I see where I went wrong now but at the time, it all seemed to work correctly as I was seeing the expected version numbers. I’ve now checked out tag v0.10.0 which works as expected. I did not have to change anything else - i.e. pdfexport and idoreports are both on the default branch as cloned. Since it is working fine at the moment, I’ll leave them as is.
