Project

General

Profile

Bug #646

field-msg-id NULL problem

Added by Andrey Ponteleev about 8 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
-
Target version:
Start date:
06/18/2012
Due date:
% Done:

0%

Estimated time:
Affected version:

Description

need to use smpp proxy without system-type (not all SMSC and SME software work with this option).

for it i uncomment strings in opensmppbox.conf and see this things:

2012-06-18 22:18:40 [8663] [3] DEBUG: SMPP[xxxxxxxxx]: Got PDU:
2012-06-18 22:18:40 [8663] [3] DEBUG: SMPP PDU 0x2630fc0 dump:
2012-06-18 22:18:40 [8663] [3] DEBUG: type_name: submit_sm
2012-06-18 22:18:40 [8663] [3] DEBUG: command_id: 4 = 0x00000004
2012-06-18 22:18:40 [8663] [3] DEBUG: command_status: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: sequence_number: 20 = 0x00000014
2012-06-18 22:18:40 [8663] [3] DEBUG: service_type: NULL
2012-06-18 22:18:40 [8663] [3] DEBUG: source_addr_ton: 5 = 0x00000005
2012-06-18 22:18:40 [8663] [3] DEBUG: source_addr_npi: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: source_addr: "xxxxxxxxx"
2012-06-18 22:18:40 [8663] [3] DEBUG: dest_addr_ton: 2 = 0x00000002
2012-06-18 22:18:40 [8663] [3] DEBUG: dest_addr_npi: 1 = 0x00000001
2012-06-18 22:18:40 [8663] [3] DEBUG: destination_addr: "xxxxxxxxx"
2012-06-18 22:18:40 [8663] [3] DEBUG: esm_class: 3 = 0x00000003
2012-06-18 22:18:40 [8663] [3] DEBUG: protocol_id: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: priority_flag: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: schedule_delivery_time: NULL
2012-06-18 22:18:40 [8663] [3] DEBUG: validity_period: "120619021839000+"
2012-06-18 22:18:40 [8663] [3] DEBUG: registered_delivery: 1 = 0x00000001
2012-06-18 22:18:40 [8663] [3] DEBUG: replace_if_present_flag: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: data_coding: 8 = 0x00000008
2012-06-18 22:18:40 [8663] [3] DEBUG: sm_default_msg_id: 0 = 0x00000000
2012-06-18 22:18:40 [8663] [3] DEBUG: sm_length: 34 = 0x00000022
2012-06-18 22:18:40 [8663] [3] DEBUG: short_message:
2012-06-18 22:18:40 [8663] [3] DEBUG: Octet string at 0x260f180:
2012-06-18 22:18:40 [8663] [3] DEBUG: len: 34
2012-06-18 22:18:40 [8663] [3] DEBUG: size: 35
2012-06-18 22:18:40 [8663] [3] DEBUG: immutable: 0
2012-06-18 22:18:40 [8663] [3] DEBUG: data: 00 77 00 69 00 74 00 68 00 6f 00 75 00 74 00 73 .w.i.t.h.o.u.t.s
2012-06-18 22:18:40 [8663] [3] DEBUG: data: 00 79 00 73 00 74 00 65 00 6d 00 74 00 79 00 70 .y.s.t.e.m.t.y.p
2012-06-18 22:18:40 [8663] [3] DEBUG: data: 00 65 .e
2012-06-18 22:18:40 [8663] [3] DEBUG: Octet string dump ends.
2012-06-18 22:18:40 [8663] [3] DEBUG: SMPP PDU dump ends.
2012-06-18 22:18:40 [8663] [3] DEBUG: diff between utc and localtime (14400)
2012-06-18 22:18:40 [8663] [3] DEBUG: Requested UTC timestamp: 2012-06-19 02:18:39
2012-06-18 22:18:40 [8663] [3] DEBUG: requested timestamp in min. (479)
2012-06-18 22:18:40 [8663] [3] DEBUG: DLR[mysql]: Adding DLR smsc=pretaxi, ts=ed75cc94, src=xxxxxxxxxxxxx, dst=xxxxxxxxx, mask=19, boxc=xxxxxxxxx, id=ed75cc94-6ccb-4e8c-8986-a3bc5e1805e1
2012-06-18 22:18:40 [8663] [3] DEBUG: adding DLR entry wirh id into database
2012-06-18 22:18:40 [8663] [3] DEBUG: sql: INSERT INTO `smppdlr` (`smsc`, `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxcid`, `status`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0)
2012-06-18 22:18:40 [8663] [1] DEBUG: DLR[mysql]:Looking for DLR id=ed75cc94-6ccb-4e8c-8986-a3bc5e1805e1
2012-06-18 22:18:40 [8663] [1] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `destination`, `boxcid`, `(null)`, `smsc` FROM `smppdlr` WHERE `(null)`=? LIMIT 1
2012-06-18 22:18:40 [8663] [1] ERROR: MYSQL: Unable to prepare statement: Unknown column '(null)' in 'field list'
2012-06-18 22:18:40 [8663] [1] WARNING: opensmppbox DLR for ID <ed75cc94-6ccb-4e8c-8986-a3bc5e1805e1> not found.

here NULL is message ID, but if we uncomment
field-msg-id = id
in dlr-db group
we have this error:

2012-06-18 22:33:08 [8791] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0
2012-06-18 22:33:08 [8791] [0] ERROR: Group 'dlr-db' may not contain field 'field-msg-id'.
2012-06-18 22:33:08 [8791] [0] ERROR: Error found on line 49 of file `/conf/opensmppbox.conf'.
2012-06-18 22:33:08 [8791] [0] PANIC: Couldn't read configuration from `/conf/opensmppbox.conf'.
2012-06-18 22:33:08 [8791] [0] PANIC: opensmppbox(gw_backtrace+0xae) [0x4441ee]
2012-06-18 22:33:08 [8791] [0] PANIC: opensmppbox(gw_panic+0x165) [0x444365]
2012-06-18 22:33:08 [8791] [0] PANIC: opensmppbox(main+0xf8f) [0x40aa0f]
2012-06-18 22:33:08 [8791] [0] PANIC: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed) [0x7f5a166d030d]
2012-06-18 22:33:08 [8791] [0] PANIC: opensmppbox() [0x40aaf9]

Also available in: Atom PDF