Great! You have configured both sqlbox and smsbox with the same smsbox-id, mysmsbox. And then, you use smsbox-route to tell bb to route all DLRs to mysmsbox. What do you think it will happen?
BR, Nikos On Sun, Jun 26, 2011 at 11:27 AM, Harbhag Singh Sohal < harbhag.so...@gmail.com> wrote: > 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 > >> > > > > >
