sql_log question

2006-04-07 Thread Miguel
hi, i have a reporting system, this will perform intensive calculations, 
agregate functions etc using accounting data, so i dont want to run this 
system in the same server where the account is stored, i plan to use the 
sql_log/sql-relay combo, however i do need that the account data be 
stored online in the database running in the radius server, because i 
have triggers in the stoptable that  calculate the h323-credit-amount 
using a modified excelent peter nixon's voip schema.

the line in radius.conf  says

accounting {
#
#  Instead of sending the query to the SQL server,
#  write it into a log file.
#
sql_log
}

cant i have both  sql account feature and sql_log at the same time?
---
Miguel

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


Re: sql_log question

2006-04-08 Thread Peter Nixon
On Sat 08 Apr 2006 00:36, Miguel wrote:
> hi, i have a reporting system, this will perform intensive calculations,
> agregate functions etc using accounting data, so i dont want to run this
> system in the same server where the account is stored, i plan to use the
> sql_log/sql-relay combo, however i do need that the account data be
> stored online in the database running in the radius server, because i
> have triggers in the stoptable that  calculate the h323-credit-amount
> using a modified excelent peter nixon's voip schema.
> the line in radius.conf  says
>
> accounting {
> #
> #  Instead of sending the query to the SQL server,
> #  write it into a log file.
> #
> sql_log
> }
>
> cant i have both  sql account feature and sql_log at the same time?

Hi Miguel

I am glad you like my schema :-)

If you have any modifications that you think would be of general use to 
others, please report them back to me so that I can check them out.

I personally have not used sql_log in combination with sql however I see no 
reason why you wouldn't be able to use both at the same time.

Regards

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpi9k2d8ek5h.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html