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 <[email protected]> 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: [email protected] > t: +45 2374 0486 > w: apide.com > > > Den 11/06/2013 kl. 08.26 skrev testn4n1 <[email protected]>: > > 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 <[email protected]> wrote: > >> check page 91 of the guide (Table 6-9. Parameters (Escape Codes)) >> >> >> 2013/6/10 testn4n1 <[email protected]> >> >>> 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 <[email protected]> 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 <[email protected]> >>>> >>>>> 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 <[email protected]> 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 <[email protected]> >>>>>> >>>>>>> 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 <[email protected]> wrote: >>>>>>> >>>>>>>> 2013/6/10 testn4n1 <[email protected]> >>>>>>>> >>>>>>>>> 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 <[email protected]> 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 <[email protected]> >>>>>>>>>> >>>>>>>>>>> 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. >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
