3cx call flow designer in v18

[ML75]

salve sto cercando di aggiornare alla v18 il 3cx v16 che ho installato in azienda su VMware . L'aggiornamento funziona. l'unico problema bloccante ( che mi obbliga a ritornare alla v16 ) è che il call flow designer, progettato per collegarsi ad un DB sql server per recuperare le informazioni del cliente, dopo l'aggiornamento mi da un errore che vi riporto di seguito.
Ho provato a cercare online,ho trovato diverse proposte: chi scrive di forzare il server dove c'e' installato il sql Server 2016 a usare SSL 2.0 ( fatto ma senza esito) . Chi dice di installare sul 3cx aggiornato una versione + aggiornata di OpenSSL ( fatto ma senza esito ) .

Qualcuno ha qualche idea?

qui di seguito i logs scaricati dal centralino.

------------|Inf(00)| Date: 13/01/2022 14:45:43
2022/01/13 14:45:43.694|30119|0001|Inf|Log is created
2022/01/13 14:45:44.642|30119|0001|Inf|Assembly load report:
mscorlib - taken from referenced /usr/lib/3cxpbx/mscorlib.dll
System - taken from referenced /usr/lib/3cxpbx/System.dll
System.Core - taken from referenced /usr/lib/3cxpbx/System.Core.dll
System.Runtime - taken from referenced /usr/lib/3cxpbx/System.Runtime.dll
System.Collections - taken from referenced /usr/lib/3cxpbx/System.Collections.dll
System.Core - taken from referenced /usr/lib/3cxpbx/System.Core.dll
System.IO - taken from referenced /usr/lib/3cxpbx/System.IO.dll
System.IO.FileSystem - taken from referenced /usr/lib/3cxpbx/System.IO.FileSystem.dll
System.Runtime - taken from referenced /usr/lib/3cxpbx/System.Runtime.dll
System.Collections - taken from referenced /usr/lib/3cxpbx/System.Collections.dll
Microsoft.CSharp - taken from referenced /usr/lib/3cxpbx/Microsoft.CSharp.dll
netstandard - taken from referenced /usr/lib/3cxpbx/netstandard.dll
System.Linq - taken from referenced /usr/lib/3cxpbx/System.Linq.dll
System.Linq.Expressions - taken from referenced /usr/lib/3cxpbx/System.Linq.Expressions.dll
System.Linq.Parallel - taken from referenced /usr/lib/3cxpbx/System.Linq.Parallel.dll
System.Linq.Queryable - taken from referenced /usr/lib/3cxpbx/System.Linq.Queryable.dll
System.Net.Http - taken from referenced /usr/lib/3cxpbx/System.Net.Http.dll
Newtonsoft.Json - taken from referenced /usr/lib/3cxpbx/Newtonsoft.Json.dll
System.Xml - taken from referenced /usr/lib/3cxpbx/System.Xml.dll
System.Xml.Linq - taken from referenced /usr/lib/3cxpbx/System.Xml.Linq.dll
System.Xml.ReaderWriter - taken from referenced /usr/lib/3cxpbx/System.Xml.ReaderWriter.dll
System.Xml.Serialization - taken from referenced /usr/lib/3cxpbx/System.Xml.Serialization.dll
System.Xml.ocument - taken from referenced /usr/lib/3cxpbx/System.Xml.ocument.dll
System.Xml.XmlDocument - taken from referenced /usr/lib/3cxpbx/System.Xml.XmlDocument.dll
System.Xml.XmlSerializer - taken from referenced /usr/lib/3cxpbx/System.Xml.XmlSerializer.dll
System.Xml.XPath - taken from referenced /usr/lib/3cxpbx/System.Xml.XPath.dll
System.Xml.XPath.ocument - taken from referenced /usr/lib/3cxpbx/System.Xml.XPath.ocument.dll
System.Xml.XPath.XmlDocument - not found in references and compiler path /usr/lib/3cxpbx
System.Xml.ocument - taken from referenced /usr/lib/3cxpbx/System.Xml.ocument.dll
System.Private.Xml - taken from referenced /usr/lib/3cxpbx/System.Private.Xml.dll
System.Private.Xml.Linq - taken from referenced /usr/lib/3cxpbx/System.Private.Xml.Linq.dll
System.Private.Uri - taken from referenced /usr/lib/3cxpbx/System.Private.Uri.dll
3cxpscomcpp2 - taken from referenced /usr/lib/3cxpbx/3cxpscomcpp2.dll
MailKit - taken from referenced /usr/lib/3cxpbx/MailKit.dll
MimeKit - taken from referenced /usr/lib/3cxpbx/MimeKit.dll
MySqlConnector - taken from referenced /usr/lib/3cxpbx/MySqlConnector.dll
Npgsql - taken from referenced /usr/lib/3cxpbx/Npgsql.dll
System.ComponentModel - taken from referenced /usr/lib/3cxpbx/System.ComponentModel.dll
System.ComponentModel.Primitives - taken from referenced /usr/lib/3cxpbx/System.ComponentModel.Primitives.dll
System.Data - taken from referenced /usr/lib/3cxpbx/System.Data.dll
System.Data.Common - taken from referenced /usr/lib/3cxpbx/System.Data.Common.dll
System.Data.SqlClient - taken from referenced /usr/lib/3cxpbx/System.Data.SqlClient.dll
System.Net.Primitives - taken from referenced /usr/lib/3cxpbx/System.Net.Primitives.dll
System.Net.Sockets - taken from referenced /usr/lib/3cxpbx/System.Net.Sockets.dll
System.Security.Cryptography.Algorithms - taken from referenced /usr/lib/3cxpbx/System.Security.Cryptography.Algorithms.dll
System.Security.Cryptography.Primitives - taken from referenced /usr/lib/3cxpbx/System.Security.Cryptography.Primitives.dll
System.Text.RegularExpressions - taken from referenced /usr/lib/3cxpbx/System.Text.RegularExpressions.dll
TcxMail - taken from referenced /usr/lib/3cxpbx/TcxMail.dll
System.Threading - taken from referenced /usr/lib/3cxpbx/System.Threading.dll
System.Threading.Timer - taken from referenced /usr/lib/3cxpbx/System.Threading.Timer.dll
System.Threading.Tasks - taken from referenced /usr/lib/3cxpbx/System.Threading.Tasks.dll
System.Threading.Tasks.Dataflow - taken from referenced /usr/lib/3cxpbx/System.Threading.Tasks.Dataflow.dll
AWSSDK.Core - taken from referenced /usr/lib/3cxpbx/AWSSDK.Core.dll
AWSSDK.Polly - taken from referenced /usr/lib/3cxpbx/AWSSDK.Polly.dll
CallFlow.CFD - taken from referenced /usr/lib/3cxpbx/CallFlow.CFD.dll
2022/01/13 14:45:44.643|30119|0001|Inf|Log verbosity is set to Low
2022/01/13 14:46:14.360|30119|0010|Err|CallPair._333_1.Main.2.[C:1.2]-From script: Assistenza - CallID 0000017E53B05BB4_1 - Callflow - Error executing last component: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
---> Interop+OpenSsl+SslException: SSL Handshake failed with OpenSSL error - SSL_ERROR_SSL.
---> Interop+Crypto+OpenSslCryptographicException: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
--- End of inner exception stack trace ---
at Interop.OpenSsl.DoSslHandshake(SafeSslHandle context, ReadOnlySpan`1 input, Byte[]& sendBuf, Int32& sendCount)
at System.Net.Security.SslStreamPal.HandshakeInternal(SafeFreeCredentials credential, SafeDeleteSslContext& context, ReadOnlySpan`1 inputBuffer, Byte[]& outputBuffer, SslAuthenticationOptions sslAuthenticationOptions)
--- End of inner exception stack trace ---
at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](TIOAdapter adapter, Boolean receiveFirst, Byte[] reAuthenticationData, Boolean isApm)
at System.Net.Security.SslStream.ProcessAuthentication(Boolean isAsync, Boolean isApm, CancellationToken cancellationToken)
at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost)
at System.Data.SqlClient.SNI.SNITCPHandle.EnableSsl(UInt32 options)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at CallFlow.CFD.DatabaseAccessComponent.PrepareCommandAsync(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteScalarAsync(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteStatement(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteStart()
at CallFlow.CFD.DatabaseAccessComponent.Start(TimerManager timerManager, Dictionary`2 variableMap, TempWavFileManager tempWavFileManager, PromptQueue promptQueue)
at _333_1.Main.ProcessStart()
ClientConnectionId:b1955426-2942-48f2-aead-38f8a6de660f
2022/01/13 14:47:31.409|30119|0014|Err|CallPair._333_2.Main.4.[C:2.2]-From script: Assistenza - CallID 0000017E53B1897E_2 - Callflow - Error executing last component: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)
---> System.IO.EndOfStreamException: End of stream reached
at System.Data.SqlClient.SNI.SslOverTdsStream.ReadInternal(Byte[] buffer, Int32 offset, Int32 count, CancellationToken token, Boolean async)
at System.Data.SqlClient.SNI.SslOverTdsStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.Stream.Read(Span`1 buffer)
at System.Net.Security.SslStream.FillHandshakeBufferAsync[TIOAdapter](TIOAdapter adapter, Int32 minSize)
at System.Net.Security.SslStream.ReceiveBlobAsync[TIOAdapter](TIOAdapter adapter)
at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](TIOAdapter adapter, Boolean receiveFirst, Byte[] reAuthenticationData, Boolean isApm)
at System.Net.Security.SslStream.ProcessAuthentication(Boolean isAsync, Boolean isApm, CancellationToken cancellationToken)
at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)
at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost)
at System.Data.SqlClient.SNI.SNITCPHandle.EnableSsl(UInt32 options)
at System.Data.SqlClient.SNI.SNIProxy.EnableSsl(SNIHandle handle, UInt32 options)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at CallFlow.CFD.DatabaseAccessComponent.PrepareCommandAsync(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteScalarAsync(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteStatement(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteStart()
at CallFlow.CFD.DatabaseAccessComponent.Start(TimerManager timerManager, Dictionary`2 variableMap, TempWavFileManager tempWavFileManager, PromptQueue promptQueue)
at _333_2.Main.ProcessStart()
ClientConnectionId:9c5b1285-603b-4c19-8279-baf396fb6446

 

[MarcelloL_3CX]

Ciao,
ti segnalo che le app CFD sono supportate (in inglese) sul forum internazionale dedicato:

Call Flow Designer

www.3cx.com

 

[ML75]

grazie. lo guardo subito.

 

[Giuseppe.IA]

Ciao, sei sicuro sia SSL 2.0?
SQL Server 2016 utilizza TLS come layer di criptazione.
non penso sia un problema di CFD, ma di openssl. Dovresti controllare se la versione minima supportata per il TLS è la v1.0 oppure v1.2.

... comunque senti anche il forum di CFD

 

[ML75]

grazie. provo a verificare.