ModDBExport module is not working in Ubuntu

Forum Home Forums Runtime Bugs Server Bugs ModDBExport module is not working in Ubuntu

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #8099
    gespitia
    Participant

    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

    #8110
    Mikhail
    Moderator

    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/

    #8114
    gespitia
    Participant

    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

    #8116
    gespitia
    Participant

    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

    #8129
    Mikhail
    Moderator

    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.

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.