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 < [email protected]> 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 <[email protected]> > 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 <[email protected]> wrote: > >> > >> I have added different smsbox-id for sqlbox. Is it ok now ?? > >> > >> On Sun, Jun 26, 2011 at 3:10 PM, Nikos Balkanas <[email protected]> > >> 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 > >> > <[email protected]> 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 < > [email protected]> > >> >> 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 > >> >> > <[email protected]> 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 > >> >> >> <[email protected]> > >> >> >> 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 > >> >> >> > <[email protected]> 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 > >> >> >> >> <[email protected]> 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 > >> >> >> >> > <[email protected]> > >> >> >> >> > wrote: > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> From: Mpeirwe Benjamin > >> [mailto:[email protected]] > >> >> >> >> >> 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 > >> >> >> >> >> <[email protected]> > >> >> >> >> >> wrote: > >> >> >> >> >> > >> >> >> >> >> Don't use the dlr database table for that. > >> >> >> >> >> Instead specify dlr-mask & dlr-url. See the users guide. > >> >> >> >> >> > >> >> > >> >> >> >> -----Original Message----- > >> >> >> >> >> From: [email protected] > >> >> >> >> >> [mailto:[email protected]] > >> >> >> >> >> On > >> >> >> >> >> Behalf > >> >> >> >> >> Of Harbhag Singh Sohal > >> >> >> >> >> Sent: Friday, 24 June, 2011 08:22 > >> >> >> >> >> To: [email protected] > >> >> >> >> >> 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 >
