Re: [Serusers] Problems Following upgrade to MySQL 4.0.20

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@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@convergenceone.com] 5(2226) DEBUG: to body [<sip:ella@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@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@convergenceone.com] 7(2234) DEBUG: to body [<sip:ella@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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers