Thanks spameden & Rene Kluwen for your replies. I have forget to mention that am using kannel 1.4.3
Rene Kluwen wrote: > > In group = smsbox, put: > > bearerbox-port = 17010 > > == Rene > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of techbrainless > Sent: dinsdag 12 juni 2012 13:06 > To: [email protected] > Subject: Re: How to save more kannel access logging info into mysql > > > 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. > > > > > > > -- View this message in context: http://old.nabble.com/How-to-save-more-kannel-access-logging-info-into-mysql-tp33993328p34002120.html Sent from the Kannel - User mailing list archive at Nabble.com.
