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(a)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