Difference In Information Realtime Database Table And Asterisk Sip Show Peers
Hello
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 ?
Using : asterisk-certified-13.21-cert6
Asterisk console data :
/usr/sbin/asterisk -rx ‘sip show peers’ | grep 660091086
660091086/660091086 11.22.33.44 D Yes Yes
55018 OK (31 ms) Cached RT
/usr/sbin/asterisk -rx ‘sip show peer 660091086’
* Name : 660091086
Description :
Realtime peer: Yes, cached
Secret :
…. …. …. ….
DTMFmode : rfc2833
Timer T1 : 500
Timer B : 32000
ToHost :
Addr->IP : 11.22.33.44:55018
Defaddr->IP : (null)
Prim.Transp. : UDP
Allowed.Trsp : UDP
Def. Username: 660091086
SIP Options : (none)
Codecs : (alaw|g729|gsm)
Auto-Framing : No
Status : OK (31 ms)
Useragent : Cisco/SPA508G-7.5.2
Reg. Contact : sip:660091086@192.168.1.12:5064
Qualify Freq : 120000 ms
Keepalive : 0 ms
Sess-Timers : Accept
Sess-Refresh : uas
Sess-Expires : 1800 secs
Min-Sess : 90 secs
RTP Engine : asterisk
Parkinglot :
Use Reason : No
Encryption : No
RTCP Mux : Yes
MySQL database table data :
SELECT name, host, nat, type, qualify, fullcontact, ipaddr, port, regserver, regseconds, lastms, defaultuser FROM sip_buddies WHERE
defaultuser=’660091086′
+———–+———+———————+——–+———+————-+——–+——+———–+————+——–+————-+
| name | host | nat | type | qualify |
fullcontact | ipaddr | port | regserver | regseconds | lastms |
defaultuser |
+———–+———+———————+——–+———+————-+——–+——+———–+————+——–+————-+
| 660091086 | dynamic | force_rport,comedia | friend | yes |
| | 0 | | 0 | 0 | 660091086 |
+———–+———+———————+——–+———+————-+——–+——+———–+————+——–+————-+
According to Asterisk console, the SIP peer is Registered and qualify
(SIP OPTION) is fine (31 ms).
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).
Is there an explanation for this “difference” in data ?!
Kind regards