On Sun, 2011-06-26 at 20:10, Harbhag Singh Sohal wrote: > I apologize for bothering you guys. I appreciate your patience. I > think I can live without delivery reports. > Anyway, Thanks for help.
I don't think that you should give up. Thoroughly study userguide, think about your configuration, carefully read log files. After that ask question in mailing list providing relevant data. Be patient. Solution will be found at the end (not before ;) ), probably. > On Sun, Jun 26, 2011 at 7:29 PM, Nikos Balkanas <nbalka...@gmail.com> wrote: > > This is your 14th mail in the past 2 days. Apparently you don't have the > > skills for what you are trying to do. Please hire a consultant to do it for > > you and free this list. > > > > Nikos > > On Sun, Jun 26, 2011 at 4:35 PM, Harbhag Singh Sohal > > <harbhag.so...@gmail.com> wrote: > >> > >> What should I change in my current configuration files to achieve > >> Bearerbox-sqlbox-smsbox ? > >> > >> > >> On Sun, Jun 26, 2011 at 3:39 PM, Cezary Siwek <cza...@thebestisp.co.uk> > >> wrote: > >> > It depends what you want to achieve. You can use the same smsboxid but > >> > you > >> > need to reconfigure sqlbox to pass-through all the messages. > >> > So your scenario will be: > >> > Bearerbox-sqlbox-smsbox > >> > > >> > Currently you have: > >> > Bearerbox-smsbox > >> > -sqlbox > >> > > >> > > >> > You need to play with ports to change your message flow. > >> > -- > >> > Sent from my Android phone with K-9 Mail. Please excuse my brevity. > >> > > >> > Harbhag Singh Sohal <harbhag.so...@gmail.com> wrote: > >> >> > >> >> 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, > >> >> >> >> > > >> >> >> >> > Y > >> >> our 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 h > >> >> ow > >> >> 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 > >> >> >> >> > >> >> >> > > >> >> >> > > >> >> > > >> >> > > >> >> > >> > > >> > >> > >> > >> -- > >> Regards > >> Harbhag Singh Sohal > >> www.harbhag.wordpress.com > > > > > > > > -- > Regards > Harbhag Singh Sohal > www.harbhag.wordpress.com > -- Kind regards, Milan -------------------------------------------------- Arvanta, IT Security http://www.arvanta.net Please do not send me e-mail containing HTML code.
