Re: [Solution] possible DLR mismatch due to the '+' character absence inthe MSISDN

Hi,

I am not so sure. It used to be like that, but then a patch was submitted 
that converted it to quotes. This permitted to use certain SQL functions as 
names for tables and columns, if I remember correctly. I think that V 
Chambanis submitted the patch.

You certainly have a point, but it needs to be discussed first.

BR,
Nikos
----- Original Message ----- 
From: Mohammed Saleem
To: kannel_dev_mailinglist
Sent: Thursday, November 25, 2010 4:40 PM
Subject: [Solution] possible DLR mismatch due to the '+' character absence 
inthe MSISDN


Dear Kannelers

I have faced a slight issue with the DLR matching when a DLR is received 
from the carrier, when we send the message we use the international format 
+XXXyzzzzzzzz and when the carrier sends the DLR it send the MSISDN with the 
'+' character, and some other times it sends it without the '+' character. I 
know it is the carrier's fault, but this causes a DLR mismatch and bb can't 
find the DLR

Anyways, I have solved this by changing the SQL statements in gw/dlr_mysql.c 
( I use MySQL ad SLR storage) I've removed the quotes from the destination 
value( changed '%s' to %s) , this lets MySQL searches for the record using 
numeric comparing not literal, therefore, the '+' character won't affect 
anything


Can anyone help with creating a patch? I tried to create one but I am not 
sure if my dlr_mysql.c is not modified before, so I thought someone would do 
this for us


Thanks



Best Regards,
Mohammed M I Sleem
http://www.abusleem.net

http://www.freakle.com - The Search Freak

http://www.colorle.com - color your Google search