Hello Group,
The log shows fine parameters to store temporary dlr :
2015-11-06 12:34:35 [26018] [7] DEBUG: data: 65 62 65 34
ebe4
2015-11-06 12:34:35 [26018] [7] DEBUG: Octet string dump ends.
2015-11-06 12:34:35 [26018] [7] DEBUG: SMPP PDU dump ends.
2015-11-06 12:34:35 [26018] [7] DEBUG: DLR[mysql]: Adding DLR smsc=smpp1,
ts=cabf1024-5679-43ba-a716-d84a5a9eebe4, src=BONGOLIVE, dst=255xxxxxxxx,
mask=31, boxc=netbox
2015-11-06 12:34:35 [26018] [7] DEBUG: adding DLR entry into database
2015-11-06 12:34:35 [26018] [7] DEBUG: sql: INSERT INTO `dlr` (`smsc`,
`ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, `status`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0)
2015-11-06 12:34:35 [26018] [7] DEBUG: SMSC[smpp1]: creating DLR message
2015-11-06 12:34:35 [26018] [7] DEBUG: SMSC[smpp1]: DLR =
2015-11-06 12:34:35 [26018] [7] DEBUG: SMPP[smpp1]: throughput (1.00,0.00)
2015-11-06 12:34:39 [26018] [8] DEBUG: Optional parameter tag (0x0427)
But why the insert statement becomes -;
INSERT INTO `dlr` ( `smsc`, `ts`, `source`, `destination`, `service`,
`url`, `mask`, `boxc`, `status` ) VALUES ( 0, 0, 0, 0, 0, 0, 0, 0, 0 )
Find the attached table data of dlr table.
*Note : This insert statement I captured through general_log of mysql
server logs, so this is the final statement executed on mysql server.*
