Here are my configurations again. Kannel.conf ===========
group = core admin-port = 13000 smsbox-port = 13001 admin-password = bar dlr-storage = mysql box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" group = smsc smsc = fake smsc-id = FAKE port = 20000 connect-allow-ip = 127.0.0.1 group = smsbox smsbox-id = box1 bearerbox-host = 127.0.0.1 sendsms-port = 13013 global-sender = 13013 group = sendsms-user username = tester password = foobar #user-deny-ip = "" #user-allow-ip = "" group = sms-service keyword = nop text = "You asked nothing and I did it!" group = sms-service keyword = default text = "No service specified" group = smsc smsc = smpp smsc-id = smpp-nexmo host = smpp0.nexmo.com port = 8000 transceiver-mode = true throughput = 10 smsc-username = ******* smsc-password = ******** system-type = nexmo dest-addr-ton=1 msg-id-type=0x01 alt-charset = LATIN1 enquire-link-interval = 30 group = sendsms-user username = tester password = foobar name = users #user-deny-ip = "*.*.*.*" user-allow-ip = "*.*.*.*" max-messages = 3 concatenation = 1 omit-empty = 1 group = mysql-connection id = mydlr host = localhost username = root password = root database = kannel group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-source=source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc sqlbox.conf ========== group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms # MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = root password = root database = kannel Please verify these and tell me if anything is wrong or missing. On 13 June 2013 14:28, testn4n1 <testn...@gmail.com> wrote: > Ya i compiled it from latest source only but still facing this problem. > > > On 13 June 2013 14:21, spameden <spame...@gmail.com> wrote: > >> I was wrong, you need to urlencode each parameter passed, i.e: >> >> 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?<http://192.168.111.151:8085/Kannel_Test/Receive_dlr?message=%25a×tamp=%25t&sender=%25p&receiver=%25P&smsc_id=%25i&dlr_value=%25d&msg_id=%25F&sendsms_user=%25n> >> message=%25a×tamp=%25t' >> >> so your previous URL should work actually >> >> >> >> 2013/6/13 testn4n1 <testn...@gmail.com> >> >>> No, this is also not working. Same result as before. >>> >>> >>> On 13 June 2013 12:37, spameden <spame...@gmail.com> wrote: >>> >>>> try urlencoding whole parameter string, i.e.: >>>> >>>> insert this value as dlr_url: >>>> >>>> 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr?<http://192.168.111.151:8085/Kannel_Test/Receive_dlr?message=%25a×tamp=%25t&sender=%25p&receiver=%25P&smsc_id=%25i&dlr_value=%25d&msg_id=%25F&sendsms_user=%25n> >>>> message%3D%25a%26timestamp%3D%25t%26sender%3D%25p%26receiver%3D%25P%26smsc_id%3D%25i%26dlr_value%3D%25d%26msg_id%3D%25F%26sendsms_user%3D%25n' >>>> >>>> hope it helps >>>> >>>> >>>> >>>> 2013/6/13 testn4n1 <testn...@gmail.com> >>>> >>>>> Hi, >>>>> >>>>> Did you find any solution to my problem? >>>>> >>>>> Regards, >>>>> James >>>>> >>>>> >>>>> On 12 June 2013 09:45, testn4n1 <testn...@gmail.com> wrote: >>>>> >>>>>> Yes, that problem is solved. But now i am having another problem. >>>>>> >>>>>> >>>>>> When i insert into the database using the following query, the >>>>>> dlr_url is called instantly and it is called as-it-is. i.e. the %i, %p >>>>>> etc. >>>>>> values are not replced with actual values. After the actual delivery >>>>>> report >>>>>> arrives, the same url is called again without actual values i.e %i, %t, >>>>>> %P >>>>>> etc. are passed. Please help. >>>>>> >>>>>> INSERT INTO send_sms (momt, sender, smsc_id, receiver, msgdata, >>>>>> sms_type, dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', >>>>>> 'smpp-clickatell', '919067184864', 'Abbe russshuuuu', 2, 31, ' >>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr?message=%25a×tamp=%25t&sender=%25p&receiver=%25P&smsc_id=%25i&dlr_value=%25d&msg_id=%25F&sendsms_user=%25n >>>>>> ' >>>>>> , 'box1'); >>>>>> >>>>>> >>>>>> On 11 June 2013 19:29, spameden <spame...@gmail.com> wrote: >>>>>> >>>>>>> Quoting Rene on this one: >>>>>>> >>>>>>> On Wed, Aug 1, 2012 at 3:05 PM, Rene Kluwen <rene.kluwen at chimit.nl >>>>>>> <http://www.kannel.org/mailman/listinfo/users>> wrote: >>>>>>> >>>>>>> The error is self-explanatory. >>>>>>> >>>>>>> You should just dlrencode your parameters in the dlr-url. Not the url >>>>>>> itself. >>>>>>> >>>>>>> >>>>>>> So >>>>>>> insert:http://10.0.0.1/sms/dlrNEW.php?dlr=%25d%26to%3D%25p%26smsID%3D%25A%26BatchID%3Dravi123-5d12d21asdq1asravi >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> 2013/6/11 testn4n1 <testn...@gmail.com> >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> I am facing some problems. >>>>>>>> When i insert into the database using the following query, the >>>>>>>> dlr_url is called instantly and it is called as-it-is. i.e. the %i, %p >>>>>>>> etc. >>>>>>>> values are not replced with actual values. After the actual delivery >>>>>>>> report >>>>>>>> arrives, the same url is called again without actual values i.e %i, >>>>>>>> %t, %P >>>>>>>> etc. are passed. Please help. >>>>>>>> >>>>>>>> INSERT INTO send_sms (momt, sender, smsc_id, receiver, msgdata, >>>>>>>> sms_type, dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', >>>>>>>> 'smpp-clickatell', '919067184864', 'Abbe russshuuuu', 2, 31, ' >>>>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr?message=%25a×tamp=%25t&sender=%25p&receiver=%25P&smsc_id=%25i&dlr_value=%25d&msg_id=%25F&sendsms_user=%25n', >>>>>>>> 'box1'); >>>>>>>> >>>>>>>> >>>>>>>> On 11 June 2013 13:12, testn4n1 <testn...@gmail.com> wrote: >>>>>>>> >>>>>>>>> I am getting this error: >>>>>>>>> >>>>>>>>> 2013-06-11 12:27:07 [4669] [7] WARNING: DLR[mysql]: DLR from >>>>>>>>> SMSC<smpp> for DST<919067184864> not found. >>>>>>>>> 2013-06-11 12:27:07 [4669] [7] ERROR: SMPP[smpp]: got DLR but >>>>>>>>> could not find message or was not interested in it id<400000007077826> >>>>>>>>> dst<919067184864>, type<1> >>>>>>>>> >>>>>>>>> I read on a blog where it says "try the smsc group parameter >>>>>>>>> "msg-id-type = 0x01" >>>>>>>>> >>>>>>>>> In my configuration, i have already set this but its not working. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On 11 June 2013 12:12, Jacob Eiler <jacob.ei...@apide.com> wrote: >>>>>>>>> >>>>>>>>>> Hi James >>>>>>>>>> >>>>>>>>>> It is only the query parameter values part that should be encoded: >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> http://192.168.111.151:8085/Kannel_Test/Recieve_dlr?message=%25a×tamp=%25tetc >>>>>>>>>> >>>>>>>>>> Jacob Eiler >>>>>>>>>> Apide ApS >>>>>>>>>> e: jacob.ei...@apide.com >>>>>>>>>> t: +45 2374 0486 >>>>>>>>>> w: apide.com >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Den 11/06/2013 kl. 08.26 skrev testn4n1 <testn...@gmail.com>: >>>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> Hi tried the following insert query with the encoded url: >>>>>>>>>> >>>>>>>>>> INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, >>>>>>>>>> dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', >>>>>>>>>> 'Abbe >>>>>>>>>> russshuuuu', 2, 31, >>>>>>>>>> 'http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fmessage%3D%25a%26timestamp%3D%25t%26sender%3D%25p%26receiver%3D%25P%26smsc_id%3D%25i%26dlr_value%3D%25d%26msg_id%3D%25F%26sendsms_user%3D%25n', >>>>>>>>>> 'box1'); >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Kannel gives the following error: >>>>>>>>>> >>>>>>>>>> ERROR: URL >>>>>>>>>> <http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fmessage%3D%25a%26timestamp%3D%25t%26sender%3D%25p%26receiver%3D%25P%26smsc_id%3D%25i%26dlr_value%3D%25d%26msg_id%3D%25F%26sendsms_user%3D%25n> >>>>>>>>>> doesn't start with `http://' nor `https://' >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> James >>>>>>>>>> >>>>>>>>>> On 10 June 2013 19:27, spameden <spame...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> check page 91 of the guide (Table 6-9. Parameters (Escape Codes)) >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com> >>>>>>>>>>> >>>>>>>>>>>> Hi, >>>>>>>>>>>> >>>>>>>>>>>> I read the user-guide. It says about url encoding in the MO >>>>>>>>>>>> Messages section. but it does not specify what are the key and >>>>>>>>>>>> values for >>>>>>>>>>>> the parameters. i.e. which are the common parameters we need to >>>>>>>>>>>> pass in the >>>>>>>>>>>> dlr-url. >>>>>>>>>>>> Only an example is given like this: >>>>>>>>>>>> >>>>>>>>>>>> http://localhost/myscript?...&meta-data=%D&... >>>>>>>>>>>> >>>>>>>>>>>> can you please tell me which are the other parameters and their >>>>>>>>>>>> values? >>>>>>>>>>>> also, it specifies %D as value for the meta-data key. Is it >>>>>>>>>>>> something that kannel replaces %D with some other value and then >>>>>>>>>>>> calls the >>>>>>>>>>>> specified url? if yes, then what are the other such values for the >>>>>>>>>>>> keys? >>>>>>>>>>>> >>>>>>>>>>>> Regards, >>>>>>>>>>>> James >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On 10 June 2013 18:23, spameden <spame...@gmail.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Yes, you need to: >>>>>>>>>>>>> >>>>>>>>>>>>> 1) URLENCODE URL before inserting into database >>>>>>>>>>>>> 2) pass parameters into URL, i.e. >>>>>>>>>>>>> >>>>>>>>>>>>> example: >>>>>>>>>>>>> http%3A%2F%2F192.168.111.151%3A8085%2FKannel_Test%2FReceive_dlr%3Fsmsc-id%3D%25i%22%22 >>>>>>>>>>>>> >>>>>>>>>>>>> Once again, read user-guide. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com> >>>>>>>>>>>>> >>>>>>>>>>>>>> ok...the url i provided gets called the second i insert data >>>>>>>>>>>>>> into the send_sms table but no parameters are passed. i printed >>>>>>>>>>>>>> all the >>>>>>>>>>>>>> request parameters but got nothing. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On 10 June 2013 17:58, spameden <spame...@gmail.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> To achieve this you need to put smsbox in between of the >>>>>>>>>>>>>>> sqlbox and bearerbox or enforce smsbox id into boxc_id field, >>>>>>>>>>>>>>> i.e.: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> INSERT INTO send_sms (momt, sender, receiver, msgdata, >>>>>>>>>>>>>>> sms_type, dlr_mask, dlr_url, boxc_id) VALUES ('MT', '1234', >>>>>>>>>>>>>>> '919067184864', >>>>>>>>>>>>>>> 'Abbe russshuuuu', 2, 31, ' >>>>>>>>>>>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr', >>>>>>>>>>>>>>> 'smsbox_id'); >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> i am trying to send sms by inserting data into send_sms >>>>>>>>>>>>>>>> table and want to process dlrs with script using dlr_url. So, >>>>>>>>>>>>>>>> i have >>>>>>>>>>>>>>>> changed the configuration to the following but i cannot >>>>>>>>>>>>>>>> receive anything in >>>>>>>>>>>>>>>> my application: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> group = sendsms-user >>>>>>>>>>>>>>>> username = tester >>>>>>>>>>>>>>>> password = foobar >>>>>>>>>>>>>>>> forced-smsc = smpp-nexmo >>>>>>>>>>>>>>>> name = users >>>>>>>>>>>>>>>> dlr-url = >>>>>>>>>>>>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> #user-deny-ip = "*.*.*.*" >>>>>>>>>>>>>>>> user-allow-ip = "*.*.*.*" >>>>>>>>>>>>>>>> max-messages = 3 >>>>>>>>>>>>>>>> concatenation = 1 >>>>>>>>>>>>>>>> omit-empty = 1 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I am executing the following query for inserting the data: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> INSERT INTO send_sms (momt, sender, receiver, msgdata, >>>>>>>>>>>>>>>> sms_type, dlr_mask, dlr_url) VALUES ('MT', '1234', >>>>>>>>>>>>>>>> '919067184864', 'Abbe >>>>>>>>>>>>>>>> russshuuuu', 2, 31, ' >>>>>>>>>>>>>>>> http://192.168.111.151:8085/Kannel_Test/Receive_dlr'); >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> The dlr is not routed to my specified url. Can you please >>>>>>>>>>>>>>>> tell me what is wrong here? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>>>> James >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On 10 June 2013 17:06, spameden <spame...@gmail.com> wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> ok...but then why are there entries in my sent_sms table >>>>>>>>>>>>>>>>>> like the following: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> 12 | DLR | 1234 | 919067184864 | NULL | >>>>>>>>>>>>>>>>>> id%3A288230376265477711+sub%3A001+dlvrd%3A001+submit+date%3A1306061034+done+date%3A1306060504+stat%3ADELIVRD+err%3A000+text%3Anone++++++++++++++++ >>>>>>>>>>>>>>>>>> | 1370495099 | smpp-nexmo | NULL | 51dc0ffb | NULL | >>>>>>>>>>>>>>>>>> 3 | NULL | >>>>>>>>>>>>>>>>>> NULL | NULL | NULL | NULL | NULL | 1 | >>>>>>>>>>>>>>>>>> NULL | NULL >>>>>>>>>>>>>>>>>> | NULL | NULL | NULL | sqlbox | NULL | >>>>>>>>>>>>>>>>>> ?smpp?dlr_err=000& | >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> what are the other ways to handle dlr instead of >>>>>>>>>>>>>>>>>> modifying the source? >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> because sqlbox moves everything into sent_sms table. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> you can process DLRs with a script supplied to dlr_url >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> but it would be easier and more proper to modify sqlbox >>>>>>>>>>>>>>>>> code to store where you want them. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> On 10 June 2013 16:55, spameden <spame...@gmail.com>wrote: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> dlr table only used to track which messages are awaiting >>>>>>>>>>>>>>>>>>> reports >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> you need to modify sqlbox source if you need to store >>>>>>>>>>>>>>>>>>> DLR entries separately >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> 2013/6/10 testn4n1 <testn...@gmail.com> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> I am able to send sms using sqlbox and able to receive >>>>>>>>>>>>>>>>>>>> dlr reports also. But, these reports do not go in the >>>>>>>>>>>>>>>>>>>> table that i specify. >>>>>>>>>>>>>>>>>>>> Instead, the reports are stored in sent_sms table. Below >>>>>>>>>>>>>>>>>>>> is my >>>>>>>>>>>>>>>>>>>> configuration: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Kannel.conf >>>>>>>>>>>>>>>>>>>> ------------------ >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = core >>>>>>>>>>>>>>>>>>>> admin-port = 13000 >>>>>>>>>>>>>>>>>>>> smsbox-port = 13001 >>>>>>>>>>>>>>>>>>>> admin-password = bar >>>>>>>>>>>>>>>>>>>> dlr-storage = mysql >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = smsbox >>>>>>>>>>>>>>>>>>>> bearerbox-host = 127.0.0.1 >>>>>>>>>>>>>>>>>>>> sendsms-port = 13013 >>>>>>>>>>>>>>>>>>>> global-sender = 13013 >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = sendsms-user >>>>>>>>>>>>>>>>>>>> username = tester >>>>>>>>>>>>>>>>>>>> password = foobar >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = sms-service >>>>>>>>>>>>>>>>>>>> keyword = nop >>>>>>>>>>>>>>>>>>>> text = "You asked nothing and I did it!" >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = smsc >>>>>>>>>>>>>>>>>>>> smsc = smpp >>>>>>>>>>>>>>>>>>>> smsc-id = server1 >>>>>>>>>>>>>>>>>>>> host = smpp0.net >>>>>>>>>>>>>>>>>>>> port = 8000 >>>>>>>>>>>>>>>>>>>> transceiver-mode = true >>>>>>>>>>>>>>>>>>>> throughput = 10 >>>>>>>>>>>>>>>>>>>> smsc-username = ********** >>>>>>>>>>>>>>>>>>>> smsc-password = ********** >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = sendsms-user >>>>>>>>>>>>>>>>>>>> username = tester >>>>>>>>>>>>>>>>>>>> password = foobar >>>>>>>>>>>>>>>>>>>> forced-smsc = server1 >>>>>>>>>>>>>>>>>>>> name = users >>>>>>>>>>>>>>>>>>>> #user-deny-ip = "*.*.*.*" >>>>>>>>>>>>>>>>>>>> user-allow-ip = "*.*.*.*" >>>>>>>>>>>>>>>>>>>> max-messages = 3 >>>>>>>>>>>>>>>>>>>> concatenation = 1 >>>>>>>>>>>>>>>>>>>> omit-empty = 1 >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = mysql-connection >>>>>>>>>>>>>>>>>>>> id = mydlr >>>>>>>>>>>>>>>>>>>> host = localhost >>>>>>>>>>>>>>>>>>>> username = root >>>>>>>>>>>>>>>>>>>> password = root >>>>>>>>>>>>>>>>>>>> database = kannel >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = dlr-db >>>>>>>>>>>>>>>>>>>> id = mydlr >>>>>>>>>>>>>>>>>>>> table = dlr >>>>>>>>>>>>>>>>>>>> field-smsc = smsc >>>>>>>>>>>>>>>>>>>> field-timestamp = ts >>>>>>>>>>>>>>>>>>>> field-source=source >>>>>>>>>>>>>>>>>>>> field-destination = destination >>>>>>>>>>>>>>>>>>>> field-service = service >>>>>>>>>>>>>>>>>>>> field-url = url >>>>>>>>>>>>>>>>>>>> field-mask = mask >>>>>>>>>>>>>>>>>>>> field-status = status >>>>>>>>>>>>>>>>>>>> field-boxc-id = boxc >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> ------------------------------ >>>>>>>>>>>>>>>>>>>> --------------------------------------------- >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> sqlbox.conf >>>>>>>>>>>>>>>>>>>> ------------------ >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> group = sqlbox >>>>>>>>>>>>>>>>>>>> id = sqlbox-db >>>>>>>>>>>>>>>>>>>> smsbox-id = sqlbox >>>>>>>>>>>>>>>>>>>> bearerbox-host = localhost >>>>>>>>>>>>>>>>>>>> bearerbox-port = 13001 >>>>>>>>>>>>>>>>>>>> smsbox-port = 13005 >>>>>>>>>>>>>>>>>>>> smsbox-port-ssl = false >>>>>>>>>>>>>>>>>>>> sql-log-table = sent_sms >>>>>>>>>>>>>>>>>>>> sql-insert-table = send_sms >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> # MYSQL Connection >>>>>>>>>>>>>>>>>>>> group = mysql-connection >>>>>>>>>>>>>>>>>>>> id = sqlbox-db >>>>>>>>>>>>>>>>>>>> host = localhost >>>>>>>>>>>>>>>>>>>> username = root >>>>>>>>>>>>>>>>>>>> password = root >>>>>>>>>>>>>>>>>>>> database = kannel >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> --------------------------------------------------------------------------- >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> The sms are sent successfully from send_sms and >>>>>>>>>>>>>>>>>>>> transferred to the table sent_sms but the delivery reports >>>>>>>>>>>>>>>>>>>> are also stored >>>>>>>>>>>>>>>>>>>> in the same table and the dlr table is always empty. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> If anyone has come accross this problem, please help me. >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >