I have added different smsbox-id for sqlbox. Is it ok now ??
On Sun, Jun 26, 2011 at 3:10 PM, Nikos Balkanas <nbalka...@gmail.com> wrote:
> 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
>> >>
>> >
>> >
>
>
