[greenfoxx]

Hi!
We faced that Grafana plugins, such as grafana-simple-json-datasource, become obsolete too often and unpredictable.
We decided not too use special plugins to integrate Rapid SCADA and Grafana. With Rapid SCADA 6.x you should configure archives to store historical data into database, then display data by Grafana. I suggest storing historical data to PostgreSQL.

Could you please check short instructions for working with Grafana
PostgreSQL data source and Rapid SCADA.

Work at Grafana:
1. Choose as data source PostgreSQL.
2. Set the data source’s basic configuration options in setting tab.
For example:
Host: The IP address/hostname your PostgreSQL instance
Database: rapid_scada
User: postgres
Password: Database user’s postgres password – postgres
3. Write a sql-query. You can use Query builder or Query editor.
4. Simple query example (Query on one channel, not including into stat = 0, and also not showing a gap, if there is no data in a certain period of time)

SELECT
time_stamp AS "time",
val
FROM mod_arc_postgre_sql.mincopy_historical
WHERE
cnl_num = 101
ORDER BY 1

[greenfoxx]

From this link you can find Mqtt – Spy https://github.com/eclipse/paho.mqtt-spy

[greenfoxx]

Hi Kokoi!
What broker do you use in your example? Have you tried to connect to server broker using MQTT Spy for example?

[greenfoxx]

Yes, we fixed.
Please check.

[greenfoxx]

Thank you very much Kumajaya! We accepted your changes in the last commit. You were right.
The issue has been fixed.

[greenfoxx]

We fixed this issue.

[greenfoxx]

Hi!

Could you please download the new dll which you can find here https://yadi.sk/d/KlvaH845L42KyQ
Has been added to the log file detailed information about the error.

[greenfoxx]

Thank you for details. We’ll investigate the problem and issue a fix. Thanks for the report.

[greenfoxx]

Could you please provide response from Grafana? It’s help me.

[greenfoxx]

Could you please provide response from Grafana?
Grafana Data Provider API represents parameters transmitted to Grafana for build graph and converts the specified date and time to the unix milliseconds.

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

[greenfoxx]

Hi!

Could you please clarify your question?

[greenfoxx]

Hi Trauden!

Thank you for your message.

Could you please set parameter allow_embedding = true in file defaults.ini wich you can find C:\Program Files\GrafanaLabs\grafana\conf
and restart.

More information https://github.com/grafana/grafana/issues/17458

I will add this important information in file ReadMe.MD

• This reply was modified 4 years ago by greenfoxx.

[greenfoxx]

Could you provide versions ScadaServer, ModDBExport and PostgresSQL?

[greenfoxx]

Hi!
Probably, you can see the error ‘Could not read remaining length’.
The exception occurs when there is no data to read or the connection is no longer valid.
You can test the following update https://yadi.sk/d/HPI_FkFPfrXbhA

[greenfoxx]

UPD to ALnaluk:
try to Upload Configuration again

[Author]

Posts