[asterisk-bugs] [Asterisk 0016112]: [patch] SIP Realtime not reading database for changes to realtime peers after initial registration
Asterisk Bug Tracker
noreply at bugs.digium.com
Wed Nov 11 14:48:43 CST 2009
A NOTE has been added to this issue.
======================================================================
https://issues.asterisk.org/view.php?id=16112
======================================================================
Reported By: ajohnson
Assigned To:
======================================================================
Project: Asterisk
Issue ID: 16112
Category: Channels/chan_sip/General
Reproducibility: always
Severity: block
Priority: normal
Status: confirmed
Target Version: 1.6.0.19
Asterisk Version: 1.6.2.0-rc3
JIRA: SWP-290
Regression: No
Reviewboard Link:
SVN Branch (only for SVN checkouts, not tarball releases): N/A
SVN Revision (number only!):
Request Review:
======================================================================
Date Submitted: 2009-10-21 21:14 CDT
Last Modified: 2009-11-11 14:48 CST
======================================================================
Summary: [patch] SIP Realtime not reading database for
changes to realtime peers after initial registration
Description:
After a realtime sip peer has registered, changes to the sip_peers table
for the related peer will never be picked up by Asterisk. In my test I
changed the context from from-test to from-softphone. The change was not
picked up until after restarting asterisk.
Sip.conf has rtcachefriends=no set.
SELECT * FROM sip_peers WHERE name = 'ajohnson'
5797, 'ajohnson', 'dynamic', 'no', 'friend', '', '', , '', '8448', 'yes',
'yes', 'from-test', '', '', '', '', '', '', '', '', '', '', '', '', '',
'no', '', '', '', '', '97983', '', 'all', 'all', '', '10.210.20.192', 5060,
'pbx2', 1256176828, 'ajohnson', '', 0, 'SJphone/1.65.377a (SJ Labs)'
-- Registered SIP 'ajohnson' at 10.210.20.192 port 5060
== Using SIP RTP CoS mark 5
-- Executing [6027414660 at from-test:1] Dial("SIP/ajohnson-b757d498",
"SIP/sbc/6027414660)") in new stack
== Using SIP RTP CoS mark 5
-- Called sbc/6027414660)
== Spawn extension (from-test, 6027414660, 1) exited non-zero on
'SIP/ajohnson-b757d498'
== Using SIP RTP CoS mark 5
-- Executing [6027414660 at from-test:1] Dial("SIP/ajohnson-b7589b98",
"SIP/sbc/6027414660)") in new stack
== Using SIP RTP CoS mark 5
-- Called sbc/6027414660)
== Spawn extension (from-test, 6027414660, 1) exited non-zero on
'SIP/ajohnson-b7589b98'
SELECT * FROM sip_peers WHERE name = 'ajohnson'
5797, 'ajohnson', 'dynamic', 'no', 'friend', '', '', , '', '8448', 'yes',
'yes', 'from-softphone', '', '', '', '', '', '', '', '', '', '', '', '',
'', 'no', '', '', '', '', '97983', '', 'all', 'all', '', '10.210.20.192',
5060, 'pbx2', 1256176828, 'ajohnson', '', 0, 'SJphone/1.65.377a (SJ Labs)'
pbx2*CLI> sip reload
Reloading SIP
== Parsing '/etc/asterisk/sip.conf': == Found
== Parsing '/etc/asterisk/sipaccounts.conf': == Found
== Parsing '/etc/asterisk/users.conf': == Found
== Parsing '/etc/asterisk/sip_notify.conf': == Found
== Using SIP RTP CoS mark 5
-- Executing [6027414660 at from-test:1] Dial("SIP/ajohnson-b7589098",
"SIP/sbc/6027414660)") in new stack
== Using SIP RTP CoS mark 5
-- Called sbc/6027414660)
== Spawn extension (from-test, 6027414660, 1) exited non-zero on
'SIP/ajohnson-b7589098'
pbx2*CLI> sip prune realtime
peer all
pbx2*CLI> sip prune realtime all
No peers found to prune.
== Using SIP RTP CoS mark 5
-- Executing [6027414660 at from-test:1] Dial("SIP/ajohnson-b758da30",
"SIP/sbc/6027414660)") in new stack
== Using SIP RTP CoS mark 5
-- Called sbc/6027414660)
== Spawn extension (from-test, 6027414660, 1) exited non-zero on
'SIP/ajohnson-b758da30'
pbx2*CLI> module reload chan_sip.so
-- Reloading module 'chan_sip.so' (Session Initiation Protocol (SIP))
Reloading SIP
== Parsing '/etc/asterisk/sip.conf': == Found
== Parsing '/etc/asterisk/sipaccounts.conf': == Found
== Parsing '/etc/asterisk/users.conf': == Found
== Parsing '/etc/asterisk/sip_notify.conf': == Found
== Using SIP RTP CoS mark 5
-- Executing [6027414660 at from-test:1] Dial("SIP/ajohnson-b780f5c0",
"SIP/sbc/6027414660)") in new stack
== Using SIP RTP CoS mark 5
-- Called sbc/6027414660)
== Spawn extension (from-test, 6027414660, 1) exited non-zero on
'SIP/ajohnson-b780f5c0'
pbx2*CLI> sip show peers
Name/username Host Dyn Nat ACL Port Status
Realtime
corppbx 10.210.10.76 5060 OK (1 ms)
inbound/inbound (Unspecified) D 5060 UNKNOWN
outbound/outbound (Unspecified) D 5060 UNKNOWN
pvpbx 10.208.8.25 5060 OK (1 ms)
pvutil 10.200.10.51 5060 OK (1 ms)
sbc 10.230.10.90 5060 OK (1 ms)
6 sip peers [Monitored: 4 online, 2 offline Unmonitored: 0 online, 0
offline]
pbx2*CLI>
======================================================================
----------------------------------------------------------------------
(0113678) ajohnson (reporter) - 2009-11-11 14:48
https://issues.asterisk.org/view.php?id=16112#c113678
----------------------------------------------------------------------
The newly uploaded create statement does not experience the error. The
breakage appears to be related to either my table structure or the name of
the table.
Issue History
Date Modified Username Field Change
======================================================================
2009-11-11 14:48 ajohnson Note Added: 0113678
======================================================================
More information about the asterisk-bugs
mailing list