<DIV>
<DIV>
<DIV>Jan,</DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>The second is when I try to create a new transaction when one already exists.<BR></DIV>
<DIV>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])</DIV>
<DIV> </DIV>
<DIV>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: failure_route[1]:jump to route[3]:vm<BR>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: submit_query(): You have an error in your SQL syntax<BR>. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at<BR> line 1<BR>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: submit_query(): Error while submitting query<BR>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: ERROR: vm: db_query() failed.<BR>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: ERROR: vm: vm_get_user_info failed<BR>Oct 1 16:50:59 jiffypop /usr/local/sbin/ser[27448]: route[3]:vm:voicemail failed</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Sep 25 14:07:56 jiffypop /usr/local/sbin/ser[23164]: ERROR: t_newtran: transaction already in process 0x422c0b38</DIV>
<DIV> </DIV>
<DIV>See also my comments in the config file for further explanation on the question of needing to be able to lookup subscribers.</DIV>
<DIV><BR>Thanks,</DIV>
<DIV>G.</DIV>
<DIV><BR><B><I>Jan Janak <jan@iptel.org></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Could you recap for me what the problem is (or send me your config file)<BR>? I tried to find it in the archive but I am quite confused.<BR><BR>Jan.<BR><BR>On 01-10 11:41, Gavin Bensom wrote:<BR>> Jiri wrote:<BR>> <BR>> There is other problem though -- the failure_route logic for VM should <BR>> be different from that in route block -- you can't create transaction state two <BR>> times (first time with t_relay, second time with t_newtran). SER will <BR>> certainly complain with some error message in your logs.<BR>> -----------------------<BR>> <BR>> 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.<BR>> <BR>> 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.<BR>> <BR>> 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.<BR>> <BR>> Thanks,<BR>> G<BR>> <BR>> <BR>> ---------------------------------<BR>> Do you Yahoo!?<BR>> The New Yahoo! Shopping - with improved product search<BR>> _______________________________________________<BR>> Serusers mailing list<BR>> serusers@lists.iptel.org<BR>> http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></DIV></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail">The New Yahoo! Shopping</a> - with improved product search