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
