Ok so i'm still having issues with remote mysql, however for now I have also installed SER on the DB server, now when a user attempts to connect with X-lite they getting a "Login timed out! Contact your administrator". Below I have included debug info from 'ser -Eddd'.
My database table subscriber contains: phplib_id username domain password first_name last_name phone email_address datetime_created datetime_modified confirmation flag sendnotification greeting ha1 ha1b perms allow_find timezone rpid
1e3f83df7c724e5e983af18d099e97f8 894485566 voipweb.fast.co.nz bazza test Murphy 6494485566 barry@unix.co.nz 2005-03-09 12:52:17 2005-03-09 13:30:56 151584fb22f7730baeaf547478a78d72 o e1021132437863e29d70c9a18e9b874c c5de05c6015f915d3e11ee0af71daa31 NULL 1 Pacific/Auckland NULL
34(85232) DEBUG: timer routine:4,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[5]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 4(85202) SIP Request: 4(85202) method: <REGISTER> 4(85202) uri: sip:voipweb.fast.co.nz 4(85202) version: <SIP/2.0> 4(85202) parse_headers: flags=1 4(85202) Found param type 235, <rport> = <n/a>; state=6 4(85202) Found param type 232, <branch> = <z9hG4bK6CCFC5AD21834ACF9A404F676C79C2CD>; state=16 4(85202) end of header reached, state=5 4(85202) parse_headers: Via found, flags=1 4(85202) parse_headers: this is the first via 4(85202) After parse_msg... 4(85202) preparing to run routing scripts... 4(85202) DEBUG : is_maxfwd_present: searching for max_forwards header 4(85202) parse_headers: flags=128 4(85202) end of header reached, state=9 4(85202) DEBUG: get_hdr_field: <To> [42]; uri=[sip:894485566@voipweb.fast.co.nz] 4(85202) DEBUG: to body [barry sip:894485566@voipweb.fast.co.nz ] 4(85202) get_hdr_field: cseq <CSeq>: <42071> <REGISTER> 4(85202) DEBUG: is_maxfwd_present: value = 70 4(85202) DEBUG: add_param: tag=3227429458 4(85202) end of header reached, state=29 4(85202) parse_headers: flags=256 4(85202) DEBUG: get_hdr_body : content_length=0 4(85202) found end of header 4(85202) find_first_route(): No Route headers found 4(85202) loose_route(): There is no Route HF 4(85202) check_self - checking if host==us: 18==11 && [voipweb.fast.co.nz] == [202.89.33.4] 4(85202) check_self - checking if port 5060 matches port 5060 4(85202) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.5.33] 4(85202) check_self - checking if port 5060 matches port 5060 4(85202) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.6.33] 4(85202) check_self - checking if port 5060 matches port 5060 4(85202) check_self - checking if host==us: 18==9 && [voipweb.fast.co.nz] == [127.0.0.1] 4(85202) check_self - checking if port 5060 matches port 5060 4(85202) check_self: host != me 4(85202) DEBUG: t_addifnew: msg id=21 , global msg id=20 , T on entrance=0xffffffff 4(85202) parse_headers: flags=-1 4(85202) parse_headers: flags=60 4(85202) t_lookup_request: start searching: hash=35089, isACK=0 4(85202) DEBUG: RFC3261 transaction matched, tid=6CCFC5AD21834ACF9A404F676C79C2CD 4(85202) DEBUG: t_lookup_request: transaction found (T=0x282fa738) 4(85202) DBG: t_retransmit_reply: nothing to retransmit 4(85202) DEBUG:destroy_avp_list: destroing list 0x0 4(85202) receive_msg: cleaning up 34(85232) DEBUG: timer routine:5,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[6]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 6(85204) SIP Request: 6(85204) method: <REGISTER> 6(85204) uri: sip:voipweb.fast.co.nz 6(85204) version: <SIP/2.0> 6(85204) parse_headers: flags=1 6(85204) Found param type 235, <rport> = <n/a>; state=6 6(85204) Found param type 232, <branch> = <z9hG4bK6CCFC5AD21834ACF9A404F676C79C2CD>; state=16 6(85204) end of header reached, state=5 6(85204) parse_headers: Via found, flags=1 6(85204) parse_headers: this is the first via 6(85204) After parse_msg... 6(85204) preparing to run routing scripts... 6(85204) DEBUG : is_maxfwd_present: searching for max_forwards header 6(85204) parse_headers: flags=128 6(85204) end of header reached, state=9 6(85204) DEBUG: get_hdr_field: <To> [42]; uri=[sip:894485566@voipweb.fast.co.nz] 6(85204) DEBUG: to body [barry sip:894485566@voipweb.fast.co.nz ] 6(85204) get_hdr_field: cseq <CSeq>: <42071> <REGISTER> 6(85204) DEBUG: is_maxfwd_present: value = 70 6(85204) DEBUG: add_param: tag=3227429458 6(85204) end of header reached, state=29 6(85204) parse_headers: flags=256 6(85204) DEBUG: get_hdr_body : content_length=0 6(85204) found end of header 6(85204) find_first_route(): No Route headers found 6(85204) loose_route(): There is no Route HF 6(85204) check_self - checking if host==us: 18==11 && [voipweb.fast.co.nz] == [202.89.33.4] 6(85204) check_self - checking if port 5060 matches port 5060 6(85204) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.5.33] 6(85204) check_self - checking if port 5060 matches port 5060 6(85204) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.6.33] 6(85204) check_self - checking if port 5060 matches port 5060 6(85204) check_self - checking if host==us: 18==9 && [voipweb.fast.co.nz] == [127.0.0.1] 6(85204) check_self - checking if port 5060 matches port 5060 6(85204) check_self: host != me 6(85204) DEBUG: t_addifnew: msg id=21 , global msg id=20 , T on entrance=0xffffffff 6(85204) parse_headers: flags=-1 6(85204) parse_headers: flags=60 6(85204) t_lookup_request: start searching: hash=35089, isACK=0 6(85204) DEBUG: RFC3261 transaction matched, tid=6CCFC5AD21834ACF9A404F676C79C2CD 6(85204) DEBUG: t_lookup_request: transaction found (T=0x282fa738) 6(85204) DBG: t_retransmit_reply: nothing to retransmit 6(85204) DEBUG:destroy_avp_list: destroing list 0x0 6(85204) receive_msg: cleaning up 5(85203) udp_rcv_loop: probing packet received from 10.23.14.16 50195 3(85201) udp_rcv_loop: probing packet received from 10.23.14.16 50195 34(85232) DEBUG: timer routine:6,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[7]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 34(85232) DEBUG: timer routine:7,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[7]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 7(85205) SIP Request: 7(85205) method: <REGISTER> 7(85205) uri: sip:voipweb.fast.co.nz 7(85205) version: <SIP/2.0> 7(85205) parse_headers: flags=1 7(85205) Found param type 235, <rport> = <n/a>; state=6 7(85205) Found param type 232, <branch> = <z9hG4bK6CCFC5AD21834ACF9A404F676C79C2CD>; state=16 7(85205) end of header reached, state=5 7(85205) parse_headers: Via found, flags=1 7(85205) parse_headers: this is the first via 7(85205) After parse_msg... 7(85205) preparing to run routing scripts... 7(85205) DEBUG : is_maxfwd_present: searching for max_forwards header 7(85205) parse_headers: flags=128 7(85205) end of header reached, state=9 7(85205) DEBUG: get_hdr_field: <To> [42]; uri=[sip:894485566@voipweb.fast.co.nz] 7(85205) DEBUG: to body [barry sip:894485566@voipweb.fast.co.nz ] 7(85205) get_hdr_field: cseq <CSeq>: <42071> <REGISTER> 7(85205) DEBUG: is_maxfwd_present: value = 70 7(85205) DEBUG: add_param: tag=3227429458 7(85205) end of header reached, state=29 7(85205) parse_headers: flags=256 7(85205) DEBUG: get_hdr_body : content_length=0 7(85205) found end of header 7(85205) find_first_route(): No Route headers found 7(85205) loose_route(): There is no Route HF 7(85205) check_self - checking if host==us: 18==11 && [voipweb.fast.co.nz] == [202.89.33.4] 7(85205) check_self - checking if port 5060 matches port 5060 7(85205) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.5.33] 7(85205) check_self - checking if port 5060 matches port 5060 7(85205) check_self - checking if host==us: 18==10 && [voipweb.fast.co.nz] == [202.7.6.33] 7(85205) check_self - checking if port 5060 matches port 5060 7(85205) check_self - checking if host==us: 18==9 && [voipweb.fast.co.nz] == [127.0.0.1] 7(85205) check_self - checking if port 5060 matches port 5060 7(85205) check_self: host != me 7(85205) DEBUG: t_addifnew: msg id=19 , global msg id=18 , T on entrance=0xffffffff 7(85205) parse_headers: flags=-1 7(85205) parse_headers: flags=60 7(85205) t_lookup_request: start searching: hash=35089, isACK=0 7(85205) DEBUG: RFC3261 transaction matched, tid=6CCFC5AD21834ACF9A404F676C79C2CD 7(85205) DEBUG: t_lookup_request: transaction found (T=0x282fa738) 7(85205) DBG: t_retransmit_reply: nothing to retransmit 7(85205) DEBUG:destroy_avp_list: destroing list 0x0 7(85205) receive_msg: cleaning up 34(85232) DEBUG: timer routine:7,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[7]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 2(85200) udp_rcv_loop: probing packet received from 203.98.56.249 1796 1(85199) 8(85206) udp_rcv_loop: probing packet received from 10.23.14.16 50195 udp_rcv_loop: probing packet received from 10.23.14.16 50195 34(85232) DEBUG: timer routine:7,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[7]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done 34(85232) DEBUG: timer routine:7,tl=0x282fa860 next=0x0 34(85232) DEBUG: retransmission_handler : request resending (t=0x282fa738, REGISTER ... ) 34(85232) DEBUG: add_to_tail_of_timer[7]: 0x282fa860 34(85232) DEBUG: retransmission_handler : done