'Logout for NAS CP port 76, but no Login record' && 'Login entry for NAS CP port 76 wrong order' Error

20 Jan 2012

      Hi all,

 I am newbie to FreeRadius. Now I am trying to set up a Hotspot with 
 PFsense (FreeRadius + MySQL + Captive Portal).
 (pfSense is a free, open source customized distribution of FreeBSD 
 tailored for use as a firewall and router.FreeRadius is a package of it.
 see more information on their website: http://www.pfsense.org/)

 Basically the Hotspot is working properly, FreeRadius is doing the auth 
 and writing the log to MySQL.

 There is one client running VMware Workstaion inside wiondow2003. And a 
 virtual Debian is running in VM. Debian's network is bridged on host.I 
 am receiving the error log:

 ==================================
 Jan 20 11:15:07 radiusd[55144]:rlm_radutmp: Logout for NAS CP port 76, 
 but no Login record
 Jan 20 11:15:07 radiusd[55144]: rlm_radutmp: Logout for NAS CP port 76, 
 but no Login record
 Jan 20 11:14:06 radiusd[55144]: rlm_radutmp: Login entry for NAS CP 
 port 76 wrong order
 Jan 20 11:14:06 radiusd[55144]: rlm_radutmp: Login entry for NAS CP 
 port 76 wrong order
 ==================================

 And the situation is, for VM_Debian and win2003, ONLY ONE can access 
 the Internet.

 Does anyone have any idea why it will happen? or you have the same 
 experience using VM like this?

 Any reply will be appreciated.

 The following is my Radiusd -X
 ==================================
 # radiusd -X
 FreeRADIUS Version 2.1.12, for host i386-portbld-freebsd8.1, built on 
 Jan  3 2012 at 23:44:16
 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
 There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
 PARTICULAR PURPOSE.
 You may redistribute copies of FreeRADIUS under the terms of the
 GNU General Public License v2.
 Starting - reading configuration files ...
 including configuration file /usr/local/etc/raddb/radiusd.conf
 including configuration file /usr/local/etc/raddb/clients.conf
 including files in directory /usr/local/etc/raddb/modules/
 including configuration file /usr/local/etc/raddb/modules/wimax
 including configuration file /usr/local/etc/raddb/modules/always
 including configuration file /usr/local/etc/raddb/modules/attr_filter
 including configuration file /usr/local/etc/raddb/modules/attr_rewrite
 including configuration file /usr/local/etc/raddb/modules/chap
 including configuration file /usr/local/etc/raddb/modules/checkval
 including configuration file /usr/local/etc/raddb/modules/counter
 including configuration file /usr/local/etc/raddb/modules/cui
 including configuration file /usr/local/etc/raddb/modules/detail
 including configuration file 
 /usr/local/etc/raddb/modules/detail.example.com
 including configuration file /usr/local/etc/raddb/modules/detail.log
 including configuration file /usr/local/etc/raddb/modules/digest
 including configuration file 
 /usr/local/etc/raddb/modules/dynamic_clients
 including configuration file /usr/local/etc/raddb/modules/echo
 including configuration file /usr/local/etc/raddb/modules/etc_group
 including configuration file /usr/local/etc/raddb/modules/exec
 including configuration file /usr/local/etc/raddb/modules/expiration
 including configuration file /usr/local/etc/raddb/modules/expr
 including configuration file /usr/local/etc/raddb/modules/files
 including configuration file /usr/local/etc/raddb/modules/inner-eap
 including configuration file /usr/local/etc/raddb/modules/ippool
 including configuration file /usr/local/etc/raddb/modules/krb5
 including configuration file /usr/local/etc/raddb/modules/ldap
 including configuration file /usr/local/etc/raddb/modules/linelog
 including configuration file /usr/local/etc/raddb/modules/logintime
 including configuration file /usr/local/etc/raddb/modules/mac2ip
 including configuration file /usr/local/etc/raddb/modules/mschap
 including configuration file /usr/local/etc/raddb/modules/mac2vlan
 including configuration file /usr/local/etc/raddb/modules/ntlm_auth
 including configuration file /usr/local/etc/raddb/modules/opendirectory
 including configuration file /usr/local/etc/raddb/modules/otp
 including configuration file /usr/local/etc/raddb/modules/pam
 including configuration file /usr/local/etc/raddb/modules/pap
 including configuration file /usr/local/etc/raddb/modules/passwd
 including configuration file /usr/local/etc/raddb/modules/perl
 including configuration file /usr/local/etc/raddb/modules/policy
 including configuration file /usr/local/etc/raddb/modules/preprocess
 including configuration file /usr/local/etc/raddb/modules/radutmp
 including configuration file /usr/local/etc/raddb/modules/realm
 including configuration file /usr/local/etc/raddb/modules/redis
 including configuration file /usr/local/etc/raddb/modules/rediswho
 including configuration file /usr/local/etc/raddb/modules/replicate
 including configuration file /usr/local/etc/raddb/modules/smbpasswd
 including configuration file /usr/local/etc/raddb/modules/smsotp
 including configuration file /usr/local/etc/raddb/modules/soh
 including configuration file /usr/local/etc/raddb/modules/sql_log
 including configuration file 
 /usr/local/etc/raddb/modules/sqlcounter_expire_on_login
 including configuration file /usr/local/etc/raddb/modules/sradutmp
 including configuration file /usr/local/etc/raddb/modules/unix
 including configuration file /usr/local/etc/raddb/modules/acct_unique
 including configuration file /usr/local/etc/raddb/eap.conf
 including configuration file /usr/local/etc/raddb/sql.conf
 including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf
 including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf
 including configuration file 
 /usr/local/etc/raddb/sql/mysql/counter.conf
 including configuration file /usr/local/etc/raddb/policy.conf
 including files in directory /usr/local/etc/raddb/sites-enabled/
 including configuration file /usr/local/etc/raddb/sites-enabled/default
 main {
         allow_core_dumps = no
 }
 including dictionary file /usr/local/etc/raddb/dictionary
 main {
         name = "radiusd"
         prefix = "/usr/local"
         localstatedir = "/var"
         sbindir = "/usr/local/sbin"
         logdir = "/var/log"
         run_dir = "/var/run"
         libdir = "/usr/local/lib/freeradius-2.1.12"
         radacctdir = "/var/log/radacct"
         hostname_lookups = no
         max_request_time = 30
         cleanup_delay = 5
         max_requests = 1024
         pidfile = "/var/run/radiusd.pid"
         checkrad = "/usr/local/sbin/checkrad"
         debug_level = 0
         proxy_requests = yes
  log {
         stripped_names = yes
         auth = yes
         auth_badpass = yes
         auth_goodpass = yes
  }
  security {
         max_attributes = 200
         reject_delay = 1
         status_server = no
  }
 }
 radiusd: #### Loading Realms and Home Servers ####
 radiusd: #### Loading Clients ####
  client CP {
         ipaddr = 192.168.1.1
         require_message_authenticator = no
         secret = "0814335e"
         shortname = "CP"
         nastype = "other"
  }
 radiusd: #### Instantiating modules ####
  instantiate {
  Module: Linked to module rlm_exec
  Module: Instantiating module "exec" from file 
 /usr/local/etc/raddb/modules/exec
   exec {
         wait = no
         input_pairs = "request"
         shell_escape = yes
   }
  Module: Linked to module rlm_expr
  Module: Instantiating module "expr" from file 
 /usr/local/etc/raddb/modules/expr
  Module: Linked to module rlm_counter
  Module: Instantiating module "daily" from file 
 /usr/local/etc/raddb/modules/counter
   counter daily {
         filename = "/usr/local/etc/raddb/db.daily"
         key = "User-Name"
         reset = "daily"
         count-attribute = "Acct-Session-Time"
         counter-name = "Daily-Session-Time"
         check-name = "Max-Daily-Session"
         reply-name = "Session-Timeout"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Daily-Session-Time is number 11273
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327075200 [2012-01-21 00:00:00]
  Module: Instantiating module "weekly" from file 
 /usr/local/etc/raddb/modules/counter
   counter weekly {
         filename = "/usr/local/etc/raddb/db.weekly"
         key = "User-Name"
         reset = "weekly"
         count-attribute = "Acct-Session-Time"
         counter-name = "Weekly-Session-Time"
         check-name = "Max-Weekly-Session"
         reply-name = "Session-Timeout"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Weekly-Session-Time is number 11275
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327161600 [2012-01-22 00:00:00]
  Module: Instantiating module "monthly" from file 
 /usr/local/etc/raddb/modules/counter
   counter monthly {
         filename = "/usr/local/etc/raddb/db.monthly"
         key = "User-Name"
         reset = "monthly"
         count-attribute = "Acct-Session-Time"
         counter-name = "Monthly-Session-Time"
         check-name = "Max-Monthly-Session"
         reply-name = "Session-Timeout"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Monthly-Session-Time is number 11277
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1328025600 [2012-02-01 00:00:00]
  Module: Instantiating module "forever" from file 
 /usr/local/etc/raddb/modules/counter
   counter forever {
         filename = "/usr/local/etc/raddb/db.forever"
         key = "User-Name"
         reset = "never"
         count-attribute = "Acct-Session-Time"
         counter-name = "Forever-Session-Time"
         check-name = "Max-Forever-Session"
         reply-name = "Session-Timeout"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Forever-Session-Time is number 11279
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 0 [2012-01-20 10:00:00]
  Module: Instantiating module "maxdailyupload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxdailyupload {
         filename = "/usr/local/etc/raddb/db.maxdailyupload"
         key = "User-Name"
         reset = "daily"
         count-attribute = "Acct-Input-Octets"
         counter-name = "Daily-Input-Octets"
         check-name = "Max-Daily-Input"
         reply-name = "Acct-Input-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Daily-Input-Octets is number 11281
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327075200 [2012-01-21 00:00:00]
  Module: Instantiating module "maxdailydownload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxdailydownload {
         filename = "/usr/local/etc/raddb/db.maxdailydownload"
         key = "User-Name"
         reset = "daily"
         count-attribute = "Acct-Output-Octets"
         counter-name = "Daily-Output-Octets"
         check-name = "Max-Daily-Output"
         reply-name = "Acct-Output-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Daily-Output-Octets is number 11283
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327075200 [2012-01-21 00:00:00]
  Module: Instantiating module "maxweeklyupload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxweeklyupload {
         filename = "/usr/local/etc/raddb/db.maxweeklyupload"
         key = "User-Name"
         reset = "weekly"
         count-attribute = "Acct-Input-Octets"
         counter-name = "Weekly-Input-Octets"
         check-name = "Max-Weekly-Input"
         reply-name = "Acct-Input-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Weekly-Input-Octets is number 11285
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327161600 [2012-01-22 00:00:00]
  Module: Instantiating module "maxweeklydownload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxweeklydownload {
         filename = "/usr/local/etc/raddb/db.maxweeklydownload"
         key = "User-Name"
         reset = "weekly"
         count-attribute = "Acct-Output-Octets"
         counter-name = "Weekly-Output-Octets"
         check-name = "Max-Weekly-Output"
         reply-name = "Acct-Output-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Weekly-Output-Octets is number 11287
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1327161600 [2012-01-22 00:00:00]
  Module: Instantiating module "maxmonthlyupload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxmonthlyupload {
         filename = "/usr/local/etc/raddb/db.maxmonthlyupload"
         key = "User-Name"
         reset = "monthly"
         count-attribute = "Acct-Input-Octets"
         counter-name = "Monthly-Input-Octets"
         check-name = "Max-Monthly-Input"
         reply-name = "Acct-Input-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Monthly-Input-Octets is number 11289
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1328025600 [2012-02-01 00:00:00]
  Module: Instantiating module "maxmonthlydownload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxmonthlydownload {
         filename = "/usr/local/etc/raddb/db.maxmonthlydownload"
         key = "User-Name"
         reset = "monthly"
         count-attribute = "Acct-Output-Octets"
         counter-name = "Monthly-Output-Octets"
         check-name = "Max-Monthly-Output"
         reply-name = "Acct-Output-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Monthly-Output-Octets is number 11291
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 1328025600 [2012-02-01 00:00:00]
  Module: Instantiating module "maxupload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxupload {
         filename = "/usr/local/etc/raddb/db.maxforeverupload"
         key = "User-Name"
         reset = "never"
         count-attribute = "Acct-Input-Octets"
         counter-name = "Forever-Input-Octets"
         check-name = "Max-Forever-Input"
         reply-name = "Acct-Input-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Forever-Input-Octets is number 11293
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 0 [2012-01-20 10:00:00]
  Module: Instantiating module "maxdownload" from file 
 /usr/local/etc/raddb/modules/counter
   counter maxdownload {
         filename = "/usr/local/etc/raddb/db.maxforeverdownload"
         key = "User-Name"
         reset = "never"
         count-attribute = "Acct-Output-Octets"
         counter-name = "Forever-Output-Octets"
         check-name = "Max-Forever-Output"
         reply-name = "Acct-Output-Octets"
         cache-size = 5000
   }
 rlm_counter: Counter attribute Forever-Output-Octets is number 11295
 rlm_counter: Current Time: 1327027970 [2012-01-20 10:52:50], Next reset 
 0 [2012-01-20 10:00:00]
  Module: Linked to module rlm_expiration
  Module: Instantiating module "expiration" from file 
 /usr/local/etc/raddb/modules/expiration
   expiration {
         reply-message = "Password Has Expired  "
   }
  Module: Linked to module rlm_logintime
  Module: Instantiating module "logintime" from file 
 /usr/local/etc/raddb/modules/logintime
   logintime {
         reply-message = "You are calling outside your allowed timespan  
 "
         minimum-timeout = 60
   }
  }
 radiusd: #### Loading Virtual Servers ####
 server { # from file /usr/local/etc/raddb/radiusd.conf
  modules {
   Module: Creating Auth-Type = digest
   Module: Creating Autz-Type = Status-Server
   Module: Creating Acct-Type = Status-Server
   Module: Creating Post-Auth-Type = REJECT
  Module: Checking authenticate {...} for more modules to load
  Module: Linked to module rlm_pap
  Module: Instantiating module "pap" from file 
 /usr/local/etc/raddb/modules/pap
   pap {
         encryption_scheme = "auto"
         auto_header = no
   }
  Module: Linked to module rlm_chap
  Module: Instantiating module "chap" from file 
 /usr/local/etc/raddb/modules/chap
  Module: Linked to module rlm_mschap
  Module: Instantiating module "mschap" from file 
 /usr/local/etc/raddb/modules/mschap
   mschap {
         use_mppe = yes
         require_encryption = no
         require_strong = no
         with_ntdomain_hack = yes
         allow_retry = yes
   }
  Module: Linked to module rlm_digest
  Module: Instantiating module "digest" from file 
 /usr/local/etc/raddb/modules/digest
  Module: Linked to module rlm_unix
  Module: Instantiating module "unix" from file 
 /usr/local/etc/raddb/modules/unix
   unix {
         radwtmp = "/var/log/radwtmp"
   }
  Module: Linked to module rlm_eap
  Module: Instantiating module "eap" from file 
 /usr/local/etc/raddb/eap.conf
   eap {
         default_eap_type = "md5"
         timer_expire = 60
         ignore_unknown_eap_types = no
         cisco_accounting_username_bug = no
         max_sessions = 4096
   }
  Module: Linked to sub-module rlm_eap_md5
  Module: Instantiating eap-md5
  Module: Linked to sub-module rlm_eap_leap
  Module: Instantiating eap-leap
  Module: Linked to sub-module rlm_eap_gtc
  Module: Instantiating eap-gtc
    gtc {
         challenge = "Password: "
         auth_type = "PAP"
    }
  Module: Linked to sub-module rlm_eap_tls
  Module: Instantiating eap-tls
    tls {
         rsa_key_exchange = no
         dh_key_exchange = yes
         rsa_key_length = 512
         dh_key_length = 512
         verify_depth = 0
         CA_path = "/usr/local/etc/raddb/certs"
         pem_file_type = yes
         private_key_file = "/usr/local/etc/raddb/certs/server.pem"
         certificate_file = "/usr/local/etc/raddb/certs/server.pem"
         CA_file = "/usr/local/etc/raddb/certs/ca.pem"
         private_key_password = "whatever"
         dh_file = "/usr/local/etc/raddb/certs/dh"
         random_file = "/usr/local/etc/raddb/certs/random"
         fragment_size = 1024
         include_length = yes
         check_crl = no
         cipher_list = "DEFAULT"
         ecdh_curve = "prime256v1"
     cache {
         enable = no
         lifetime = 24
         max_entries = 255
     }
     verify {
     }
     ocsp {
         enable = no
         override_cert_url = no
         url = "http://127.0.0.1/ocsp/"
     }
    }
  Module: Linked to sub-module rlm_eap_ttls
  Module: Instantiating eap-ttls
    ttls {
         default_eap_type = "md5"
         copy_request_to_tunnel = no
         use_tunneled_reply = no
         include_length = yes
    }
  Module: Linked to sub-module rlm_eap_peap
  Module: Instantiating eap-peap
    peap {
         default_eap_type = "mschapv2"
         copy_request_to_tunnel = no
         use_tunneled_reply = no
         proxy_tunneled_request_as_eap = yes
         soh = no
    }
  Module: Linked to sub-module rlm_eap_mschapv2
  Module: Instantiating eap-mschapv2
    mschapv2 {
         with_ntdomain_hack = no
         send_error = no
    }
  Module: Checking authorize {...} for more modules to load
  Module: Linked to module rlm_preprocess
  Module: Instantiating module "preprocess" from file 
 /usr/local/etc/raddb/modules/preprocess
   preprocess {
         huntgroups = "/usr/local/etc/raddb/huntgroups"
         hints = "/usr/local/etc/raddb/hints"
         with_ascend_hack = no
         ascend_channels_per_line = 23
         with_ntdomain_hack = no
         with_specialix_jetstream_hack = no
         with_cisco_vsa_hack = no
         with_alvarion_vsa_hack = no
   }
  Module: Linked to module rlm_realm
  Module: Instantiating module "suffix" from file 
 /usr/local/etc/raddb/modules/realm
   realm suffix {
         format = "suffix"
         delimiter = "@"
         ignore_default = no
         ignore_null = yes
   }
  Module: Instantiating module "ntdomain" from file 
 /usr/local/etc/raddb/modules/realm
   realm ntdomain {
         format = "prefix"
         delimiter = "\"
         ignore_default = no
         ignore_null = yes
   }
  Module: Linked to module rlm_files
  Module: Instantiating module "files" from file 
 /usr/local/etc/raddb/modules/files
   files {
         usersfile = "/usr/local/etc/raddb/users"
         acctusersfile = "/usr/local/etc/raddb/acct_users"
         preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users"
         compat = "no"
   }
  Module: Linked to module rlm_sql
  Module: Instantiating module "sql" from file 
 /usr/local/etc/raddb/sql.conf
   sql {
         driver = "rlm_sql_mysql"
         server = "192.168.1.25"
         port = "3306"
         login = "radius"
         password = "0814335e"
         radius_db = "radius"
         read_groups = yes
         sqltrace = no
         sqltracefile = "/var/log/sqltrace.sql"
         readclients = yes
         deletestalesessions = yes
         num_sql_socks = 5
         lifetime = 0
         max_queries = 0
         sql_user_name = "%{User-Name}"
         default_user_profile = ""
         nas_query = "SELECT id, nasname, shortname, type, secret, 
 server FROM nas"
         authorize_check_query = "SELECT id, username, attribute, value, 
 op           FROM radcheck           WHERE username = '%{SQL-User-Name}' 
          ORDER BY id"
         authorize_reply_query = "SELECT id, username, attribute, value, 
 op           FROM radreply           WHERE username = '%{SQL-User-Name}' 
          ORDER BY id"
         authorize_group_check_query = "SELECT id, groupname, attribute, 
          Value, op           FROM radgroupcheck           WHERE 
 groupname = '%{Sql-Group}'           ORDER BY id"
         authorize_group_reply_query = "SELECT id, groupname, attribute, 
          value, op           FROM radgroupreply           WHERE 
 groupname = '%{Sql-Group}'           ORDER BY id"
         accounting_onoff_query = "          UPDATE radacct           
 SET              acctstoptime       =  '%S',              
 acctsessiontime    =  unix_timestamp('%S') -                             
       unix_timestamp(acctstarttime),              acctterminatecause =  
 '%{Acct-Terminate-Cause}',              acctstopdelay      =  
 %{%{Acct-Delay-Time}:-0}           WHERE acctstoptime IS NULL           
 AND nasipaddress      =  '%{NAS-IP-Address}'           AND acctstarttime 
    <= '%S'"
         accounting_update_query = "           UPDATE radacct           
 SET              framedipaddress = '%{Framed-IP-Address}',              
 acctsessiontime     = '%{Acct-Session-Time}',              
 acctinputoctets     = '%{%{Acct-Input-Gigawords}:-0}'  << 32 |           
                         '%{%{Acct-Input-Octets}:-0}',              
 acctoutputoctets    = '%{%{Acct-Output-Gigawords}:-0}' << 32 |           
                         '%{%{Acct-Output-Octets}:-0}'           WHERE 
 acctsessionid = '%{Acct-Session-Id}'           AND username        = 
 '%{SQL-User-Name}'           AND nasipaddress    = '%{NAS-IP-Address}'"
         accounting_update_query_alt = "           INSERT INTO radacct   
          (acctsessionid,    acctuniqueid,      username,              
 realm,            nasipaddress,      nasportid,              
 nasporttype,      acctstarttime,     acctsessiontime,              
 acctauthentic,    connectinfo_start, acctinputoctets,              
 acctoutputoctets, calledstationid,   callingstationid,              
 servicetype,      framedprotocol,    framedipaddress,              
 acctstartdelay,   xascendsessionsvrkey)           VALUES             
 ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',              
 '%{SQL-User-Name}',              '%{Realm}', '%{NAS-IP-Address}', 
 '%{NAS-Port}',              '%{NAS-Port-Type}',              
 DATE_SUB('%S',                       INTERVAL 
 (%{%{Acct-Session-Time}:-0} +                                 
 %{%{Acct-Delay-Time}:-0}) SECOND),                       
 '%{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}',              
 '0', '%{X-Ascend-Session-Svr-Key}')"
         accounting_start_query = "           INSERT INTO radacct        
     (acctsessionid,    acctuniqueid,     username,              realm,  
          nasipaddress,     nasportid,              nasporttype,      
 acctstarttime,    acctstoptime,              acctsessiontime,  
 acctauthentic,    connectinfo_start,              connectinfo_stop, 
 acctinputoctets,  acctoutputoctets,              calledstationid,  
 callingstationid, acctterminatecause,              servicetype,      
 framedprotocol,   framedipaddress,              acctstartdelay,   
 acctstopdelay,    xascendsessionsvrkey)           VALUES             
 ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',              
 '%{SQL-User-Name}',              '%{Realm}', '%{NAS-IP-Address}', 
 '%{NAS-Port}',              '%{NAS-Port-Type}', '%S', NULL,              
 '0', '%{Acct-Authentic}', '%{Connect-Info}',              '', '0', '0',  
            '%{Called-Station-Id}', '%{Calling-Station-Id}', '',         
     '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',    
          '%{%{Acct-Delay-Time}:-0}', '0', 
 '%{X-Ascend-Session-Svr-Key}')"
         accounting_start_query_alt = "           UPDATE radacct SET     
         acctstarttime     = '%S',              acctstartdelay    = 
 '%{%{Acct-Delay-Time}:-0}',              connectinfo_start = 
 '%{Connect-Info}'           WHERE acctsessionid  = '%{Acct-Session-Id}'  
         AND username         = '%{SQL-User-Name}'           AND 
 nasipaddress     = '%{NAS-IP-Address}'"
         accounting_stop_query = "           UPDATE radacct SET          
    acctstoptime       = '%S',              acctsessiontime    = 
 '%{Acct-Session-Time}',              acctinputoctets    = 
 '%{%{Acct-Input-Gigawords}:-0}' << 32 |                                  
 '%{%{Acct-Input-Octets}:-0}',              acctoutputoctets   = 
 '%{%{Acct-Output-Gigawords}:-0}' << 32 |                                 
  '%{%{Acct-Output-Octets}:-0}',              acctterminatecause = 
 '%{Acct-Terminate-Cause}',              acctstopdelay      = 
 '%{%{Acct-Delay-Time}:-0}',              connectinfo_stop   = 
 '%{Connect-Info}'           WHERE acctsessionid   = '%{Acct-Session-Id}' 
          AND username          = '%{SQL-User-Name}'           AND 
 nasipaddress      = '%{NAS-IP-Address}'"
         accounting_stop_query_alt = "           INSERT INTO radacct     
        (acctsessionid, acctuniqueid, username,              realm, 
 nasipaddress, nasportid,              nasporttype, acctstarttime, 
 acctstoptime,              acctsessiontime, acctauthentic, 
 connectinfo_start,              connectinfo_stop, acctinputoctets, 
 acctoutputoctets,              calledstationid, callingstationid, 
 acctterminatecause,              servicetype, framedprotocol, 
 framedipaddress,              acctstartdelay, acctstopdelay)           
 VALUES             ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',   
           '%{SQL-User-Name}',              '%{Realm}', 
 '%{NAS-IP-Address}', '%{NAS-Port}',              '%{NAS-Port-Type}',     
         DATE_SUB('%S',                  INTERVAL 
 (%{%{Acct-Session-Time}:-0} +                  %{%{Acct-Delay-Time}:-0}) 
 SECOND),              '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', 
 '',              '%{Connect-Info}',              
 '%{%{Acct-Input-Gigawords}:-0}' << 32 |              
 '%{%{Acct-Input-Octets}:-0}',              
 '%{%{Acct-Output-Gigawords}:-0}' << 32 |              
 '%{%{Acct-Output-Octets}:-0}',              '%{Called-Station-Id}', 
 '%{Calling-Station-Id}',              '%{Acct-Terminate-Cause}',         
     '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',    
          '0', '%{%{Acct-Delay-Time}:-0}')"
         group_membership_query = "SELECT groupname           FROM 
 radusergroup           WHERE username = '%{SQL-User-Name}'           
 ORDER BY priority"
         connect_failure_retry_delay = 60
         simul_count_query = ""
         simul_verify_query = "SELECT radacctid, acctsessionid, 
 username,                                nasipaddress, nasportid, 
 framedipaddress,                                callingstationid, 
 framedprotocol                                FROM radacct               
                 WHERE username = '%{SQL-User-Name}'                     
           AND acctstoptime IS NULL"
         postauth_query = "INSERT INTO radpostauth                       
    (username, pass, reply, authdate)                           VALUES ( 
                          '%{User-Name}',                           
 '%{%{User-Password}:-%{Chap-Password}}',                           
 '%{reply:Packet-Type}', '%S')"
         safe-characters = 
 "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
   }
 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and 
 linked
 rlm_sql (sql): Attempting to connect to radius@192.168.1.25:3306/radius
 rlm_sql (sql): starting 0
 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
 rlm_sql_mysql: Starting connect to MySQL server for #0
 rlm_sql (sql): Connected new DB handle, #0
 rlm_sql (sql): starting 1
 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
 rlm_sql_mysql: Starting connect to MySQL server for #1
 rlm_sql (sql): Connected new DB handle, #1
 rlm_sql (sql): starting 2
 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
 rlm_sql_mysql: Starting connect to MySQL server for #2
 rlm_sql (sql): Connected new DB handle, #2
 rlm_sql (sql): starting 3
 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
 rlm_sql_mysql: Starting connect to MySQL server for #3
 rlm_sql (sql): Connected new DB handle, #3
 rlm_sql (sql): starting 4
 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
 rlm_sql_mysql: Starting connect to MySQL server for #4
 rlm_sql (sql): Connected new DB handle, #4
 rlm_sql (sql): Processing generate_sql_clients
 rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, 
 shortname, type, secret, server FROM nas
 rlm_sql (sql): Reserving sql socket id: 4
 rlm_sql (sql): Released sql socket id: 4
  Module: Linked to module rlm_checkval
  Module: Instantiating module "checkval" from file 
 /usr/local/etc/raddb/modules/checkval
   checkval {
         item-name = "Calling-Station-Id"
         check-name = "Calling-Station-Id"
         data-type = "string"
         notfound-reject = no
   }
 rlm_checkval: Registered name Calling-Station-Id for attribute 31
  Module: Checking preacct {...} for more modules to load
  Module: Linked to module rlm_acct_unique
  Module: Instantiating module "acct_unique" from file 
 /usr/local/etc/raddb/modules/acct_unique
   acct_unique {
         key = "User-Name, Acct-Session-Id, NAS-IP-Address, 
 Client-IP-Address, NAS-Port"
   }
  Module: Checking accounting {...} for more modules to load
  Module: Linked to module rlm_detail
  Module: Instantiating module "detail" from file 
 /usr/local/etc/raddb/modules/detail
   detail {
         detailfile = 
 "/var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d"
         header = "%t"
         detailperm = 384
         dirperm = 493
         locking = no
         log_packet_header = no
   }
  Module: Linked to module rlm_radutmp
  Module: Instantiating module "radutmp" from file 
 /usr/local/etc/raddb/modules/radutmp
   radutmp {
         filename = "/var/log/radutmp"
         username = "%{User-Name}"
         case_sensitive = yes
         check_with_nas = yes
         perm = 384
         callerid = yes
   }
  Module: Linked to module rlm_attr_filter
  Module: Instantiating module "attr_filter.accounting_response" from 
 file /usr/local/etc/raddb/modules/attr_filter
   attr_filter attr_filter.accounting_response {
         attrsfile = "/usr/local/etc/raddb/attrs.accounting_response"
         key = "%{User-Name}"
         relaxed = no
   }
  Module: Checking session {...} for more modules to load
  Module: Checking pre-proxy {...} for more modules to load
  Module: Instantiating module "attr_filter.pre-proxy" from file 
 /usr/local/etc/raddb/modules/attr_filter
   attr_filter attr_filter.pre-proxy {
         attrsfile = "/usr/local/etc/raddb/attrs.pre-proxy"
         key = "%{Realm}"
         relaxed = no
   }
  Module: Checking post-proxy {...} for more modules to load
  Module: Instantiating module "attr_filter.post-proxy" from file 
 /usr/local/etc/raddb/modules/attr_filter
   attr_filter attr_filter.post-proxy {
         attrsfile = "/usr/local/etc/raddb/attrs"
         key = "%{Realm}"
         relaxed = no
   }
  Module: Checking post-auth {...} for more modules to load
  Module: Instantiating module "attr_filter.access_reject" from file 
 /usr/local/etc/raddb/modules/attr_filter
   attr_filter attr_filter.access_reject {
         attrsfile = "/usr/local/etc/raddb/attrs.access_reject"
         key = "%{User-Name}"
         relaxed = no
   }
  } # modules
 } # server
 radiusd: #### Opening IP addresses and Ports ####
 listen {
         type = "auth"
         ipaddr = 192.168.1.1
         port = 1812
 }
 listen {
         type = "acct"
         ipaddr = 192.168.1.1
         port = 1813
 }
 listen {
         type = "proxy"
         ipaddr = 192.168.1.1
         port = 1814
 }
 Listening on authentication address 192.168.1.1 port 1812
 Listening on accounting address 192.168.1.1 port 1813
 Listening on proxy address 192.168.1.1 port 1814
 Ready to process requests.
 ==================================
 Thanks for any reply in advance!!
 Zlyzwy