What happens if you try to do the same insert, manually? Do you get an error message?
== Rene From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Jinson Sent: dinsdag 29 juni 2010 19:00 To: users Subject: SMPP Delivery Reports Issue Hello Users, I've configured a new SMSC on my existing kannel installation. My DLRs are not working on this SMSC. I'm using mysql DLR storage. I can see the insert queries in the log but nothing gets inserted into the DB. DLRs are coming on SMPP properly. 2010-06-29 16:55:18 [24139] [22] DEBUG: priority_flag: 0 = 0x00000000 2010-06-29 16:55:18 [24139] [22] DEBUG: schedule_delivery_time: NULL 2010-06-29 16:55:18 [24139] [22] DEBUG: validity_period: NULL 2010-06-29 16:55:18 [24139] [22] DEBUG: registered_delivery: 1 = 0x00000001 2010-06-29 16:55:18 [24139] [22] DEBUG: replace_if_present_flag: 0 = 0x00000000 2010-06-29 16:55:18 [24139] [22] DEBUG: data_coding: 0 = 0x00000000 2010-06-29 16:55:18 [24139] [22] DEBUG: sm_default_msg_id: 0 = 0x00000000 2010-06-29 16:55:18 [24139] [22] DEBUG: sm_length: 8 = 0x00000008 2010-06-29 16:55:18 [24139] [22] DEBUG: short_message: "Test SMS" 2010-06-29 16:55:18 [24139] [22] DEBUG: SMPP PDU dump ends. 2010-06-29 16:55:18 [24139] [22] DEBUG: SMPP[160by2SMPP]: Got PDU: 2010-06-29 16:55:18 [24139] [22] DEBUG: SMPP PDU 0x795bf0 dump: 2010-06-29 16:55:18 [24139] [22] DEBUG: type_name: submit_sm_resp 2010-06-29 16:55:18 [24139] [22] DEBUG: command_id: 2147483652 = 0x80000004 2010-06-29 16:55:18 [24139] [22] DEBUG: command_status: 0 = 0x00000000 2010-06-29 16:55:18 [24139] [22] DEBUG: sequence_number: 18 = 0x00000012 2010-06-29 16:55:18 [24139] [22] DEBUG: message_id: "0000000051" 2010-06-29 16:55:18 [24139] [22] DEBUG: SMPP PDU dump ends. 2010-06-29 16:55:18 [24139] [22] DEBUG: DLR[mysql]: Adding DLR smsc=160by2SMPP, ts=51, src=91XXXXXXXXX, dst=91XXXXXXXXX, mask=31, boxc=fabox 2010-06-29 16:55:18 [24139] [22] DEBUG: sql: INSERT INTO kannel_table (smsc, ts, source, destination, service, url, mask, boxc, status) VALUES ('XXXSMPP', '51', '91XXXXXXXXX', '91XXXXXXXXX', 'xxxx', 'http://xxx.xxx.xxx/dlr.php?type=%d <http://xxx.xxx.xxx/dlr.php?type=%25d&kannel_id=%25F&msisdn=%25p&dlrvalue=%2 5A&message_id=900629222518-836128> &kannel_id=%F&msisdn=%p&dlrvalue=%A&message_id=900629222518-836128', '31', 'faaabox', '0') This is not getting inserted into the DB. Is there anything to do with msg-id-type? Can somebody help me on this? -------- Thanks Jinson Abraham