Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Please help in understanding of MySqlConnector?
sp_NewPost Add Reply sp_NewTopic Add Topic
August 11, 2015
11:19 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Steven,

The SQL Connector in Diafaan SMS Server can use three database tables in your database, MessageOut, MessageLog and MessageIn.

The MessageOut database table can be used to send SMS messages, the SQL Connector will read the records from the MessageOut database every 5 seconds, remove the records and send the SMS messages. The MessageOut table is always empty after each read cycle except when you set up the SQL Connector to keep the messages in the MessageOut table (not recommended).

After the messages from the MessageOut table are processed (sent or failed), the result is stored in the MessageLog table. Please not that the SQL Connector by default only stores the messages in the MessageLog table that originate from the MessageOut table in the same SQL Connector. It is possible to log all messages in Diafaan SMS Server to the MessageLog table of your database but in order to do this, you have to set the 'Log all messages to SQL Connector ...' option in the advanced settings of the general options (menu items 'Actions-Options-Advanced').

Received messages are stored in the MessageIn database table, if you do not see any messages in the MessageIn table there could be an error in the event log that might explain the root of the problem.

For more information about the use of a MySQL database in Diafaan SMS Server you can look here and here.

Regards, Henk

August 10, 2015
1:06 pm

Hello to you,

I'm newbie using Diafaan SMS Server 3.0

For the first, I'm using WebConnector
I can send and receive sms successfully

For the next, I try using MySqlConnector
I do create the database, table then setting its properties in advance tab, all well done
Had 3 tables, MessageIn, MessageOut, MessageLog.
I also successfully to send and receive sms successfully (I read from Diafaan SMS Server console)
Maybe I'm not understanding, its concept in MySqlConnector.
I tried to insert a record in MessageOut then the sms sent successfully, then I tried to send back to sms server, It also recieved (I read from Diafaan SMS Server console)
When I tried to view the table in MessageIn, MessageOut, MessageLog (only the MessageLog have some records/rows, MessageIn and MessageOut is empty)
How can I have logs of send-out sms and received sms ?
Please advice and guide me in understanding MySqlConnector.

Thanks in advance.


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
6 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