If you are using sql box then just delete specific data from table.... don't try to remove it from stor file it will crupt file
On Thu, Jul 31, 2008 at 9:01 PM, Alvaro Cornejo <[EMAIL PROTECTED]> wrote: > Hi All > > > I've the following issue, I need to delete some messages from kannel since > the destination number is being rejected by carrier. I use kannel with mysql > and flushed dlr but messages still there. The only way I can get read from > them is waiting I have only the specific message in queue - quite diffcult > to do- and restart kannel. > > Is there another way to do that? Also, how to configure kannel to preserve > queue after a reset? I've set storage as mysql but seems not working. > > > > #CORE BEARERBOX > group = core > admin-port = 13000 > smsbox-port = 13001 > wapbox-port = 13002 > dlr-storage = mysql > # usar en vez del MYSQL-DLR > # dlr-storage = internal > admin-password = ****** > status-password = ****** > #box-allow-ip = "*.*.*.*" > box-allow-ip = "127.0.0.1;10.10.5.2" > box-deny-ip = "*.*.*.*" > log-file = "/var/log/kannel/bearerbox.log" > log-level = 0 > access-log = "/var/log/kannel/beareraccess.log" > > ############## > # SMSBOX SETUP > # > group = smsbox > bearerbox-host = 10.10.5.2 > sendsms-chars = "0123456789 +" > sendsms-port = 13013 > global-sender = SmsGlobal > log-file = "/var/log/kannel/smsbox.log" > log-level = 0 > access-log = "/var/log/kannel/smsaccess.log" > http-request-retry = 5 > http-queue-delay = 5 > > #### CONEXION A MYSQL LOCALHOST > group = mysql-connection > id = mydlr > host = localhost > username = xxxxx > password = xxxxxxxxx > database = kannel_dlr > max-connections = 2 > > > #### DLR DB DEFINITION > group = dlr-db > id = mydlr > table = tblkannel_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 > > Regards > > Alvaro > > -- Syed Kashif Ali Bukhari +92-300-4295604 http://www.sysadminsline.com http://www.kashifbukhari.com
