Remember, DLR's are deleted from the dlr table after they reach a final state.
That might be your problem? From: [email protected] [mailto:[email protected]] On Behalf Of ZeeJee Sent: Sunday, 23 October, 2011 19:12 To: [email protected] Subject: DLR's not posting in mysql Dear All, i have kannel with opensmppbox installed. also have support for mysql but my problem is that dlr's are not posting in mysql database. following are the logs and confs. from logs its confirmed that bearerbox and opensmppbox is connected to mysql and using mysql database. But still DLR's are not going into dlr table. database and tables are as per configuration. if i enable sqlbox then messages are recorded into sent_sms table. please help me in this regard that what i m missing. regards Bearerbox log [root@SIP temp]# bearerbox kannel.conf 2011-10-23 19:42:48 [19984] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2011-10-23 19:42:48 [19984] [0] DEBUG: Loading include file `dlr-mysql.conf' (on line 40 of file kannel.conf). 2011-10-23 19:42:48 [19984] [0] INFO: MYSQL: Connected to server at localhost. 2011-10-23 19:42:48 [19984] [0] INFO: MYSQL: server version 5.0.77, client version 5.0.77. 2011-10-23 19:42:48 [19984] [0] INFO: DLR using storage type: mysql 2011-10-23 19:42:48 [19984] [0] DEBUG: Kannel bearerbox version `svn-r4936M'. Build `Oct 17 2011 16:41:48', compiler `4.1.2 20080704 (Red Hat 4.1.2-50)'. System Linux, release 2.6.18-238.12.1.el5, version #1 SMP Tue May 31 13:23:01 EDT 2011, machine i686. Hostname SIP, IP 127.0.0.1. Libxml version 2.6.26. Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008. Compiled with MySQL 5.0.77, using MySQL 5.0.77. Using native malloc. 2011-10-23 19:42:48 [19984] [0] INFO: Added logfile `/var/log/kannel/bearerbox.log' with level `1'. 2011-10-23 19:42:48 [19984] [0] INFO: Started access logfile `/var/log/kannel/access.log'. 2011-10-23 19:42:48 [19984] [0] INFO: HTTP: Opening server at port 13000. 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 1 (gwlib/fdset.c:poller) 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 2 (gwlib/http.c:server_thread) 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 3 (gw/bb_http.c:httpadmin_run) 2011-10-23 19:42:48 [19984] [0] DEBUG: starting smsbox connection module 2011-10-23 19:42:48 [19984] [0] INFO: BOXC: 'smsbox-max-pending' not set, using default (100). 2011-10-23 19:42:48 [19984] [0] DEBUG: Adding smsbox routing to id <smsbox> for smsc id <FakeSMSC-1> 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 4 (gw/bb_boxc.c:sms_to_smsboxes) 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 5 (gw/bb_boxc.c:smsboxc_run) 2011-10-23 19:42:48 [19984] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) maps to pid 19984. 2011-10-23 19:42:48 [19984] [4] DEBUG: Thread 4 (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 19984. 2011-10-23 19:42:48 [19984] [3] DEBUG: Thread 3 (gw/bb_http.c:httpadmin_run) maps to pid 19984. 2011-10-23 19:42:48 [19984] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps to pid 19984. 2011-10-23 19:42:48 [19984] [2] DEBUG: Thread 2 (gwlib/http.c:server_thread) maps to pid 19984. 2011-10-23 19:42:48 [19984] [2] DEBUG: HTTP: Including port 13000, fd 11 for polling in server thread 2011-10-23 19:42:48 [19984] [0] INFO: Set SMS resend frequency to 60 seconds. 2011-10-23 19:42:48 [19984] [0] INFO: SMS resend retry set to unlimited. 2011-10-23 19:42:48 [19984] [0] DEBUG: MO concatenated message handling enabled 2011-10-23 19:42:48 [19984] [0] INFO: DLR rerouting for smsc id <FakeSMSC-1> disabled. 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 6 (gw/smsc/smsc_smpp.c:io_thread) 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 7 (gw/bb_smscconn.c:sms_router) 2011-10-23 19:42:48 [19984] [0] INFO: ---------------------------------------- 2011-10-23 19:42:48 [19984] [0] INFO: Kannel bearerbox II version svn-r4936M starting 2011-10-23 19:42:48 [19984] [0] INFO: Loading store file `/var/spool/kannel' 2011-10-23 19:42:48 [19984] [0] INFO: Store-file size 0, starting to unpack 2011-10-23 19:42:48 [19984] [0] INFO: Retrieved 0 messages, non-acknowledged messages: 0 2011-10-23 19:42:48 [19984] [7] DEBUG: Thread 7 (gw/bb_smscconn.c:sms_router) maps to pid 19984. 2011-10-23 19:42:48 [19984] [0] DEBUG: Started thread 8 (gw/bb_store_file.c:store_dumper) 2011-10-23 19:42:48 [19984] [0] INFO: MAIN: Start-up done, entering mainloop 2011-10-23 19:42:48 [19984] [6] DEBUG: Thread 6 (gw/smsc/smsc_smpp.c:io_thread) maps to pid 19984. 2011-10-23 19:42:48 [19984] [6] DEBUG: Connecting to <1xx.2xx.2xx.1xx> 2011-10-23 19:42:48 [19984] [8] DEBUG: Thread 8 (gw/bb_store_file.c:store_dumper) maps to pid 19984. 2011-10-23 19:42:48 [19984] [8] DEBUG: Dumping 0 messages to store 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP[FakeSMSC-1]: Sending PDU: 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP PDU 0xa12d940 dump: 2011-10-23 19:42:48 [19984] [6] DEBUG: type_name: bind_transceiver 2011-10-23 19:42:48 [19984] [6] DEBUG: command_id: 9 = 0x00000009 2011-10-23 19:42:48 [19984] [6] DEBUG: command_status: 0 = 0x00000000 2011-10-23 19:42:48 [19984] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-10-23 19:42:48 [19984] [6] DEBUG: system_id: "xxxxxx" 2011-10-23 19:42:48 [19984] [6] DEBUG: password: "xxxxxx" 2011-10-23 19:42:48 [19984] [6] DEBUG: system_type: "SMPP" 2011-10-23 19:42:48 [19984] [6] DEBUG: interface_version: 52 = 0x00000034 2011-10-23 19:42:48 [19984] [6] DEBUG: addr_ton: 0 = 0x00000000 2011-10-23 19:42:48 [19984] [6] DEBUG: addr_npi: 0 = 0x00000000 2011-10-23 19:42:48 [19984] [6] DEBUG: address_range: NULL 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP PDU dump ends. 2011-10-23 19:42:48 [19984] [6] DEBUG: Optional parameter tag (0x0210) 2011-10-23 19:42:48 [19984] [6] DEBUG: Optional parameter length read as 1 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP[FakeSMSC-1]: Got PDU: 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP PDU 0xa12dd68 dump: 2011-10-23 19:42:48 [19984] [6] DEBUG: type_name: bind_transceiver_resp 2011-10-23 19:42:48 [19984] [6] DEBUG: command_id: 2147483657 = 0x80000009 2011-10-23 19:42:48 [19984] [6] DEBUG: command_status: 0 = 0x00000000 2011-10-23 19:42:48 [19984] [6] DEBUG: sequence_number: 1 = 0x00000001 2011-10-23 19:42:48 [19984] [6] DEBUG: system_id: "XXXXXX" 2011-10-23 19:42:48 [19984] [6] DEBUG: sc_interface_version: 52 = 0x00000034 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP PDU dump ends. 2011-10-23 19:42:48 [19984] [6] DEBUG: SMPP[FakeSMSC-1]: throughput (0.00,0.00) ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------ Opensmppbox log [root@SIP temp]# opensmppbox open1.conf 2011-10-23 19:45:22 [20036] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2011-10-23 19:45:22 [20036] [0] DEBUG: Loading include file `dlr-mysql.conf' (on line 15 of file open1.conf). 2011-10-23 19:45:22 [20036] [0] DEBUG: Kannel opensmppbox version svn-r62 gwlib version `svn-r4936M'. Build `Oct 17 2011 16:41:48', compiler `4.1.2 20080704 (Red Hat 4.1.2-50)'. System Linux, release 2.6.18-238.12.1.el5, version #1 SMP Tue May 31 13:23:01 EDT 2011, machine i686. Hostname SIP, IP 127.0.0.1. Libxml version 2.6.26. Using OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008. Compiled with MySQL 5.0.77, using MySQL 5.0.77. Using native malloc. 2011-10-23 19:45:22 [20036] [0] INFO: MYSQL: Connected to server at localhost. 2011-10-23 19:45:22 [20036] [0] INFO: MYSQL: server version 5.0.77, client version 5.0.77. 2011-10-23 19:45:22 [20036] [0] INFO: DLR using storage type: mysql 2011-10-23 19:45:22 [20036] [0] INFO: Starting to log to file /var/log/kannel/opensmppbox.log level 1 2011-10-23 19:45:22 [20036] [0] INFO: Added logfile `/var/log/kannel/opensmppbox.log' with level `1'. 2011-10-23 19:45:22 [20036] [0] INFO: Waiting for SMPP connections on port 6201. ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------ kannel.conf [root@SIP temp]# cat kannel.conf group = core dlr-storage = mysql admin-port = 13000 smsbox-port = 13001 admin-password = xxxxxx log-file = "/var/log/kannel/bearerbox.log" log-level = 1 access-log = "/var/log/kannel/access.log" store-location = /var/spool/kannel store-dump-freq = 1 #box-deny-ip = "*.*.*.*" box-allow-ip = "0.0.0.0" group = smsbox bearerbox-host = 127.0.0.1 bearerbox-port = 13001 smsbox-id = smsbox sendsms-port = 13013 global-sender = 13013 group = smsbox-route smsbox-id = smsbox smsc-id = FakeSMSC-1 group = smsc smsc = smpp smsc-id = FakeSMSC-1 allowed-smsc-id = FakeSMSC-1 host = xxx.xxx.xxx.xxx port = 2345 smsc-username = xxxx smsc-password = xxxx #allowed-smsc-id = smsc1 system-type = "SMPP" transceiver-mode = 1 smsc-id = FakeSMSC-1 include = dlr-mysql.conf ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- -------------------------------- dlr-mysql.conf [root@SIP temp]# cat dlr-mysql.conf group = mysql-connection id = mydlr host = localhost username = xxx password = xxx database = kannel max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- -------------------------------- opensmppbox.conf group = core dlr-storage = mysql group = opensmppbox opensmppbox-id = mydlr opensmppbox-port = 6201 bearerbox-host = localhost bearerbox-port = 13001 log-level = 1 log-file = /var/log/kannel/opensmppbox.log our-system-id = opensmppbox route-to-smsc = FakeSMSC-1 smpp-logins = "/etc/kannel/smpplogins.txt" include = dlr-mysql.conf
