Hi
Use update xxxx instead of insert xxxx on your script, thererefore
you can keep the unique key coherent with the logs.
On 12/27/12, spameden <spame...@gmail.com> wrote:
> 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
>>>
>>
>>
>>
>
--
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
SMS y GPRS online
Visitenos en www.perusms.NET www.smsglobal.com.mx y
www.pravcom.com
