All the solutions based on parsing logs will affect your performance and cause a delay on processing MO's.
You need to take care about 'duplicate entries' bug - either patch kannel or re-write your processing script to avoid multiple entries insterted with the same sql-id. 2012/12/27 Jose Figueroa <josen.figue...@unixmexico.org> > 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 >> > > >
