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<andyonf...@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)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html