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. >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >