[Serusers] Problems Following upgrade to MySQL 4.0.20

[Jan Janak]

Did you check if you have corresponding line in the grp table ? Maybe
something went wrong and the table is empty now ?

 Jan.

On 03-06 06:22, Shad Mortazavi wrote:
> 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
> 

> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers