Number of port users logged in - 2.1-RELEASE

Gertjan

Code: [Select]
php -q captiveportal_count_online_users.php
Does it return a number like 0 or more, or the same error.
php -q cptotaluser
It gives me the right number of the connection of my captive portal.

Thus, the script works.

Btw :

				if (array_key_exists('enable', $config['captiveportal'][$cpkey])) {

is already checking IF the captive portal instance is running.

Double check if your are running the script as super user (= 'root')

myke

Btw :

				if (array_key_exists('enable', $config['captiveportal'][$cpkey])) {

is already checking IF the captive portal instance is running.

Double check if your are running the script as super user (= 'root')

i add "echo $USER" on the script :

zabbix_get -s "Wan" -p 10050 -k CP_users
root
Fatal error: Class 'SQLite3' not found in /etc/inc/captiveportal.inc on line 1454
PHP ERROR: Type: 1, File: /etc/inc/captiveportal.inc, Line: 1454, Message: Class 'SQLite3' not found
root

so you can see the script is running with the user root.

Gertjan

@myke:

PHP ERROR: Type: 1, File: /etc/inc/captiveportal.inc, Line: 1454, Message: Class 'SQLite3' not found

Was reading this message again - and this time in the afternoon, so this time the caffeine worked.
The errors is "Class 'SQLite3' not found" which is (should be) part of the PHP install on pfSense.

Visit this page : https://your-pfsense-box/phpinfo.php
Does it have a section that says "sqlite3" is included ?

Also : when using a navigator, php is using this php.ini file : /usr/local/etc/php.ini
When using the CLI, it 'could' be another one - check that.
Run :

php -q /usr/local/www/phpinfo.php | grep 'sqlite'

Does it say:

PDO drivers => sqlite
pdo_sqlite
sqlite3
sqlite3.extension_dir => no value => no value

It looks like you haven't the same version of pfSEnse as I do … (which is, of course, the latest 'stable' version)

edit : or whatever what could explain why the sqlite3 php extension isn't avaible.

doktornotor

That extension hasn't been there for a while. Use /usr/local/bin/sqlite3 instead.

Gertjan

@doktornotor:

That extension hasn't been there for a while. Use /usr/local/bin/sqlite3 instead.

According to : /usr/local/etc/php/extensions.ini :

[2.3.2-RELEASE][admin@pfsense.brit-hotel-fumel.net]/root: cat /usr/local/etc/php/extensions.ini
....
extension=pdo_sqlite.so
.....
extension=sqlite3.so

I have a clean

2.3.2-RELEASE-p1 (amd64)
built on Tue Sep 27 12:13:07 CDT 2016
FreeBSD 10.3-RELEASE-p9

install.
I do have

/usr/local/bin/sqlite3

But : does /etc/inc/captiveportal.inc use the 'extension' or the external binary ? If the external binary was used, I should have found a proof in the code.

myke

Hello Gentleman,

Visit this page : https://your-pfsense-box/phpinfo.php
Does it have a section that says "sqlite3" is included ?

I have an error : 404 Not Found so i can't tell you.

And

php -q /usr/local/www/phpinfo.php

I don't have any phpinfo.php on my whole pfsense…

Why the library missed when i used my zabbix server to launch the script on pfsense. and it's perfectly working on pfsense :-(

Gertjan

@myke:

Hello Gentleman,

Visit this page : https://your-pfsense-box/phpinfo.php
Does it have a section that says "sqlite3" is included ?

I have an error : 404 Not Found so i can't tell you.

And

php -q /usr/local/www/phpinfo.php

I don't have any phpinfo.php on my whole pfsense…

Stupid me.
Create a file called "phpinfo.php" in /usr/local/www/
an put this into it :

phpinfo();
?>

@myke:

Why the library missed when i used my zabbix server to launch the script on pfsense. and it's perfectly working on pfsense :-(

Dono.
I'm using a "munin plugin" like this :


#!/bin/sh
#
# Plugin to monitor the number of captive portal users. 
#
# Parameters:
#
# 	config   (required)
# 	autoconf (optional - used by munin-config)
#
# Magick markers (optional - used by munin-config and som installation
# scripts):
#%# family=auto
#%# capabilities=autoconf

if [ "$1" = "autoconf" ]; then
	echo yes 
	exit 0
fi

if [ "$1" = "config" ]; then

	echo 'graph_title Captive Portal Users'
	echo 'graph_args --base 1000 -l 0 '
	echo 'graph_vlabel Number of users'
	echo 'graph_category portalusers'
	echo 'graph_info This graph shows the number of portal users on the system.'
	echo 'portalusers.label users'
	echo 'portalusers.info The current number of users.'
	echo 'portalusers.draw LINE2'
	exit 0
fi

echo -n "portalusers.value "
/usr/local/bin/php -q /root/captiveportal_count_online_users.php

and it works well.

myke

I just test with the new release of pfSense 2.3.3 and the script worked.
hallelujah :-)

Thanks for the help by the way :)

Best regards
Myke

skron

Thanks, this still works (2.3.4)

I implemented it differently, but using your script. I uploaded the script in the captive portal and my cacti-install gets the value via https from https://pfsensehost:8003/captiveportal-cpcount.php and graphs the output… works great! Finally CP count monitored.

An OID for SNMP would be great though.

graph_image.png_thumb

nilux17

Hello, here is my version of the script :

<?php
	require_once("/etc/inc/util.inc");
	require_once("/etc/inc/functions.inc");
	require_once("/etc/inc/captiveportal.inc");

	/* read in captive portal db */
	/* determine number of logged in users */
	$count_cpusers = 0;
	/* Is portal activated ? */
	if (is_array($config['captiveportal'])) {
		//only one zone
		if(isset($_GET["cpzone"])){
			$cpzone=$_GET["cpzone"];
			$count_cpusers = count(captiveportal_read_db());
		}
		else {

			/* For every zone, do */
			foreach ($config['captiveportal'] as $cpkey => $cp) {
				/* Sanity check */
				if (is_array($config['captiveportal'][$cpkey])) 
					/* Is zone enabled ? */
					if (array_key_exists('enable', $config['captiveportal'][$cpkey])) {
						$cpzone = $cpkey;
						/* Zone selected -> count users and add */
						$count_cpusers += count(captiveportal_read_db());
					}
			}
		}
	}

	echo $count_cpusers;
?>

Here is how i check it with centreon :

#!/bin/bash
url=$1
libelle=$2
warningvalue=$3
criticalvalue=$4

if [ $# -eq '4' ]	
	then

        #get the value
	value=$(curl -sk $url)

        # UNKNOWN
         if [ -z "$value" ]
         then
                echo "UNKNOWN - unable to establish the value returned"
                exit 3

        # OK
         elif [ $value -lt $warningvalue ]
	 then
		echo "OK  - $value $libelle| value=$value"
		exit 0

        # WARNING
         elif [ $value -gt $warningvalue ] && [ $value -lt $criticalvalue ]
	 then
		echo "WARNING - $value $libelle| value=$value"
		exit 1

	#CRITICAL
	 else
	 	echo "CRITICAL - $value $libelle| value=$value"
		exit 2
         fi


else
	echo "Usage $0 url \"description of the value\" warningvalue criticalvalue"
	exit 1

fi

this script is used like this :

check_http_value https://10.11.0.1:8005/captiveportal-count-online-users.php?cpzone=captive_portal_r "users connected" 150 200
OK  - 127 users connected| value=127

maybe it is possible to improve this with using the $HOSTADRESS$...

and here is the final result in centreon :