On Thu, Jul 7, 2011 at 10:09 AM, ahthrift <andyonfire@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