2006 Nov 28 - Tue
Cisco Syslog Additions
I have updated ciscowatcher.pl and
ciscowatcher.sql.
There are now six tables that are updated from syslog event information:
- ActiveCalls: shows the in progres calls and the interface to which they are assigned
- CallLog: Final Call Leg accounting information
- Counters: keeps track of how many calls are connected (for use in Cricket)
- InterfaceStatus: Tracks link and protocol status on an interface basis (for use in a weathermap)
- OspfStatus: maintains OSPF Neighbor information (for use in a weathermap)
- WirelessAssoc: tracks, by mac address which devices are associated with which AP
[/OpenSource/Debian/Monitoring]
permanent link
SmartQuant QuantDeveloper & DataCenter Release
SmartQuant has released revisions to
DataCenter and
QuantDeveloper. They are at the following revision levels:
DataCenter
Version 2.1.4 (27-Nov-2006)
QuantDeveloper Enterprise Edition
Version 2.3.1 (27-Nov-2006)
QuantDeveloper source code.
Version 2.2.4 (30-Oct-2006)
[/Trading/SmartQuant/Releases]
permanent link
Processing Cisco Syslog Events
First Version: 2006/11/27
Cisco devices generate a number of syslog event types. Common ones include interface
up/down events. From a voice perspective, a number of h.323 call logging events can also be
generated. By default, with PRI lines, a Cisco Voice Gateway will generate an
%ISDN-6-CONNECT event when a call connects and an %ISDN-6-DISCONNECT when the call
disconnects. This information can be used to get an idea of call volume and average call
duration. These events contain number information for the voip side of the peer only.
To fill a table with call detail records and to generate billing records, which have
numbers for both peers, full h.323 connection
call accounting needs to be turned on. The records from this process generate a
%VOIPAAA-5-VOIP_CALL_HISTORY syslog
entry. More details can be found at Cisco's Web Site. In short, add these lines to the gateway to enable
detail records:
!
aaa authentication login default local
aaa accounting connection h323 start-stop group radius
aaa session-id common
!
gw-accounting syslog
!
logging x.x.x.x
!
Here is a ciscowatcher.pl Perl
script. It provides an idea of how to process the syslog entries in real time through a
pipe. This script
will form the primary source of updates to the monitoring server status screens for
calls, interfaces, wireless, and related information in the monitoring server I'm currently
putting together.
The script populates tables in a PostgreSQL database. Here is the ciscowatcher.sql to create the
PostgreSQL tables in a database called oneunified.
[/OpenSource/Debian/Monitoring]
permanent link
|
