moddbexport-mysql-current data

[asherb]

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 3 months, 2 weeks ago by Mikhail.

[asherb]

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

[Mikhail]

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.

[Mikhail]

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

[asherb]

error fix, thanks Mikhail!

[Author]

Posts