Hello Aaron -
On Wed, 07 Jun 2000, Aaron Holtz wrote:
> 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.
>
I agree with you - %N should always work.
Could you try doing something other than a LogSQL to see whether the special
variables work elsewhere?
thanks
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.