Got it to working after many hours of experimenting. Now I can receive all the dlr to db and all MO to DB. Using this I am providing SMS to Email service. Its simply awesome. Kannel rocks, you guys rocks. On Sun, Jun 26, 2011 at 11:35 PM, Milan P. Stanic <m...@arvanta.net> wrote: > 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. > >
-- Regards Harbhag Singh Sohal www.harbhag.wordpress.com