Support forum

Hello Adolfo,

The MessageOut database table in the SQL Connector of Diafaan SMS Server is intended for messages than need to be sent out, it is not used to store messages that are sent or received by Diafaan SMS Server.

If you want to store outbound messages from the SMPP Connector or inbound messages from the SMPP Gateway in a database you can use 3 methods:

1. Use one of the SQL Connectors to store all messages in Diafaan SMS Server by setting the option 'Log all messages to SQL Connector ...' in the 'Advanced' page of the general options. This stores the outbound messages in the MessageLog table and the inbound messages in the MessageIn table. With most SQL databases you can use a database trigger to copy specific records from the MessageLog database table to the MessageOut table when you require this for your application.

2. Use the Scripting Gateway with a customized script to store outbound messages from the SMPP Connector in a database and/or use the Scripting Connector with a customized script to store inbound messages from the SMPP Gateway in a database.

3. Use the HTTP callback functionality of Diafaan SMS Server with a custom (PHP) script to store the messages in a database.

Regards, Henk