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]> 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]> 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]> 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, 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]> wrote: Dear Alejandro, I am waiting for your replay. Regards, Chirag. --- On Tue, 21/7/09, Chirag Baraliya <[email protected]> wrote: From: Chirag Baraliya <[email protected]> Subject: Re: Problem with dlrurl invocation To: [email protected] Cc: "Alejandro Guerrieri" <[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]> wrote: From: Alejandro Guerrieri <[email protected]> Subject: Re: Problem with dlrurl invocation To: "Chirag Baraliya" <[email protected]> Cc: [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]> 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. Looking for local information? Find it on Yahoo! Local Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. Looking for local information? Find it on Yahoo! Local Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
