Kannel 1.5.0 sqlbo 0.7.2 On 13 June 2013 12:39, spameden <spame...@gmail.com> wrote:
> What kannel version you're using btw? > > > 2013/6/13 spameden <spame...@gmail.com> > >> 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. >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >