Forum Home › Forums › Runtime Bugs › Server Bugs › ModDBExport module is not working in Ubuntu
Tagged: ModBusExport Linux
- This topic has 4 replies, 2 voices, and was last updated 2 years, 8 months ago by
Mikhail.
-
AuthorPosts
-
January 19, 2021 at 9:04 pm #8099
gespitia
ParticipantFirst 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 exceededCurrently 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
January 20, 2021 at 1:48 pm #8110Mikhail
ModeratorHello,
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/
January 20, 2021 at 2:21 pm #8114gespitia
ParticipantHello 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.2I 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
January 20, 2021 at 4:17 pm #8116gespitia
ParticipantHello 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
January 21, 2021 at 2:10 pm #8129Mikhail
ModeratorHello,
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.
-
AuthorPosts
- You must be logged in to reply to this topic.