Skip to content

Check starface-database-stats

Overview

Reports database connection statistics of a Starface PBX, including opened, closed, active, and idle connections.

Important Notes:

Data Collection:

  • Connects via socket to the Starface Monitoring Module on port 6556
  • Supports both IPv4 (default) and IPv6
  • Fetched data is cached for up to one minute in a shared SQLite database, so that multiple Starface checks running in parallel do not overload the PBX

Fact Sheet

Fact Value
Check Plugin Download https://github.com/Linuxfabrik/monitoring-plugins/tree/main/check-plugins/starface-database-stats
Nagios/Icinga Check Name check_starface_database_stats
Check Interval Recommendation Every minute
Can be called without parameters Yes
Runs on Cross-platform
Compiled for Windows No
Requirements Monitoring module for Starface PBX
Uses SQLite DBs $TEMP/linuxfabrik-monitoring-plugins-starface.db

Help

usage: starface-database-stats [-h] [-V] [--cache-expire CACHE_EXPIRE]
                               [-H HOSTNAME] [--port PORT] [--test TEST]
                               [--timeout TIMEOUT] [--ipv6]

Monitors database connection statistics of a Starface PBX via its monitoring
module on port 6556. Reports active, idle, and total connections. Supports
both IPv4 and IPv6. Data is cached to avoid overloading the PBX when multiple
checks run in parallel. Alerts when connection usage exceeds the configured
thresholds.

options:
  -h, --help            show this help message and exit
  -V, --version         show program's version number and exit
  --cache-expire CACHE_EXPIRE
                        The amount of time after which the credential/data
                        cache expires, in minutes. Default: 1
  -H, --hostname HOSTNAME
                        Starface PBX hostname or IP address. Default:
                        localhost
  --port PORT           Starface PBX monitoring port. Default: 6556
  --test TEST           For unit tests. Needs "path-to-stdout-file,path-to-
                        stderr-file,expected-retc".
  --timeout TIMEOUT     Network timeout in seconds. Default: 8 (seconds)
  --ipv6                Use IPv6.

Usage Examples

./starface-database-stats --cache-expire 1 --hostname mypbx --port 6556 --timeout 3

Output:

Connections: 26.7M opened, 26.7M closed, 19.0 active, 0.0 idle

States

  • Always returns OK.

Perfdata / Metrics

Name Type Description
active_connections Number Number of currently active database connections
closed_connections Continuous Counter Total number of closed database connections
idle_connections Number Number of currently idle database connections
opened_connections Continuous Counter Total number of opened database connections

Credits, License