Consider TimeZoneProvider to build states for time-stamp channels (#13386)

Signed-off-by: Christoph Weitkamp <github@christophweitkamp.de>

fix README.md (#13387)

Signed-off-by: Alexander Friese <af944580@googlemail.com>

Fix date cast exception (#13382)

After upgrading mysql-connector to 8.0.30 this exception was thrown: class java.time.LocalDateTime cannot be cast to class java.sql.Timestamp

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

[fineoffsetweatherstation] Fix measurands (#13381)

* fix the PIEZO_GAIN10 measurand
* skip RAIN_PRIO measurand
* skip RCSATION measurand

Signed-off-by: Andreas Berger <andreas@berger-freelancer.com>

[velux] Correction to channel label (#13379)

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

[velux] Vane position channel is visible when required (#13271)

* [velux] make vanePosition channel dynamic
* [velux] change category of window position from 'blinds' to 'window'

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

[systeminfo] Add CPU load channel, update dependencies (#13292)

* Add CPU load channel, update dependencies
* use PercentType, correct process CPU load
* Add and fix test

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

[rotel] New channel to select FM/DAB/iRadio preset (#13285)

* [rotel] New channel to select FM/DAB/iRadio preset

For models RCX-1500, RDG-1520, RT-11, RT-1570, T11 and T14

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

New translations unifi.properties (Dutch) (#13372)

[linky] Docker specificities (#13348)

Related to #13336

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

[unifi] Fix portoverride to not remove any other data (#13362)

When a user has configured additional settings on a PoE port, like name.
These settings where lost when changing the PoEPort status in openHAB.
This was because in the binding only some information of the override was stored and when writing the new state this information would have been sent too.
In this change the object to store the override has been replaced by a plain json object. Therefore we don't have to know what is in it and all information is kept.

Signed-off-by: Hilbrand Bouwkamp <hilbrand@h72.nl>

[Easee] Initial contribution (#12954)

* initial binding version

Signed-off-by: Alexander Friese <af944580@gmail.com>

[hdpowerview] Correct shade capabilities information (#13330)

* [hdpowerview] corrections to capabilities database

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

[Konnected] Taking configured onValue into account when sending status to actuator (#13360)

* Taking configured onvalue into account when sending status to actuator
* Added documentation for onValue configuration

Signed-off-by: Haavar Valeur <haavar@haavar.com>

New translations shelly.properties (German) (#13366)

[upnpcontrol] Prepare dynamic channels and status messages for translation (#13364)

* prepare dynamic channels and status messages for translation

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

[jablotron] Added thermometers support for JA100F alarms (#13361)

Signed-off-by: Ondrej Pecta <opecta@gmail.com>

Fixed example thing. Made names less ambiguous (#13363)

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[dsmr] Made additional key for smarty meter an option (#13359)

* [dsmr] Made additional key for smarty meter optional

Signed-off-by: Hilbrand Bouwkamp <hilbrand@h72.nl>

[remoteopenhab] Fix the pattern to parse DateTime (#13349)

Re-use the same pattern as defined in class DateTimeTyoe.

Allows the support of 0 to 9 digits after the seconds.

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

[Konnected] Using default onvalue if configured is null (#13354)

* Using default onvalue if configured is null
* Using DTO for channel configuration. Changing channel config parameter names to camel case

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[remoteopenhab] Handle REFRESH command as any command (#13350)

The received command (REFRESH) is transmitted as a REFRESH command to
the remote item.

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

[nuvo] Fix MPS4 flag and online status reporting (#13345)

* Fix mps4 flag and online status reporting
* Update missing statuses

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

[avmfritz] Allow to set every userdefined color (#13317)

* Added INCREASE/DECREASE commands for brightness/color Channels
* Fixed NPE in HeatingModel
* Use set unmapped color command for color control of bulbs

Signed-off-by: Christoph Weitkamp <github@christophweitkamp.de>

Update API URL. (#13306)

Signed-off-by: Stewart Cossey <stewart.cossey@gmail.com>

[mimictts] Use http method POST instead of GET (#13239)

* [mimictts] Use http method POST instead of GET

Using POST method allows longer request size.
Also, using InputStreamResponseListener avoid keeping the response in-memory

* [mimictts] quick fix for regression : providing length

Some audiosink needs it

Signed-off-by: Gwendal Roulleau <gwendal.roulleau@gmail.com>

New translations fineoffsetweatherstation.properties (Italian) (#13341)

Upgrade MySQL connector to 8.0.30 (#13242)

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

[fineoffsetweatherstation] Add support for the new GW2001 weather station (#13283)

* [fineoffsetweatherstation] add support for the new GW2001 weather station with its WH90 sensor
* [fineoffsetweatherstation] add missing channel labels
* [fineoffsetweatherstation] remove redundant translations
* [fineoffsetweatherstation] add test data + fix for WH90
* [fineoffsetweatherstation] fix wrong size for `CMD_READ_RAIN`

Signed-off-by: Andreas Berger <andreas@berger-freelancer.com>

[boschindego] Add another status code for returning to dock (#13335)

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

[Konnected] Removed defaults for zone configuration parameter from the channels (#13333)

* Removed defaults from zone parameter
* Corrected the name of the zone property in example

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[rrd4j] Use RrdDbPool to prevent ClosedByInterruptException (#13332)

Using the pool prevents exceptions like:

```
java.nio.channels.ClosedByInterruptException: null
at java.nio.channels.spi.AbstractInterruptibleChannel.end(AbstractInterruptibleChannel.java:199) ~[?:?]
at sun.nio.ch.FileChannelImpl.endBlocking(FileChannelImpl.java:162) ~[?:?]
at sun.nio.ch.FileChannelImpl.size(FileChannelImpl.java:388) ~[?:?]
at org.rrd4j.core.RrdNioBackend.<init>(RrdNioBackend.java:94) ~[?:?]
at org.rrd4j.core.RrdNioBackendFactory.open(RrdNioBackendFactory.java:163) ~[?:?]
at org.rrd4j.core.RrdBackendFactory.getBackend(RrdBackendFactory.java:521) ~[?:?]
at org.rrd4j.core.RrdDb.<init>(RrdDb.java:627) ~[?:?]
at org.rrd4j.core.RrdDb.of(RrdDb.java:500) ~[?:?]
at org.openhab.persistence.rrd4j.internal.RRD4jPersistenceService.getDB(RRD4jPersistenceService.java:323) ~[?:?]
at org.openhab.persistence.rrd4j.internal.RRD4jPersistenceService.store(RRD4jPersistenceService.java:141) ~[?:?]
at org.openhab.persistence.rrd4j.internal.RRD4jPersistenceService.lambda$0(RRD4jPersistenceService.java:211) ~[?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
```

Fixes #13297

Also includes a few code improvements.

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

[Konnected] Fixed null pointer exception on state update with missing state (#13329)

* Fixed null pointer exception on state update with missing state
* Added variable for state. Changed onvalue configuration type to integer.

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[jrubyscripting] avoid polluting environment when auto-installing gems (#13328)

fixes https://github.com/boc-tothefuture/openhab-jruby/issues/634;
regression from https://github.com/openhab/openhab-addons/pull/13151

Signed-Off-By: Cody Cutrer <cody@cutrer.us>

[fineoffsetweatherstation] Add information about unsupported devices (#13307)

* [fineoffsetweatherstation] add information about unsupported devices

Signed-off-by: Andreas Berger <andreas@berger-freelancer.com>

[hdpowerview] Battery channels visible only when required (#13324)

* [hdpowerview] add batteryKind field
* [hdpowerview] battery channels visible depending on batteryKind

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

Nobø hub addon: Add more component types with serial numbers. (#13326)

Minor change which gives more properties to detected things, which
should make a little easyer for users with these devices to identify them.

Signed-off-by: Jørgen Austvik <jaustvik@acm.org>

[myStrom] Corrected readMe, mystrompir is not a bulb. (#13322)

* Corrected ReadMe, mystrompir is not a bulb.

Signed-off-by: Stefan Navratil <stefan@navratil.ch>

[wemo] Add Wemo Outdoor plug (#13319)

Signed-off-by: bill <git@billforsyth.net>

New translations mqtt.properties (Italian) (#13323)

[mqtt] Add missing broker connection configuration parameters (#13303)

Allows to configure the following broker connection configuration parameters:

* Protocol: TCP (default), WEBSOCKETS
* MQTT Version: V3 (default), V5
* Hostname Validation: true (default), false

The defaults are chosen to remain backwards compatible.

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

[mail] Correct action names (#13318)

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

[bluetooth] Add support for service data (#10278)

Signed-off-by: Peter Rosenberg <prosenb.dev@gmail.com>

New translations mercedesme.properties (Italian) (#13312)

[mercedesme] Initial contribution (#13044)

Signed-off-by: Bernd Weymann <bernd.weymann@gmail.com>

[hdpowerview] Channels are visible depending on shade capabilities (#13275)

* [hdpowerview] create channels dynamically
* [hdpowerview] revert from channel creation to channel removal
* [hdpowerview] add category

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

[nobohub] Initial contribution (#12937)

* Added NoboHub binding.

Signed-off-by: Espen Fossen <espenaf@junta.no>

[lutron] Add mDNS discovery for RadioRA 3 processor (#13299)

Signed-off-by: Bob Adair <bob.github@att.net>

[jrubyscripting] document how to use Ruby in a transformation (#13286)

using the core ScriptTransformationService. See
https://github.com/openhab/openhab-addons/pull/13255 for prior
discussion on this.

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

Adapt to AccessTokenResponse API change (#13278)

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

[smhi] Prepare for easier translation (#13305)

Signed-off-by: Anders Alfredsson <andersb86@gmail.com>

Setting auto discovered callback URL in configuration. Cleaned up callback URL handling (#13295)

Signed-off-by: Haavar Valeur <haavar@haavar.com>

New translations fineoffsetweatherstation.properties (Italian) (#13300)

[Konnected] Refreshed readme to include latest changes (#13294)

* Refreshed readme to include latest changes

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[transformation.jinja] Update jinjava to 2.6.0 from 2.5.7 (#13296)

Signed-off-by: Sami Salonen <ssalonen@gmail.com>

New Crowdin updates (#13291)

* New translations shelly.properties (German)
* New translations goecharger.properties (Italian)

[fineoffsetweatherstation] Add channel for the sensors battery voltage (#13284)

* [fineoffsetweatherstation] add channel for the sensors battery voltage

Signed-off-by: Andreas Berger <andreas@berger-freelancer.com>

Solves issue #13196 (#13281)

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

Add transaction to Go-Echarger (#13105)

Signed-off-by: Sascha Kloß <sascha.kloss@gmx.de>

[jrubyscripting] Update to jruby 9.3.7.0 to fix BootstrapMethodError (#13280)

* [jrubyscripting] Update to jruby 9.3.7.0
* [jrubyscripting] Exception fixed in jruby 9.3.7.0

The BootstrapMethodError should no longer be thrown by jruby since 9.3.7. Fixed in https://github.com/jruby/jruby/pull/7271

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

return rollershutter pos (#13191)

Signed-off-by: Tobias Lange <vich-667@gmx.de>

[Hydrawise] concurrent error (#13268)

* Fixes a concurrent modification exception, cleans up handler on dispose, fixes totally broken last contact channel
Fixes #13094

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

[tado] Fix AC target temperature reading and writing bugs (#13272)

* [tado] fix npe when target temperature json element is missing
* [tado] apply temperature command/value restrictions

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

Refresh token if expired (#13274)

Signed-off-by: Boris Krivonog <boris.krivonog@inova.si>

[automower] Adapt login due to Husqvarna API change (#13263)

* The Automower Connect API Authentication does not work anymore as they moved to a new authentication method. (AppKey and AppSecret) - adopted. Fixes issue #12980.

Signed-off-by: Boris Krivonog <boris.krivonog@inova.si>

New translations boschindego.properties (Danish) (#13269)

[serial] Allow custom baudrate and add option 2400 (#13265)

Fix #13131

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

[velux] Add an action to simultaneously set main and vane positions (#13199)

* [velux] add moveMainAndVane action
* [velux] add claridications to read me
* [velux] refactor actions and translate
* [velux] fix thing lookup

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

[miio] adding support for ijai.vacuum.v19 : Xiaomi Vacuum Mop 2S (#12723)

Signed-off-by: Tiller <github.me@tiller.fr>

[mielecloud] Adapt to inbox api changes (#13185)

* No unneccessary calls to thingRegistry.get
* Handle Inbox.add now returning CompletableFuture

Signed-off-by: Björn Lange <bjoern.lange@itemis.de>

[pwm] Fix handling of "maxDutyCycle" parameter value (#12197)

* [pwm] Fix handling of "maxDutyCycle" parameter value

Signed-off-by: Andriy Yemets <cyborg.andy@gmail.com>
* [pwm] Clarify behavior of the parameters

Signed-off-by: Andriy Yemets <cyborg.andy@gmail.com>
* [pwm] Update README.md (#12196)

Fixed description for maxDutycycle parameter
Added two new parameters: equateMinToZero and equateMaxToHundred

Signed-off-by: Andriy Yemets <cyborg.andy@gmail.com>
* Update bundles/org.openhab.automation.pwm/src/main/java/org/openhab/automation/pwm/internal/handler/PWMTriggerHandler.java

Signed-off-by: Fabian Wolter <github@fabian-wolter.de>
* Update bundles/org.openhab.automation.pwm/src/main/java/org/openhab/automation/pwm/internal/handler/PWMTriggerHandler.java

Signed-off-by: Fabian Wolter <github@fabian-wolter.de>
Signed-off-by: Andriy Yemets <cyborg.andy@gmail.com>
Signed-off-by: Fabian Wolter <github@fabian-wolter.de>
Co-authored-by: Fabian Wolter <github@fabian-wolter.de>

Support one decimal for pressure value (#13257)

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

New translations gardena.properties (German) (#13256)

[Konnected] Adding base URL to config to allow for manually adding thing (#13251)

* Adding base URL to config to allow for manually adding thing
* Simplified reading of the base URL configuration. Renamed field to baseUrl to be consistent.
* Changed config parameters to camel case

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[gardena] synchronized (#13253)

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

[gardena] Fixed connection tracker (#13238)

* Removed provider header, no longer necessary
* Fixed connection tracker not starting after some websocket restarts

Signed-off-by: Gerhard Riegler <gerhard.riegler@gmail.com>

[rotel] Set model and firmware properties (#13240)

For all models providing these information and relying on ASCII protocol.
The binding now supports reading of status message containing variable length content.

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

Add RSSI channel to intesisHome and fixed some NPEs (#13244)

Signed-off-by: Hans-Jörg Merk <github@hmerk.de>

[homekit] allow multiple bridge instances to break the 150 limit (#13226)

fixes #11508, #12927

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

[velux] Implement new API, and log critical device errors (#13212)

* [velux] use new API, and log StatusReply codes
Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>
Signed-off-by: Andrew Fiddian-Green <software@whitebear.ch>

New translations sonos.properties (French) (#13250)

[broadlinkthermostat] Fix parameter name in README (#13246)

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

[sonos] Unit tests added for OPML request parsing (#13245)

Fix a typo in previous unit tests

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

[sonos] Ignore TRANSITIONING device state when updating channels (#13241)

* [sonos] Ignore TRANSITIONING device state when updating channels
* Remove TRANSITIONING state option

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

[sonos] Added support of RadioApp music service (#13235)

* [sonos] Added support of RadioApp music service
* Extract artist and song title from TITLE
* Extract code in methods to reduce the size of the method updateMediaInformation
* Create new class and add tests

Fix #13208

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

[jdbc] Update PostgreSQL JDBC driver to 42.4.1 (#13221)

Bumps [postgresql](https://github.com/pgjdbc/pgjdbc) from 42.3.3 to 42.4.1.
- [Release notes](https://github.com/pgjdbc/pgjdbc/releases)
- [Changelog](https://github.com/pgjdbc/pgjdbc/blob/master/CHANGELOG.md)
- [Commits](https://github.com/pgjdbc/pgjdbc/compare/REL42.3.3...REL42.4.1)

Also-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Signed-off-by: Jacob Laursen <jacob-github@vindvejr.dk>

[myStrom] Added Motionsensor and API Token (#13201)

* Added API Token to configuration.
* Added motionsensor to myStrom binding.
* Added SPDX Header.
* fix: removed unnecessary updateStatus().

Signed-off-by: Stefan Navratil <stefan@navratil.ch>

[shelly] Improved TRV profile handling (selectable list via dynamic state options (#13227)

provider); some improvements & fixes

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

[konnected] Added support for Konnected Pro (#13180)

* - bug fix in konnnected handler to update change of smarthome units to Units
- multiple changes to code to enable support for the konnected pro-module
* Added optional configuration for callback URI
* Added support for more than one buzzer sound. Made zone/pin variables consistent. Removed preconfigured channels to be consistent (either all should be added or none).

Signed-off-by: Haavar Valeur <haavar@haavar.com>

[homekit] support actual booleans in metadata config (#13228)

as well as strings, too.

reduces confusion, if someone doesn't know it needed to be a string

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

[knx] Add support for KNX IP Secure (#12709)

* [knx] Add support for KNX IP Secure

* add support for KNX IP Secure, new options SECURETUNNEL and
  SECUREROUTER, refers to #8872
* add config options for credentials for secure connections
* update user documentation
* add test cases

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

New translations jruby.properties (Italian) (#13229)

[homekit] fix collecting characteristics that don't belong to a complex accessory (#13233)

given:

```
Group eThermostat { homekit="Thermostat" }
Number:Temperature Thermostat_AmbTemp (eThermostat) { homekit="CurrentTemperature" }
Number:Temperature Thermostat_SetTemp (eThermostat) { homekit="TargetTemperature" }

Group gThermostatZoneContacts
// in reality there are multiple thermostats and multiple of these groups,
// so that a rule on members of gThermostatZoneContacts can find the related
// thermostat to turn it off when a window is open
Group:Contact:OR(OPEN,CLOSED) gWindows (eThermostat, gThermostatZoneContacts)

Contact Window_Contact (gWindows) { homekit="ContactSensor" }
```

When constructing the Thermostat accessory for eThermostat, detects the
Window_Contact as a mandatory characteristic, because it's a base accessory
in a nested group. This leads to lots of warnings about the temperature
value of a contact item being out of range.

The fix is two-fold - first of all, there's no reason to search nested
groups for characteristics of a complex accessory. Second of all,
even if for some reason you were to nest an accessory in an accessory,
the nested accessory does not actually belong to the outer accessory,
so don't add it as a mandatory characteristic of the outer.

I suspect there's still one more bug, because AbstractHomekitAccessoryImpl.
getCharacteristic(HomekitCharacteristicType.CURRENT_TEMPERATURE) was
returning Window_Contact, which is only tagged as a ContactSensor. But
after fixing the above two bugs, it was no longer reproducible, and I
didn't continue digging.

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

[homekit] fix window coverings based on groups of  rollershutters (#13232)

it was getting the state as a decimal type, not a percent type, so
it was getting 1 instead of 100.

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

[daikin] Fix changing specialmode from ECO to NORMAL (#13230)

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

[rotel] Other commands added for RSP-1576, RSP-1582, RAP-1580, RDD-1580, RA-1592, RC-1590 (#13223)

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

[jrubyscripting] check if gems are installed before installing them (#13151)

* [jrubyscripting] check if gems are installed before installing them

this avoids unecessary downloads and overwrites, or even more importantly
errors if the GEM_HOME is not writable by the openhab user.

this also adds a configuration option for if you want to check for
updates every time configuration is applied (or openhab restarts). this
is useful if your OpenHAB system can't access the internet regularly.

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

[tapocontrol] included P115 smart-socket (#13225)

* [tapocontrol] added P115 smart socket
* [tapocontrol] enabled energy-data for P115 socket

Signed-off-by: Christian Wild <christian@wild-bw.de>

Added how to configure InfluxDB Persistance via Web-UI (#13213)

[nibeheatpump] Added PRODINo ESP32 Ethernet v1 board support (#13190)

* [nibeheatpump] Added PRODINo ESP32 Ethernet v1 board support

Also added:
- telnet debug support (UDP debug removed)
- new configuration model
- OTA update support for PRODINo ESP32 Ethernet v1 board

Signed-off-by: Pauli Anttila <pauli.anttila@gmail.com>