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.
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.
Most Users Ever Online: 529
Currently Browsing this Page:
Guest Posters: 657
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1425