Reduce the default character limit for VARCHAR columns in MySQL (#16680)

Resolves #13920

Resolves #16678

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[radiothermostat] Skip shutdown actions if thing offline (#16677)

Signed-off-by: Michael Lobstein <michael.lobstein@gmail.com>

[Renault] Cockpit/odometer information no longer retrieved #16669 (#16675)

Signed-off-by: dougculnane <doug@culnane.net>

[CI] Add Java 21 compiling to J17 and native J21 (#16672)

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

[freeathomesystem] Initial contribution (#13703)

Signed-off-by: Andras Uhrin <andras.uhrin@gmail.com>

[evcc] Adjust to evcc 0.125.0 API changes (#16660)

* avoid deprecated parameters evcc rest API parameters 'batteryConfigured' and 'pvConfigured'

Signed-off-by: Michael Weger <weger.michael@gmx.net>

[openwebnet] Thermo: new channels and README updates (#16652)

* [openwebnet] added new channels: targetTemperature, heating and cooling to bus_thermo_zone
Fixes #12019
* [openwebnet] cleaner code in updateModeAndFunction() to handle *4*1*w## messages
* [openwebnet] Updated README. Added new device images

---------

Signed-off-by: Massimo Valla <mvcode00@gmail.com>

New translations livisismarthome.properties (Italian) (#16662)

[miio] Add Yeelight W3 RGB (#16659)

* fix: Added Yeelight W3 RGB props

cherrypicked from #7717221

Signed-off-by: Marcel Verpaalen <marcel@verpaalen.com>
* [miio] update readme

Signed-off-by: Marcel Verpaalen <marcel@verpaalen.com>
Co-authored-by: Igor Svehla <igor@taxtris.com>

[miio] add suppoprt Mijia Omni Robot Vacuum-Mop dreame.vacuum.p2114o (#16383)

* [miio] add suppoprt Mijia Omni Robot Vacuum-Mop dreame.vacuum.p2114o

Signed-off-by: Marcel Verpaalen <marcel@verpaalen.com>

[miio] add support for Xiaomi Smart Plug 2 cuco.plug.v2eur (#16381)

* [miio] add support for Xiaomi Smart Plug 2 cuco.plug.v2eur

Signed-off-by: Marcel Verpaalen <marcel@verpaalen.com>

Fix tariff time series update during spot price unavailability (#16654)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[openwebnet] Thermo: fixes update setPoint when local offset in in use (#16626)

Signed-off-by: Massimo Valla <mvcode00@gmail.com>

Resolve runbundles for Jollyday upgrade (#16632)

Related to openhab/openhab-core#4178

Signed-off-by: Wouter Born <github@maindrain.net>

Adjust retry policy for extended spot price unavailability (#16653)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

Fix handling of multiple sprinklers (#16630)

Signed-off-by: Mark Hilbush <mark@hilbush.com>

[openwebnet] Thermo: added support for HOLIDAY/VACATION central unit modes (#16605)

* [openwebnet] added vacationDays channel
* [openwebnet] Added support for HOLIDAY/VACATION Thermo CU modes.
Refactored Thermo mode handling using updated OWN lib.
Bump openwebnet lib to 0.13.0.
* [openwebnet] added checks for some corner cases

Signed-off-by: Massimo Valla <mvcode00@gmail.com>

Restrict CO2 emission datasets to price area DK1/DK2 (#16649)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[tr064] Enable fourth WiFi channel and improvements (#16650)

Signed-off-by: Jan N. Klug <github@klug.nrw>

Improve error handling for action calculatePrice (#16651)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

Log warning when spot prices are unavailable (#16648)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

Resolves issue #16629 (#16640)

Signed-off-by: gael@lhopital.org <gael@lhopital.org>

[network] Fix NumberFormatException for ping when locale has comma as decimal separator (#16636)

* fixing bug:
LatencyParser fails to parse ping times on systems with comma (,) set as decimal separator

Signed-off-by: Stephan Richter <s.richter@srsoftware.de>

Bypass WAF by using app user-agent (#16644)

Resolves #16517

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[harmonyhub] Updates harmony library, uses strings for ids (#16646)

See #6732

Signed-off-by: Dan Cunningham <dan@digitaldan.com>

[mybmw] Fix images not loading anymore (#16643)

* [mybmw] fix image not loading anymore Fixes #16642

Signed-off-by: Martin Grassl <martin.grassl@digital-filestore.de>

[deutschebahn] Fix example and update links (#16645)

* [deutschebahn] Fix example and update links

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

Update tariff filter for Radius (#16634)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[telegram] Functionality added to delete a Query (#16631)

* [telegram] Functionality added to delete a Query

Signed-off-by: Christoph <fd0cwp@gmx.de>

[tibber] Add two channels: consumption and production for current hour (#16623)

* Add 2 new live channels; consumption and production this hour (since last hour shift)

Signed-off-by: Arne Seime <arne.seime@gmail.com>

[mqtt] fix UnDefType comparison in PercentageValue (#16639)

Signed-off-by: Cody Cutrer <cody@cutrer.us>

[jrubyscripting] Fix an error in received_command example (#16637)

Signed-off-by: Jimmy Tanagra <jcode@tanagra.id.au>

Provide unit hints for humidity/noise/volume channels (#16614)

* Provide unit hints for humidity channel types

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>
* Provide unit hints for noise/volume channel types

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>
---------

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[knx] Add JaCoCo test-coverage (#16507)

Test coverage analysis is based on JaCoCo tool.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

Provide unit hint for water consumption channel (#16621)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[intesis] Session Handling improved (#16620)

Signed-off-by: Christoph <fd0cwp@gmx.de>

[siemensrds] Remove r.H. from humidity state description pattern (#16616)

Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>

[lifx] Add support for new LIFX products (#16618)

* [lifx] Add support for new LIFX products

Allows for discovering all the new LIFX products and their features including:

* LIFX Ceiling
* LIFX Outdoor Neon
* LIFX PAR38
* LIFX Round/Square Path
* LIFX Round Spot

See:

* https://github.com/LIFX/products/blob/master/products.json
* https://www.lifx.com/products/neon-flex-16ft-outdoor
* https://www.lifx.com/products/supercolor-1600lm-par38
* https://www.lifx.com/products/spot-light-round
* https://www.lifx.com/products/path-light-round
* https://www.lifx.com/products/path-light-square

Signed-off-by: Wouter Born <github@maindrain.net>

[hue] fix npe (#16619)

Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>

[lutron] Implement button press notifications for Picos from LEAP (#16550)

* [lutron] implement button press notifications for Picos from LEAP
* reverse equality check for null safety

Signed-off-by: Cody Cutrer <cody@cutrer.us>

[miio] Add Roborock S7/S7MaxV mop mode (#16608)

* [miio] Add Roborock S7/S7MaxV mop mode
Signed-off-by: Ruediger Sopp <ruediger.sopp@gmail.com>

[persistence.jpa] Pin to Java 17 (#16612)

This is a workaround to allow compiling with Java 21.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

[enocean] Fix Java 21 build (#16615)

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

Improve handling of error code 14 (#16613)

Signed-off-by: Mark Hilbush <mark@hilbush.com>

[Senec] Add request timeout (#16611)

Fixes #12900. Add a timeout for requests to the local Senec device. Currently there may occur some endlessly hanging requests which basically freeze the values provided by the binding.

Signed-off-by: Stefan Sedlmaier <github@ssedlmaier.de>

Bump maven-compiler-plugin to 3.13.0 (#16609)

Avoid ZipException with ejc >3.30.0.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

[hue] Improve color setting (#16436)

* [hue] fix xy conversion when B is 0
* [hue] remove gamut correction; let Hue bridge do it instead
* [hue] fix gamma round trips; modernize instanceof syntax

Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>

Provide better MySQL datatype for DateTimeType (#16604)

Resolves #15697

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

Move to JUPnP v3.0.1 (#16598)

Signed-off-by: Laurent Garnier <lg.hc@free.fr>

Declare countries (#16603)

Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

New translations tado.properties (Italian) (#16602)

Update Cloud Connector installation procedure (#16601)

Signed-off-by: sihui <10405486+sihui62@users.noreply.github.com>

[mqtt.homie] build a per-thing thing type (#15893)

* [mqtt.homie] build a per-thing thing type

Signed-off-by: Cody Cutrer <cody@cutrer.us>

[tado] Change humidity and heatingPower channels to QuantityType (#16531)

* [tado] tweaks to xml

Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>

Allow for compiling with Java 21 (#16594)

* Support Java 17 and 21, default compilation to Java 17 class files
* Add profile "j21" to compile to Java 21 class files
* Bump ecj to 3.36.0

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

[boschshc] Add support for Dimmer (#16501)

Adds support for Bosch Smart Home Dimmer devices.

Signed-off-by: David Pace <dev@davidpace.de>

[upnpcontrol] Catch IAE when Album Art URI is invalid (#16597)

Fixes #16595

Signed-off-by: Wouter Born <github@maindrain.net>

[lutron] update instructions for LEAP authentication (#16510)

* [lutron] update instructions for LEAP authentication

Signed-off-by: Cody Cutrer <cody@cutrer.us>

[boschshc] Boost unit test coverage (#16500)

Boosts the unit test coverage for the `boschshc` binding in `src/main/java` to 94%.

Signed-off-by: David Pace <dev@davidpace.de>

[knx] Upgrade Calimero to 2.6-rc1 (#16588)

* [knx] Upgrade Calimero to 2.6-rc1
- Bugfixes and new subtypes for DPTs 20, 21, 22.
- Remove workarounds for issues in v2.5.1.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

Upgrade SAT plugin to 0.16.0 (#16582)

Modify code which leads to build error with new version of SpotBugs.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

[boschshc] Add support for Light/Shutter Control II (#16400)

* [boschshc] Add support for Shutter Control II (#14562)
* add new channel type for child protection

Signed-off-by: David Pace <dev@davidpace.de>

[shelly] Add support for Range Extender feature (#16419)

* Add support for Shelly Range Extender mode (Plus/Pro series only)
* Check for secondary devices also when manual scan is triggered

Signed-off-by: Markus Michels <markus7017@gmail.com>

[dynamodb] Enable tests (#16554)

Add missing dependencies after Karaf upgrade #16493.

Fixes #16535.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

Bump Kotlin, okhttp, okio, and java-telegram-bot-api libraries (#16458)

* update libs

Signed-off-by: Matthew Skinner <matt@pcmus.com>

Complement to issue #16561 (#16589)

Signed-off-by: gael@lhopital.org <gael@lhopital.org>

[netatmo] Enhance RefreshCapability (#16574)

Signed-off-by: clinique <gael@lhopital.org>
Signed-off-by: gael@lhopital.org <gael@lhopital.org>

[linky] Binding stopped working (#16586)

* Change lincs entrypoint

Signed-off-by: gael@lhopital.org <gael@lhopital.org>

[jsscripting] Fix memory leak on script execution failure (#16578)

Make engineIdentifier a instance field to ease debugging.

Signed-off-by: Florian Hotze <florianh_dev@icloud.com>

[rrd4j] Fix missing service pid (#16569)

Signed-off-by: Jan N. Klug <github@klug.nrw>

[mongodb] Fix missing service pid (#16568)

Signed-off-by: Jan N. Klug <github@klug.nrw>

[mapdb] Fix missing service pid (#16567)

Signed-off-by: Jan N. Klug <github@klug.nrw>

[mail] Fix sending HTML mails (#16587)

Signed-off-by: Jan N. Klug <github@klug.nrw>

[mail] Fix content processing (#16580)

Signed-off-by: Jan N. Klug <github@klug.nrw>

[jsscripting] Upgrade to openhab-js 4.9.0 (#16576)

Signed-off-by: Florian Hotze <florianh_dev@icloud.com>

[netatmo] Add a buffer to lower Home API requests (#16562)

* Adding CacheCapability to HomeAPI

---------

Signed-off-by: clinique <gael@lhopital.org>
Signed-off-by: gael@lhopital.org <gael@lhopital.org>

Enhance getActiveChildren() (#16573)

Signed-off-by: clinique <gael@lhopital.org>

[netatmo] Enhance bridge status reporting (#16571)

* Enhance bridge status reporting

---------

Signed-off-by: clinique <gael@lhopital.org>

Synchronized Weather cache update requests (#16572)

Signed-off-by: clinique <gael@lhopital.org>

Enable accumulated channels for Shelly Pro 3EM (#16566)

Signed-off-by: Leif Bladt <leif.bladt@gmx.de>

Use mac address as a fallback name (#16547)

Signed-off-by: Holger Hees <holger.hees@gmail.com>

[inmemory] Fix boundaries for queries (#16563)

Queries should include the boundaries, but the previous code did not.

Signed-off-by: Jan N. Klug <github@klug.nrw>

[Jellyfin] Overhaul README.md (#16359)

* Overhaul README.md

- Fix some typos
- Add some code brackets
- Some formatting changes

* Minor spelling and grammar changes

Signed-off-by: Felix Schneider <fs@felix-schneider.org>

[modbus.sungrow] Add missing sungrow bundle (#16557)

Fixes #16558

Signed-off-by: Wouter Born <github@maindrain.net>

Amend README with missing bridge configuration parameter (#16556)

Signed-off-by: Georgios Moutsos <georgios.moutsos@gmail.com>

[systeminfo] Use the existing ChannelUID instance to check the linked state (#16553)

Signed-off-by: Jörg Sautter <joerg.sautter@gmx.net>

[rotel] Support added for model RX-1052 (#16486)

* Two new channels to enable/disable speaker A and speaker B

Signed-off-by: Laurent Garnier <lg.hc@free.fr>

[netatmo] Bring back auto refresh for Weather Station and HomeCoach (#16546)

* Corrects and completes PR #16492

---------

Signed-off-by: gael@lhopital.org <gael@lhopital.org>

Reverting incorrect code move (#16548)

Signed-off-by: gael@lhopital.org <gael@lhopital.org>

Avoiding reads of Energy data for Security channels (#16543)

Signed-off-by: clinique <gael@lhopital.org>

[jythonscripting] Updated documentation (#16541)

Signed-off-by: Holger Hees <holger.hees@gmail.com>

[systeminfo] Add CPU frequency channels (#16012)

Signed-off-by: Mark Herwege <mark.herwege@telenet.be>

[hue] Shrink step size for increase/decrease commands (#16538)

A step size of 30 with a value range of 0..100 leads to only 4 steps,
which additionally are spaced unevenly. Shrink the step size to 10,
which yields 10 evenly spaced steps.
While at it, also deduplicate the increase/decrease code, which had
slightly different implementation in both branches.

Signed-off-by: Danny Baumann <dannybaumann@web.de>

[openwebnet] Thermo: Fixed handling of mode=AUTO for bus_thermo_zone (#16534)

* [openwebnet] improved Thermo mode/weekly/scenario channels descriptions
* [openwebnet] Fixed handling of mode=AUTO for bus_thermo_zone
Fixes #13754

---------

Signed-off-by: Massimo Valla <mvcode00@gmail.com>

[avmfritz] Disable unstable AVMFritzDiscoveryServiceOSGiTest (#16537)

See: https://github.com/openhab/openhab-addons/issues/16536

Signed-off-by: Wouter Born <github@maindrain.net>

[jythonscripting] Refactor, improve and simplify (#16508)

* moved implementation to 'internal'
* refactored JythonScriptEngineFactory
* implemented JythonScriptFileWatcher
* fixed addon.xml & package-info.java
* simplify stream list collector in JythonScriptEngineFactory
* changed codeowner for jythonscripting
* organized imports in JythonScriptEngineFactory

Signed-off-by: Holger Hees <holger.hees@gmail.com>

[netatmo] Thing properties were no more provided (#16530)

Signed-off-by: clinique <gael@lhopital.org>

[ecovacs] Add support for new API for fetching cleaning logs (#16524)

The existing cleaning logs API is only populated for devices older than
the T9/N9 generation; all newer devices use a new API. Since the new API
isn't populated for older devices, select the correct API depending on
device type.

Signed-off-by: Danny Baumann <dannybaumann@web.de>

Upgrade to Karaf 4.4.5 (#16493)

For release notes, see:
https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12353604&projectId=12311140

* [dynamodb] Disable tests

Tests are disabled due to compatibility issue of DynamoDBLocal and Jetty upgrade #16493.
To be resolved in subsequent commit.

Signed-off-by: Holger Friedrich <mail@holger-friedrich.de>

New Crowdin updates (#16526)

* New translations netatmo.properties (Italian)
* New translations energidataservice.properties (Italian)