Support forum

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