Hi, Here is the full accounting section of sites-available/default accounting { # # Create a 'detail'ed log of the packets. # Note that accounting requests which are proxied # are also logged in the detail file. detail # daily # Update the wtmp file # # If you don't use "radlast", you can delete this line. unix # # For Simultaneous-Use tracking. # # Due to packet losses in the network, the data here # may be incorrect. There is little we can do about it. radutmp # sradutmp # Return an address to the IP Pool when we see a stop record. # main_pool # # Log traffic to an SQL database. # # See "Accounting queries" in sql.conf #sql * if(Acct-Status-Type := 'stop') { sql }* # # Instead of sending the query to the SQL server, # write it into a log file. # # sql_log # Cisco VoIP specific bulk accounting # pgsql-voip # Filter attributes from the accounting response. attr_filter.accounting_response # # See "Autz-Type Status-Server" for how this works. # Acct-Type Status-Server { } } Thanks, Rams. On 13/8/09 07:10, ramesh p wrote:
Though i have placed the code in sites-available/default under accounting section:
if(Acct-Status-Type := 'stop'){ sql
Can you post the full section that you have added this to, if you have only added just those 2 lines then you haven't closed the statement off with a "}". Steve -- Steven Carr Systems Development Officer SLS/ITS/Systems - (0191) 515 3953