rlm_sql: "NUMERIC VALUE OUT OF RANGE" error

[Fajar A. Nugraha]

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)

-- 
Fajar