Messages would be stored in sent_sms table only in SQLBOX. Any message you try to put in send_sms would be picked up by bbox for MT delivery. I am not sure whether there can be customized changes to DB structure.
On Mon, Apr 18, 2011 at 7:23 PM, Harbhag Singh Sohal < harbhag.so...@gmail.com> wrote: > 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 > >
