symfony - Kannel: get sms status from database -

i'm making symfony application stores huge amount of sms in database , kannel detectes these sms , sends , i'm using sqlbox sure, problem kannel notifies our symfony app sms throug dlr-url causing alot of memory usage of apache, cause every sms got 3 http request dlr update sms 100k sms 300k request , in each request update database...

so i'm thinking of why not kannel update sms status in database directly without calling dlr url... possible ?

from understanding, tests based on following configuration:

• sqlbox send messages (through insert in send_sms table
• dlr_url set in configuration delivery reports
• no custom dlr-storage

how keep dlr without using additional http calls

there tool automatically dlr database: interest of dlr-storage

in kannel documentation, see field has several possibilities:

supported types are: internal, spool, mysql, pgsql, sdb, mssql, sqlite3, oracle , redis. default set internal.

from experience, when using database dlr-storage, delivery reports (dlr) kept in datatable while delivered status has not been received, automatically deleted.

so if wish keep logs sent items, need edit files (gw/dlr_mysql.c , gw/dlr.c) avoid delete.

configuration of dlr-strorage

here provide example mysql.

sample of additional configuration in kannel.conf file:

# line must in "core" group dlr-storage = mysql  #--------------------------------------------- # dlr storage # #  group = mysql-connection id = mydlr host = localhost username = *yourmysqlusername* password = *yourmysqlpass* database = *yourmysqldatabasewiththedlrtable* max-connections = 1  # group defining data in db (table, columns) group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc