Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

MySQL connection errors
sp_NewPost Add Reply sp_NewTopic Add Topic
August 28, 2016
1:13 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Eric,

The SQL Connector can only work reliably when the connection to the database is stable. If there are connection errors to with the database then there is a chance that some of the records in the MessageLog or MessageIn tables are not inserted or updated properly. Fetching messages from the MessageOut table should normally not be affected since the database commands are wrapped in a transaction and are rolled back when the transaction fails.

There are two settings in the advanced settings of the SQL Connector that can improve the reliability when you see database connection problems: 'MessageInRetryOnError' and 'MessagesLogRetryOnError'. If you set these two properties to 'True', the SQL Connector will keep the messages in memory try to insert or update the records later.

Regards, Henk

August 27, 2016
4:44 am

Hello Henk,

I have another queries,
If the SQL Connector not connect to MySQL in my hosting server, all of the sms in send queue updated as Error.
Is there any configuration/setting to make diafaan server to not updating sms in queue as Error while sql connector not connected to MySQL server and make diafaan server to try proccess/sent again all of sms in queue while the sql connector connected again?

The reason of connector can't connect to mysql server is from my internet connection is not stable.

The message of error is:
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '103.23.xx.xx' (10065)

Thank you.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502