Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Database MessageLog
sp_NewPost Add Reply sp_NewTopic Add Topic
June 22, 2016
3:40 pm
Henk Helmantel
Forum Posts: 520
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sarfaraz,

Diafaan SMS Server has two ways to log messages to an external SQL database. The default is that each SQL Connector only logs the messages that are sent from the same SQL Connector. In addition it is possible to use one of the SQL Connectors to log all messages that are sent and received by Diafaan SMS Server, but this option is not enabled by default.

There are no options in Diafaan SMS Server to log only specific messages to your SQL database. The only way to achieve this is to add a trigger to the SQL database that removes specific messages after they are added by Diafaan SMS Server.

Regards, Henk

June 22, 2016
1:01 pm

Hi Henk,

We are facing an issue while logging the messages in the SQL Connector. We have many SQL, SMPP & Email Connectors. We need an option where we can define that only SQL Connector1, SMPP1 & SMPP2 messages should be logged into the SQL Connector rest all the connector message should not be logged as it is increasing the load on our SQL database.

Please let us know how we can achieve this.

Thanks in advance

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 354

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 512

Posts: 1774

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 520