Changes since 1.36.34

• Merge in auto package building using github ci
• On upgrade, always attempt re-applying the last db update. This helps when running proposed ppa
• Only use fps_report_interval for the logging of fps updates. Always update the db. This fixes cameras being listed as offline despite being fine due to a very long fps update interval
• Track Monitor_Status and FPS logging times separately. Update db every 10seconds.
• Don't output the boundary if we aren't streaming. Single jpegs don't need it and something was complaining about it
• Only output 403 status if not nph
• add MariaDB to docs
• • more ffmpeg5 deprecations
• Handle ffmpeg6 deprecating (renaming) pkt_duration
• ffmpeg7 fixes
• add logging of stream index in debug code
• Remove deprecated reconnect setting for mysql
• Auto reconnect when mysql is lost
• Replace deprecated mysql_ssl_set with mysql_options()
• Add getting the connection id from mysql and log it in zmDbDo. This is so that when mysql reports a dropped connection, we can figure out which process it was.
• Add debugging of db failures
• If an invalid port is specified, don't actually start the rtp threads. They don't get used in RTP/RTSP. Fixes [#3759]
• Default end_time to start_time on event creation so that we don't get a negative duration
• Don't start max score at -1 as that is not a valid value for the db.
• Add support for DateTime and Server advsearch filters
• Remove reorder_queue_size from output options to prevent logging
• Add event->Duration and use it when considering min_section_length because the first keyframe may have been quite a while ago and we can end up closing an empty event.
• Remove default of NOW from UpdatedOn in Monitor_Status field because old mysql can't handle it. Explicilty set it in zmc. Fixes [#4155]
• Use htmlspecialchars on Message to prevent Stored Cross-Site Scripting. Fixes GHSA-rqxv-447h-g7jx
• Fix crash in api when auth is turned off and you try to log in
• Add End Date Time and None as options for sorting in filters, which allows us to create more efficient SQL queries.
• Fix labelling for defaultCodec, as it is used for event viewing, not live view.
• Only show location tab when GEOLOCATION is turned on
• Fix zone edit image jumping around when status is alert
• Handle change of res/colours in zms by reloading the monitor object.
• Count keyframes on queuePacket so that analysis Ready() will start recording when there are enough packets in queue.
• Make NULL be case-insensitive in filter rules

A lot of back ports from 1.37. One security vulnerability fix. The main thrust was the mysql and ffmpeg deprecations. All users are encouraged to upgrade.

Updating the sort field on your filters can have a significant effect on mysql cpu/ram use. For example the Update Disk Space filter defaults to sorting by StartDateTime or ID which makes mysql not use the index on EndDateTime and DiskSpace. Since we don't care about the order we act on results, we don't need to sort at all. So on a large database this query can go from hitting every row in the table, to almost none.