Hi Guys,
Wonder if anyone has experienced this before, on kamailio 4.1.
I am using an sql_pvquery and it works fine, unless I pull a value from the
database that is defined as 10 digits and starts with a 3, actually its
populated as 03785702370 but due to the table it removes the leading 0
(bigint(20) unsigned).
Running a manual query in my database for a DestinationMsisdn I get;
select DestinationMsisdn,SourceMsisdn from MsisdnPoolAllocations where
PoolMsisdn='+44162489xxxx';+-------------------+--------------+|
DestinationMsisdn | SourceMsisdn |+-------------------+--------------+|
3785702370 | 4474526xxxxx |+-------------------+--------------+
However running in the kamailio.cfg an sql_pvquery to do the same query as
below;
sql_pvquery("cd","select DestinationMsisdn,SourceMsisdn from
MsisdnPoolAllocations where
PoolMsisdn='$rU'","$var(MOdest),$var(NewSourceMSISDN)");
However this returns a value of -509264926 for $var(MOdest) which should just
be the 3785702370 number.
What can cause kamailio to interpret this as a negative value? Has anyone seen
this before?
Many thanks
Jon _______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
