[Serusers] Problems Following upgrade to MySQL 4.0.20

[Jan Janak]

I can't say more from the info you sent to the list. I am sure that the
group code works, so there must be some error in your config file or
database. 

  Jan.

On 08-06 01:06, Shad Mortazavi wrote:
> Jan,
> 
> 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?
> 
> Could this be due to using the RPM's? 
> 
> 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.
> 
> Warm Regards
> 
> Shad
> 
> -----Original Message-----
> From: Jan Janak [mailto:jan at iptel.org] 
> Sent: Monday, June 07, 2004 6:13 PM
> To: Shad Mortazavi
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] Problems Following upgrade to MySQL 4.0.20
> 
> 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