Re: SQL Accounting and Null Attribute Values

2006-03-02 Thread trs
Thanks Peter. It seems I'm using the wrong sql.conf :/. I'm using postgres, and while setting this up I thought the postgresql.conf file was included in the sql.conf for stuff specific to postgres. So instead of using that for sql.conf, I modified the default sql.conf to use the postgres driver.

Re: SQL Accounting and Null Attribute Values

2006-03-02 Thread Peter Nixon
You're welcome. Given that MySQL speaks a fairly basic dialect of (mostly) ANSI SQL sql.conf should actually work with most different brands of SQL servers. Using posgresql.conf will give you some Posgres specific optimisations though. Cheers Peter On Thu 02 Mar 2006 20:36, trs wrote: Thanks

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

Re: SQL Accounting and Null Attribute Values

2006-03-01 Thread Peter Nixon
On Thu 02 Mar 2006 08:39, trs wrote: 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