Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_TopicIcon
SQL Connector for Outgoing Messages that are in queue
sp_NewPost Add Reply sp_NewTopic Add Topic
September 9, 2021
1:05 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
4sp_Permalink sp_Print sp_QuotePost Quote

Hello Gerik,

The external SQL database where you keep the send log does not show the message queue. Apart from the method that I described in my first response, it is not possible to get a list of messages that are still in the send queue of Diafaan SMS Server.

The request-server-status HTTP API call returns a the status information of Diafaan SMS Server, including the number of messages in the send queue.

Regards, Henk

September 8, 2021
5:16 pm
gerik
Guest
Guests
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

Hi sorry I just found this thread again.

I am sending the messages thru HTTP but i cannot see them in the message queue in the SQL Connector.

I want to be able to see how many and what messages are still on queue via SQL is there any way?

May 4, 2021
2:30 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

Hello Gerik,

When Diafaan SMS Server reads the MessageOut table of the database, it removes records or sets the IsSent flag immediately after the messages are imported. Only after the message is sent by Diafaan SMS Server (or failed to send) and is removed from the send queue, a log record is added to the MessageLog table. The SQL Connector does not keep a list in the external database of messages that are still in the send queue of Diafaan SMS Server.

In theory you could use a database trigger to remove messages from the MessageOut table when they are added to the MessageLog table, or set a specific flag. But I don't recommend this because it will have a negative effect on the performance of the database processing.

Regards, Henk

May 2, 2021
12:06 pm
gerik
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Hi how can i see the messages that are still queued for sending when I check the database even when the messages are not yet sent and not yet in the MessageLog they are already flagged as isSent in the MessageOut table. Is this a bug? and is there a bugfix for this?

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
37 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488