<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<br><div> <br>> Well, that's a typo. I've pushed another fix.<br>> <br>> Alan DeKok.<br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br><br>Perfect, it's working now!<br>Thanks<br><br>one other small thing:<br>in freeradius-server/raddb/sql/mysql/dialup.conf there is an error<br><br>in <br>accounting {<br>interim-update {<br><br>the insert sql is not correct (value count is incorrect)<br>was:<br>query = "\<br> INSERT INTO ${....acct_table1} \<br> (${...column_list}) \<br> VALUES \<br> ('%{Acct-Session-Id}', \<br> '%{Acct-Unique-Session-Id}', \<br> '%{SQL-User-Name}', \<br> '%{Realm}', \<br> '%{NAS-IP-Address}', \<br> '%{NAS-Port}', \<br> '%{NAS-Port-Type}', \<br> FROM_UNIXTIME(%{integer:Event-Timestamp} - \<br> %{%{Acct-Session-Time}:-0}), \<br> FROM_UNIXTIME(%{integer:Event-Timestamp}), \<br> '%{Acct-Session-Time}', \<br> '%{Acct-Authentic}', '', \<br> '%{%{Acct-Input-Gigawords}:-0}' << 32 | \<br> '%{%{Acct-Input-Octets}:-0}', \<br> '%{%{Acct-Output-Gigawords}:-0}' << 32 | \<br> '%{%{Acct-Output-Octets}:-0}', \<br> '%{Called-Station-Id}', \<br> '%{Calling-Station-Id}', \<br> '%{Service-Type}', \<br> '%{Framed-Protocol}', \<br> '%{Framed-IP-Address}')"<br> }<br><br><br>should be:<br> query = "\<br> INSERT INTO ${....acct_table1} \<br> (${...column_list}) \<br> VALUES \<br> ('%{Acct-Session-Id}', \<br> '%{Acct-Unique-Session-Id}', \<br> '%{SQL-User-Name}', \<br> '%{Realm}', \<br> '%{NAS-IP-Address}', \<br> '%{NAS-Port}', \<br> '%{NAS-Port-Type}', \<br> FROM_UNIXTIME(%{integer:Event-Timestamp} - \<br> %{%{Acct-Session-Time}:-0}), \<br> FROM_UNIXTIME(%{integer:Event-Timestamp}), \<br> NULL, \<br> '%{Acct-Session-Time}', \<br> '%{Acct-Authentic}', '', '', \<br> '%{%{Acct-Input-Gigawords}:-0}' << 32 | \<br> '%{%{Acct-Input-Octets}:-0}', \<br> '%{%{Acct-Output-Gigawords}:-0}' << 32 | \<br> '%{%{Acct-Output-Octets}:-0}', \<br> '%{Called-Station-Id}', \<br> '%{Calling-Station-Id}', \<br> '', \<br> '%{Service-Type}', \<br> '%{Framed-Protocol}', \<br> '%{Framed-IP-Address}')"<br><br><br> }<br><br></div> </div></body>
</html>