Alan DeKok <[EMAIL PROTECTED]> wrote:
> No... the "radcheck" table contains information that tells the
> server how to check authentication for the user.
> No... the "radcheck" table contains information that tells the
> server how to check authentication for the user.
Ok.
> sql.conf clearly shows that the only authenticating logging query is
> the post-auth one. It also clearly shows that the authcheck_table
> compares the check items for the user.
Clearly... As I said in my first email. There are no insert statements that coincide to what I am looking for and thus my original question about crafting my own sql statements. Moving on... I will break this down simply so that we do not drift. The data i need is being logged to the log file:
$prefix/var/log/radius/radacct/<source_ip>/auth-detail-yyyymmdd
with contents:
Packet-Type = Access-Request
Sat Mar 5 15:04:02 2005
User-Name = "user"
User-Password = "password"
NAS-IP-Address = 1.2.3.4
Client-IP-Address = 1.3.4.5
Sat Mar 5 15:04:02 2005
User-Name = "user"
User-Password = "password"
NAS-IP-Address = 1.2.3.4
Client-IP-Address = 1.3.4.5
Module-Failure-Message = "rlm_ldap: User not found"
_I would like this information logged to sql instead, how do I do that?_
> This is all documented in the comments in the file.
_I would like this information logged to sql instead, how do I do that?_
> This is all documented in the comments in the file.
Sure it is...
> The your NAS isn't sending accounting requests to the server. See the FAQ.
> The your NAS isn't sending accounting requests to the server. See the FAQ.
The information is already at my disposal, hence the log file. I dont want to rely on the NAS to send the request or have to manage that in any way. Can I force the logging to SQL? I want to log ALL authentication requests to SQL, this seems like a pretty primitive feature. Thanks for the help.
Kris
