[Serusers] voicemail on failure_route and user is subscriber questions

[Gavin Bensom]

Jan,
Here is my config file. And two varieties of errors from my logs. The first is when I try to send a call to voicemail that already has a transaction.
 
The second is when I try to create a new transaction when one already exists.

Log sample 1: for this error, I just tried to route a busy call to voicemail The included config file created this error. (route[4] is called from failure_route[1])
 
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: failure_route[1]:jump to route[3]:vm
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: submit_query(): You have an error in your SQL syntax
.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at
 line 1
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: submit_query(): Error while submitting query
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: ERROR: vm: db_query() failed.
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: ERROR: vm: vm_get_user_info failed
Oct  1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: route[3]:vm:voicemail failed
 
Log sample 2: for this error, I tried to create a new transaction when a call failed with a busy status. The included config file didn't generate this error. However if I had called route(3) from failure_route[1] this is what would happen.
 
Sep 25 14:07:56 jiffypop /usr/local/sbin/ser[23164]: ERROR: t_newtran: transaction already in process 0x422c0b38
 
See also my comments in the config file for further explanation on the question of needing to be able to lookup subscribers.

Thanks,
G.

Jan Janak <jan at iptel.org> wrote:
Could you recap for me what the problem is (or send me your config file)
? I tried to find it in the archive but I am quite confused.

Jan.

On 01-10 11:41, Gavin Bensom wrote:
> Jiri wrote:
> 
> There is other problem though -- the failure_route logic for VM should 
> be different from that in route block -- you can't create transaction state two 
> times (first time with t_relay, second time with t_newtran). SER will 
> certainly complain with some error message in your logs.
> -----------------------
> 
> Can anyone tell me how to set up vm to work on a failure route. I've tried several times and although Jiri says the logic has to be different because you can't create a transaction two times, I can't figure out how to make it work, and I haven't found any documentation detailing this issue. I have seen the errors in the logs that verify what Jiri is saying.
> 
> Jiri said that he'd introduce new commands to hide tansaction functionality from script writers, but I'd like to know how to make this work without those new commands.
> 
> Also, is there a command that queries whether or not a sip message is for a user in the subscriber table? I need to know if the user exists regardless of whether or not lookup("location") = true.
> 
> Thanks,
> G
> 
> 
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers




---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20031001/38f8805f/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ser.cfg.txt
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20031001/38f8805f/attachment.txt>