ioBroker / ioBroker.sql

Store history data in SQL Database: MySQL, PostgreSQL or SQLite
MIT License
45 stars 25 forks source link

Fehler: invalid config #355

Open xelarep opened 5 months ago

xelarep commented 5 months ago

Describe the bug
After moving a MariaDB database (i.e. stopping sql.0, export from current server, import on new server, changing server details in sql.0 instance) from one server to a new one. The "Verbindung Testen" (Check Connection?) reports

"Fehler; invalid config?"

However everything is OK when saving and closing the settings New data is written to sql.0/database, ECharts can access history data

Expected behavior
"Connection OK" would be fine...

Versions:

Apollon77 commented 5 months ago

Can you please show the settings you use to try to reproducte it?PLease also try to enable debug log and see if something is logged when you do such a check

xelarep commented 5 months ago

Ok, 1st try. These are my current settings:

Bildschirmfoto 2024-02-17 um 18 45 33 Bildschirmfoto 2024-02-17 um 18 44 43 Bildschirmfoto 2024-02-17 um 18 52 38

When I pick Test, I get this dialog: Bildschirmfoto 2024-02-17 um 18 45 12

I just switched debug level from info to debug for sql.0. However there are tons of messages, because of my current loggings...

I tried the following:

for whatever reason I'm not able to dwnload the log, hoverer I can provide some timestamped screenshots:

Bildschirmfoto 2024-02-17 um 18 53 51 Bildschirmfoto 2024-02-17 um 19 01 14 Bildschirmfoto 2024-02-17 um 19 01 49

Please advise how to get better information...

Apollon77 commented 5 months ago

Ok we need to try to reproduce it