ModDBExport module is not working in Ubuntu

[gespitia]

First of all, thankyou for this magnificent product, it is very useful for my thesis research.

Currently I am facing an issue with ModDB Export module. It doesn’t work when I try to use it on Ubuntu 18.04 , and in the ModDBExport.log reports this:

2021-01-19 15:34:36 Error initializing data source PostgreSQL – 172.17.7.1: Could not load type of field ‘Npgsql.NpgsqlConnection:CertificateSelectionCallback’ (9) due
to: Could not resolve type with token 01000058 from typeref (expected class ‘Mono.Security.Protocol.Tls.CertificateSelectionCallback’ in assembly ‘Mono.Security, Versio
n=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756’) assembly:Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 type:Mono.Securi
ty.Protocol.Tls.CertificateSelectionCallback member:(null)
2021-01-19 15:35:47 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2021-01-19 15:35:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2021-01-19 15:35:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded

Currently I have installed Rapid SCADA 5.8.2 Mono. Others features runs well in Linux and ModDBExport runs well in Windows 10.

I apreciate so much your sugestion to resolve this issue.

Thanks in advance.

Gustavo Espitia

[Mikhail]

Hello,

What PostgreSQL version do you use?
What is Mono version? Command to check:

mono --version

Try copying Mono.Security.dll from the Windows installation package to /opt/scada/ScadaServer/Mod/

[gespitia]

Hello Mikhail, thanks for answer.

Currently I have:
PostreSQL version: 13.1
Mono version: 6.12.0.107
Rapid Scada: 5.8.2 Mono
Ubuntu: 18.04.2

I just copied Mono.Security.dll from Windows installation package to /opt/scada/ScadaServer/Mod and restart scada, but that did not solve the problem. In ModDBExport.log now appears:

2021-01-20 09:03:13 Start ModDBExport module
2021-01-20 09:03:13 Error connecting to DB PostgreSQL – 172.17.7.1: Could not load type of field ‘System.Net.Security.SslStream:provider’ (0) due to: Could not resolve type with token 01000030 from typeref (expected class ‘Mono.Security.Interface.MonoTlsProvider’ in assembly ‘Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756’) assembly:Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 type:Mono.Security.Interface.MonoTlsProvider member:(null)

I am pending any comment from you.

Warm regards,

Gustavo Espitia

[gespitia]

Hello Mikhail

I want to share my workaround for this issue:

I downloaded Mono.Security.dll from https://www.dllme.com/dll/files/mono_security_dll.html and copied into /opt/scada/ScadaServer/Mod then I restarted the scada service.

I tried against both 172.17.7.1 and 127.0.0.1 server addresses making the respective modification in /opt/scada/ScadaServer/Config/ModDBExport.xml and /etc/postgresql/13/main/pg_hba.conf with good results (Rapid Scada is registring data in the database).

I am pending if you set up a standard solution for this issue.

Thankyou again.

Warm regards,

Gustavo Espitia

[Mikhail]

Hello,

Thanks for the recipe.

I am pending if you set up a standard solution for this issue.

There is a update for PostgreSQL connector, but it has a lot of dependencies and it’s better to use it with .NET 5. In the future Rapid SCADA will be ported to .NET 5, and this should solve the problem.

[Author]

Posts