Thanks for your replies. And one more problem. I'm getting the following (when i send stop packet. Am trying to store stop packet in different table 'radiusacct' now(in sql.conf i changed acct_table2=radiusacct). tail -f /usr/local/fnmt/var/log/radius/radius.log = Thu Jan 22 08:51:49 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - INSERT command denied to user 'radius'@'localhost' for table 'radiusacct' .... Thu Jan 22 09:30:59 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - UPDATE command denied to user 'radius'@'localhost'for table 'radiusacct' Plz. help me. Regards, Ramesh. On Wed, Jan 21, 2009 at 5:25 PM, <tnt@kalik.net> wrote:

...

I need a help to store only accounting stop packets in sql database.

So i have commented out start queries and update queries. Only the active accounting queries are stop and stop alt. Will this works fine??

You need just stop alt then.

...

or do i need to have accounting update queries also??

You need start as well if you want things like Simultaneous-Use to work.

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

ramesh p wrote:

Thanks for your replies. And one more problem.

I'm getting the following (when i send stop packet. Am trying to store stop packet in different table 'radiusacct' now(in sql.conf i changed acct_table2=radiusacct).

tail -f /usr/local/fnmt/var/log/radius/radius.log =

Thu Jan 22 08:51:49 2009 : Error: rlm_sql (sql): Couldn't update SQL accounting STOP record - INSERT command denied to user 'radius'@'localhost' for table 'radiusacct'

This is an SQL question. Fix your database so that the radius user has INSERT permission on that table. Alan DeKok.