<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><font face="Helvetica, Arial, sans-serif">Hello</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">can anyone explain to
me why (and HOW) there is a difference in data between the
Asterisk console "sip show peers" and the realtime MySQL
configuration ?</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Using :
asterisk-certified-13.21-cert6<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Asterisk console data :</font></p>
<p><font face="Helvetica, Arial, sans-serif">/usr/sbin/asterisk -rx
'sip show peers' | grep 660091086<br>
660091086/660091086 11.22.33.44
D Yes Yes 55018 OK (31
ms) Cached RT</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">/usr/sbin/asterisk -rx
'sip show peer 660091086'</font></p>
<p><font face="Helvetica, Arial, sans-serif"> * Name :
660091086<br>
Description : <br>
Realtime peer: Yes, cached<br>
Secret : <Set><br>
.... .... .... ....<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"> DTMFmode :
rfc2833<br>
Timer T1 : 500<br>
Timer B : 32000<br>
ToHost : <br>
Addr->IP : 11.22.33.44:55018<br>
Defaddr->IP : (null)<br>
Prim.Transp. : UDP<br>
Allowed.Trsp : UDP<br>
Def. Username: 660091086<br>
SIP Options : (none)<br>
Codecs : (alaw|g729|gsm)<br>
Auto-Framing : No<br>
Status : OK (31 ms)<br>
Useragent : Cisco/SPA508G-7.5.2<br>
Reg. Contact : <a class="moz-txt-link-abbreviated" href="mailto:sip:660091086@192.168.1.12:5064">sip:660091086@192.168.1.12:5064</a><br>
Qualify Freq : 120000 ms<br>
Keepalive : 0 ms<br>
Sess-Timers : Accept<br>
Sess-Refresh : uas<br>
Sess-Expires : 1800 secs<br>
Min-Sess : 90 secs<br>
RTP Engine : asterisk<br>
Parkinglot : <br>
Use Reason : No<br>
Encryption : No<br>
RTCP Mux : Yes<br>
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">MySQL database table
data :</font></p>
<p><font face="Helvetica, Arial, sans-serif">SELECT name, host, nat,
type, qualify, fullcontact, ipaddr, port, regserver, regseconds,
lastms, defaultuser FROM sip_buddies WHERE
defaultuser='660091086'<br>
+-----------+---------+---------------------+--------+---------+-------------+--------+------+-----------+------------+--------+-------------+<br>
| name | host | nat | type | qualify |
fullcontact | ipaddr | port | regserver | regseconds | lastms |
defaultuser |<br>
+-----------+---------+---------------------+--------+---------+-------------+--------+------+-----------+------------+--------+-------------+<br>
| 660091086 | dynamic | force_rport,comedia | friend | yes
| | | 0 | | 0 | 0
| 660091086 |<br>
+-----------+---------+---------------------+--------+---------+-------------+--------+------+-----------+------------+--------+-------------+<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">According to Asterisk
console, the SIP peer is Registered and qualify (SIP OPTION) is
fine (31 ms).<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">According to Mysql
data, the SIP peer has no "fullcontact", no "ipaddr", no "port"
and 0 (zero) regseconds and 0 (zero) lastms. While I would
expect this to be filled in and/or has values higher than 0
(zero).<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Is there an explanation
for this "difference" in data ?!</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Kind regards</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
</body>
</html>