Thanks spameden for your reply , I have downloaded the .deb package from http://packages.ubuntu.com/lucid/kannel-sqlbox http://packages.ubuntu.com/lucid/kannel-sqlbox (am using ubuntu 10.04) , it has been installed successfully without errors . after running the command $ sudo sqlbox -v 0 sqlbox.conf it has created 2 tables (send_sms,sent_sms)
I have received and sent sms but nothing has been stored in mysql tables no error is displaying while sending and receiving sms , i really dont know what is the wrong , is my configuration is correct ? by the way I am using Selenium smpp simulator (SMPPSim) , everything is running locally (database , kannel , smppsim , ...etc) here is my configuration sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = sqlbox bearerbox-host = localhost bearerbox-port = 17001 smsbox-port = 17010 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 #smsbox-port = 13003 #smsbox-id = sqlbox #global-sender = 000037 group = mysql-connection id = sqlbox-db host = localhost username = dbusername password = dbpassword database = dlr #max-connections = 1 #port = 3306 kannel.conf group = core admin-port = 17000 smsbox-port = 17001 admin-password = adminpassword log-file = "/var/log/kannel/kannel.log" log-level = 0 box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1;192.168.1.*" admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1;192.168.1.*" #unified-prefix = "+91,0091,+0091;+,;" access-log = "/var/log/kannel/access.log" dlr-storage = mysql #dlr-url = "http://localhost/cgi-bin/kannel-dlr.pl?id=%I&smsc=%i&dest=%p&src="; #smsc-packet-log = "smsc_pkt.log" #submit_resp_key = 8888 #dlr_rept_key = 8889 #mo_key = 8890 group = smsbox bearerbox-host = localhost sendsms-port = 17017 bearerbox-port = 17001 #global-sender = 345 #sendsms-chars = "0123456789 +-" #log-file = "/tmp/smsbox.log" log-level = 0 mo-recode=false #access-log = "/var/log/kannel/access.log" group = sendsms-user username = test password = test #user-deny-ip = "*.*.*.*" user-allow-ip = "127.0.0.1;192.168.1.*" #default-smsc = "test_cell" concatenation = true max-messages = 10 group = smsc smsc = smpp smsc-id = "SMPPSim" host = localhost port =2775 #transceiver-mode = false receive-port = 2775 system-type = "" #my-number = "" smsc-username = username smsc-password = password keepalive = 2 interface-version = 34 source-addr-ton = 5 source-addr-npi = 0 source-addr-autodetect = yes dest-addr-ton = 1 dest-addr-npi = 1 address-range = "" enquire-link-interval = 60 max-pending-submits = 10 reconnect-delay = 10 priority = 0 here are the logs ==> /var/log/kannel/access.log <== 2012-06-12 12:35:13 Sent SMS [SMSC:SMPPSim] [SVC:test] [ACT:] [BINF:] [FID:] [from:9997] [to:9988776655] [flags:-1:0:-1:-1:-1] [msg:32:Thanks alot 1.] [udh:0:] 2012-06-12 12:35:13 Receive SMS [SMSC:SMPPSim] [SVC:] [ACT:] [BINF:] [FID:] [from:9997] [to:+9988776655] [flags:-1:0:-1:0:-1] [msg:32:Thanks alot 1.] [udh:0:] 2012-06-12 12:36:07 Receive SMS [SMSC:SMPPSim] [SVC:] [ACT:] [BINF:] [FID:] [from:9988776655] [to:9997] [flags:-1:2:-1:0:-1] [msg:10:06270627062706270627] [udh:0:] 2012-06-12 12:36:07 Sent SMS [SMSC:SMPPSim] [SVC:test] [ACT:] [BINF:] [FID:] [from:9997] [to:9988776655] [flags:-1:2:-1:-1:-1] [msg:10:06270627062706270627] [udh:0:] 2012-06-12 12:36:07 Receive SMS [SMSC:SMPPSim] [SVC:] [ACT:] [BINF:] [FID:] [from:9997] [to:+9988776655] [flags:-1:2:-1:0:-1] [msg:10:06270627062706270627] [udh:0:] 2012-06-12 12:36:22 Sent SMS [SMSC:SMPPSim] [SVC:test] [ACT:] [BINF:] [FID:] [from:9997] [to:9988776655] [flags:-1:0:-1:-1:-1] [msg:32:Thanks alot 1.] [udh:0:] 2012-06-12 12:36:22 Receive SMS [SMSC:SMPPSim] [SVC:] [ACT:] [BINF:] [FID:] [from:9997] [to:+9988776655] [flags:-1:0:-1:0:-1] [msg:32:Thanks alot 1.] [udh:0:] ==> /var/log/kannel/kannel-sqlbox.log <== 2012-06-12 11:48:34 [4834] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 4834. 2012-06-12 11:55:35 [4834] [0] ERROR: SIGINT received, aborting program... 2012-06-12 11:55:38 [5143] [0] INFO: Added logfile `/var/log/kannel/kannel-sqlbox.log' with level `0'. 2012-06-12 11:55:38 [5143] [0] INFO: MYSQL: Connected to server at localhost. 2012-06-12 11:55:38 [5143] [0] INFO: MYSQL: server version 5.1.41-3ubuntu12.10, client version 5.1.61. 2012-06-12 11:55:38 [5143] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2012-06-12 11:55:38 [5143] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 5143. 2012-06-12 11:55:38 [5143] [1] INFO: Connected to bearerbox at localhost port 17001. 2012-06-12 11:55:38 [5143] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2012-06-12 11:55:38 [5143] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 5143. ==> /var/log/kannel/kannel.log <== 2012-06-12 12:35:13 [4805] [7] DEBUG: SMPP PDU 0x8c965d8 dump: 2012-06-12 12:35:13 [4805] [10] DEBUG: boxc_sender: sent message to <127.0.0.1> 2012-06-12 12:35:13 [4805] [7] DEBUG: type_name: deliver_sm_resp 2012-06-12 12:35:13 [4805] [7] DEBUG: command_id: 2147483653 = 0x80000005 2012-06-12 12:35:13 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:35:13 [4805] [7] DEBUG: sequence_number: 22 = 0x00000016 2012-06-12 12:35:13 [4805] [7] DEBUG: message_id: NULL 2012-06-12 12:35:13 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:35:13 [4805] [9] DEBUG: boxc_receiver: got ack 2012-06-12 12:35:14 [4805] [9] DEBUG: boxc_receiver: heartbeat with load value 0 received 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU 0x8c96498 dump: 2012-06-12 12:36:07 [4805] [7] DEBUG: type_name: deliver_sm 2012-06-12 12:36:07 [4805] [7] DEBUG: command_id: 5 = 0x00000005 2012-06-12 12:36:07 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: sequence_number: 23 = 0x00000017 2012-06-12 12:36:07 [4805] [7] DEBUG: service_type: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr_ton: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr_npi: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr: "9988776655" 2012-06-12 12:36:07 [4805] [7] DEBUG: dest_addr_ton: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: dest_addr_npi: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: destination_addr: "9997" 2012-06-12 12:36:07 [4805] [7] DEBUG: esm_class: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: protocol_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: priority_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: schedule_delivery_time: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: validity_period: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: registered_delivery: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: data_coding: 8 = 0x00000008 2012-06-12 12:36:07 [4805] [7] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: sm_length: 10 = 0x0000000a 2012-06-12 12:36:07 [4805] [7] DEBUG: short_message: 2012-06-12 12:36:07 [4805] [7] DEBUG: Octet string at 0x8c94b68: 2012-06-12 12:36:07 [4805] [7] DEBUG: len: 10 2012-06-12 12:36:07 [4805] [7] DEBUG: size: 11 2012-06-12 12:36:07 [4805] [7] DEBUG: immutable: 0 2012-06-12 12:36:07 [4805] [7] DEBUG: data: 06 27 06 27 06 27 06 27 06 27 .'.'.'.'.' 2012-06-12 12:36:07 [4805] [7] DEBUG: Octet string dump ends. 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP[SMPPSim]: Sending PDU: 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU 0x8c96570 dump: 2012-06-12 12:36:07 [4805] [7] DEBUG: type_name: deliver_sm_resp 2012-06-12 12:36:07 [4805] [10] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2012-06-12 12:36:07 [4805] [7] DEBUG: command_id: 2147483653 = 0x80000005 2012-06-12 12:36:07 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [10] DEBUG: boxc_sender: sent message to <127.0.0.1> 2012-06-12 12:36:07 [4805] [7] DEBUG: sequence_number: 23 = 0x00000017 2012-06-12 12:36:07 [4805] [7] DEBUG: message_id: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [9] DEBUG: boxc_receiver: got ack 2012-06-12 12:36:07 [4805] [9] DEBUG: boxc_receiver: sms received 2012-06-12 12:36:07 [4805] [9] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP[SMPPSim]: Manually forced source addr ton = 5, source add npi = 0 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP[SMPPSim]: Manually forced dest addr ton = 1, dest add npi = 1 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP[SMPPSim]: Sending PDU: 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP PDU 0x8c94548 dump: 2012-06-12 12:36:07 [4805] [6] DEBUG: type_name: submit_sm 2012-06-12 12:36:07 [4805] [6] DEBUG: command_id: 4 = 0x00000004 2012-06-12 12:36:07 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: sequence_number: 106 = 0x0000006a 2012-06-12 12:36:07 [4805] [6] DEBUG: service_type: NULL 2012-06-12 12:36:07 [4805] [6] DEBUG: source_addr_ton: 5 = 0x00000005 2012-06-12 12:36:07 [4805] [6] DEBUG: source_addr_npi: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: source_addr: "9997" 2012-06-12 12:36:07 [4805] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 2012-06-12 12:36:07 [4805] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-06-12 12:36:07 [4805] [6] DEBUG: destination_addr: "9988776655" 2012-06-12 12:36:07 [4805] [6] DEBUG: esm_class: 3 = 0x00000003 2012-06-12 12:36:07 [4805] [6] DEBUG: protocol_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: priority_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: schedule_delivery_time: NULL 2012-06-12 12:36:07 [4805] [6] DEBUG: validity_period: NULL 2012-06-12 12:36:07 [4805] [6] DEBUG: registered_delivery: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: data_coding: 8 = 0x00000008 2012-06-12 12:36:07 [4805] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: sm_length: 10 = 0x0000000a 2012-06-12 12:36:07 [4805] [6] DEBUG: short_message: 2012-06-12 12:36:07 [4805] [6] DEBUG: Octet string at 0x8c96430: 2012-06-12 12:36:07 [4805] [6] DEBUG: len: 10 2012-06-12 12:36:07 [4805] [6] DEBUG: size: 11 2012-06-12 12:36:07 [4805] [6] DEBUG: immutable: 0 2012-06-12 12:36:07 [4805] [6] DEBUG: data: 06 27 06 27 06 27 06 27 06 27 .'.'.'.'.' 2012-06-12 12:36:07 [4805] [6] DEBUG: Octet string dump ends. 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP PDU 0x8c94548 dump: 2012-06-12 12:36:07 [4805] [6] DEBUG: type_name: submit_sm_resp 2012-06-12 12:36:07 [4805] [6] DEBUG: command_id: 2147483652 = 0x80000004 2012-06-12 12:36:07 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [6] DEBUG: sequence_number: 106 = 0x0000006a 2012-06-12 12:36:07 [4805] [6] DEBUG: message_id: "9" 2012-06-12 12:36:07 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:07 [4805] [7] DEBUG: type_name: deliver_sm 2012-06-12 12:36:07 [4805] [7] DEBUG: command_id: 5 = 0x00000005 2012-06-12 12:36:07 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: sequence_number: 25 = 0x00000019 2012-06-12 12:36:07 [4805] [7] DEBUG: service_type: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr_ton: 5 = 0x00000005 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr_npi: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: source_addr: "9997" 2012-06-12 12:36:07 [4805] [7] DEBUG: dest_addr_ton: 1 = 0x00000001 2012-06-12 12:36:07 [4805] [7] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-06-12 12:36:07 [4805] [7] DEBUG: destination_addr: "9988776655" 2012-06-12 12:36:07 [4805] [7] DEBUG: esm_class: 3 = 0x00000003 2012-06-12 12:36:07 [4805] [7] DEBUG: protocol_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: priority_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: schedule_delivery_time: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: validity_period: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: registered_delivery: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: data_coding: 8 = 0x00000008 2012-06-12 12:36:07 [4805] [7] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [7] DEBUG: sm_length: 10 = 0x0000000a 2012-06-12 12:36:07 [4805] [7] DEBUG: short_message: 2012-06-12 12:36:07 [4805] [7] DEBUG: Octet string at 0x8c96530: 2012-06-12 12:36:07 [4805] [7] DEBUG: len: 10 2012-06-12 12:36:07 [4805] [7] DEBUG: size: 11 2012-06-12 12:36:07 [4805] [7] DEBUG: immutable: 0 2012-06-12 12:36:07 [4805] [7] DEBUG: data: 06 27 06 27 06 27 06 27 06 27 .'.'.'.'.' 2012-06-12 12:36:07 [4805] [7] DEBUG: Octet string dump ends. 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP[SMPPSim]: Sending PDU: 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU 0x8c96548 dump: 2012-06-12 12:36:07 [4805] [7] DEBUG: type_name: deliver_sm_resp 2012-06-12 12:36:07 [4805] [7] DEBUG: command_id: 2147483653 = 0x80000005 2012-06-12 12:36:07 [4805] [10] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2012-06-12 12:36:07 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:07 [4805] [10] DEBUG: boxc_sender: sent message to <127.0.0.1> 2012-06-12 12:36:07 [4805] [7] DEBUG: sequence_number: 25 = 0x00000019 2012-06-12 12:36:07 [4805] [7] DEBUG: message_id: NULL 2012-06-12 12:36:07 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:07 [4805] [9] DEBUG: boxc_receiver: got ack 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP[SMPPSim]: Sending enquire link: 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:11 [4805] [6] DEBUG: type_name: enquire_link 2012-06-12 12:36:11 [4805] [6] DEBUG: command_id: 21 = 0x00000015 2012-06-12 12:36:11 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:11 [4805] [6] DEBUG: sequence_number: 107 = 0x0000006b 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP[SMPPSim]: Sending enquire link: 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:11 [4805] [7] DEBUG: type_name: enquire_link 2012-06-12 12:36:11 [4805] [7] DEBUG: command_id: 21 = 0x00000015 2012-06-12 12:36:11 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:11 [4805] [7] DEBUG: sequence_number: 108 = 0x0000006c 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:11 [4805] [6] DEBUG: type_name: enquire_link_resp 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP PDU 0x8c96530 dump: 2012-06-12 12:36:11 [4805] [6] DEBUG: command_id: 2147483669 = 0x80000015 2012-06-12 12:36:11 [4805] [7] DEBUG: type_name: enquire_link_resp 2012-06-12 12:36:11 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:11 [4805] [7] DEBUG: command_id: 2147483669 = 0x80000015 2012-06-12 12:36:11 [4805] [6] DEBUG: sequence_number: 107 = 0x0000006b 2012-06-12 12:36:11 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:11 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:11 [4805] [7] DEBUG: sequence_number: 108 = 0x0000006c 2012-06-12 12:36:11 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:14 [4805] [9] DEBUG: boxc_receiver: heartbeat with load value 1 received 2012-06-12 12:36:22 [4805] [9] DEBUG: boxc_receiver: sms received 2012-06-12 12:36:22 [4805] [9] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP[SMPPSim]: Manually forced source addr ton = 5, source add npi = 0 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP[SMPPSim]: Manually forced dest addr ton = 1, dest add npi = 1 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP[SMPPSim]: Sending PDU: 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:22 [4805] [6] DEBUG: type_name: submit_sm 2012-06-12 12:36:22 [4805] [6] DEBUG: command_id: 4 = 0x00000004 2012-06-12 12:36:22 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: sequence_number: 109 = 0x0000006d 2012-06-12 12:36:22 [4805] [6] DEBUG: service_type: NULL 2012-06-12 12:36:22 [4805] [6] DEBUG: source_addr_ton: 5 = 0x00000005 2012-06-12 12:36:22 [4805] [6] DEBUG: source_addr_npi: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: source_addr: "9997" 2012-06-12 12:36:22 [4805] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 2012-06-12 12:36:22 [4805] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-06-12 12:36:22 [4805] [6] DEBUG: destination_addr: "9988776655" 2012-06-12 12:36:22 [4805] [6] DEBUG: esm_class: 3 = 0x00000003 2012-06-12 12:36:22 [4805] [6] DEBUG: protocol_id: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: priority_flag: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: schedule_delivery_time: NULL 2012-06-12 12:36:22 [4805] [6] DEBUG: validity_period: NULL 2012-06-12 12:36:22 [4805] [6] DEBUG: registered_delivery: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: data_coding: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: sm_length: 32 = 0x00000020 2012-06-12 12:36:22 [4805] [6] DEBUG: short_message: 2012-06-12 12:36:22 [4805] [6] DEBUG: Octet string at 0x8c96430: 2012-06-12 12:36:22 [4805] [6] DEBUG: len: 32 2012-06-12 12:36:22 [4805] [6] DEBUG: size: 33 2012-06-12 12:36:22 [4805] [6] DEBUG: immutable: 0 2012-06-12 12:36:22 [4805] [6] DEBUG: data: 54 68 61 6e 6b 73 20 66 6f 72 20 79 6f 75 72 20 Thanks for your 2012-06-12 12:36:22 [4805] [6] DEBUG: data: 73 75 62 73 63 72 69 70 74 69 6f 6e 73 20 31 2e subscriptions 1. 2012-06-12 12:36:22 [4805] [6] DEBUG: Octet string dump ends. 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:22 [4805] [6] DEBUG: type_name: submit_sm_resp 2012-06-12 12:36:22 [4805] [6] DEBUG: command_id: 2147483652 = 0x80000004 2012-06-12 12:36:22 [4805] [6] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [6] DEBUG: sequence_number: 109 = 0x0000006d 2012-06-12 12:36:22 [4805] [6] DEBUG: message_id: "10" 2012-06-12 12:36:22 [4805] [6] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP[SMPPSim]: Got PDU: 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP PDU 0x8c96458 dump: 2012-06-12 12:36:22 [4805] [7] DEBUG: type_name: deliver_sm 2012-06-12 12:36:22 [4805] [7] DEBUG: command_id: 5 = 0x00000005 2012-06-12 12:36:22 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: sequence_number: 27 = 0x0000001b 2012-06-12 12:36:22 [4805] [7] DEBUG: service_type: NULL 2012-06-12 12:36:22 [4805] [7] DEBUG: source_addr_ton: 5 = 0x00000005 2012-06-12 12:36:22 [4805] [7] DEBUG: source_addr_npi: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: source_addr: "9997" 2012-06-12 12:36:22 [4805] [7] DEBUG: dest_addr_ton: 1 = 0x00000001 2012-06-12 12:36:22 [4805] [7] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-06-12 12:36:22 [4805] [7] DEBUG: destination_addr: "9988776655" 2012-06-12 12:36:22 [4805] [7] DEBUG: esm_class: 3 = 0x00000003 2012-06-12 12:36:22 [4805] [7] DEBUG: protocol_id: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: priority_flag: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: schedule_delivery_time: NULL 2012-06-12 12:36:22 [4805] [7] DEBUG: validity_period: NULL 2012-06-12 12:36:22 [4805] [7] DEBUG: registered_delivery: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: data_coding: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: sm_length: 32 = 0x00000020 2012-06-12 12:36:22 [4805] [7] DEBUG: short_message: 2012-06-12 12:36:22 [4805] [7] DEBUG: Octet string at 0x8c96430: 2012-06-12 12:36:22 [4805] [7] DEBUG: len: 32 2012-06-12 12:36:22 [4805] [7] DEBUG: size: 33 2012-06-12 12:36:22 [4805] [7] DEBUG: immutable: 0 2012-06-12 12:36:22 [4805] [7] DEBUG: data: 54 68 61 6e 6b 73 20 66 6f 72 20 79 6f 75 72 20 Thanks for your 2012-06-12 12:36:22 [4805] [7] DEBUG: data: 73 75 62 73 63 72 69 70 74 69 6f 6e 73 20 31 2e subscriptions 1. 2012-06-12 12:36:22 [4805] [7] DEBUG: Octet string dump ends. 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP[SMPPSim]: Sending PDU: 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP PDU 0x8c94548 dump: 2012-06-12 12:36:22 [4805] [10] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2012-06-12 12:36:22 [4805] [7] DEBUG: type_name: deliver_sm_resp 2012-06-12 12:36:22 [4805] [10] DEBUG: boxc_sender: sent message to <127.0.0.1> 2012-06-12 12:36:22 [4805] [7] DEBUG: command_id: 2147483653 = 0x80000005 2012-06-12 12:36:22 [4805] [7] DEBUG: command_status: 0 = 0x00000000 2012-06-12 12:36:22 [4805] [7] DEBUG: sequence_number: 27 = 0x0000001b 2012-06-12 12:36:22 [4805] [7] DEBUG: message_id: NULL 2012-06-12 12:36:22 [4805] [7] DEBUG: SMPP PDU dump ends. 2012-06-12 12:36:22 [4805] [9] DEBUG: boxc_receiver: got ack spameden wrote: > > check sqlbox > > 2012/6/11 techbrainless <[email protected]> > >> >> Hi All, >> >> I am able to store data into dlr table (mysql) , >> but is it possible to store information like that one in access logs into >> one of mysql tables once it received/sent to/from kannel >> >> 2012-03-17 17:20:42 Receive SMS [SMSC:SMPPSim] [SVC:] [ACT:] [BINF:] >> [FID:] >> [from:+454546565656] [to:+1111] [flags:-1:0:-1:0:-1] [msg:31:Could not >> fetch >> content, sorry.] [udh:0:] >> >> >> messagetype(sent or received),from,to,type of message,message >> length,udh,flags....etc >> >> >> -- >> View this message in context: >> http://old.nabble.com/How-to-save-more-kannel-access-logging-info-into-mysql-tp33993328p33993328.html >> Sent from the Kannel - User mailing list archive at Nabble.com. >> >> >> > > -- View this message in context: http://old.nabble.com/How-to-save-more-kannel-access-logging-info-into-mysql-tp33993328p33999056.html Sent from the Kannel - User mailing list archive at Nabble.com.
