Hello, I'm sorry for the confusion. It was getting inserted. But not processing the DLRs.
I could see the following in my smsbox log * * *010-06-29 17:35:36 [24643] [4] WARNING: No translation found for <id:0000000070 sub:001 dlvrd:001 submit date:1006292305 done date:1006292305 stat:DELIVRD err:000 text:Test > from <+xxxxxx> to <+xxxxxx>* *2010-06-29 17:35:36 [24643] [4] ERROR: request failed* -------- Thanks Jinson Abraham On Tue, Jun 29, 2010 at 10:56 PM, Rene Kluwen <rene.klu...@chimit.nl> wrote: > 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&kannel_id=%F&msisdn=%p&dlrvalue=%A&message_id=900629222518-836128<http://xxx.xxx.xxx/dlr.php?type=%25d&kannel_id=%25F&msisdn=%25p&dlrvalue=%25A&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 > > >
