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