Re: SQL Logging Access-Reject

2010-09-10 Thread Alan DeKok 
Kristoffer Milligan wrote:
> I'm still working on my FreeRADIUS server in connection with 4Motion
> equipment from Alvarion. It's getting better and better and more
> integrated, but I still have a few quirks I need to work out.
> 
> My main problem now is the logging part. In the post-auth section, I
> have added some SQL logging. I am logging Access-Accept and
> Access-Reject. My problem is that access-rejects are appearing
> scrambeled.. Example:
...
> How can I log the tried username in cleartext?

  Find out where the username exists in cleartext, and use that.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

SQL Logging Access-Reject

2010-09-10 Thread Kristoffer Milligan 

Hello again list,

I'm still working on my FreeRADIUS server in connection with 4Motion 
equipment from Alvarion. It's getting better and better and more 
integrated, but I still have a few quirks I need to work out.


My main problem now is the logging part. In the post-auth section, I 
have added some SQL logging. I am logging Access-Accept and 
Access-Reject. My problem is that access-rejects are appearing 
scrambeled.. Example:


| 50 | us...@mydomain.tld  |  | 
Access-Accept | 2010-09-10 10:53:36 |
| 51 | =7bam=3d1=7d917341235f4283123a58e52b623d2...@mydomain.tld |  
| Access-Reject | 2010-09-10 10:53:39 |
| 52 | =7bam=3d1=7ac00fa703f004q25ed1ef4e3dcb5f4...@mydomain.tld |  
| Access-Reject | 2010-09-10 10:53:47 |
| 53 | us...@mydomain.tld|  
| Access-Accept | 2010-09-10 10:53:58 |


The SQL statement from sql_log module is:

Post-Auth = "INSERT INTO ${postauth_table}   \
 (username, pass, reply, authdate) VALUES\
 ('%{SQL-User-Name}', '%{User-Password:-Chap-Password}', \
 '%{reply:Packet-Type}', '%S');"


How can I log the tried username in cleartext?

- Kristoffer Milligan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html