Re: Logging to database?

Zak Wolfinger ( (no email) )
Thu, 23 Apr 1998 13:50:40 -0500

The RadLogs table contains errors or denials. Are you
expected
something else in it? Your example was just accounting. You
can
use radlogin to create a failed auth attempt and see if
logged.
==================================================

OK, I was confused. I was thinking that it would be like
the detail file, not like the log file. My mistake.
However I tried doing a login with an incorrect password (by
dialing into the NAS, not using RadLogin) and it doesn't
show up in EITHER the logfile nor the RadLog table. Here is
the output:

radrecv: Request from host d0d10541 code=1, id=62,
length=105
User-Name = "wolfman"
Password =
"\243:\352\310w\213\350\233\203\346\024\311K\35589"
NAS-Identifier = 208.209.5.65
NAS-Port = 10
NAS-Port-Type = Async
Connect-Info = "14400 LAPM/V42BIS"
NAS-Port-DNIS = "6754200"
Caller-Id = "2192351599"
rad_authenticate_ODBC()
Password =
"\243:\352\310w\213\350\233\203\346\024\311K\35589"

SQL Statement: Select DateAdd('d', ma.extension,
maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType,
sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where
(sa.Login='wolfman' or sa
..Shell='wolfman') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and ma.Active
<>0

Decrypted Password: fred
Database Password: ilpww
Not Found in ODBC, Checking users file...
rad_authenticate()
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is **REMOVED**
decrypted pwd is fred
Sending Reject of id 62 to d0d10541 (OCPM3-1)

Resp Time: 2083 Auth: 0/6 -> 6 Acct: 7/0/0 -> 7

Zak