hey... again... at sqlcounter.conf i can't stripped-user-name if i used in dialup.conf why sqlcounter got at 1st time stripped-user-name and in the sql action use full username form NAS?
check the log [monthlycounter1] sql_set_user escaped user --> 'griseramirez' [monthlycounter1] expand: SELECT SUM(acctsessiontime - GREATEST((1346472000 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='griserami...@testing.localdomain.cu' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1346472000' -> SELECT SUM(acctsessiontime - ................ rest part in que query shlud be griseramirez too like sql_set_user escaped. cheers 2012/9/6 Tony Peña <emperor...@gmail.com> > cool... > > works great... > setting 2 instance monthlycounter monthlycounter1 { bla } and 2 the same > rules... about it.. > and in authorization session reundant-load-balance {monthlycounter1 > monthlycounter2} works fine.... i got balance in the queries like sql1 and > 2 accounting,.. > good work team... > > ;-) > > > 2012/9/6 Arran Cudbard-Bell <a.cudba...@freeradius.org> > >> >> On 6 Sep 2012, at 14:44, Tony Peña <emperor...@gmail.com> wrote: >> >> > hi again.... all fine with redundant-load-balance {sql1 sql2} >> > now .. have a different issue with that... when i set sql with 2 sql >> server for balance.. in the monthlysession i have sql_modinst = sql >> > and have noop check because sql is not define ok... so, i do in 1 >> server sql_modinst = sql1 and the other server sql_modinst = sql2 to check >> monthlysession again.. is possible to do load-balance in that case too? >> >> you have to create two instances of the dependent module and put them in >> a redundant-load-balance bock too. >> >> -Arran >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > > > -- > Antonio Peña > Secure email with PGP 0x8B021001 available at http://pgp.mit.edu > Fingerprint: 74E6 2974 B090 366D CE71 7BB2 6476 FA09 8B02 1001 > -- Antonio Peña Secure email with PGP 0x8B021001 available at http://pgp.mit.edu Fingerprint: 74E6 2974 B090 366D CE71 7BB2 6476 FA09 8B02 1001
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html