Hello Nikos, If the DLRs which are coming to MySQL is temporary, Then i can also use DLR storage "Internal", and Make a SMALL application to sense DLRs.
i am confused "is there any Key Or any Value by which we can compare that the coming DLR is for any specfic Message Sent." for example : While Sending SMS I get only text "0: Accepted for delivery" But if i get *message ID* here while sending & same *message ID* is returned as value when i get DLR, i can match DLR with Sent message easily in my table. Hope that *message ID is an Unqiue *value. Regards, Anshu 2010/8/26 Nikos Balkanas <nbalka...@gmail.com> > Hi, > > For info read UG about reroute-smsc. Once you reroute that, you may also > want to reroute its DLRs. Since you don't, you don't need to. Just ignore > it. > > I see you are using a DB for dlr-storage (mysql)?. This table is for > internal processing only. DLR is deleted once it is matched. If you want > permanent DLR storage, use your own web application, and use dlr-url. Filed > timestamp is really SMSc forreign id and should be varchar(64). > > > BR, > Nikos > ----- Original Message ----- From: Anshu Sah > To: Rene Kluwen > Cc: Nikos Balkanas ; users@kannel.org > Sent: Wednesday, August 25, 2010 11:55 PM > > Subject: Re: UNABLE TO RECEIVE DLR FROM KANNEL & SMPP > > > Hello Nikos, > > Can you please explain this below Line. > > 2010-08-25 13:01:27 [6057] [0] INFO: DLR rerouting for smsc id <vFirstDEMO> > disabled. > > One more thing by adding &dlr-mask=31 i got the DLR but i got only below > params, But i want to add a custom column, which i will add while sending > message & by which i could Query into this table for DLRs. > > > id smsc timestamp destination source service url mask status boxc_id > > > 1vFirstDEMO0000-00-00 00:00:009216217231anshukannel 310 > 4vFirstDEMO34102674779781114229anshukannel 310 > > > Regards > Anshu > > > > On Tue, Aug 17, 2010 at 6:55 PM, Rene Kluwen <rene.klu...@chimit.nl> > wrote: > > See this post from Nikos. > > > -----Original Message----- > From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf > Of Nikos Balkanas > Sent: Monday, 16 August, 2010 22:55 > To: Anshu Sah; users@kannel.org > Subject: Re: UNABLE TO RECEIVE DLR FROM KANNEL & SMPP > > > Hi, > > Please post your sendsms URL and detailed bb logs of an attempt to send an > MT. > > BR, > > Nikos > ----- Original Message ----- > From: Anshu Sah > > To: users@kannel.org > Sent: Monday, August 16, 2010 10:39 PM > Subject: UNABLE TO RECEIVE DLR FROM KANNEL & SMPP > > > Hello > > I am unable to receive DLR in Kannel using SMPP Connectivity., > Please guide. If i am doing something wrong, > > Regards > Anshu > > Configuration is below > > group = core > admin-port = 13000 > smsbox-port = 13001 > admin-password = bar > log-file = "/projects/kannel/logs/core.log" > log-level = 0 > #box-deny-ip = "*.*.*.*" > #box-allow-ip = "127.0.0.1" > dlr-storage = mysql > access-log = "/projects/kannel/logs/access.log" > #store-file = "/projects/kannel/logs/storefile.log" > #dlr-storage = internal > > > group=smsc > smsc=smpp > smsc-id=xxxxxxxxx > host = xxxxxxxxxxxxxx > port = 2345 > receive-port = 2345 > log-file = "/projects/kannel/logs/smsc.log" > log-level = 0 > smsc-username = "xxxxxxxxxxxxx" > smsc-password = "xxxxxxx" > msg-id-type = 0x01 > transceiver-mode=1 > system-type = 'VMA' > #service-type = 'test' > interface-version = 34 > address-range = '' > #msg-id-type = 0 > > group = smsbox > bearerbox-host = 127.0.0.1 > sendsms-port = 13013 > log-level = 0 > > group = sendsms-user > username = kannel > password = hard2guess > concatenation = true > max-messages = 3 > > #--- mysql connection > group = mysql-connection > id = mydlr > host = localhost > username = xxxxxxxxxx > password = xxxxxxxxxxx > database = kannel > max-connections = 1 > > #---- DLR table structure > group = dlr-db > id = mydlr > table = kannel_dlr > field-smsc = smsc > field-timestamp = timestamp > field-destination = destination > field-source = source > field-service = service > field-url = url > field-mask = mask > field-status = status > field-boxc-id = boxc_id > > > > LOGS > > > [r...@splash gw]# ./bearerbox /projects/kannel/configs/xxxxxxxxx.inc > 2010-08-16 13:15:49 [32566] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2010-08-16 13:15:49 [32566] [0] INFO: MYSQL: Connected to server at > localhost. > 2010-08-16 13:15:49 [32566] [0] INFO: MYSQL: server version 5.0.77, client > version 5.0.77. > 2010-08-16 13:15:49 [32566] [0] INFO: DLR using storage type: mysql > 2010-08-16 13:15:49 [32566] [0] DEBUG: Kannel bearerbox version `1.4.3'. > Build `Aug 15 2010 18:31:17', compiler `4.1.2 20080704 (Red Hat 4.1.2-48)'. > System Linux, release 2.6.18-194.8.1.el5.028stab070.2, version #1 SMP Tue > Jul 6 14:55:39 MSD 2010, machine i686. > Hostname xxxxxxxxxxxxxxxxxxxxxxxxx. > 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. > > 2010-08-16 13:15:49 [32566] [0] INFO: Added logfile > `/projects/kannel/logs/core.log' with level `0'. > 2010-08-16 13:15:49 [32566] [0] INFO: Started access logfile > `/projects/kannel/logs/access.log'. > 2010-08-16 13:15:49 [32566] [0] INFO: HTTP: Opening server at port 13000. > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 1 > (gwlib/fdset.c:poller) > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 2 > (gwlib/http.c:server_thread) > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 3 > (gw/bb_http.c:httpadmin_run) > 2010-08-16 13:15:49 [32566] [0] DEBUG: starting smsbox connection module > 2010-08-16 13:15:49 [32566] [0] INFO: BOXC: 'smsbox-max-pending' not set, > using default (100). > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 5 > (gw/bb_boxc.c:smsboxc_run) > 2010-08-16 13:15:49 [32566] [0] INFO: Set SMS resend frequency to 60 > seconds. > 2010-08-16 13:15:49 [32566] [0] INFO: SMS resend retry set to unlimited. > 2010-08-16 13:15:49 [32566] [0] DEBUG: smsbox MO concatenated message > handling enabled > 2010-08-16 13:15:49 [32566] [0] INFO: DLR rerouting for smsc id > <vFirstDEMO> > > disabled. > 2010-08-16 13:15:49 [32566] [0] INFO: Added logfile > `/projects/kannel/logs/smsc.log' with level `0'. > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 6 > (gw/smsc/smsc_smpp.c:io_thread) > 2010-08-16 13:15:49 [32566] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) maps > to pid 32566. > 2010-08-16 13:15:49 [32566] [2] DEBUG: Thread 2 > (gwlib/http.c:server_thread) > > maps to pid 32566. > 2010-08-16 13:15:49 [32566] [3] DEBUG: Thread 3 > (gw/bb_http.c:httpadmin_run) > > maps to pid 32566. > 2010-08-16 13:15:49 [32566] [4] DEBUG: Thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 32566. > 2010-08-16 13:15:49 [32566] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) > maps to pid 32566. > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 7 > (gw/smsc/smsc_smpp.c:io_thread) > 2010-08-16 13:15:49 [32566] [0] DEBUG: Started thread 8 > (gw/bb_smscconn.c:sms_router) > 2010-08-16 13:15:49 [32566] [0] > INFO: ---------------------------------------- > 2010-08-16 13:15:49 [32566] [0] INFO: Kannel bearerbox II version 1.4.3 > starting > 2010-08-16 13:15:49 [32566] [0] INFO: MAIN: Start-up done, entering > mainloop > 2010-08-16 13:15:49 [32566] [6] DEBUG: Thread 6 > (gw/smsc/smsc_smpp.c:io_thread) maps to pid 32566. > 2010-08-16 13:15:49 [32566] [6] INFO: Logging thread `6' to logfile > `/projects/kannel/logs/smsc.log' with level `0'. > 2010-08-16 13:15:49 [32566] [8] DEBUG: Thread 8 > (gw/bb_smscconn.c:sms_router) maps to pid 32566. > 2010-08-16 13:15:49 [32566] [7] DEBUG: Thread 7 > (gw/smsc/smsc_smpp.c:io_thread) maps to pid 32566. > 2010-08-16 13:15:49 [32566] [7] INFO: Logging thread `7' to logfile > `/projects/kannel/logs/smsc.log' with level `0'. > > 2010-08-16 13:16:16 [32566] [5] INFO: Client connected from <127.0.0.1> > 2010-08-16 13:16:16 [32566] [5] DEBUG: Started thread 9 > (gw/bb_boxc.c:function) > 2010-08-16 13:16:16 [32566] [9] DEBUG: Thread 9 (gw/bb_boxc.c:function) > maps > > to pid 32566. > 2010-08-16 13:16:16 [32566] [9] DEBUG: Started thread 10 > (gw/bb_boxc.c:boxc_sender) > 2010-08-16 13:16:16 [32566] [10] DEBUG: Thread 10 > (gw/bb_boxc.c:boxc_sender) > > maps to pid 32566. > 2010-08-16 13:17:29 [32566] [2] DEBUG: HTTP: Creating HTTPClient for > `122.173.126.230'. > 2010-08-16 13:17:29 [32566] [2] DEBUG: HTTP: Created HTTPClient area > 0x916a2d8. > 2010-08-16 13:17:29 [32566] [3] DEBUG: sql: SELECT count(*) FROM > kannel_dlr; > 2010-08-16 13:17:29 [32566] [3] DEBUG: HTTP: Resetting HTTPClient for > `122.173.126.230'. > 2010-08-16 13:17:32 [32566] [3] DEBUG: sql: SELECT count(*) FROM > kannel_dlr; > 2010-08-16 13:17:32 [32566] [3] DEBUG: HTTP: Resetting HTTPClient for > `122.173.126.230'. > 2010-08-16 13:17:33 [32566] [3] DEBUG: sql: SELECT count(*) FROM > kannel_dlr; > 2010-08-16 13:17:33 [32566] [3] DEBUG: HTTP: Resetting HTTPClient for > `122.173.126.230'. > 2010-08-16 13:17:38 [32566] [9] DEBUG: boxc_receiver: sms received > 2010-08-16 13:17:38 [32566] [9] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-08-16 13:18:33 [32566] [1] DEBUG: Timeout for fd:35 appeares. > 2010-08-16 13:18:33 [32566] [1] DEBUG: HTTP: Destroying HTTPClient area > 0x916a2d8. > 2010-08-16 13:18:33 [32566] [1] DEBUG: HTTP: Destroying HTTPClient for > `122.173.126.230'. > 2010-08-16 13:26:45 [32566] [2] DEBUG: HTTP: Creating HTTPClient for > `122.173.126.230'. > 2010-08-16 13:26:45 [32566] [2] DEBUG: HTTP: Created HTTPClient area > 0x91671e0. > 2010-08-16 13:26:45 [32566] [3] DEBUG: sql: SELECT count(*) FROM > kannel_dlr; > 2010-08-16 13:26:45 [32566] [3] DEBUG: HTTP: Resetting HTTPClient for > `122.173.126.230'. > 2010-08-16 13:27:45 [32566] [1] DEBUG: Timeout for fd:35 appeares. > 2010-08-16 13:27:45 [32566] [1] DEBUG: HTTP: Destroying HTTPClient area > 0x91671e0. > 2010-08-16 13:27:45 [32566] [1] DEBUG: HTTP: Destroying HTTPClient for > `122.173.126.230'. > 2010-08-16 13:34:07 [32566] [0] WARNING: Killing signal or HTTP admin > command received, shutting down... > 2010-08-16 13:34:07 [32566] [0] DEBUG: Shutting down Kannel... > 2010-08-16 13:34:07 [32566] [0] DEBUG: shutting down smsc > 2010-08-16 13:34:07 [32566] [0] DEBUG: Shutting down SMSCConn > SMPP:8.6.95.145:2345/2345:demovfaggsmp5:'VMA<http://8.6.95.145:2345/2345:demovfaggsmp5:%27VMA>' > (slow) > 2010-08-16 13:34:07 [32566] [0] DEBUG: SMSCConn > SMPP:8.6.95.145:2345/2345:demovfaggsmp5:'VMA<http://8.6.95.145:2345/2345:demovfaggsmp5:%27VMA>' > shut down. > 2010-08-16 13:34:07 [32566] [0] DEBUG: shutting down udp > 2010-08-16 13:34:07 [32566] [4] DEBUG: Thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) terminates. > 2010-08-16 13:34:07 [32566] [10] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-08-16 13:34:07 [32566] [10] DEBUG: Thread 10 > (gw/bb_boxc.c:boxc_sender) > > terminates. > 2010-08-16 13:34:07 [32566] [9] INFO: Connection closed by the box > <127.0.0.1> > 2010-08-16 13:34:07 [32566] [9] DEBUG: Thread 9 (gw/bb_boxc.c:function) > terminates. > 2010-08-16 13:34:07 [32566] [5] DEBUG: Thread 5 (gw/bb_boxc.c:smsboxc_run) > terminates. > 2010-08-16 13:34:07 [32566] [8] DEBUG: Thread 8 > (gw/bb_smscconn.c:sms_router) terminates. > 2010-08-16 13:34:07 [32566] [0] INFO: All flow threads have died, killing > core > 2010-08-16 13:34:07 [32566] [0] DEBUG: Waiting for 2 > (gwlib/http.c:server_thread) to terminate > 2010-08-16 13:34:07 [32566] [3] DEBUG: HTTP: No clients with requests, > quitting. > 2010-08-16 13:34:07 [32566] [3] DEBUG: Thread 3 > (gw/bb_http.c:httpadmin_run) > > terminates. > 2010-08-16 13:34:07 [32566] [2] DEBUG: Thread 2 > (gwlib/http.c:server_thread) > > terminates. > 2010-08-16 13:34:07 [32566] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) > terminates. > 2010-08-16 13:34:07 [32566] [0] DEBUG: final clean-up for SMSCConn > 2010-08-16 13:34:07 [32566] [0] DEBUG: smsbox MO concatenated message > handling cleaned up > 2010-08-16 13:34:07 [32566] [0] INFO: Total WDP messages: received 0, sent > 0 > 2010-08-16 13:34:07 [32566] [0] INFO: Total SMS messages: received 0, sent > 1 > 2010-08-16 13:34:07 [32566] [0] DEBUG: Immutable octet strings: 218. >
