Sqlbox doesnt handle dlrs, other than inserting them in the sent_sms table.
DLRs are routed to the boxc_id that they appear to come from. So yes, you should be able to insert messages in sqlbox-mt and set the boxc_id to smsbox. There is one quick way to see if it works or not Just try it once and you will find out. == Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Emmanuel CHANSON Sent: dinsdag 13 juli 2010 2:11 To: users Subject: Kannel system with 2 sqlbox and DLRs-URL My config: HTTP CGI script --> SMSBOX <---> SQLBOX-MO <---> BEARERBOX <---> MODEM | | HTTP SCRIPT for MT Injection -----> SQLBOX-MT-------------------- Basically I would like to use sqlbox-mt to send mailling SMS and sqlbox-mo to receive incoming MO. Therefore I would like to handle DLR reports for all MTs sent by SQLBOX-MT. I come to you to get some advises on how to configure the system to handle MOs, MTs and DLRs DLRs can comes from MTs sent by SQLBOX-MT (MT injection) and CGI Script interface of SMSBOX so my question is to know if SQLBOX-MT can fetch DLR URL is no SMSBOX are connected to it, I think the answer is NO ? So I need to route incoming DLRs to SQLBOX-MO ? I notice something strange when I made some tests. What is the purpose of 'boxc_id' in sqlbox ? When sending a SMS from CGI interface, sqlbox-mo insert 'smsbox' in the sent_sms table for this case. DLR-URL is fetched. When sending a SMS with an MT injection (done with sqlbox-mo), sqlbo-mo insert 'sqlbox-mo' (its id in fact) in the boxc_id field, but the DLR URL is not fetched at all, AND if I made the same test but I force to insert 'smsbox' in boxc_id field this time DLR_URL is fetched. An idea ? boxc_id from sqlbox doc: The bearerbox ID that should handle this message. You can usually leave this one alone Is it a normal behavior to force this parameter to be 'smsbox' in my case in order to fetch the DLR-URL ? How to handle DLRs correctly in the case where I have 2 sqlbox ? It seems to work with this config below where I route all incoming MO to sqlbox-mo (I think DLRs are incoming MO too) and insert MT in sqlbox-mt using 'boxc_id' = 'smsbox' in order to fetch the DLR-URL when the DLR comes into sqlbox-mo database. sqlbox-mo.conf: ---------------------- ####################### # SQLBOX group = sqlbox id = sqlbox-db #global-sender = "" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-id = sqlbox-mo smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/sqlbox.log" log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = root password = m...@c0m! database = kannelsql max-connections = 1 sqlbox-mt.conf: ---------------------- ####################### # SQLBOX group = sqlbox id = sqlbox-mt #global-sender = "" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13006 smsbox-id = sqlbox-mt smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/sqlbox-mt.log" log-level = 0 group = mysql-connection id = sqlbox-mt host = localhost username = root password = m...@c0m! database = sqlboxmt max-connections = 1 kannel.conf: ----------------- ... ############################# group = smsbox-route smsbox-id = sqlbox-mo smsc-id = huawei_e220 Regards, -- Emmanuel CHANSON Emmanuel Mobile Nouvelle-Calédonie: +687.77.35.02 Mobile France: +33 (0) 6.68.03.89.56 @email : emmanuelchan...@gmail.com
