Coa problem

Mixmasterontour PureDJ mixmasterontour at hotmail.com
Thu Nov 8 08:38:44 CET 2012



 
>   Well, that's a typo.  I've pushed another fix.
> 
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Perfect, it's working now!
Thanks

one other small thing:
in freeradius-server/raddb/sql/mysql/dialup.conf there is an error

in 
accounting {
interim-update {

the insert sql is not correct (value count is incorrect)
was:
query = "\
                                        INSERT INTO ${....acct_table1} \
                                                (${...column_list}) \
                                        VALUES \
                                                ('%{Acct-Session-Id}', \
                                                '%{Acct-Unique-Session-Id}', \
                                                '%{SQL-User-Name}', \
                                                '%{Realm}', \
                                                '%{NAS-IP-Address}', \
                                                '%{NAS-Port}', \
                                                '%{NAS-Port-Type}', \
                                                FROM_UNIXTIME(%{integer:Event-Timestamp} - \
                                                        %{%{Acct-Session-Time}:-0}), \
                                                FROM_UNIXTIME(%{integer:Event-Timestamp}), \
                                                '%{Acct-Session-Time}', \
                                                '%{Acct-Authentic}', '', \
                                                '%{%{Acct-Input-Gigawords}:-0}' << 32 | \
                                                        '%{%{Acct-Input-Octets}:-0}', \
                                                '%{%{Acct-Output-Gigawords}:-0}' << 32 | \
                                                        '%{%{Acct-Output-Octets}:-0}', \
                                                '%{Called-Station-Id}', \
                                                '%{Calling-Station-Id}', \
                                                '%{Service-Type}', \
                                                '%{Framed-Protocol}', \
                                                '%{Framed-IP-Address}')"
                        }


should be:
                                query = "\
                                        INSERT INTO ${....acct_table1} \
                                                (${...column_list}) \
                                        VALUES \
                                                ('%{Acct-Session-Id}', \
                                                '%{Acct-Unique-Session-Id}', \
                                                '%{SQL-User-Name}', \
                                                '%{Realm}', \
                                                '%{NAS-IP-Address}', \
                                                '%{NAS-Port}', \
                                                '%{NAS-Port-Type}', \
                                                FROM_UNIXTIME(%{integer:Event-Timestamp} - \
                                                        %{%{Acct-Session-Time}:-0}), \
                                                FROM_UNIXTIME(%{integer:Event-Timestamp}), \
                                                NULL, \
                                                '%{Acct-Session-Time}', \
                                                '%{Acct-Authentic}', '', '', \
                                                '%{%{Acct-Input-Gigawords}:-0}' << 32 | \
                                                        '%{%{Acct-Input-Octets}:-0}', \
                                                '%{%{Acct-Output-Gigawords}:-0}' << 32 | \
                                                        '%{%{Acct-Output-Octets}:-0}', \
                                                '%{Called-Station-Id}', \
                                                '%{Calling-Station-Id}', \
                                                '', \
                                                '%{Service-Type}', \
                                                '%{Framed-Protocol}', \
                                                '%{Framed-IP-Address}')"


                        }

 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121108/1ac8b5b9/attachment-0001.html>


More information about the Freeradius-Users mailing list