Use sqlbox. On Tue, Mar 22, 2011 at 7:52 AM, Harbhag Singh Sohal < harbhag.so...@gmail.com> wrote:
> Hi, > I want to know that how can I store the received SMS to the database. > I guess I am receiving SMS beacause I can see them in the access.log > file. But I want to know if how can I store them into the Database. ? > below are my 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 > > 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 = > > > > This is what I see when I start bearerbox > > > > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT&F^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- AT&F > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> ATE0^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- ATE0 > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+IFC=2,2^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPIN?^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPIN: READY > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGF=0^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CSMS=?^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CNMI=0,1^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CSMS: (0-1) > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS="SM"^M > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] INFO: AT2[huawei_e220]: AT SMSC > successfully opened. > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > 0,20,0,20,0,20 > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:12:34 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:12:35 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:13:37 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:14:39 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:15:41 [7861] [6] DEBUG: AT2[huawei_e220]: <-- OK > > > from bearerbox log, this is what I see when a SMS is received > > > > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",1,20,"SM",1,20,"SM",1,20 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: 1 messages > waiting in memory > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGR=0^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CMGR: 0,,23 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- > 0791194971909979240C9119494661994000001130228060122204D4F29C0E > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: received > message from SMSC: +919417099997 > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: Numeric sender > (international) <+91> > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: User data > length read as (4) > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: Udh decoding > done len=4 udhi=0 udhlen=0 udh='' > 2011-03-22 08:07:00 [7225] [6] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGD=0^M > 2011-03-22 08:07:00 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:08:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",0,20,"SM",0,20,"SM",0,20 > 2011-03-22 08:08:02 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:09:00 [7225] [4] WARNING: smsbox_list empty! > 2011-03-22 08:09:04 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CPMS?^M > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CPMS: > "SM",1,20,"SM",1,20,"SM",1,20 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- OK > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: 1 messages > waiting in memory > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: --> AT+CMGR=0^M > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- +CMGR: 0,,26 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: <-- > 0791194971909979240C9119494661994000001130228070942207C8703C2D0E8B01 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: received > message from SMSC: +919417099997 > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: Numeric sender > (international) <+91> > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: User data > length read as (7) > 2011-03-22 08:09:05 [7225] [6] DEBUG: AT2[huawei_e220]: Udh decoding > done len=7 udhi=0 udhlen=0 udh='' > 2011-03-22 08:09:05 [7225] [6] WARNING: smsbox_list empty! > > > Moreover I get this smsbox_list empty warning. > I am using Ubuntu 10.10 64 bit and Kannel version 1.50. > Thanks > -- > Harbhag Singh Sohal > www.harbhag.wordpress.com > >
