[Serusers] Problems Following upgrade to MySQL 4.0.20

[Shad Mortazavi]

Dear Group,

I got a copy of  ser + sems + serweb and voicemail working, thanks to some
great input from the group. 

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.

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. 

I tried dropping the DB, recreating is with the ser_mysql.sh  command, and
reading the users and I keep getting the same result;

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??? 

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;

	if ( !( isflagset(4) || (uri =~ "conference") || (uri =~ "echo") ) )
{
		log(1, "no voicemail subscriber->return 404"); 
		sl_send_reply("404", "Not Found and no voicemail turned
on");
		break;
	};

As always your help would be appreciated.

Here is the debug.

5(2226) SIP Request:
 5(2226)  method:  <INVITE>
 5(2226)  uri:     <sip:ella at convergenceone.com>
 5(2226)  version: <SIP/2.0>
 5(2226) parse_headers: flags=1
 5(2226) Found param type 235, <rport> = <n/a>; state=6
 5(2226) Found param type 232, <branch> =
<z9hG4bKF54DAB3D6C0C455FBF00B605D4C8A3CD>; state=16
 5(2226) end of header reached, state=5
 5(2226) parse_headers: Via found, flags=1
 5(2226) parse_headers: this is the first via
 5(2226) After parse_msg...
 5(2226) preparing to run routing scripts...
 5(2226) -------------------------------------------
 5(2226) entering main loop
 5(2226) INVITE message received
 5(2226) DEBUG : is_maxfwd_present: searching for max_forwards header
 5(2226) parse_headers: flags=128
 5(2226) end of header reached, state=9
 5(2226) DEBUG: get_hdr_field: <To> [31]; uri=[sip:ella at convergenceone.com] 
 5(2226) DEBUG: to body [<sip:ella at convergenceone.com>

]
 5(2226) get_hdr_field: cseq <CSeq>: <54246> <INVITE>
 5(2226) DEBUG: is_maxfwd_present: value = 70 
 5(2226) parse_headers: flags=256
 5(2226) DEBUG: get_hdr_body : content_length=270
 5(2226) found end of header
 5(2226) find_first_route(): No Route headers found
 5(2226) loose_route(): There is no Route HF
 5(2226) check_self - checking if host==us: 18==9 &&  [convergenceone.com]
== [127.0.0.1]
 5(2226) check_self - checking if port 5060 matches port 5060
 5(2226) check_self - checking if host==us: 18==13 &&  [convergenceone.com]
== [192.168.0.206]
 5(2226) check_self - checking if port 5060 matches port 5060
 5(2226) lookup(): 'ella' Not found in usrloc
 5(2226) is_user_in(): User is not in group 'voicemail
'
 5(2226) lookup(): 'ella' Not found in usrloc
 5(2226) requested user not found
 5(2226) -------------------------------------------
 5(2226) entering route[4] = requested user not online
 5(2226) no voicemail subscriber->return 404 5(2226) parse_headers: flags=-1
 5(2226) check_via_address(192.168.0.1, 144.137.65.167, 0)
 5(2226) receive_msg: cleaning up
 7(2234) SIP Request:
 7(2234)  method:  <ACK>
 7(2234)  uri:     <sip:ella at convergenceone.com>
 7(2234)  version: <SIP/2.0>
 7(2234) parse_headers: flags=1
 7(2234) Found param type 235, <rport> = <n/a>; state=6
 7(2234) Found param type 232, <branch> =
<z9hG4bKF54DAB3D6C0C455FBF00B605D4C8A3CD>; state=16
 7(2234) end of header reached, state=5
 7(2234) parse_headers: Via found, flags=1
 7(2234) parse_headers: this is the first via
 7(2234) After parse_msg...
 7(2234) parse_headers: flags=4
 7(2234) DEBUG: add_param: tag=b27e1a1d33761e85846fc98f5f3a7e58.9612
 7(2234) end of header reached, state=29
 7(2234) DEBUG: get_hdr_field: <To> [73]; uri=[sip:ella at convergenceone.com] 
 7(2234) DEBUG: to body [<sip:ella at convergenceone.com>]
 7(2234) DEBUG: sl_filter_ACK : local ACK found -> dropping it!


Kind Regards

Shad Mortazavi
---------------------------------------------------
Nexus Technical Manager
n|m Nexus Management Inc 
Neutral Bay
Sydney

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040603/4b8a07ed/attachment.htm>