nie no bardzo fajnie dzieki za rozwiazanie, ja musialem nieco zmodyfikowac<br>postauth_query = &quot;UPDATE nodes SET lastonline = unix_timestamp() WHERE name=Left(&#39;%{User-Name}&#39;, Length(&#39;%{User-Name}&#39;)-14)&quot;<br>
<br>Poniewaz umnie username to nazwa komputer + @domena.pl<br><br>Ale i tak chodzilo mi o statystyki sciągania a nie o włączone komputery, no ale to dobry początek:P<br><br>Pozdrawiam<br><br><div><span class="gmail_quote">30-01-08, <b class="gmail_sendername">Przemysław Kudyba</b> &lt;<a href="mailto:przemekk@zwierzu.zepsul.net">przemekk@zwierzu.zepsul.net</a>&gt; napisał(a):</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Michał Gacek pisze:<br>&gt; no dobra a teraz kto&nbsp;&nbsp;mi zrobi cos takiego tylko zeby sciagal komputerki z<br>&gt; accountinga z radiusa ;p<br>&gt;<br>Przepraszam , że takiego kotleta odgrzewam , ale pomysła mam :)<br><br>kawałek sql.conf:<br>
<br>sql sql_last_online {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;driver = &quot;rlm_sql_mysql&quot;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;server = &quot;localhost&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;login = &quot;lms&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;password = &quot;lms&quot;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;radius_db = &quot;lms_dev&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;postauth_table = &quot;nodes&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;deletestalesessions = yes<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqltrace = yes<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqltracefile = ${logdir}/sqltrace.sql<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;num_sql_socks = 10<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;connect_failure_retry_delay = 60<br>
<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sql_user_name = &quot;%{User-Name}&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sql_set_password = &quot;&quot;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;postauth_query = &quot;UPDATE nodes SET lastonline = unix_timestamp()<br>WHERE name=&#39;%{User-Name}&#39;&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;}<br><br><br>a w radiusd.conf:<br>post-auth {<br><br>sql_last_online<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;&nbsp;Get an address from the IP Pool.<br>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Post-Auth-Type REJECT {<br>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insert-module-name-here<br>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br><br>
}<br><br>Pozdrawiam<br><br><br><br><br><br>_______________________________________________<br>lms mailing list<br><a href="mailto:lms@lists.lms.org.pl">lms@lists.lms.org.pl</a><br><a href="http://lists.lms.org.pl/mailman/listinfo/lms">http://lists.lms.org.pl/mailman/listinfo/lms</a><br>
</blockquote></div><br>

!DSPAM:47a193e2262441859716918!