rlm_sql: "NUMERIC VALUE OUT OF RANGE" error

[Andrew Thrift]

Thanks Fajar,

I actually figured this out 10 minutes after posting to the list, blue 
text on black terminal window  :(


Thanks for your response.




Regards,




Andrew

On 7/07/2011 3:52 p.m., Fajar A. Nugraha wrote:
> On Thu, Jul 7, 2011 at 10:09 AM, ahthrift<andyonfire at gmail.com>  wrote:
>> I too am experiencing this issue with FreeRadius 2.1.10 and Postgres.
>> I cannot figure out how to modify the query that is executed for this, I
> Did you read the file sql.conf?
>
> ######################################################################
> #
> #  Configuration for the SQL module
> #
> #  The database schemas and queries are located in subdirectories:
> #
> #       sql/DB/schema.sql       Schema
> #       sql/DB/dialup.conf      Basic dialup (including policy) queries
> #       sql/DB/counter.conf     counter
> #       sql/DB/ippool.conf      IP Pools in SQL
> #       sql/DB/ippool.sql       schema for IP pools.
> #
> #  Where "DB" is mysql, mssql, oracle, or postgresql.
> #
>
> so if you're using the default setup it should be in sql/postgresql/dialup.conf
>
>> modified /etc/freeradius/sql.conf with addtional section:
>>
>>   /       accounting_update_query_alt = "INSERT into ${acct_table1} \
> Look at dialup.conf, and change the part that matches the offending
> query (it should be accounting_start_query)
>