Owen, The DLR's will be on the database for a usually small period of time (the time it takes for the message to get delivered. After that, It'll be deleted from the table.
The process is as follows: 1. Kannel sends a message to the SMSC using a submit_sm PDU (If you're using SMPP, I mean) because you specified that wanted a DLR. You also specified some sort of return URL with some sort of coding (your particular message id, etc). 2. The SMSC replies with a message id. 3. Kannel stores that message id along with a timestamp and the URL specified on the MySQL database. 4. The SMSC returns one or many DLR reports (one for "queuing" the message and at least one more to inform of delivery or failure). Kannel "visits" the URL you specified each time, loaded with the corresponding status code and message ID (there are many parameters you may pass, read the docs). 5. If the DLR report is a "final" report (delivery or fatal failure), Kannel deletes the DLR row from the mysql table. So at the end you won't have any DLR rows if your messages are properly handled. Read the DLR section on the docs for further information. Hope it helps, On Apr 6, 2005 5:23 PM, Owen Simwanda <[EMAIL PROTECTED]> wrote: > i am soory for mailling you to you mail box rather than the users mail > list. But anyways i need your help. I have been able to compile my > kannel 1.4.0 with mysql suppot alright on red hat 8. It is able to > recieve and send smses. But the problem is this there are no DLRs stored > in the dlr table in the mysql database. > I also see this line when bearerbox is starting up > > INFO: DLR rerouting for smsc id <owen> disabled. > > could this be the problem? > **************************************************************************************************************** > here is my configuration > > group = core > admin-port = 13000 > smsbox-port = 13001 > admin-password = bar > #status-password = foo > #admin-deny-ip = "" > #admin-allow-ip = "" > log-file = "/var/log/kannel.log" > #log-level = 0 > box-deny-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1" > dlr-storage = mysql > #unified-prefix = "+358,00358,0;+,00" > #access-log = "/tmp/access.log" > #store-file = "/tmp/kannel.store" > #ssl-server-cert-file = "cert.pem" > #ssl-server-key-file = "key.pem" > #ssl-certkey-file = "mycertandprivkeyfile.pem" > > # SMSC CONNECTIONS > > #group = smsc > #smsc = fake > #smsc-id = FAKE > #port = 10000 > #connect-allow-ip = 127.0.0.1 > > #SMPP based SMSC configuration file > > #include =/usr/local/gateway-1.4.0/gw/smpp.conf > > # MODEMS SETUP > > group = modems > id = wavecom > name = Wavecom > detect-string = "WAVECOM" > > #GSM Modem Virtual SMSC > group = smsc > smsc = at > smsc-id = celtel > modemtype = auto > device = /dev/ttyS0 > speed = 9600 > #sms-center = "+26096060015" > sms-center = "+260971911200" > > group = smsbox > bearerbox-host = localhost.localdomain > sendsms-port = 13013 > global-sender = 13013 > #sendsms-chars = "0123456789 +-" > log-file = "/var/log/smsbox.log" > #log-level = 0 > access-log = "/var/log/access.log" > > # SEND-SMS USERS > > group = sendsms-user > username = tester > password = foobar > #user-deny-ip = "" > #user-allow-ip = "" > > #include = /usr/local/gateway-1.4.0/gw/services.conf > include = /usr/local/gateway-1.4.0/gw/dlr-mysql.conf > > # SERVICES > > group = sms-service > keyword = nop > text = "You asked nothing and I did it!" > > # there should be default always > > group = sms-service > keyword = default > aliases = d > get-url = > "http://192.168.0.25/contentsys/randomselection.php?content_type=%k"; > > *********************************************************************************************************** > > and my kannel log > > 2005-04-06 17:01:24 [22896] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2005-04-06 17:01:24 [22896] [0] DEBUG: Loading include file > `/usr/local/gateway-1.4.0/gw/dlr-mysql.conf' (on line 90 of file > /usr/local/gateway-1.4.0/gw/kannel.conf). > 2005-04-06 17:01:25 [22896] [0] INFO: MYSQL: Connected to server at > localhost. > 2005-04-06 17:01:25 [22896] [0] INFO: MYSQL: server version 3.23.52, > client version 3.23.52. > 2005-04-06 17:01:25 [22896] [0] INFO: DLR using storage type: mysql > 2005-04-06 17:01:25 [22896] [0] DEBUG: Kannel bearerbox version `1.4.0'. > Build `Apr 6 2005 16:55:49', compiler `3.2 20020903 (Red Hat Linux 8.0 > 3.2-7)'. > System Linux, release 2.4.18-14, version #1 Wed Sep 4 13:35:50 EDT 2002, > machine i686. > Hostname localhost.localdomain, IP 127.0.0.1. > Libxml version 2.4.23. > Using OpenSSL 0.9.6b [engine] 9 Jul 2001. > Compiled with MySQL 3.23.52, using MySQL 3.23.52. > Using native malloc. > > 2005-04-06 17:01:25 [22896] [0] INFO: Added logfile > `/var/log/kannel.log' with level `0'. > 2005-04-06 17:01:25 [22896] [0] INFO: HTTP: Opening server at port 13000. > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 1 > (gwlib/fdset.c:poller) > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 2 > (gwlib/http.c:server_thread) > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 3 > (gw/bb_http.c:httpadmin_run) > 2005-04-06 17:01:25 [22896] [0] DEBUG: starting smsbox connection module > 2005-04-06 17:01:25 [22896] [0] INFO: BOXC: 'smsbox-max-pending' not > set, using default (100). > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) > 2005-04-06 17:01:25 [22899] [1] DEBUG: Thread 1 (gwlib/fdset.c:poller) > maps to pid 22899. > 2005-04-06 17:01:25 [22900] [2] DEBUG: Thread 2 > (gwlib/http.c:server_thread) maps to pid 22900. > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 5 > (gw/bb_boxc.c:smsboxc_run) > 2005-04-06 17:01:25 [22896] [0] INFO: DLR rerouting for smsc id <celtel> > disabled. > 2005-04-06 17:01:25 [22896] [0] INFO: AT2[celtel]: configuration doesn't > show modemtype. will autodetect > 2005-04-06 17:01:25 [22901] [3] DEBUG: Thread 3 > (gw/bb_http.c:httpadmin_run) maps to pid 22901. > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 6 > (gw/smsc/smsc_at.c:at2_device_thread) > 2005-04-06 17:01:25 [22902] [4] DEBUG: Thread 4 > (gw/bb_boxc.c:sms_to_smsboxes) maps to pid 22902. > 2005-04-06 17:01:25 [22896] [0] DEBUG: Started thread 7 > (gw/bb_smscconn.c:sms_router) > > any help will be appreciated > > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/
