Current Data Export

Forum Home Forums Runtime Bugs Server Bugs Current Data Export

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #8516
    afzal
    Participant

    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

    #8522
    MikhailMikhail
    Moderator

    Hi,

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

    #8523
    afzal
    Participant

    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 ?

    #8525
    afzal
    Participant

    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’

    #8533
    afzal
    Participant

    i solved the problem.

    #8536
    MikhailMikhail
    Moderator

    OK

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.