moddbexport-mysql-current data

Forum Home Forums Understanding the Software moddbexport-mysql-current data

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #12139
    asherb
    Participant

    hello, i have problems with loading current data into mysql database, i can see right now, i have the table-cnldata in my database, however, i can’t load data into it. the connection string is as following: server=localhost;uid=root;pwd=*****;database=sakila

    my query is: INSERT INTO CnlData (DateTime, CnlNum, Val, Stat)
    VALUES (@datetime, @cnlnum, @val, @stat)

    in general options, the status channel number i set to 1

    the log i can see for the moddbexport is:

    2023-02-23 15:53:32 Error connecting to DB:
    MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
     ---> System.Net.Sockets.SocketException (11001): No such host is known.
       at System.Net.NameResolutionPal.ProcessResult(SocketError errorCode, GetAddrInfoExContext* context)
       at System.Net.NameResolutionPal.GetAddressInfoExCallback(Int32 error, Int32 bytes, NativeOverlapped* overlapped)
    --- End of stack trace from previous location ---
    
       at MySql.Data.MySqlClient.NativeDriver.<>c.<Open>b__40_0(Exception ex)
       at System.AggregateException.Handle(Func`2 predicate)
       at MySql.Data.MySqlClient.NativeDriver.Open()
       at MySql.Data.MySqlClient.Driver.Open()
       at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
       at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
       at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
       at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
       at MySql.Data.MySqlClient.MySqlPool.GetConnection()
       at MySql.Data.MySqlClient.MySqlConnection.Open()
       at Scada.MultiDb.DataSource.Connect()
       at Scada.Server.Modules.ModDbExport.Logic.Exporter.Connect()
    2023-02-23 15:53:34 Exporter "[1] Target 1" is stopped
    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    2023-02-23 15:53:37 Exporter "[1] Target 1" started
    2023-02-23 15:53:43 Error exporting slice by the query "Query 1": Fatal error encountered during command execution.
    2023-02-23 15:53:44 Error exporting slice by the query "Query 1": Fatal error encountered during command execution.
    2023-02-23 15:53:45 Error exporting slice by the query "Query 1": Fatal error encountered during command execution.
    

    please help, thanks!

    • This topic was modified 1 year, 3 months ago by Mikhail.
    #12140
    asherb
    Participant

    also, in another log(ModDbExport_001.txt), i can see this:
    Current Data
    ————
    Status : Error
    In queue : 762 of 1000
    Exported : 56
    Skipped : 0

    #12142
    Mikhail
    Moderator

    Hello,
    If you already solved the database connection error, use the scripts from here for creating tables and export data. They are a bit different comparing with version 5.

    #12144
    Mikhail
    Moderator

    <pre> </pre> tags make log more readable.

    #12148
    asherb
    Participant

    error fix, thanks Mikhail!

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