I'm setting up a custom LogQuery for my Log SQL function and it appears
that not all the % variables are getting expanded like I would expect
that they should. Here is my config:
<Log SQL>
Table radlog
LogQuery insert into radlog values (%t, '%N', '%h', $p, $s)
include %D/connections/logsql.remote.connection
Trace 3
</Log>
Here is a snippet of the output:
*** Received from 205.212.1.1 port 1187 ....
Code: Access-Request
Identifier: 140
Authentic: 1234567890123456
Attributes:
User-Name = "primus"
Service-Type = Framed-User
NAS-IP-Address = 205.212.1.1
NAS-Port = 1234
NAS-Port-Type = Async
Framed-IP-Address = 255.255.255.254
Password =
"<164>R<196><236>p<150><219><214>Q{<156><237><156><187><234><229>"
Fri Jun 2 12:56:58 2000: DEBUG: do query is: insert into radlog values
(959965018, '', 'radiator.comnetohio.com', 3, 'Access for \'primus\'
rejected: Bad Encrypted password')
%N should have no problem being expanded as there is a NAS-IP-Address
attribute. Some other attributes don't show up either (%n, %U to name
two.) I'm using radpwtst -gui to send this access packet. Not sure why
these aren't getting expanded like they should. It's as if the contents
of the packet are the ones that don't get expanded, just those variables
that are internal to the program (like the DbDir and hostname, etc.) I
didn't see any docs on using LogQuery or caveats so maybe I'm missing
something here. Thanks.
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
