DLR's never reaching to DLR table. i am running only bearerbox and opensmsbox.
regards On Mon, Oct 24, 2011 at 2:24 AM, Rene Kluwen <[email protected]> wrote: > 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 > > **** >
