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

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.

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

Robert Anderson authored 14 years ago and Nigel Kukard committed 14 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.

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

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

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

Enable the use of the disabled parameter for admin user and group attributes in the webgui. Allow smradiusd to select enabled attributes.

Indexed PeriodKey column

Check if user is disabled

Pass datetime as text to DBSelect
Selected topups ValidFrom must equal the first of the current month

* Modified NAS-Port-Id to use a blank default if not defined (in the case of vpn's)

Added UPGRADING file for upgrading information from previous revision

Added default config get
Added client config get

Added mod_config_sql_topups queries to config

* Make userdb macros entirely dynamic

* Use  request.  and not  authentication. as macros

* Fixed incorrect configuration, we need to load the config module for system, not the userdb module

Added initial support for realms and realm attributes

* Added template queries to the smradiusd.conf file

* Added authentication mechanisms & users config section