Hi all, I am running Kannel 1.5 on CentOS and am happily sending messages over SMPP. What has been wrecking my head for a few weeks now, is how to capture the delivery reports in a MySQL table. I have been making one BOLD assumption: that there is life without the smsbox. And when I look at the logs, except for some warnings about a non-existent smsbox, everything is there: the PDU's deliver_sm has all the information I am looking for.
I have 3 MySQL tables: the default 'send_sms' and 'sent_sms' and an additional table 'verslag' that has columns 'smsc', 'ts', 'dst', 'source', 'service', 'url', 'mask', 'status', 'boxc_id', 'to', 'network-code', 'msisdn', 'scts', 'id_sms'. Obviously, the dlr.php should update the 'status' column for the relevant 'id_sms' but it doesn't. In the attached file, I am sending my config files, logs and the dlr.php file. I would be very grateful if you could point me in the right direction. I must be doing something very wrong! Regards, Michael
>>> kannel.config <<< group = core admin-port = 13000 admin-password = bar admin-deny-ip = "*.*.*.*" admin-allow-ip = "127.0.0.1" smsbox-port = 13003 log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" dlr-storage=mysql log-level=0 group = smsbox bearerbox-host="localhost" sendsms-port = 13013 sendsms-chars = "+0123456789" log-file = "/var/log/kannel/smsbox.log" log-level = 0 access-log = "/var/log/kannel/access.log" log-level = 0 mo-recode = 1 group = smsc smsc = smpp smsc-id = smpp-provider host = msg1.provider.com port = 8000 receive-port = 8000 #transceiver-mode = false transceiver-mode = 1 throughput = 10 smsc-username = username smsc-password = password system-type = username dest-addr-ton=1 log-file = "/var/log/kannel/smpp-provider.log" log-level = 0 msg-id-type=0x01 enquire-link-interval = 30 dlr-url="http://[IP address]/cgi-bin/dlr.php?to=%to&msisdn=%msisdn&status=%status&messagId=%messagId&scts=%scts" group = sendsms-user username = username password = pwd forced-smsc = smpp-provider name = users user-deny-ip = "*.*.*.*" user-allow-ip = "127.0.0.1" max-messages = 3 concatenation = 1 omit-empty = 1 # DLR SETUP #mysql connection group = mysql-connection id = mydlr host = localhost username = gebruikersnaam password = geheimwoord database = tekstberichten max-connections = 5 group = dlr-db id = mydlr table=verslag field-smsc=smsc field-timestamp=ts field-destination=dst field-source=source field-service=service field-url=url field-mask=mask field-status=status field-boxc-id=boxc_id >>> sqlbox.conf <<< group = sqlbox id = sqlbox-db smsbox-id = sqlbox global-sender = "sender" bearerbox-host = localhost bearerbox-port = 13003 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 # Example MYSQL Connection group=mysql-connection id =sqlbox-db host = localhost username = gebruikersnaam password = geheimwoord database = tekstberichten max-connections = 1 >>> bearerbox.log <<< 2011-07-10 05:08:41 [21821] [0] INFO: HTTP: Opening server at port 13000. 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2011-07-10 05:08:41 [21821] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps to pid 21821. 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 3 (gw/bb_http.c:httpadmin_run) 2011-07-10 05:08:41 [21821] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) maps to pid 21821. 2011-07-10 05:08:41 [21821] [0] DEBUG: starting smsbox connection module 2011-07-10 05:08:41 [21821] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 4 (gw/bb_boxc.c:sms_to_smsboxes) 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 5 (gw/bb_boxc.c:smsboxc_run) 2011-07-10 05:08:41 [21821] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 21821. 2011-07-10 05:08:41 [21821] [0] INFO: Set SMS resend frequency to 60 seconds. 2011-07-10 05:08:41 [21821] [0] INFO: SMS resend retry set to unlimited. 2011-07-10 05:08:41 [21821] [0] DEBUG: MO concatenated message handling enabled 2011-07-10 05:08:41 [21821] [0] INFO: Set throughput to 10.000 for smsc id <smpp-provider> 2011-07-10 05:08:41 [21821] [0] INFO: DLR rerouting for smsc id <smpp-provider> disabled. 2011-07-10 05:08:41 [21821] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) maps to pid 21821. 2011-07-10 05:08:41 [21821] [0] INFO: Added logfile `/var/log/kannel/smpp-provider.log' with level `0'. 2011-07-10 05:08:41 [21821] [0] WARNING: SMPP: receive-port for transceiver mode defined, ignoring. 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 6 (gw/smsc/smsc_smpp.c:io_thread) 2011-07-10 05:08:41 [21821] [6] DEBUG: Thread 6 (gw/smsc/smsc_smpp.c:io_thread) maps to pid 21821. 2011-07-10 05:08:41 [21821] [0] DEBUG: Started thread 7 (gw/bb_smscconn.c:sms_router) 2011-07-10 05:08:41 [21821] [0] INFO: ---------------------------------------- 2011-07-10 05:08:41 [21821] [0] INFO: Kannel bearerbox II version 1.5.0 starting 2011-07-10 05:08:41 [21821] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) maps to pid 21821. 2011-07-10 05:08:41 [21821] [6] INFO: Logging thread `6' to logfile `/var/log/kannel/smpp-provider.log' with level `0'. 2011-07-10 05:08:41 [21821] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) maps to pid 21821. 2011-07-10 05:08:41 [21821] [2] DEBUG: HTTP: Including port 13000, fd 12 for polling in server thread 2011-07-10 05:08:41 [21821] [0] INFO: MAIN: Start-up done, entering mainloop 2011-07-10 05:08:45 [21821] [5] INFO: Client connected from <127.0.0.1> 2011-07-10 05:08:45 [21821] [5] DEBUG: Started thread 8 (gw/bb_boxc.c:function) 2011-07-10 05:08:45 [21821] [8] DEBUG: Thread 8 (gw/bb_boxc.c:function) maps to pid 21821. 2011-07-10 05:08:45 [21821] [8] DEBUG: Started thread 9 (gw/bb_boxc.c:boxc_sender) 2011-07-10 05:08:45 [21821] [8] DEBUG: boxc_receiver: got boxc_id <sqlbox> from <127.0.0.1> 2011-07-10 05:08:45 [21821] [9] DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) maps to pid 21821. 2011-07-10 05:08:45 [21821] [8] DEBUG: boxc_receiver: sms received 2011-07-10 05:08:45 [21821] [8] DEBUG: send_msg: sending msg to boxc: <sqlbox> 2011-07-10 05:08:46 [21821] [9] DEBUG: send_msg: sending msg to boxc: <sqlbox> 2011-07-10 05:08:46 [21821] [9] DEBUG: boxc_sender: sent message to <127.0.0.1> 2011-07-10 05:08:46 [21821] [8] DEBUG: boxc_receiver: got ack 2011-07-10 05:08:48 [21821] [4] WARNING: Could not route message to smsbox id <0>, smsbox is gone! 2011-07-10 05:08:48 [21821] [4] WARNING: smsbox_list empty! 2011-07-10 05:08:50 [21821] [2] DEBUG: HTTP: Creating HTTPClient for `127.0.0.1'. 2011-07-10 05:08:50 [21821] [2] DEBUG: HTTP: Created HTTPClient area 0xdbf4b70. 2011-07-10 05:08:50 [21821] [3] DEBUG: Shutting down Kannel... 2011-07-10 05:08:50 [21821] [3] DEBUG: shutting down smsc 2011-07-10 05:08:50 [21821] [3] DEBUG: Shutting down SMSCConn SMPP:msg1.provider.com:8000/8000:username:password (slow) 2011-07-10 05:08:50 [21821] [3] DEBUG: shutting down udp 2011-07-10 05:08:50 [21821] [0] WARNING: Killing signal or HTTP admin command received, shutting down... 2011-07-10 05:08:50 [21821] [3] DEBUG: HTTP: Destroying HTTPClient area 0xdbf4b70. 2011-07-10 05:08:50 [21821] [3] DEBUG: HTTP: Destroying HTTPClient for `127.0.0.1'. 2011-07-10 05:09:48 [21821] [4] WARNING: Could not route message to smsbox id <0>, smsbox is gone! 2011-07-10 05:09:48 [21821] [4] WARNING: smsbox_list empty! 2011-07-10 05:09:48 [21821] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) terminates. 2011-07-10 05:09:48 [21821] [9] DEBUG: send_msg: sending msg to boxc: <sqlbox> 2011-07-10 05:09:48 [21821] [9] DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) terminates. 2011-07-10 05:09:49 [21821] [8] INFO: Connection closed by the box <127.0.0.1> 2011-07-10 05:09:49 [21821] [8] DEBUG: Thread 8 (gw/bb_boxc.c:function) terminates. 2011-07-10 05:09:49 [21821] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) terminates. 2011-07-10 05:09:50 [21821] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) terminates. 2011-07-10 05:09:50 [21821] [0] INFO: All flow threads have died, killing core 2011-07-10 05:09:50 [21821] [0] DEBUG: Waiting for 2 (gwlib/http.c:server_thread) to terminate 2011-07-10 05:09:50 [21821] [3] DEBUG: HTTP: No clients with requests, quitting. 2011-07-10 05:09:50 [21821] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) terminates. 2011-07-10 05:09:50 [21821] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) terminates. 2011-07-10 05:09:50 [21821] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) terminates. 2011-07-10 05:09:50 [21821] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) terminates. 2011-07-10 05:09:50 [21821] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) terminates. 2011-07-10 05:09:50 [21821] [0] DEBUG: final clean-up for SMSCConn 2011-07-10 05:09:50 [21821] [0] DEBUG: MO concatenated message handling cleaned up 2011-07-10 05:09:50 [21821] [0] INFO: Total WDP messages: received 0, sent 0 2011-07-10 05:09:50 [21821] [0] DEBUG: Remaining SMS: 1 incoming, 0 outgoing 2011-07-10 05:09:50 [21821] [0] INFO: Total SMS messages: received 0, dlr 2, sent 1, dlr 0 2011-07-10 05:09:50 [21821] [0] DEBUG: Immutable octet strings: 237. >>> smpp_provider.log <<< 2011-07-10 05:08:41 [21821] [6] DEBUG: Connecting to <an IP address> 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP[smpp-provider]: Sending PDU: 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP PDU 0xdbf7020 dump: 2011-07-10 05:08:42 [21821] [6] DEBUG: type_name: bind_transceiver 2011-07-10 05:08:42 [21821] [6] DEBUG: command_id: 9 = 0x00000009 2011-07-10 05:08:42 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:42 [21821] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-07-10 05:08:42 [21821] [6] DEBUG: system_id: "username" 2011-07-10 05:08:42 [21821] [6] DEBUG: password: "password" 2011-07-10 05:08:42 [21821] [6] DEBUG: system_type: "username" 2011-07-10 05:08:42 [21821] [6] DEBUG: interface_version: 52 = 0x00000034 2011-07-10 05:08:42 [21821] [6] DEBUG: addr_ton: 0 = 0x00000000 2011-07-10 05:08:42 [21821] [6] DEBUG: addr_npi: 0 = 0x00000000 2011-07-10 05:08:42 [21821] [6] DEBUG: address_range: NULL 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP[smpp-provider]: Got PDU: 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP PDU 0xdbf7020 dump: 2011-07-10 05:08:42 [21821] [6] DEBUG: type_name: bind_transceiver_resp 2011-07-10 05:08:42 [21821] [6] DEBUG: command_id: 2147483657 = 0x80000009 2011-07-10 05:08:42 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:42 [21821] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-07-10 05:08:42 [21821] [6] DEBUG: system_id: "PB SMPP" 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:42 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) 2011-07-10 05:08:45 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) 2011-07-10 05:08:45 [21821] [6] DEBUG: SMPP[smpp-provider]: Sending PDU: 2011-07-10 05:08:45 [21821] [6] DEBUG: SMPP PDU 0xdc055d0 dump: 2011-07-10 05:08:45 [21821] [6] DEBUG: type_name: submit_sm 2011-07-10 05:08:45 [21821] [6] DEBUG: command_id: 4 = 0x00000004 2011-07-10 05:08:45 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: sequence_number: 2 = 0x00000002 2011-07-10 05:08:45 [21821] [6] DEBUG: service_type: NULL 2011-07-10 05:08:45 [21821] [6] DEBUG: source_addr_ton: 2 = 0x00000002 2011-07-10 05:08:45 [21821] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2011-07-10 05:08:45 [21821] [6] DEBUG: source_addr: "3538*********" 2011-07-10 05:08:45 [21821] [6] DEBUG: dest_addr_ton: 2 = 0x00000002 2011-07-10 05:08:45 [21821] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2011-07-10 05:08:45 [21821] [6] DEBUG: destination_addr: "3538*********" 2011-07-10 05:08:45 [21821] [6] DEBUG: esm_class: 3 = 0x00000003 2011-07-10 05:08:45 [21821] [6] DEBUG: protocol_id: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: priority_flag: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: schedule_delivery_time: NULL 2011-07-10 05:08:45 [21821] [6] DEBUG: validity_period: NULL 2011-07-10 05:08:45 [21821] [6] DEBUG: registered_delivery: 1 = 0x00000001 2011-07-10 05:08:45 [21821] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: data_coding: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2011-07-10 05:08:45 [21821] [6] DEBUG: sm_length: 15 = 0x0000000f 2011-07-10 05:08:45 [21821] [6] DEBUG: short_message: "Hello Nikos and friends" 2011-07-10 05:08:45 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:45 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (1.00,10.00) 2011-07-10 05:08:46 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) 2011-07-10 05:08:46 [21821] [6] DEBUG: SMPP[smpp-provider]: Got PDU: 2011-07-10 05:08:46 [21821] [6] DEBUG: SMPP PDU 0xdc05150 dump: 2011-07-10 05:08:46 [21821] [6] DEBUG: type_name: submit_sm_resp 2011-07-10 05:08:46 [21821] [6] DEBUG: command_id: 2147483652 = 0x80000004 2011-07-10 05:08:46 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:46 [21821] [6] DEBUG: sequence_number: 2 = 0x00000002 2011-07-10 05:08:46 [21821] [6] DEBUG: message_id: "022EC347" 2011-07-10 05:08:46 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:46 [21821] [6] DEBUG: DLR[mysql]: Adding DLR smsc=smpp-provider, ts=36619079, src=3538*********, dst=3538*********, mask=31, boxc=sqlbox 2011-07-10 05:08:46 [21821] [6] DEBUG: adding DLR entry into database 2011-07-10 05:08:46 [21821] [6] DEBUG: sql: INSERT INTO `verslag` (`smsc`, `ts`, `source`, `dst`, `service`, `url`, `mask`, `boxc_id`, `status`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) 2011-07-10 05:08:46 [21821] [6] DEBUG: SMSC[smpp-provider]: creating DLR message 2011-07-10 05:08:46 [21821] [6] DEBUG: SMSC[smpp-provider]: DLR = http%3A%2F%2F[IP address]%2Fcgi-bin%2Fdlr.php%3Fto%3D%25to%26msisdn%3D%25msisdn%26status%3D%25status%26messagId%3D1008924%26scts%3D%25scts 2011-07-10 05:08:46 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP[smpp-provider]: Got PDU: 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP PDU 0xdbf4c70 dump: 2011-07-10 05:08:48 [21821] [6] DEBUG: type_name: deliver_sm 2011-07-10 05:08:48 [21821] [6] DEBUG: command_id: 5 = 0x00000005 2011-07-10 05:08:48 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-07-10 05:08:48 [21821] [6] DEBUG: service_type: NULL 2011-07-10 05:08:48 [21821] [6] DEBUG: source_addr_ton: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: source_addr_npi: 1 = 0x00000001 2011-07-10 05:08:48 [21821] [6] DEBUG: source_addr: "3538*********" 2011-07-10 05:08:48 [21821] [6] DEBUG: dest_addr_ton: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: dest_addr_ton: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2011-07-10 05:08:48 [21821] [6] DEBUG: destination_addr: "3538*********" 2011-07-10 05:08:48 [21821] [6] DEBUG: esm_class: 4 = 0x00000004 2011-07-10 05:08:48 [21821] [6] DEBUG: protocol_id: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: priority_flag: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: schedule_delivery_time: NULL 2011-07-10 05:08:48 [21821] [6] DEBUG: validity_period: NULL 2011-07-10 05:08:48 [21821] [6] DEBUG: registered_delivery: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: data_coding: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: sm_length: 122 = 0x0000007a 2011-07-10 05:08:48 [21821] [6] DEBUG: short_message: 2011-07-10 05:08:48 [21821] [6] DEBUG: Octet string at 0xdc01290: 2011-07-10 05:08:48 [21821] [6] DEBUG: len: 122 2011-07-10 05:08:48 [21821] [6] DEBUG: size: 123 2011-07-10 05:08:48 [21821] [6] DEBUG: immutable: 0 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 69 64 3a 30 30 33 36 36 31 39 30 37 39 20 73 75 id:0036619079 su 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 62 3a 30 30 31 20 64 6c 76 72 64 3a 30 30 31 20 b:001 dlvrd:001 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 73 75 62 6d 69 74 20 64 61 74 65 3a 31 31 30 37 submit date:1107 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 31 30 30 37 30 38 20 64 6f 6e 65 20 64 61 74 65 100708 done date 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 3a 31 31 30 37 31 30 30 34 35 37 20 73 74 61 74 :1107100457 stat 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 3a 44 45 4c 49 56 52 44 20 65 72 72 3a 30 30 30 :DELIVRD err:000 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 20 74 65 78 74 3a 6e 6f 6e 65 20 20 20 20 20 20 text:none 2011-07-10 05:08:48 [21821] [6] DEBUG: data: 20 20 20 20 20 20 20 20 20 20 2011-07-10 05:08:48 [21821] [6] DEBUG: Octet string dump ends. 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP[smpp-provider] handle_pdu, got DLR 2011-07-10 05:08:48 [21821] [6] DEBUG: DLR[mysql]: Looking for DLR smsc=smpp-provider, ts=36619079, dst=3538*********, type=1 2011-07-10 05:08:48 [21821] [6] DEBUG: sql: SELECT `mask`, `service`, `url`, `source`, `dst`, `boxc_id` FROM `verslag` WHERE `smsc`=? AND `ts`=? LIMIT 1 2011-07-10 05:08:48 [21821] [6] DEBUG: column=mask buffer_type=253 max_length=0 length=20 2011-07-10 05:08:48 [21821] [6] DEBUG: column=service buffer_type=253 max_length=0 length=40 2011-07-10 05:08:48 [21821] [6] DEBUG: column=url buffer_type=253 max_length=0 length=40 2011-07-10 05:08:48 [21821] [6] DEBUG: column=source buffer_type=253 max_length=0 length=20 2011-07-10 05:08:48 [21821] [6] DEBUG: column=dst buffer_type=253 max_length=0 length=20 2011-07-10 05:08:48 [21821] [6] DEBUG: column=boxc_id buffer_type=3 max_length=0 length=11 2011-07-10 05:08:48 [21821] [6] DEBUG: DLR[mysql]: created DLR message for URL <http%3A%2F%2F[IP address]%2Fcgi-bin%2> 2011-07-10 05:08:48 [21821] [6] DEBUG: removing DLR from database 2011-07-10 05:08:48 [21821] [6] DEBUG: sql: DELETE FROM `verslag` WHERE `smsc`=? AND `ts`=? LIMIT 1 2011-07-10 05:08:48 [21821] [6] DEBUG: new group created `smpp' 2011-07-10 05:08:48 [21821] [6] DEBUG: group=`smpp' key=`dlr_err' value=`000' 2011-07-10 05:08:48 [21821] [6] WARNING: Could not route message to smsbox id <0>, smsbox is gone! 2011-07-10 05:08:48 [21821] [6] WARNING: smsbox_list empty! 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP[smpp-provider]: Sending PDU: 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP PDU 0xdbefaa0 dump: 2011-07-10 05:08:48 [21821] [6] DEBUG: type_name: deliver_sm_resp 2011-07-10 05:08:48 [21821] [6] DEBUG: command_id: 2147483653 = 0x80000005 2011-07-10 05:08:48 [21821] [6] DEBUG: command_status: 0 = 0x00000000 2011-07-10 05:08:48 [21821] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-07-10 05:08:48 [21821] [6] DEBUG: message_id: NULL 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP PDU dump ends. 2011-07-10 05:08:48 [21821] [6] DEBUG: SMPP[smpp-provider]: throughput (0.00,10.00) >>> dlr.php <<< <?php include('../../mysql_connect2.php'); $messageId=$_GET['messageId']; $status=$_GET['status']; //$scts =$_GET['scts']; //$msisdn=$_GET['msisdn']; //$to=$_GET['to']; $query ="UPDATE verslag SET status='$status' WHERE id_sms='$messageId'"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); ?>
