[Zeus]

Hi,
I use influxdb storage history data.
I can use api GetTrend and GetCurrentData get data from influx.
When i use getslice

ScadaClient.GetSlice(ArchiveBit.Minute, DateTime.UtcNow.AddMinute(-1), new int[] { 101 })

it returns scadadata undefined stat 0 val 0

the influxdb has cnl 101’s data every secend.

If i want to get cnl 101’s data at “DateTime.UtcNow.AddMinute(-1)”. how can i make it?

[Zeus]

Hi,
I save data into influxdb per secend.
How can i get cnl data an hour ago.

[Zeus]

Hi,
It works excellent

[Zeus]

Hi,
I use ExtDepPostgreSql to storage config.
So the config files won’t written into the directory.
The config info in directory and sql are different.
The server and comm start up with the config in file but not sql.
How to config it to make it right?

[Zeus]

Hi,
There is nothing special in log fie
Config file is below

<ScadaAgentConfig>
<ListenerOptions>
<Port>10002</Port>
<Timeout>10000</Timeout>
<SecretKey>0E063D581B1DB27B8E984993DED65CE99284A706756C706C7F3B12C44BD55D4D</SecretKey>
</ListenerOptions>
<ReverseConnection enabled=”false”>
<Name>Reverse Connection</Name>
<Host>localhost</Host>
<Port>10002</Port>
<Username>ScadaAgent</Username>
<Password>B9D0F030265751578B00E9801C69320C</Password>
<Instance>Default</Instance>
<Timeout>10000</Timeout>
<SecretKey>0E063D581B1DB27B8E984993DED65CE99284A706756C706C7F3B12C44BD55D4D</SecretKey>
</ReverseConnection>
<Instances>
<Instance active=”true” name=”Default”>
<ProxyMode>false</ProxyMode>
<Directory>/data/scada/</Directory>
<AdminUser>
<Username>ScadaAdmin</Username>
<Password>B9D0F030265751578B00E9801C69320C</Password>
</AdminUser>
</Instance>
<Instance active=”false” name=”Remote Site”>
<ProxyMode>true</ProxyMode>
<AdminUser>
<Username>ScadaAdmin</Username>
<Password>B9D0F030265751578B00E9801C69320C</Password>
</AdminUser>
<AgentUser>
<Username>ScadaAgent</Username>
<Password>B9D0F030265751578B00E9801C69320C</Password>
</AgentUser>
</Instance>
</Instances>
</ScadaAgentConfig>

[Zeus]

Hi,
I tried it and it do not work. there won’t be new file. The directory is empty

[Zeus]

Hi,
I did not get any error in log file.
I test it in a new ubuntu 20.04.
It could not override the old config files in the config directory.
the user and group is both root and the permissions is 777

[Zeus]

Thanks

[Zeus]

My archive config is like this

<Archives>
<Archive active=”true” code=”Cur” name=”Current Data” kind=”Current” module=”ModArcInfluxDb”>
<Option name=”FlushPeriod” value=”30″ />
<Option name=”LogEnabled” value=”false” />
<Option name=”ReadOnly” value=”false” />
<Option name=”UseCopyDir” value=”true” />
</Archive>
<Archive active=”true” code=”Min” name=”Minute Archive” kind=”Historical” module=”ModArcInfluxDb”>
<Option name=”Connection” value=”” />
<Option name=”IsPeriodic” value=”true” />
<Option name=”LogEnabled” value=”false” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”ReadOnly” value=”false” />
<Option name=”Retention” value=”365″ />
<Option name=”WriteWithPeriod” value=”true” />
<Option name=”WritingPeriod” value=”1″ />
<Option name=”WritingPeriodUnit” value=”Minute” />
</Archive>
<Archive active=”true” code=”Hour” name=”Hourly Archive” kind=”Historical” module=”ModArcInfluxDb”>
<Option name=”IsPeriodic” value=”true” />
<Option name=”LogEnabled” value=”false” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”ReadOnly” value=”false” />
<Option name=”Retention” value=”365″ />
<Option name=”UseCopyDir” value=”true” />
<Option name=”WriteWithPeriod” value=”true” />
<Option name=”WritingPeriod” value=”1″ />
<Option name=”WritingPeriodUnit” value=”Minute” />
</Archive>
<Archive active=”false” code=”Day” name=”Daily archive” kind=”Historical” module=”ModArcBasic”>
<Option name=”LogEnabled” value=”false” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”Retention” value=”365″ />
<Option name=”UseCopyDir” value=”false” />
<Option name=”WritingMode” value=”AutoWithPeriod” />
<Option name=”WritingPeriod” value=”24″ />
<Option name=”WritingUnit” value=”Hour” />
</Archive>
<Archive active=”true” code=”Events” name=”Event Archive” kind=”Events” module=”ModArcInfluxDb”>
<Option name=”LogEnabled” value=”false” />
<Option name=”ReadOnly” value=”false” />
<Option name=”Retention” value=”365″ />
<Option name=”UseCopyDir” value=”true” />
</Archive>
<Archive active=”true” code=”CurCopy” name=”Current Data” kind=”Current” module=”ModArcPostgreSql”>
<Option name=”Connection” value=”” />
<Option name=”FlushPeriod” value=”30″ />
<Option name=”LogEnabled” value=”false” />
<Option name=”MaxQueueSize” value=”1000″ />
<Option name=”ReadOnly” value=”false” />
<Option name=”UseStorageConn” value=”true” />
</Archive>
<Archive active=”true” code=”MinCopy” name=”Minute Archive” kind=”Historical” module=”ModArcPostgreSql”>
<Option name=”Connection” value=”” />
<Option name=”LogEnabled” value=”false” />
<Option name=”MaxQueueSize” value=”1000″ />
<Option name=”PartitionSize” value=”OneMonth” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”Retention” value=”365″ />
<Option name=”UseStorageConn” value=”true” />
<Option name=”WritingMode” value=”AutoWithPeriod” />
<Option name=”WritingPeriod” value=”1″ />
<Option name=”WritingUnit” value=”Minute” />
</Archive>
<Archive active=”true” code=”HourCopy” name=”Hourly Archive” kind=”Historical” module=”ModArcPostgreSql”>
<Option name=”Connection” value=”” />
<Option name=”IsPeriodic” value=”true” />
<Option name=”LogEnabled” value=”false” />
<Option name=”MaxQueueSize” value=”1000″ />
<Option name=”PartitionSize” value=”OneMonth” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”ReadOnly” value=”false” />
<Option name=”Retention” value=”365″ />
<Option name=”UseStorageConn” value=”true” />
<Option name=”WriteWithPeriod” value=”true” />
<Option name=”WritingPeriod” value=”1″ />
<Option name=”WritingPeriodUnit” value=”Minute” />
</Archive>
<Archive active=”false” code=”DayCopy” name=”Daily archive copy” kind=”Historical” module=”ModArcPostgreSql”>
<Option name=”Connection” value=”” />
<Option name=”LogEnabled” value=”false” />
<Option name=”MaxQueueSize” value=”1000″ />
<Option name=”PartitionSize” value=”OneMonth” />
<Option name=”PullToPeriod” value=”0″ />
<Option name=”Retention” value=”365″ />
<Option name=”UseStorageConn” value=”true” />
<Option name=”WritingMode” value=”AutoWithPeriod” />
<Option name=”WritingPeriod” value=”24″ />
<Option name=”WritingUnit” value=”Hour” />
</Archive>
<Archive active=”true” code=”EventsCopy” name=”Event Archive” kind=”Events” module=”ModArcPostgreSql”>
<Option name=”Connection” value=”” />
<Option name=”LogEnabled” value=”false” />
<Option name=”MaxQueueSize” value=”1000″ />
<Option name=”PartitionSize” value=”OneMonth” />
<Option name=”Retention” value=”365″ />
<Option name=”UseStorageConn” value=”true” />
</Archive>
</Archives>

• This reply was modified 3 years, 7 months ago by Zeus.

[Zeus]

Hi,
the other file could be transfer right

[Zeus]

Hi,
there is no error in log file

[Zeus]

upload project could not upload file in scadaserver/config

[Zeus]

postgres and influxdb archive error

[Zeus]

If we have many SCADA installed in different computers. I want to know the status of Servers and Comms.

[Zeus]

Thanks i see.

[Author]

Posts