Author Topic: fork through mysql  (Read 5329 times)

iKenny

  • Newbie
  • *
  • Posts: 18
    • View Profile
fork through mysql
« on: October 18, 2013, 01:57:35 AM »
I have a stored procedure for routing witch return a single column named 'location'
In section of call route in register.conf i have a query for procedure and result option
query=call routing('${caller}', '${called}')
result=location

The thing i would like to do is to make a call to a user and if he didn't answered after
a while - redirect call to another number. User number is 111 for example and number for redirection is 222
I am bit confused, in that case, what should my procedure return?
I suppose it must return a location with
"fork route/111 |exec=15000 route/222"?
Or maybe something else?
Thank you for answer.

iKenny

  • Newbie
  • *
  • Posts: 18
    • View Profile
Re: fork through mysql
« Reply #1 on: October 18, 2013, 02:52:03 AM »
I have found the solution.
The key is first to call to client's location, then to call to second number.
In short, location must be
Code: [Select]
fork sip/sip:user number@ip |exec=5000 route/number to redirect |stoperror=busy
for procedure in it self you can contact me via e-mail

vankooch

  • Administrator
  • Newbie
  • *****
  • Posts: 49
    • View Profile
Re: fork through mysql
« Reply #2 on: October 18, 2013, 07:57:56 AM »