<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>RE: [Serusers] Problems Following upgrade to MySQL 4.0.20</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Jan,</FONT>
</P>
<P><FONT SIZE=2>I double checked to make sure the group exits and that the user being called is a member of the voicemail group. Still the same problem?</FONT></P>
<P><FONT SIZE=2>Could this be due to using the RPM's? </FONT>
</P>
<P><FONT SIZE=2>I'll be building a new system from scratch on my second test box to get back to where I was before the upgrade and then building my original box as the test box.</FONT></P>
<P><FONT SIZE=2>Warm Regards</FONT>
</P>
<P><FONT SIZE=2>Shad</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Jan Janak [<A HREF="mailto:jan@iptel.org">mailto:jan@iptel.org</A>] </FONT>
<BR><FONT SIZE=2>Sent: Monday, June 07, 2004 6:13 PM</FONT>
<BR><FONT SIZE=2>To: Shad Mortazavi</FONT>
<BR><FONT SIZE=2>Cc: serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>Subject: Re: [Serusers] Problems Following upgrade to MySQL 4.0.20</FONT>
</P>
<P><FONT SIZE=2>Did you check if you have corresponding line in the grp table ? Maybe</FONT>
<BR><FONT SIZE=2>something went wrong and the table is empty now ?</FONT>
</P>
<P><FONT SIZE=2> Jan.</FONT>
</P>
<P><FONT SIZE=2>On 03-06 06:22, Shad Mortazavi wrote:</FONT>
<BR><FONT SIZE=2>> Dear Group,</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I got a copy of ser + sems + serweb and voicemail working, thanks to some</FONT>
<BR><FONT SIZE=2>> great input from the group. </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I saw that there was error 77 on the missed calls page on serweb. I</FONT>
<BR><FONT SIZE=2>> understood from the user group that this is due to a missing function in</FONT>
<BR><FONT SIZE=2>> version 3.1.x of Mysql. I upgraded my MySQL version 4.0.22. I booted ran the</FONT>
<BR><FONT SIZE=2>> fix privileges routine as advised. MySQL started.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I then started my testing and now my Voice Mail and Forwarding to my</FONT>
<BR><FONT SIZE=2>> Asterisk Box are broken ???. I can see from the debug(below) that the system</FONT>
<BR><FONT SIZE=2>> can no longer find the user in the voicemail group? So there is some change</FONT>
<BR><FONT SIZE=2>> in the table/db or the interaction of the script with the DB. </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I tried dropping the DB, recreating is with the ser_mysql.sh command, and</FONT>
<BR><FONT SIZE=2>> reading the users and I keep getting the same result;</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Here is the debug. You can see from the debug that 5(2226) is_user_in():</FONT>
<BR><FONT SIZE=2>> User is not in group 'voicemail, before the upgrade the system showed the</FONT>
<BR><FONT SIZE=2>> user in the voicemail group??? </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Before this issue my voicemail would go to the voicemail.cfg script and</FONT>
<BR><FONT SIZE=2>> record a voicemail, now I get Not Found and no voicemail turned on from;</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> if ( !( isflagset(4) || (uri =~ "conference") || (uri =~ "echo") ) )</FONT>
<BR><FONT SIZE=2>> {</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</FONT>
<BR><FONT SIZE=2>> on");</FONT>
<BR><FONT SIZE=2>> break;</FONT>
<BR><FONT SIZE=2>> };</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> As always your help would be appreciated.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Here is the debug.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><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> =</FONT>
<BR><FONT SIZE=2>> <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>
<BR><FONT SIZE=2>> </FONT>
<BR><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]</FONT>
<BR><FONT SIZE=2>> == [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]</FONT>
<BR><FONT SIZE=2>> == [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> =</FONT>
<BR><FONT SIZE=2>> <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>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Kind Regards</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><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>
<BR><FONT SIZE=2>> </FONT>
</P>
<P><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> Serusers mailing list</FONT>
<BR><FONT SIZE=2>> serusers@lists.iptel.org</FONT>
<BR><FONT SIZE=2>> <A HREF="http://lists.iptel.org/mailman/listinfo/serusers" TARGET="_blank">http://lists.iptel.org/mailman/listinfo/serusers</A></FONT>
</P>
</BODY>
</HTML>