Seems the logic I used is flawed, problem is not all of the sip clients register their domain in the location table, alot of them have NULL as domain, so I need to rely on the socket column in location table to determine where to send the incoming call. Problem is I need to extract only the IP from udp:xx.xx.xx.xx:5060 , any idea on how to achieve that ?
Regards

On Mon, Dec 17, 2012 at 4:13 PM, Alex Balashov <abalashov@evaristesys.com> wrote:
Your reference to the row, column lacks $dbr() PV encapsulation.

Ali Jawad <ali.jawad@splendor.net> wrote:

>Thanks Alex, now it works if I do set the $ru manually, however if I do
>set
>it dynamically it still gives destination unresolvable, I do fetch a
>SQL
>statement and row 1,1 is hostname
>
>
>                while($var(i)<$dbr(ra=>rows))
>
>                {
>
>                        $var(j) = 0;
>
>                        while($var(j)<$dbr(ra=>cols))
>
>                        {
>
>                                xlog("[$var(i),$var(j)] =
>$dbr(ra=>[$var(i),$var(j)])\n");
>
>                                $var(j) = $var(j) + 1;
>
>                        }
>
>                        $var(i) = $var(i) + 1;
>
>                }
>
>        }
>
>
>
>        $ru = "sip:support1@ra=>[$var(1),$var(1)]:5060";
>
>
>On Mon, Dec 17, 2012 at 2:22 PM, Alex Balashov
><abalashov@evaristesys.com>wrote:
>
>> $ru

--
Sent from my mobile, and thus lacking in the refinement one might expect from a fully-fledged keyboard.

Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

_______________________________________________
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



--
Ali Jawad   
Information Systems Manager
CISSP - PMP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
Splendor Telecom (www.splendor.net)
Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554