Hello Ombongi I had the same problem once and I had to write a awk scripting file in order to accomplish it. On the previous email you said to process them at least to send to the subscribers so It would be easy if you need this and even if you need to insert them into the MySQL table.
If you need some help with the awk scripting file I can help you on doing this. Saludos mi querido Ombongi. Jose On Dec 26, 2012, at 11:42 PM, Tapan Kumar Thapa <tapan.thapa2...@gmail.com> wrote: > I think automatically by kannel itself is not possible however you can write > a small program which will parse access logs and will reinsert the same in > MySQL table. > > Thanks & Regards > Tapan Thapa > > On Thu, Dec 27, 2012 at 11:03 AM, Ombongi Moraa Fe > <moraa.lovetak...@gmail.com> wrote: > Hello Team, > > I realized some 20 Hours later that insertion of messages into mysql database > wasn't working. When I tried to insert manually, I got the error "duplicate > entry to autoincrement field...." Therefore, almost 10000 messages were never > inserted into the mysql table holding messages because of this. Hence, > basically nothing was done to these requests. > > When I check the kannel MO log file, I can see alot of those messages that > were never processed as a result. I wonder, Is i possible to reprocess my log > entries during this period and at least send out responses to the > subscribers? I cannot reprocess them from the database since they were never > inserted into the table for holding incoming messages. I therefore need > another position of re-running my processing. > > I'll appreciate your advise. > > Saludos > > Ombongi Moraa fe >
