Hi,
i start the upgrade from OH 3 to OH4. But now there is a problem with the SQL.
OH and MYSQL are installed in seperatet docker container.
2023-11-15 15:22:35.215 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2023-11-15 15:22:35.216 [WARN ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: failed to open connection: Failed to initialize pool: Communications link failure
I checked the file jdbc.cfg from /opt/openhab/conf/services
url=jdbc:mysql://SERVERIP:3306/openhab
user=USERNAME
password=PASSWORD
The add-on JDBC persistence (MySQL) is installed in Persistence Services
I don´t know if i`m right, but this command
mysql -h localhost -u USERNAME -D DB-NAME -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
doesn´t work.
JDBC Persistence
All item- and event-related configuration is done in the file persistence/jdbc.persist.
To configure this service as the default persistence service for openHAB, add or change the line
org.openhab.core.persistence:default=jdbc
in the file services/runtime.cfg.
################ PERSISTENCE ####################
The persistence service to use if no other is specified.
#org.openhab.persistence:default=
org.openhab.core.persistence:default=jdbc
Thx for help
#newbee