Mysql Connection from CFD is not working but from CRM Integration is working

[Goga]

I try to connect to Amazon Mysql Database using 3cx CFD I cannot connect and it show error as below.

From script: inboundmap - CallID 0000018ED6BADA6A_12842 - Callflow - Error executing last component: MySqlConnector.MySqlException (0x80004005): Connect Timeout expired.
---> MySqlConnector.MySqlException (0x80004005): Connect Timeout expired.
at MySqlConnector.Core.ServerSession.OpenTcpSocketAsync(ConnectionSettings cs, ILoadBalancer loadBalancer, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1131
at MySqlConnector.Core.ServerSession.ConnectAsync(ConnectionSettings cs, MySqlConnection connection, Int32 startTickCount, ILoadBalancer loadBalancer, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 438
at MySqlConnector.Core.ConnectionPool.ConnectSessionAsync(MySqlConnection connection, String logMessage, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 403
at MySqlConnector.Core.ConnectionPool.ConnectSessionAsync(MySqlConnection connection, String logMessage, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 408
at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 98
at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 128
at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 929
at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 959
at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 423
at CallFlow.CFD.DatabaseAccessComponent.PrepareCommandAsync(DbConnection conn)
at CallFlow.CFD.DatabaseAccessComponent.ExecuteReaderAsync(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 _9001_6.Main.ProcessStart()


But when I try using CRM integration Mysql connection it is working.
I tried using PHP it is working.

Tried on both 3cx V18 latest and V20

Interestingly I am able to connect to other Mysql database hosted on Digital Ocean.
Only Amazon Mysql database I am not able to connect .
I tried using IP also instead of DNS still not working.

 

[Evolute IT]

Connection timeout it says. There must be something blocking the connection, or you misconfigured the database component. Specially ports and such.

 

[Goga]

But I used same port in CRM Integration and it is working ..

 

[TheodorosG_3CX]

From script: inboundmap - CallID 0000018ED6BADA6A_12842 - Callflow - Error executing last component: MySqlConnector.MySqlException (0x80004005): Connect Timeout expired.

This is related with the connection, maybe there is no response to the PBX as the connection will timeout.

 

[edossantos_sipcaller]

A connection timeout is a firewall issue in 99% of the cases. You should check your CFD app configuration, if this is working fine for the MySQL integration in 3CX, then maybe you're pointing to a different server.....