ioBroker.sql icon indicating copy to clipboard operation
ioBroker.sql copied to clipboard

Fehler: invalid config

Open xelarep opened this issue 1 year ago • 3 comments

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:

  • Adapter version: 2.2.0
  • JS-Controller version: 5.0.17
  • Node version: 18.19.0
  • Operating system: Linux 5.10.103-v7l+ #1529 SMP Tue Mar 8 12:24:00 GMT 2022 armv7l GNU/Linux (Raspberry Pi 4)

xelarep avatar Feb 17 '24 14:02 xelarep

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

Apollon77 avatar Feb 17 '24 15:02 Apollon77

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:

  • stopping sql.0
  • switching log level from info to debug
  • restarting sql.o
  • klicking Teste Verbindung
  • stopping sql.0
  • switching log level from debug to info
  • readout the log

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...

xelarep avatar Feb 17 '24 18:02 xelarep

Ok we need to try to reproduce it

Apollon77 avatar Feb 20 '24 08:02 Apollon77