My config files. group = core admin-port = 13015 admin-password = foo #admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1" dlr-storage = mysql smsbox-port = 13016 #wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" access-log = "/var/log/kannel/access.log" #box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" log-level = 0
group = smsc smsc-id = huawei_e220 smsc = at modemtype = auto device= /dev/ttyUSB0 my-number = +91 connect-allow-ip = 127.0.0.1 sim-buffering = true log-level = 0 #log-file = "/var/log/kannel/smsc.log" # DLR with MySQL support configuration group = mysql-connection id = mydlr host = localhost username = foo password = bar database = foobar 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 group = modems id = auto name = "Huawei" detect-string = "huawei" init-string = "ATZ" #init-string = "AT+CMEE=1" #init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" init-string = "AT+CNMI=2,1,2,2,0;+CMEE=1" message-storage = SM message-start = 0 #speed = 460800 #message-start = 0 group = smsbox smsbox-id = mysmsbox bearerbox-host = *********** bearerbox-port = 13016 sendsms-port = 13018 global-sender = +91 access-log = "/var/log/kannel/smsbox-access.log" log-file = "/var/log/kannel/smsbox.log" log-level = 0 mo-recode = true group = smsbox-route smsbox-id = mysmsbox smsc-id = huawei_e220 group = sendsms-user username = foo password = bar concatenation= true max-messages = 10000 group = sms-service keyword-regex = .* text = "Thanks for sending SMS" catch-all = true accepted-smsc = huawei_e220 max-messages = 3 #get-url = "http://202.164.53.116/~harbhag/test.php?phone=%p&text=%r" group = sqlbox id = sqlbox-db smsbox-id = mysmsbox global-sender = "+91" bearerbox-host = ************ bearerbox-port = 13016 smsbox-port = 13020 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 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = foo password = bar database = foobar On Sun, Jun 26, 2011 at 10:06 AM, Nikos Balkanas <nbalka...@gmail.com> wrote: > Hi, > > Apparently your bearerbox doesn't know where to route received DLRs. You > should read UG about smsbox-route, and then route all your DLRs to your > smsbox, so that they can be posted to your dlr-url. > BR, > Nikos > On Sun, Jun 26, 2011 at 7:04 AM, Harbhag Singh Sohal > <harbhag.so...@gmail.com> wrote: >> >> Sometimes the dlr is stored in the table specified by me via the >> dlr-url script and sometimes it get stored in the sent_sms table of >> sqlbox. Why is this happening ? >> >> On Sat, Jun 25, 2011 at 5:39 PM, Nikos Balkanas <nbalka...@gmail.com> >> wrote: >> > Hi, >> > >> > Your php is not kannel's problem. This is not a php forum. There are 2 >> > ways >> > to match dlrs to original SMS. >> > 1) access.log >> > 2) Specify your own msgid in your dlr-url: >> > &msgid=<id> >> > wehere id=1,2..... >> > You know what sms you are sending when you specify your dlr-url. You >> > also >> > get back that id once the relevant DLR arrives. You can match those two. >> > BR, >> > Nikos >> > >> > >> > On Sat, Jun 25, 2011 at 1:29 PM, Harbhag Singh Sohal >> > <harbhag.so...@gmail.com> wrote: >> >> >> >> but how would I know that which dlr is from which SMS ? >> >> is it being identified by msgid parameter ? >> >> >> >> >> >> I am using sqlbox to send sms so in the dlr-url column I have added >> >> http://localhost/dlr.php as the dlr-url and dlr-mask is set to 31. >> >> >> >> and the dlr.php file contains >> >> >> >> $conn = mysql_connect("localhost","foo","bar"); >> >> mysql_select_db("adbook",$conn); >> >> mysql_query("INSERT INTO tdlr ('dlr') VALUES ('1')"); >> >> >> >> mysql_close($conn); >> >> >> >> this is the only code that is there in dlr.php file and according to >> >> this an new row should be inserted into the database everytime dlr is >> >> received, but its not happening. >> >> >> >> On Sat, Jun 25, 2011 at 1:41 PM, Harbhag Singh Sohal >> >> <harbhag.so...@gmail.com> wrote: >> >> > but how would I know that which dlr is from which SMS ? >> >> > is it being identified by msgid parameter ? >> >> > >> >> > On Fri, Jun 24, 2011 at 9:03 PM, Rene Kluwen <rene.klu...@chimit.nl> >> >> > wrote: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> From: Mpeirwe Benjamin [mailto:bmpei...@gmail.com] >> >> >> Sent: Friday, 24 June, 2011 15:54 >> >> >> To: Rene Kluwen >> >> >> Subject: Re: understanding DLR >> >> >> >> >> >> >> >> >> >> >> >> dlr you specified is a temporary storage....do what rene told you >> >> >> >> >> >> On Fri, Jun 24, 2011 at 2:07 PM, Rene Kluwen <rene.klu...@chimit.nl> >> >> >> wrote: >> >> >> >> >> >> Don't use the dlr database table for that. >> >> >> Instead specify dlr-mask & dlr-url. See the users guide. >> >> >> >> >> >> -----Original Message----- >> >> >> From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On >> >> >> Behalf >> >> >> Of Harbhag Singh Sohal >> >> >> Sent: Friday, 24 June, 2011 08:22 >> >> >> To: users@kannel.org >> >> >> Subject: understanding DLR >> >> >> >> >> >> HI, >> >> >> >> >> >> I am using mysql as dlr-storage. When I send SMS I can see dlr table >> >> >> get populated but after its gets deleted. Now in the access.log >> >> >> file, >> >> >> I see the following entries >> >> >> >> >> >> 2011-06-24 11:42:58 Sent SMS [SMSC:huawei_e220] [SVC:] [ACT:] >> >> >> [BINF:] >> >> >> [FID:62] [META:] [from:+9194********] [to:94********] >> >> >> [flags:-1:0:-1:-1:31] [msg:38:---..Harbhag Singh Sohal.] [udh:0:] >> >> >> 2011-06-24 11:42:58 Receive DLR [SMSC:huawei_e220] [SVC:] [ACT:] >> >> >> [BINF:] [FID:62] [META:] [from:+9194********] [to:94*******] >> >> >> [flags:-1:-1:-1:-1:8] [msg:4:ACK/] [udh:0:] >> >> >> 2011-06-24 11:43:57 Receive DLR [SMSC:huawei_e220] [SVC:] [ACT:] >> >> >> [BINF:] [FID:62] [META:] [from:+9194**********] [to:94*******] >> >> >> [flags:-1:-1:-1:-1:1] [msg:7:Success] [udh:0:] >> >> >> >> >> >> From above i can see that message was delivered successfully. What >> >> >> is >> >> >> [FID:62] , is it being used to associate a particular message to its >> >> >> dlr. How can store the above information to the database so that I >> >> >> can >> >> >> notify the users that the message has been delivered successfully ? >> >> >> >> >> >> -- >> >> >> Regards >> >> >> Harbhag Singh Sohal >> >> >> www.harbhag.wordpress.com >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> "The Scientist explores what is, >> >> >> the Engineer creates what has never been." >> >> >> Theodore von Karman >> >> >> >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > Regards >> >> > Harbhag Singh Sohal >> >> > www.harbhag.wordpress.com >> >> > >> >> >> >> >> >> >> >> -- >> >> Regards >> >> Harbhag Singh Sohal >> >> www.harbhag.wordpress.com >> >> >> > >> > >> >> >> >> -- >> Regards >> Harbhag Singh Sohal >> www.harbhag.wordpress.com >> > >