[SR-Users] Using Dispatcher Module From Mysql

[Amit Nepal]

Yes,
     I set the dburl now and  i have the following :

modparam("dispatcher", "db_url", DBURL) >>> this sets the dburl. Now it 
shows not found to the caller but also makes calls to the destination, 
and a copy of call is also forwarded to the asterisk.. any thing wrong 
with my config ?


  if(uri=~"^sip:1[2-9][0-9]{9}@")
                 {
                 if(is_user_in("credentials","longdistance"))
                         {
                         ds_select_dst("1","8");
                         forward();
                         }
                 else{
                         sl_send_reply("403","No Permissions for Long 
Distance calls");
                         exit;
                         };

Thank You
Amit Nepal
Systems Administrator
Phoenix Internet
Phone: 602-385-0731
        602-234-0917#112
http://www.phoenixinternet.net


On 1/7/2011 10:57 AM, Daniel-Constantin Mierla wrote:
> Hello,
>
> On 1/7/11 6:47 PM, Amit Nepal wrote:
>> Hi everyone,
>>         Again stuck at the dispatcher module.Do anyone happen to have 
>> a working config for kamailio with dispatcher list from mysql database ?
>> if not can someone please guide me on this ?
>>
>> Do i need to pass module parameters for the column and the table names ?
>>
>> I have the following config :
>>
>> loadmodule "dispatcher.so"
> have you set the db_url parameter for dispatcher module? If not, then 
> dispatcher does not connect to database.
>
> Cheers,
> Daniel
>
>>
>>  if(uri=~"^sip:1[2-9][0-9]{9}@")
>>                 {
>>                 if(is_user_in("credentials","longdistance"))
>>                         {
>>                         #route(PSTN);
>>                         #exit;
>>                         ds_select_dst("1","8");
>>                         forward();
>>                         }
>>                 else{
>>                         sl_send_reply("403","No Permissions for Long 
>> Distance calls");
>>                         exit;
>>                         };
>>                 };
>>
>