Chirag, If you want your dlr-url to be hit by smsbox, the dlr's must end into smsbox.
There's two ways to connect smsbox and sqlbox: either in "paralell" or "serial". In paralell mode, both boxes connect directly to bearerbox, and messages inserted on sqlbox are delivered to bearerbox, but all MO traffic and DLR's go to smsbox. To achieve this, the simpler way is to set an smsbox-id on sqlbox, and none on smsbox. In "serial" mode, sqlbox connects to bearerbox and smsbox connects to smsbox. All MO and MT messages pass thru sqlbox and gets logged there. To do this you must set the smsbox port on smsbox to sqlbox's port instead of bearerbox's, so you'll probably need a separate configuration file for bearerbox and smsbox. Regards, Alejandro On Wed, Jul 29, 2009 at 2:08 PM, Chirag Baraliya <[email protected]>wrote: > Dear Alejandro / Kannel Group: > > I am anxiously waiting for any help / inputs / suggesions..!! > > Chirag > > --- On *Sat, 25/7/09, Chirag Baraliya <[email protected]>* wrote: > > > From: Chirag Baraliya <[email protected]> > Subject: Re: Fw: Re: Problem with dlrurl invocation > To: [email protected] > Cc: "Alejandro Guerrieri" <[email protected]> > Date: Saturday, 25 July, 2009, 10:36 AM > > Dear Alejandro, > > I have tried removing smsbox-id from smsbox config and keeping it in sqlbox > config (and also vice-versa) > If I remove smsbox-id from smsbox config, smsbox log doesn't show DLR but > if its there smsbox log shows DLR. In any case dlr-url is not invoked. > > I was refering to post: > http://www.mail-archive.com/[email protected]/msg11402.html and was adding > same smsbox-id to both smsbox and sqlbox config. > > Any opnions ?!! > > --- On *Sat, 25/7/09, Alejandro Guerrieri > <[email protected]>*wrote: > > > From: Alejandro Guerrieri <[email protected]> > Subject: Re: Fw: Re: Problem with dlrurl invocation > To: "Chirag Baraliya" <[email protected]> > Cc: [email protected] > Date: Saturday, 25 July, 2009, 8:22 AM > > That's the problem then. Remove it from smsbox and leave it on sqlbox. > Regards, > > Alejandro > > On Sat, Jul 25, 2009 at 8:11 AM, Chirag Baraliya <[email protected]>wrote: > >> Dear Alejandro, >> >> The said configuration line "smsbox-id = sqlbox" is already there in >> sqlbox.conf. Also the same line is present in group = smsbox in kannel.conf >> >> Is there any other setting or configuration I may tick to make dlr-url >> work ?? >> >> --------------------------------- 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 >> log-file = "/var/log/kannel/kannel-sqlbox.log" >> log-level = 0 >> >> # Example MYSQL Connection >> group = mysql-connection >> id = sqlbox-db >> host = localhost >> username = xxxxxxxx >> password = xxxxxxxx >> database = xxxxxxxx >> >> --- On *Fri, 24/7/09, Alejandro Guerrieri <[email protected]> >> * wrote: >> >> >> From: Alejandro Guerrieri <[email protected]> >> Subject: Re: Fw: Re: Problem with dlrurl invocation >> To: "Chirag Baraliya" <[email protected]> >> Cc: [email protected] >> Date: Friday, 24 July, 2009, 3:42 PM >> >> >> Chirag, >> Ok, try adding "smsbox-id = sqlbox" to your sqlbox.conf and see if that >> solves it. >> >> Regards, >> >> Alejandro >> >> On Fri, Jul 24, 2009 at 3:28 PM, Chirag Baraliya >> <[email protected]<http://mc/[email protected]> >> > wrote: >> >>> Dear Alejandro, >>> >>> 1. I have tested agian (with and without encoding dlr-url) - DLRs are >>> comming in. >>> 2. DLRs are getting inserted in sent_sms table and therefore, as you >>> said, are not going to smsbox. >>> 3. Please refer to my previously attached smslog, DLRs were also comming >>> to smsbox. >>> 4. This time, DLRs were seen in smsbox log only after I have closed >>> sqlbox - log pasted below. >>> 5. I am not able to understand SMSBox Log error - "ERROR: >>> smsbox_req_thread: no sender/receiver" >>> 6. I thanks you for you concern and looking for small thing, where I am >>> stuck up, to get going. >>> >>> ----------------------------------- SMSBox Log >>> ---------------------------- >>> 2009-07-24 18:48:42 [3692] [4] ERROR: smsbox_req_thread: no >>> sender/receiver, dump follows: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Msg object at 0x84ec5f0: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: type: sms >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.sender: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.receiver: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84e7738: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 12 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 13 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 39 31 39 38 39 30 30 34 30 >>> 38 34 37 919890040847 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.udhdata: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.msgdata: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ec918: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 119 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 120 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 69 64 3a 36 30 44 37 30 44 >>> 42 46 20 73 75 62 3a id:60D70DBF sub: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 30 30 31 20 64 6c 76 72 64 >>> 3a 30 30 31 20 73 75 001 dlvrd:001 su >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 62 6d 69 74 20 64 61 74 65 >>> 3a 30 39 30 37 32 34 bmit date:090724 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 31 38 34 36 20 64 6f 6e 65 >>> 20 64 61 74 65 3a 30 1846 done date:0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 39 30 37 32 34 31 38 34 36 >>> 20 73 74 61 74 3a 44 907241846 stat:D >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 45 4c 49 56 52 44 20 65 72 >>> 72 3a 30 30 31 20 54 ELIVRD err:001 T >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 65 78 74 3a 4a 61 79 20 73 >>> 68 72 65 65 4b 72 69 ext:Jay shreeKri >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 73 68 6e 61 36 34 >>> 36 shna646 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.time: 1248441410 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.smsc_id: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ec9b0: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 6 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 7 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 6d 79 73 6d 73 >>> 63 mysmsc >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.smsc_number: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.foreign_id: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ec9c8: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 8 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 9 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 36 30 44 37 30 44 42 >>> 46 60D70DBF >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.service: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.account: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ec9e0: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 5 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 6 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 63 69 6e 66 >>> 6f cinfo >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.id: >>> 2275b6c1-a155-4509-9a16-4def7cb41004 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.sms_type: 3 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.mclass: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.mwi: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.coding: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.compress: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.validity: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.deferred: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.dlr_mask: 1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.dlr_url: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84eca08: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 97 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 98 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 68 74 74 70 25 33 41 25 32 >>> 46 25 32 46 6c 6f 63 http%3A%2F%2Floc >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 61 6c 68 6f 73 74 25 32 46 >>> 64 6c 72 2e 70 68 70 alhost%2Fdlr.php >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 25 33 46 6d 73 67 69 64 25 >>> 33 44 38 35 63 63 66 %3Fmsgid%3D85ccf >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 39 63 33 2d 35 31 33 62 2d >>> 31 35 38 65 2d 33 36 9c3-513b-158e-36 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 64 31 2d 39 63 37 34 31 32 >>> 37 66 35 30 34 64 25 d1-9c74127f504d% >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 32 36 73 74 61 74 75 73 25 >>> 33 44 43 68 69 72 61 26status%3DChira >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: >>> 67 g >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.pid: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.alt_dcs: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.rpi: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.charset: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.boxc_id: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ecab8: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 6 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 7 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 73 71 6c 62 6f >>> 78 sqlbox >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.binfo: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.msg_left: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.split_parts: (nil) >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.priority: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.resend_try: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.resend_time: -1 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: sms.meta_data: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string at 0x84ecb00: >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: len: 18 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: size: 19 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: immutable: 0 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 3f 73 6d 70 70 3f 64 6c 72 >>> 5f 65 72 72 3d 30 30 ?smpp?dlr_err=00 >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: data: 31 >>> 26 1& >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Octet string dump ends. >>> 2009-07-24 18:48:42 [3692] [4] DEBUG: Msg object ends. >>> >>> >>> --- On *Fri, 24/7/09, Alejandro Guerrieri >>> <[email protected]<http://mc/[email protected]> >>> >* wrote: >>> >>> >>> From: Alejandro Guerrieri >>> <[email protected]<http://mc/[email protected]> >>> > >>> Subject: Re: Fw: Re: Problem with dlrurl invocation >>> To: "Chirag Baraliya" >>> <[email protected]<http://mc/[email protected]> >>> > >>> Cc: [email protected] <http://mc/[email protected]> >>> Date: Friday, 24 July, 2009, 12:37 PM >>> >>> >>> Chirad, >>> Assuming the dlr was received on the bearerbox, it should be directed to >>> smsbox, which will hit your url. >>> >>> If instead of smsbox, the dlr got back into sqlbox, it will be stored on >>> sqlbox and your url won't be hit. >>> >>> Check on sent_sms and look if your dlr's are there. >>> >>> On Fri, Jul 24, 2009 at 2:23 PM, Chirag Baraliya >>> <[email protected]<http://mc/[email protected]> >>> > wrote: >>> >>>> Hi Alejandro, >>>> >>>> I cant understand what you said, I checked it again, dlr created msg >>>> comes in the BBlog >>>> but problem not solved, Please explain in Brirf. >>>> >>>> Chirag >>>> >>>> --- On *Fri, 24/7/09, Alejandro Guerrieri < >>>> [email protected]<http://mc/[email protected]> >>>> >* wrote: >>>> >>>> >>>> From: Alejandro Guerrieri >>>> <[email protected]<http://mc/[email protected]> >>>> > >>>> Subject: Re: Fw: Re: Problem with dlrurl invocation >>>> To: "Chirag Baraliya" >>>> <[email protected]<http://mc/[email protected]> >>>> > >>>> Cc: [email protected] <http://mc/[email protected]> >>>> Date: Friday, 24 July, 2009, 10:46 AM >>>> >>>> >>>> Check if the dlr messages are being routed to smsbox, maybe are being >>>> stored on sqlbox instead? >>>> >>>> On Fri, Jul 24, 2009 at 6:56 AM, Chirag Baraliya >>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>> > wrote: >>>> >>>>> >>>>> Dear Alejandro, >>>>> >>>>> I am waiting for your replay. >>>>> >>>>> Regards, >>>>> Chirag. >>>>> >>>>> >>>>> --- On *Tue, 21/7/09, Chirag Baraliya >>>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> >* wrote: >>>>> >>>>> >>>>> From: Chirag Baraliya >>>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]>> >>>>> >>>>> Subject: Re: Problem with dlrurl invocation >>>>> To: >>>>> [email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> Cc: "Alejandro Guerrieri" >>>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> > >>>>> Date: Tuesday, 21 July, 2009, 1:04 PM >>>>> >>>>> >>>>> I have checked the Apache log, url is not being called. >>>>> I have tested this using cgi-bin/sendsms - thru smsbox - in this case >>>>> dlr-url is being called as seen in apache log. >>>>> >>>>> Chirag. >>>>> >>>>> --- On *Tue, 21/7/09, Alejandro Guerrieri < >>>>> [email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> >* wrote: >>>>> >>>>> >>>>> From: Alejandro Guerrieri >>>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> > >>>>> Subject: Re: Problem with dlrurl invocation >>>>> To: "Chirag Baraliya" >>>>> <[email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> > >>>>> Cc: >>>>> [email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> Date: Tuesday, 21 July, 2009, 12:59 PM >>>>> >>>>> Are you sure that your script is not being called? Check on your apache >>>>> logs to be sure. >>>>> >>>>> On Tue, Jul 21, 2009 at 1:53 PM, Chirag Baraliya < >>>>> [email protected]<http://in.mc1124.mail.yahoo.com/mc/[email protected]> >>>>> > wrote: >>>>> >>>>>> Dear All Kannel user, >>>>>> >>>>>> I am newly working with kannel, I have one problem. >>>>>> I have one php script for inserting message in the sqlbox send_sms >>>>>> table and that script also inserts the row in the one another >>>>>> table(smslog), >>>>>> in which I want to insert record for message and when the dlrurl will be >>>>>> invoked, I want to update that table (status field) for delivered message >>>>>> using php script in dlrurl. But when the dlr came, my table was not >>>>>> uadate >>>>>> its status. >>>>>> I think that dlr.php script is not invoked. But when I run this >>>>>> script manually >>>>>> at that time it updates the status. >>>>>> >>>>>> Attaching : smsboxlog file, Kannel.log file, kannel config >>>>>> file(cd.conf), sqlbox config file(sql.conf). >>>>>> >>>>>> Please Sombody help me in this situation. >>>>>> >>>>>> >>>>>> Warms Regards, >>>>>> Chirag. >>>>>> >>>>>> ------------------------------ >>>>>> Yahoo! recommends that you upgrade to the new and safer Internet >>>>>> Explorer >>>>>> 8<http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/> >>>>>> . >>>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> Looking for local information? Find it on Yahoo! >>>>> Local<http://in.rd.yahoo.com/tagline_local_1/*http://in.local.yahoo.com/> >>>>> >>>>> >>>>> ------------------------------ >>>>> Yahoo! recommends that you upgrade to the new and safer Internet >>>>> Explorer >>>>> 8<http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/> >>>>> . >>>>> >>>> >>>> >>>> ------------------------------ >>>> Yahoo! recommends that you upgrade to the new and safer Internet >>>> Explorer >>>> 8<http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/> >>>> . >>>> >>> >>> >>> ------------------------------ >>> Looking for local information? Find it on Yahoo! >>> Local<http://in.rd.yahoo.com/tagline_local_1/*http://in.local.yahoo.com/> >>> >> >> >> ------------------------------ >> See the Web's breaking stories, chosen by people like you. Check out Yahoo! >> Buzz <http://in.rd.yahoo.com/tagline_buzz_1/*http://in.buzz.yahoo.com/>. >> > > > ------------------------------ > See the Web's breaking stories, chosen by people like you. Check out Yahoo! > Buzz <http://in.rd.yahoo.com/tagline_buzz_1/*http://in.buzz.yahoo.com/>. > > > ------------------------------ > Yahoo! recommends that you upgrade to the new and safer Internet Explorer > 8<http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/> > . >
