Re: Can i do that?

2007-04-09 Thread Marat Rysbekov
Hello, apolyxrono. OK, an example. I use freeradius server to do the accounting for my DSL clients. There are two tables in the accounting scheme: 1. dsl_accounting. This is a shorter version of radacct, containing only the fields I found to be useful to me. MySQL create statement: CREATE TABLE

Re: Can i do that?

2007-04-08 Thread Marat Rysbekov
Hello, Kostas. I believe the best way to do that is to use stored procedures, if your DB server supports them. Then you can replace the accounting query strings in sql.conf to something like: "CALL accounting_start_procedure(attributes_you_want_to_pass)", and compose a stored procedure that will p

Re: Can i do that?

2007-04-06 Thread Kostas Kalevras
O/H apolyxrono έγραψε: > Hi list, > > I have freeradius-1.1.3 doing accounting with mysql. I am thinking to > create 2 or 3 new tables in the radius db for my purposes and write in > them the info i want every time freeradius writes data to the other > tables (nas ,radcheck ,radacct etc.). freeradi

Can i do that?

2007-04-06 Thread apolyxrono
Hi list, I have freeradius-1.1.3 doing accounting with mysql. I am thinking to create 2 or 3 new tables in the radius db for my purposes and write in them the info i want every time freeradius writes data to the other tables (nas ,radcheck ,radacct etc.). Is it possible to do that ? If yes how ? I