Re: nas table in SQL backend

2006-03-08 Thread trs
How is it used? Can I modify it (e.g., add columns, change the primary key, etc.) to better suit my environment? On 3/8/06, Alan DeKok <[EMAIL PROTECTED]> wrote: > trs <[EMAIL PROTECTED]> wrote: > > The SQL scripts have a comment for the nas table that says it isn't

nas table in SQL backend

2006-03-08 Thread trs
The SQL scripts have a comment for the nas table that says it isn't used by freeradius. Is this still the case? How is it populated otherwise? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: SQL Accounting and Null Attribute Values

2006-03-02 Thread trs
res driver. Lesson learned. I'll be a bit more attentive next time. Thanks again. On 3/2/06, Peter Nixon <[EMAIL PROTECTED]> wrote: > On Thu 02 Mar 2006 08:39, trs wrote: > > Accounting queries fail if an attribute is null when supplied as a > > value for certain colum

SQL Accounting and Null Attribute Values

2006-03-01 Thread trs
Accounting queries fail if an attribute is null when supplied as a value for certain column types. Partial line from debug output: radius_xlat: 'UPDATE radacct SET AcctStartTime = '2006-03-02 01:18:04', AcctStartDelay = '', It fails with: rlm_sql (sql): Couldn't update SQL accounting START recor

VSA Accounting

2006-03-01 Thread trs
How does one refer to VSAs in the accounting queries in sql.conf? I figure it would just be the name of the attribute from the dictionary, but what if there's a VSA name the conflicts with a standard name (e.g. "Realm")? Is there a prefix that can be used to differenciate them? Also, what's a bet