Current Data Export

[afzal]

Hi,

i am having trouble for data export.
is there anyone who have successfully exported current realtime data using mysql workbench.
i am following the indications given in the following link
http://rapidscada.net/doc/content/latest/en/modules/mod-db-export.html

— Insert current data
INSERT INTO cnldata (datetime, cnlnum, val, stat)
VALUES (@dateTime, @cnlNum, @val, @stat)

Error: datetime cannot be null
cnlNum cannot be null
val cannot be null.

can you please help me out

Thanks
Hayat

[Mikhail]

Hi,

The module writes log files that are located in C:\SCADA\ScadaServer\Log
Please copy meaningful parts of log files in this topic.

[afzal]

Hi,

the message that i see in log file is

2021-03-17 12:57:08 Error connecting to DB MySQL – localhost: Authentication method ‘caching_sha2_password’ not supported by any of the available plugins.

what could be the problem ?

[afzal]

above problem was related to mysql authentication.
that is solved now i think now there is connection between rapidscada and mysql.

but i get another error

2021-03-17 15:38:27 Error export current data to DB MySQL – localhost: Duplicate entry ‘2021-03-17 15:38:26-101’ for key ‘cnldata.PRIMARY’

[afzal]

i solved the problem.

[Mikhail]

OK

[Author]

Posts