<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>Problems Following upgrade to MySQL 4.0.20</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Dear Group,</FONT>
</P>
<P><FONT SIZE=2>I got a copy of ser + sems + serweb and voicemail working, thanks to some great input from the group. </FONT>
</P>
<P><FONT SIZE=2>I saw that there was error 77 on the missed calls page on serweb. I understood from the user group that this is due to a missing function in version 3.1.x of Mysql. I upgraded my MySQL version 4.0.22. I booted ran the fix privileges routine as advised. MySQL started.</FONT></P>
<P><FONT SIZE=2>I then started my testing and now my Voice Mail and Forwarding to my Asterisk Box are broken ☹. I can see from the debug(below) that the system can no longer find the user in the voicemail group? So there is some change in the table/db or the interaction of the script with the DB. </FONT></P>
<P><FONT SIZE=2>I tried dropping the DB, recreating is with the ser_mysql.sh command, and reading the users and I keep getting the same result;</FONT></P>
<P><FONT SIZE=2>Here is the debug. You can see from the debug that 5(2226) is_user_in(): User is not in group 'voicemail, before the upgrade the system showed the user in the voicemail group??? </FONT></P>
<P><FONT SIZE=2>Before this issue my voicemail would go to the voicemail.cfg script and record a voicemail, now I get Not Found and no voicemail turned on from;</FONT></P>
<P> <FONT SIZE=2>if ( !( isflagset(4) || (uri =~ "conference") || (uri =~ "echo") ) ) {</FONT>
<BR> <FONT SIZE=2>log(1, "no voicemail subscriber->return 404"); </FONT>
<BR> <FONT SIZE=2>sl_send_reply("404", "Not Found and no voicemail turned on");</FONT>
<BR> <FONT SIZE=2>break;</FONT>
<BR> <FONT SIZE=2>};</FONT>
</P>
<P><FONT SIZE=2>As always your help would be appreciated.</FONT>
</P>
<P><FONT SIZE=2>Here is the debug.</FONT>
</P>
<P><FONT SIZE=2>5(2226) SIP Request:</FONT>
<BR><FONT SIZE=2> 5(2226) method: <INVITE></FONT>
<BR><FONT SIZE=2> 5(2226) uri: <sip:ella@convergenceone.com></FONT>
<BR><FONT SIZE=2> 5(2226) version: <SIP/2.0></FONT>
<BR><FONT SIZE=2> 5(2226) parse_headers: flags=1</FONT>
<BR><FONT SIZE=2> 5(2226) Found param type 235, <rport> = <n/a>; state=6</FONT>
<BR><FONT SIZE=2> 5(2226) Found param type 232, <branch> = <z9hG4bKF54DAB3D6C0C455FBF00B605D4C8A3CD>; state=16</FONT>
<BR><FONT SIZE=2> 5(2226) end of header reached, state=5</FONT>
<BR><FONT SIZE=2> 5(2226) parse_headers: Via found, flags=1</FONT>
<BR><FONT SIZE=2> 5(2226) parse_headers: this is the first via</FONT>
<BR><FONT SIZE=2> 5(2226) After parse_msg...</FONT>
<BR><FONT SIZE=2> 5(2226) preparing to run routing scripts...</FONT>
<BR><FONT SIZE=2> 5(2226) -------------------------------------------</FONT>
<BR><FONT SIZE=2> 5(2226) entering main loop</FONT>
<BR><FONT SIZE=2> 5(2226) INVITE message received</FONT>
<BR><FONT SIZE=2> 5(2226) DEBUG : is_maxfwd_present: searching for max_forwards header</FONT>
<BR><FONT SIZE=2> 5(2226) parse_headers: flags=128</FONT>
<BR><FONT SIZE=2> 5(2226) end of header reached, state=9</FONT>
<BR><FONT SIZE=2> 5(2226) DEBUG: get_hdr_field: <To> [31]; uri=[sip:ella@convergenceone.com] </FONT>
<BR><FONT SIZE=2> 5(2226) DEBUG: to body [<sip:ella@convergenceone.com></FONT>
</P>
<P><FONT SIZE=2>]</FONT>
<BR><FONT SIZE=2> 5(2226) get_hdr_field: cseq <CSeq>: <54246> <INVITE></FONT>
<BR><FONT SIZE=2> 5(2226) DEBUG: is_maxfwd_present: value = 70 </FONT>
<BR><FONT SIZE=2> 5(2226) parse_headers: flags=256</FONT>
<BR><FONT SIZE=2> 5(2226) DEBUG: get_hdr_body : content_length=270</FONT>
<BR><FONT SIZE=2> 5(2226) found end of header</FONT>
<BR><FONT SIZE=2> 5(2226) find_first_route(): No Route headers found</FONT>
<BR><FONT SIZE=2> 5(2226) loose_route(): There is no Route HF</FONT>
<BR><FONT SIZE=2> 5(2226) check_self - checking if host==us: 18==9 && [convergenceone.com] == [127.0.0.1]</FONT>
<BR><FONT SIZE=2> 5(2226) check_self - checking if port 5060 matches port 5060</FONT>
<BR><FONT SIZE=2> 5(2226) check_self - checking if host==us: 18==13 && [convergenceone.com] == [192.168.0.206]</FONT>
<BR><FONT SIZE=2> 5(2226) check_self - checking if port 5060 matches port 5060</FONT>
<BR><FONT SIZE=2> 5(2226) lookup(): 'ella' Not found in usrloc</FONT>
<BR><FONT SIZE=2> 5(2226) is_user_in(): User is not in group 'voicemail</FONT>
<BR><FONT SIZE=2>'</FONT>
<BR><FONT SIZE=2> 5(2226) lookup(): 'ella' Not found in usrloc</FONT>
<BR><FONT SIZE=2> 5(2226) requested user not found</FONT>
<BR><FONT SIZE=2> 5(2226) -------------------------------------------</FONT>
<BR><FONT SIZE=2> 5(2226) entering route[4] = requested user not online</FONT>
<BR><FONT SIZE=2> 5(2226) no voicemail subscriber->return 404 5(2226) parse_headers: flags=-1</FONT>
<BR><FONT SIZE=2> 5(2226) check_via_address(192.168.0.1, 144.137.65.167, 0)</FONT>
<BR><FONT SIZE=2> 5(2226) receive_msg: cleaning up</FONT>
<BR><FONT SIZE=2> 7(2234) SIP Request:</FONT>
<BR><FONT SIZE=2> 7(2234) method: <ACK></FONT>
<BR><FONT SIZE=2> 7(2234) uri: <sip:ella@convergenceone.com></FONT>
<BR><FONT SIZE=2> 7(2234) version: <SIP/2.0></FONT>
<BR><FONT SIZE=2> 7(2234) parse_headers: flags=1</FONT>
<BR><FONT SIZE=2> 7(2234) Found param type 235, <rport> = <n/a>; state=6</FONT>
<BR><FONT SIZE=2> 7(2234) Found param type 232, <branch> = <z9hG4bKF54DAB3D6C0C455FBF00B605D4C8A3CD>; state=16</FONT>
<BR><FONT SIZE=2> 7(2234) end of header reached, state=5</FONT>
<BR><FONT SIZE=2> 7(2234) parse_headers: Via found, flags=1</FONT>
<BR><FONT SIZE=2> 7(2234) parse_headers: this is the first via</FONT>
<BR><FONT SIZE=2> 7(2234) After parse_msg...</FONT>
<BR><FONT SIZE=2> 7(2234) parse_headers: flags=4</FONT>
<BR><FONT SIZE=2> 7(2234) DEBUG: add_param: tag=b27e1a1d33761e85846fc98f5f3a7e58.9612</FONT>
<BR><FONT SIZE=2> 7(2234) end of header reached, state=29</FONT>
<BR><FONT SIZE=2> 7(2234) DEBUG: get_hdr_field: <To> [73]; uri=[sip:ella@convergenceone.com] </FONT>
<BR><FONT SIZE=2> 7(2234) DEBUG: to body [<sip:ella@convergenceone.com>]</FONT>
<BR><FONT SIZE=2> 7(2234) DEBUG: sl_filter_ACK : local ACK found -> dropping it!</FONT>
</P>
<BR>
<P><FONT SIZE=2>Kind Regards</FONT>
</P>
<P><FONT SIZE=2>Shad Mortazavi</FONT>
<BR><FONT SIZE=2>---------------------------------------------------</FONT>
<BR><FONT SIZE=2>Nexus Technical Manager</FONT>
<BR><FONT SIZE=2>n|m Nexus Management Inc </FONT>
<BR><FONT SIZE=2>Neutral Bay</FONT>
<BR><FONT SIZE=2>Sydney</FONT>
</P>
</BODY>
</HTML>