Export to Database Module

Forum Home Forums Development and Integration Export to Database Module

This topic contains 24 replies, has 3 voices, and was last updated by Mikhail Mikhail 4 months, 3 weeks ago.

Viewing 10 posts - 16 through 25 (of 25 total)
  • Author
    Posts
  • #5622
    fhserver
    fhserver
    Participant

    hi,

    Can you tell me, the correct way to configure the database.

    “Configure connection” Is this configuration referring to the database of rapid scada? If so, what are the default credentials?

    imagen1

    Config server Mysql

    imagen2

    Query Sql

    imagen3

    Tables DB

    imagen4

    I can not copy the data, to the external DB Mysql.

    #5627
    Mikhail
    Mikhail
    Moderator

    Hi,

    Connection settings on the 1st image are not related to database. Don’t mind about them.

    You should find ModDBExport.log and ModDBExport.txt in C:\SCADA\ScadaServer\Log and check the error details.

    #5631
    fhserver
    fhserver
    Participant

    Apparently I have problems with the MYSQL database.

    imagen5

    Thank you very much for the help !!

    I’ll tell you as soon as I solve it

    #5640
    Mikhail
    Mikhail
    Moderator

    May be you should change cnlmun to cnlnum in the INSERT request.

    #5643
    fhserver
    fhserver
    Participant

    Thank you ! , layer 8 error (between the chair and the keyboard).

    Captura02

    Log.

    Captura03

    #5648
    Mikhail
    Mikhail
    Moderator

    Is the “duplicate entry” error critical in your situation or can be ignored?

    #5706
    fhserver
    fhserver
    Participant

    Disable PK, I have not had any more problems

    tablas<br />

    Log.

    log<br />

    • This reply was modified 4 months, 3 weeks ago by fhserver fhserver.
    #5714
    Mikhail
    Mikhail
    Moderator

    This is a bad practice, because records still duplicated, but without error.
    Somewhere in this forum or https://forum.rapidscada.ru/, a solution how to skip inserting duplicated records.

    #5716
    fhserver
    fhserver
    Participant

    Apparently this was solved

    SQL

    https://i.ibb.co/6ypdsjG/sql.png

    Table

    https://i.ibb.co/YdqGZ9V/key.png

    Log

    https://i.ibb.co/bJRnYzY/log.png

    • This reply was modified 4 months, 3 weeks ago by fhserver fhserver.
    • This reply was modified 4 months, 3 weeks ago by Mikhail Mikhail.
    #5727
    Mikhail
    Mikhail
    Moderator

    On my PC images are not available. Could you check them?

Viewing 10 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic.