Thanks Nikos, I have successfully stored the received SMS to database today. But the messages are getting stored in the sent_sms table being used by sqlbox. What should I do to store the SMS to some other table ?
2011/4/18 Nikos Balkanas <nbalka...@gmail.com>: > Hi, > > You should give the same smsbox-id as sqlbox-id, so that DLRs are forwarded > to your smsbox correctly. > In group sqlbox you should set as bearerbox-host: 127.0.0.1 (or the > bearerbox ip) > In group smsbox you should set bearerbox-host: 127.0.0.1 (or the sqlbox ip) > and bearerbox-port: 13007. > > BR, > Nikos > ----- Original Message ----- From: "Harbhag Singh Sohal" > <harbhag.so...@gmail.com> > To: <users@kannel.org> > Sent: Monday, April 18, 2011 6:13 AM > Subject: bearerbox sqlbox smsbox > > >> How can I achieve the setup below >> >> bearerbox<-->sqlbox<-->smsbox >> >> I want to store to received SMSs to the database. >> >> Below are my current config files >> >> #Sample configuration file for Kannel bearerbox on Debian. >> # See the documentation for explanations of fields. >> # >> >> # HTTP administration is disabled by default. Make sure you set the >> # password if you enable it. >> >> group = core >> admin-port = 13015 >> admin-password = hard2guess >> #admin-deny-ip = "*.*.*.*" >> admin-allow-ip = "127.0.0.1" >> dlr-storage = internal >> 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 = wapbox >> #bearerbox-host = localhost >> #log-file = "/var/log/kannel/wapbox.log" >> group = smsc >> smsc-id = huawei_e220 >> smsc = at >> modemtype = huawei >> device= /dev/ttyUSB0 >> my-number = +91 >> connect-allow-ip = 127.0.0.1 >> sim-buffering = true >> log-level = 0 >> >> # DLR with MySQL support configuration >> group = mysql-connection >> id = mydlr >> host = localhost >> username = >> password = >> database = a >> >> 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 = nokia >> 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=0,1" >> message-storage = SM >> message-start = 0 >> #speed = 460800 >> #message-start = 0 >> >> group = smsbox >> smsbox-id = mysmsc >> bearerbox-host = 2 >> #bearerbox-port = 13018 >> 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 = mysmsc >> smsc-id = huawei_e220 >> >> group = sendsms-user >> username = >> password = hard2guess >> concatenation= true >> max-messages = 10000 >> >> group = sms-service >> keyword-regex = .* >> catch-all = yes >> accepted-smsc = huawei_e220 >> max-messages = 3 >> get-url = "http://localhost/~harbhag/test.php?phone=%p&text=%a"; >> >> >> >> group = sqlbox >> id = sqlbox-db >> smsbox-id = mysmsc >> global-sender = "+91" >> bearerbox-host = 202 >> bearerbox-port = 13016 >> smsbox-port = 13017 >> 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 = >> password = >> database = >> >> >> I am using Ubuntu 10.10 64 bit and Kannel version 1.50. >> Thanks >> >> -- >> Harbhag Singh Sohal >> www.harbhag.wordpress.com >> >> >> >> -- >> Harbhag Singh Sohal >> www.harbhag.wordpress.com >> > > -- Harbhag Singh Sohal www.harbhag.wordpress.com
