RE: All attributes in rlm_sql_log or rlm_sql ?

2008-04-12 Thread Dean Smith
Ultimately for the same reasons that rlm_detail exists. I'd like to give my ops guys the ability to see all attributes in requests and replies when they're debugging or monitoring. We want to maintain all records in a single SQL database with access via our existing web frontends...so I'd like the

Re: All attributes in rlm_sql_log or rlm_sql ?

2008-04-12 Thread Alan DeKok
Dean Smith wrote: Ultimately for the same reasons that rlm_detail exists. I'd like to give my ops guys the ability to see all attributes in requests and replies when they're debugging or monitoring. We want to maintain all records in a single SQL database with access via our existing web

Re: All attributes in rlm_sql_log or rlm_sql ?

2008-04-11 Thread A . L . M . Buxey
Hi, Is there a way of using either rlm_sql_log or the post-auth query within rlm_sql to log all the request and/or reply attributes to mysql ? as part of our PERL bit of handling we spew out all of the attributes to a debug log when we want ('if file exists' logic to turn it off and on) you

RE: All attributes in rlm_sql_log or rlm_sql ?

2008-04-10 Thread Dean Smith
From: Dean Smith [mailto:[EMAIL PROTECTED] Sent: 10 April 2008 00:14 To: 'freeradius-users@lists.freeradius.org' Subject: All attributes in rlm_sql_log or rlm_sql ? Is there a way of using either rlm_sql_log or the post-auth query within rlm_sql to log all the request and/or reply attributes

Re: All attributes in rlm_sql_log or rlm_sql ?

2008-04-10 Thread Alan DeKok
Dean Smith wrote: I guess I’m asking is there an unlang equivalent to this snippet from rlm_detail.c. .. No. I don't see why it makes sense to log all of the attributes as one big line of text in SQL. If you need that, it shouldn't be hard to write a Perl plugin that does it. Alan

All attributes in rlm_sql_log or rlm_sql ?

2008-04-09 Thread Dean Smith
Is there a way of using either rlm_sql_log or the post-auth query within rlm_sql to log all the request and/or reply attributes to mysql ? E.g. I could populate one SQL field with a string of the whole packet (just as you would see in the detail log). I would still add my key attributes to