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]>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]>*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, 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/> >
