This is already in RadiusNT 2.2. A peak from the manual, although its
You can enabled ODBC logging to allow RadiusNT to log information to the
This information can be very useful in debugging or problem solving.
You can also
do reporting and gather statistics to find out any possible problems
The log table, described above, is very simply. The main field is the
field, which tells what the error is. If the error has a user
associated with it,
the username will be stored in the username field. Lastly, the data
information, which is specific to the type of log message. For example,
a type 0
generic message or type 1 generic error will have a description of what
it is in
the data field (and typically the username field is blank). However,
for a type 4
message of bad password, the username field will be the username entered
data field will be the password the user entered.
Below is a list and description of the RadLogMsgIDs:
RadLogMsgID Log Message Description
0 Generic Log Message This is a generic log message which does not a
pre-defined RadLogMsgID. This will be informational only, and is
not an error.
1 Generic Error Message This is a generic error message which does not a
pre-defined RadLogMsgID. This is typically a recoverable error.
10 User Not Found The username was not found in the database.
11 Bad Password The username was found in the database, but the password
12 Expired Account The userís account is expired.
13 Overdue Account The userís account is overdue (Balance is larger than
14 Concurrency Limit The user is already logged in the maximum allowed
15 Time Limit The user does not have any time left to use.
19 No Service Defaults The userís service does not have any defined
and the service type does not have any defined RADIUS attributes.
50 Unauthorized Requst A RADIUS request was received from a RADIUS
client who is not authorized to send requests.
51 No Username A RADIUS request did not have a username attribute.
52 No Password A RADIUS request did not have a password attribute.
53 Digest Mismatch A RADIUS request did not have a correct digest. This
is typically because the secret
used by the NAS does not match the secret RadiusNT has for the NAS.
60 Parse Error The data RadiusNT was trying to parse was in error.
100 CHAP not allowed The user authenticate using CHAP, but the userís
Password is "UNIX" or "WINNT".
For these two cases, the user must use PAP.
The table is:
RadLogMsgID integer Related Log Message Identifier from RadLogMsgs
LogDate datetime The date of the message
UserName varchar(32) The associated username (if one exists)
Data varchar(50) Additional data, dependent on the Log Message ID
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com