balancing sql servers

[Tony Peña]

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='griseramirez at 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.cu at 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.cudbardb at freeradius.org>
>
>>
>> On 6 Sep 2012, at 14:44, Tony Peña <emperor.cu at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120906/7e61e9ed/attachment.html>