Added cleanup functionality to remove old user data if the user no longer exists

When enabled mod_feature_validity will now check if the time since first successful connect until now is more than the allowed value set using the SMRadius-Validity-ValidWindow attribute.

Make sure we standardize how the database columns are cased. The only
real impact of this change is userdb.id becomes userdb.ID as this was
the only variable affected.

mysql> select * from users_data;
+----+--------+-------------+-------------------------------------------------+--------------+
| ID | UserID | LastUpdated | Name                                            | Value        |
+----+--------+-------------+-------------------------------------------------+--------------+
| 25 |      1 |  1301180792 | global/FirstLogin                               | 1301180792   |
+----+--------+-------------+-------------------------------------------------+--------------+
1 row in set (0.00 sec)

This module create the following users_data entries...
mysql> select * from users_data;
+----+--------+-------------+-------------------------------------------------+--------------+
| ID | UserID | LastUpdated | Name                                            | Value        |
+----+--------+-------------+-------------------------------------------------+--------------+
| 26 |      1 |  1301181002 | mod_feature_user_stats/CurrentMonthTotalTraffic | 1            |
| 27 |      1 |  1301181002 | mod_feature_user_stats/CurrentMonthTotalUptime  | 244          |
| 28 |      1 |  1301181002 | mod_feature_user_stats/NAS-Identifier           | Neemo        |
| 29 |      1 |  1301181002 | mod_feature_user_stats/Framed-IP-Address        | 192.168.0.99 |
+----+--------+-------------+-------------------------------------------------+--------------+
4 rows in set (0.00 sec)

Added to config file

Fixed bug in config file regarding users_data query

- Better describe functions
- Formatting fixups
- Use better cached variable names
- Fixed bug where wrong cached time variable was being used
- Set cache dataset name to something more meaningful
- Database column names are lowercase not upper case , this must be fixed though

Better support for globally unique user data caching.

Robert Anderson authored 14 years ago and Nigel Kukard committed 13 years ago

Added new data_set() and data_get() userdb functions for setting and fetching user data. New table users_data stores user data as Name => Value. Updated UPGRADING file with upgrading instructions.

This allows us to easily use the userdb module used to grab the user
in other places.

Use correct 'server' path for timezone config

Updated for 2011 when displaying help for running smradiusd

Added and corrected copyright dates

Display timers only if we have log level greater than NOTICE (so we display for LOG_INFO)

Fixed incorret calculation, we forgot a timer to add into the mix

The actual enabling config line should be below a default which disables

Updated users-accounting-summary.tsql to use @PREFIX@ instead of @TP@
Removed accounting summary plugin from config file, users can optionally include it

Robert Anderson authored 14 years ago and Nigel Kukard committed 14 years ago

Use integer instead of string when using Math::BigInt
Fixed comment for post accounting hook

Configurable caching of the getUsage function added

Removed the included use mod_accounting_sql as it isn't needed

Added accounting stats plugin and support through extra columns in the users table and a config section in the config file

Added defined checks as limits are set instead of checking later on
Removed the inclusion of Date::Parse in this module

Improved readability and structure of code
More descriptive comments

Fixed spelling mistakes

Updated and added license information to reflect 2011

Added better runfile ownership and security. pid & cache file
are now stored in /var/run/smradius by default and the log file
is stored in /var/log/smradius by default . user= and group=
will apply to both of these now.

Added support for abuse prevention using the below configuration item
[radius]
use_abuse_prevention=yes

Moved use_packet_timestamp from [server] to [radius]

Added additional profiling informaion to logging messages

If ->log is given additional arguments, the $msg will be used as
a format, and all additional arguments will be used as parameters
to sprintf()