Hi Users,
I have installed and configured SQLBOX with mysql support.
When I insert a record in send_sms table, message received successfully but
the log shows the empty *message_id* that causing the DLR receipt failure.
Also unable to retrieve all columns for dlr_rpt table for the given dlr-url.
I am using
dlr-mask = 31 and
dlr-url =
http://111.222.333.444/sms/dlr.php?dlr=%d&dest=%p&report=%A
#id, destination, status, status2, server_date,
deliver_date, sms_id
'4', '', '8', 'Pending', '2015-08-18
09:47:38', 'Pending', ''
See my log here..
2015-08-18 09:30:05 [14047] [8] DEBUG: SMPP[testuser]: Got PDU:
2015-08-18 09:30:05 [14047] [8] DEBUG: SMPP PDU 0x7ff8140018a0 dump:
2015-08-18 09:30:05 [14047] [8] DEBUG: type_name: submit_sm_resp
2015-08-18 09:30:05 [14047] [8] DEBUG: command_id: 2147483652 = 0x80000004
2015-08-18 09:30:05 [14047] [8] DEBUG: command_status: 0 = 0x00000000
2015-08-18 09:30:05 [14047] [8] DEBUG: sequence_number: 8935 = 0x000022e7
2015-08-18 09:30:05 [14047] [8] DEBUG: message_id:
2015-08-18 09:30:05 [14047] [8] DEBUG: Octet string at 0x7ff8140023d0:
2015-08-18 09:30:05 [14047] [8] DEBUG: len: 36
2015-08-18 09:30:05 [14047] [8] DEBUG: size: 37
2015-08-18 09:30:05 [14047] [8] DEBUG: immutable: 0
2015-08-18 09:30:05 [14047] [8] DEBUG: data: 63 38 33 62 34 34 62 30
2d 35 38 38 39 2d 34 31 c83b44b0-5889-41
2015-08-18 09:30:05 [14047] [8] DEBUG: data: 37 66 2d 62 66 32 35 2d
31 62 38 61 66 31 31 37 7f-bf25-1b8af117
2015-08-18 09:30:05 [14047] [8] DEBUG: data: 62 32 62
33 b2b3
2015-08-18 09:30:05 [14047] [8] DEBUG: Octet string dump ends.
2015-08-18 09:30:05 [14047] [8] DEBUG: SMPP PDU dump ends.
2015-08-18 09:30:05 [14047] [8] DEBUG: DLR[mysql]: Adding DLR
smsc=testuser, ts=c83b44b0-5889-417f-bf25-1b8af117b2b3, src1, boxc=sqlbox
2015-08-18 09:30:05 [14047] [8] DEBUG: adding DLR entry into database
2015-08-18 09:30:05 [14047] [8] DEBUG: sql: INSERT INTO `dlr` (`smsc`,
`ts`, `source`, `destination`, `service`, `url`, `, ?, ?, ?, ?, ?, ?, ?, 0)
2015-08-18 09:30:05 [14047] [8] DEBUG: SMSC[testuser]: creating DLR message
2015-08-18 09:30:05 [14047] [8] DEBUG: SMSC[testuser]: DLR =
http://111.222.333.444/sms/dlr.php?dlr=%d&dest=%p&report=%A
2015-08-18 09:30:05 [14047] [8] DEBUG: SMPP[testuser]: throughput
(0.00,0.00)
2015-08-18 09:30:06 [14047] [8] DEBUG: SMPP[testuser]: throughput
(0.00,0.00)
