hey... again... <div><br></div><div>at sqlcounter.conf i can't stripped-user-name</div><div>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?</div>
<div><br></div><div>check the log</div><div><br></div><div><div>[monthlycounter1] sql_set_user escaped user --> 'griseramirez'</div><div>[monthlycounter1] expand: SELECT SUM(acctsessiontime - GREATEST((1346472000 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='<a href="mailto:griseramirez@testing.localdomain.cu">griseramirez@testing.localdomain.cu</a>' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1346472000' -> SELECT SUM(acctsessiontime - ................ rest part</div>
<div><br></div><div>in que query shlud be griseramirez too like sql_set_user escaped.</div><div><br></div><div>cheers</div><br><div class="gmail_quote">2012/9/6 Tony Peña <span dir="ltr"><<a href="mailto:emperor.cu@gmail.com" target="_blank">emperor.cu@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">cool... <div><br></div><div>works great... </div><div>setting 2 instance monthlycounter monthlycounter1 { bla } and 2 the same rules... about it..</div>
<div>and in authorization session reundant-load-balance {monthlycounter1 monthlycounter2} works fine.... i got balance in the queries like sql1 and 2 accounting,.. </div>
<div>good work team...</div><div><br></div><div>;-)<div><div class="h5"><br><br><div class="gmail_quote">2012/9/6 Arran Cudbard-Bell <span dir="ltr"><<a href="mailto:a.cudbardb@freeradius.org" target="_blank">a.cudbardb@freeradius.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br>
On 6 Sep 2012, at 14:44, Tony Peña <<a href="mailto:emperor.cu@gmail.com" target="_blank">emperor.cu@gmail.com</a>> wrote:<br>
<br>
> hi again.... all fine with redundant-load-balance {sql1 sql2}<br>
> 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<br>
> 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?<br>
<br>
</div>you have to create two instances of the dependent module and put them in a redundant-load-balance bock too.<br>
<span><font color="#888888"><br>
-Arran<br>
</font></span><div><div>-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div></div></div><div class="im">-- <br><font color="#888888"><font color="#888888">Antonio Pe</font><span><font color="#888888">ñ</font></span><font color="#888888">a</font><span></span><br>
<font color="#888888">Secure email with PGP 0x8B021001 available at <a href="http://pgp.mit.edu" target="_blank">http://pgp.mit.edu</a><br></font></font><font color="#888888">
<font color="#888888">Fingerprint: 74E6 2974 B090 366D CE71 7BB2 6476 FA09 8B02 1001</font></font><br>
</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><font color="#888888"><font color="#888888">Antonio Pe</font><span><font color="#888888">ñ</font></span><font color="#888888">a</font><span></span><br><font color="#888888">Secure email with PGP 0x8B021001 available at <a href="http://pgp.mit.edu" target="_blank">http://pgp.mit.edu</a><br>
</font></font><font color="#888888">
<font color="#888888">Fingerprint: 74E6 2974 B090 366D CE71 7BB2 6476 FA09 8B02 1001</font></font><br>
</div>