I have followed Rene Kluwen instructions by adding [quote]In group = smsbox, put:
bearerbox-port = 17010 [/quote] and it works like a charm, (it needed to start sqlbox before smsbox) Thanks all techbrainless wrote: > > 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-tp33993328p34004609.html Sent from the Kannel - User mailing list archive at Nabble.com.
