Honestly Angelo, I haven't gotten that far yet....was just trying to get auth working.  Logging and accounting are still on the "to do list".
 
If I figure out something I'll let you know!
 
JD


>>> Angelo Compagnucci <angelo.compagnucci@gmail.com> 9/26/2011 2:43 PM >>>
A month ago,I had to read the source code to understand why the group membership was disabled in my configuration!

I'm using odbc also with mssql!

How have you resolved theunix_timestamp issue? I had to rewrite queries converting theunix_timestamp to something like CONVERT(datetime, '%S', 20) to accomodate my db.

Angelo

2011/9/26 John Dunning <jodunni1@wsc.edu>
Angelo - that was it!! Thanks so much.
Just a note to the maintainers....I used the dialup.conf from the 2.1.10 source. The debian packages don't have a dialup.conf for mssql, so I used the 2.1.10 source mssql directory and created a logical link for iodbc.
It was, evidently, fixed in 2.1.11 as the one from that version has the query.
Thanks all!!
JD


>>> Angelo Compagnucci <angelo.compagnucci@gmail.com> 9/26/2011 12:46 PM >>>

Hi John,

Your sql configuration lacks of group_membership_query .

Whitout this one, group checking is disabled silently during start up.

Hope this helps!

Angelo

2011/9/26 John Dunning <jodunni1@wsc.edu>

Arran,

Yea - I did give that a try. I'm not sure if fall-through appears in the reply list at the end of the transaction like the other attributes do, but it didn't show up, nor did the group attributes show up.
JD

Re: rlm_sql not checking radgroupreply

I have the read_groups setting set to "yes" in sql.conf and the debug log would make it appear that it's reading it in correctly. The mac is found in radcheck and any attributes in radreply are correctly returned, but rlm_sql never checks for any group memberships at all. I've done a trace on the sql server and it confirms what I see in the debug log from radius - it just never checks.
Thoughts?

Weird... Have you tried setting Fall-Through := yes in radcheck... In theory you shouldn't need to, but just to see if it works.

-Arran

Arran Cudbard-Bell
a.cudbardb@freeradius.org

Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !

This archive was generated by a fusion of Pipermail (Mailman edition) and MHonArc.

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



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