rlm_sqlcounter: Max-Daily-Session.

* zhex900 at gmail.com
Mon May 12 14:16:59 CEST 2014


Thank you for your reply.

Here is my radius -X

> radiusd: FreeRADIUS Version 3.0.1, for host x86_64-pc-linux-gnu, built on
Apr 15 2014 at 14:04:23
>
> Copyright (C) 1999-2014 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
>
> For more information about these matters, see the file named COPYRIGHT
>
> Starting - reading configuration files ...
>
> including dictionary file /etc/freeradius/dictionary
>
> including configuration file /etc/freeradius/radiusd.conf
>
> including configuration file /etc/freeradius/proxy.conf
>
> including configuration file /etc/freeradius/clients.conf
>
> including files in directory /etc/freeradius/mods-enabled/
>
> including configuration file /etc/freeradius/mods-enabled/eap
>
> including configuration file /etc/freeradius/mods-enabled/always
>
> including configuration file /etc/freeradius/mods-enabled/dynamic_clients
>
> including configuration file /etc/freeradius/mods-enabled/detail.log
>
> including configuration file /etc/freeradius/mods-enabled/detail
>
> including configuration file /etc/freeradius/mods-enabled/sradutmp
>
> including configuration file /etc/freeradius/mods-enabled/expiration
>
> including configuration file /etc/freeradius/mods-enabled/preprocess
>
> including configuration file /etc/freeradius/mods-enabled/logintime
>
> including configuration file /etc/freeradius/mods-enabled/soh
>
> including configuration file /etc/freeradius/mods-enabled/dhcp
>
> including configuration file /etc/freeradius/mods-enabled/radutmp
>
> including configuration file /etc/freeradius/mods-enabled/digest
>
> including configuration file /etc/freeradius/mods-enabled/exec
>
> including configuration file /etc/freeradius/mods-enabled/echo
>
> including configuration file /etc/freeradius/mods-enabled/replicate
>
> including configuration file /etc/freeradius/mods-enabled/cache_eap
>
> including configuration file /etc/freeradius/mods-enabled/linelog
>
> including configuration file /etc/freeradius/mods-enabled/utf8
>
> including configuration file /etc/freeradius/mods-enabled/attr_filter
>
> including configuration file /etc/freeradius/mods-enabled/chap
>
> including configuration file /etc/freeradius/mods-enabled/realm
>
> including configuration file /etc/freeradius/mods-enabled/passwd
>
> including configuration file /etc/freeradius/mods-enabled/ntlm_auth
>
> including configuration file /etc/freeradius/mods-enabled/sql
>
> including configuration file
/etc/freeradius/mods-config/sql/main/mysql/queries.conf
>
> including configuration file /etc/freeradius/mods-enabled/sqlcounter
>
> including configuration file /etc/freeradius/mods-enabled/pap
>
> including configuration file /etc/freeradius/mods-enabled/perl
>
> including configuration file /etc/freeradius/mods-enabled/files
>
> including configuration file /etc/freeradius/mods-enabled/expr
>
> including configuration file /etc/freeradius/mods-enabled/unix
>
> including configuration file /etc/freeradius/mods-enabled/mschap
>
> including files in directory /etc/freeradius/policy.d/
>
> including configuration file /etc/freeradius/policy.d/eap
>
> including configuration file /etc/freeradius/policy.d/cui
>
> including configuration file /etc/freeradius/policy.d/operator-name
>
> including configuration file /etc/freeradius/policy.d/dhcp
>
> including configuration file /etc/freeradius/policy.d/control
>
> including configuration file /etc/freeradius/policy.d/filter
>
> including configuration file /etc/freeradius/policy.d/canonicalization
>
> including configuration file /etc/freeradius/policy.d/accounting
>
> including files in directory /etc/freeradius/sites-enabled/
>
> including configuration file /etc/freeradius/sites-enabled/inner-tunnel
>
> including configuration file /etc/freeradius/sites-enabled/default
>
> main {
>
>  security {
>
>   user = "freerad"
>
>   group = "freerad"
>
>   allow_core_dumps = no
>
>  }
>
> }
>
> main {
>
> name = "freeradius"
>
> prefix = "/usr"
>
> localstatedir = "/var"
>
> sbindir = "/usr/sbin"
>
> logdir = "/var/log/freeradius"
>
> run_dir = "/var/run/freeradius"
>
> libdir = "/usr/lib/freeradius"
>
> radacctdir = "/var/log/freeradius/radacct"
>
> hostname_lookups = no
>
> max_request_time = 30
>
> cleanup_delay = 5
>
> max_requests = 1024
>
> pidfile = "/var/run/freeradius/freeradius.pid"
>
> checkrad = "/usr/sbin/checkrad"
>
> debug_level = 0
>
> proxy_requests = no
>
>  log {
>
>   stripped_names = no
>
>   auth = no
>
>   auth_badpass = no
>
>   auth_goodpass = no
>
>   colourise = yes
>
>  }
>
>  security {
>
>   max_attributes = 200
>
>   reject_delay = 1
>
>   status_server = yes
>
>  }
>
> }
>
> radiusd: #### Loading Realms and Home Servers ####
>
>  proxy server {
>
>   retry_delay = 5
>
>   retry_count = 3
>
>   default_fallback = no
>
>   dead_time = 120
>
>   wake_all_if_all_dead = no
>
>  }
>
>  home_server localhost {
>
>   ipaddr = 127.0.0.1
>
>   port = 1812
>
>   type = "auth"
>
>   secret = "testing123"
>
>   response_window = 20
>
>   max_outstanding = 65536
>
>   zombie_period = 40
>
>   status_check = "status-server"
>
>   ping_interval = 30
>
>   check_interval = 30
>
>   num_answers_to_alive = 3
>
>   revive_interval = 120
>
>   status_check_timeout = 4
>
>   coa {
>
>   irt = 2
>
>   mrt = 16
>
>   mrc = 5
>
>   mrd = 30
>
>   }
>
>   limit {
>
>   max_connections = 16
>
>   max_requests = 0
>
>   lifetime = 0
>
>   idle_timeout = 0
>
>   }
>
>  }
>
>  home_server_pool my_auth_failover {
>
> type = fail-over
>
> home_server = localhost
>
>  }
>
>  realm example.com {
>
> auth_pool = my_auth_failover
>
>  }
>
>  realm LOCAL {
>
>  }
>
> radiusd: #### Loading Clients ####
>
>  client localhost {
>
>   ipaddr = 127.0.0.1
>
>   require_message_authenticator = no
>
>   secret = "radius"
>
>   shortname = "localhost"
>
>   nas_type = "other"
>
>   proto = "*"
>
>   limit {
>
>   max_connections = 16
>
>   lifetime = 0
>
>   idle_timeout = 30
>
>   }
>
>  }
>
>  client 27.33.228.125 {
>
>   require_message_authenticator = no
>
>   secret = "radius"
>
>   shortname = "14kimberleyst"
>
>   nas_type = "mikrotik"
>
>   limit {
>
>   max_connections = 16
>
>   lifetime = 0
>
>   idle_timeout = 30
>
>   }
>
>  }
>
>  client 220.244.108.10 {
>
>   require_message_authenticator = no
>
>   secret = "radius"
>
>   shortname = "30cookst"
>
>   nas_type = "mikrotik_snmp"
>
>   limit {
>
>   max_connections = 16
>
>   lifetime = 0
>
>   idle_timeout = 30
>
>   }
>
>  }
>
>  client 10.1.1.22/24 {
>
>   require_message_authenticator = no
>
>   secret = "radius"
>
>   shortname = "MikroTik"
>
>   limit {
>
>   max_connections = 16
>
>   lifetime = 0
>
>   idle_timeout = 30
>
>   }
>
>  }
>
>  client 99hamilton.no-ip.biz {
>
>   require_message_authenticator = no
>
>   secret = "radius"
>
>   shortname = "99hamilton"
>
>   nas_type = "mikrotik"
>
>   limit {
>
>   max_connections = 16
>
>   lifetime = 0
>
>   idle_timeout = 30
>
>   }
>
>  }
>
> radiusd: #### Instantiating modules ####
>
>  instantiate {
>
>  }
>
>  modules {
>
>   # Loaded module rlm_eap
>
>   # Instantiating module "eap" from file /etc/freeradius/mods-enabled/eap
>
>   eap {
>
>   default_eap_type = "md5"
>
>   timer_expire = 60
>
>   ignore_unknown_eap_types = no
>
>   mod_accounting_username_bug = no
>
>   max_sessions = 4096
>
>   }
>
>    # Linked to sub-module rlm_eap_md5
>
>    # Linked to sub-module rlm_eap_leap
>
>    # Linked to sub-module rlm_eap_gtc
>
>    gtc {
>
>    challenge = "Password: "
>
>    auth_type = "PAP"
>
>    }
>
>    # Linked to sub-module rlm_eap_tls
>
>    tls {
>
>    tls = "tls-common"
>
>    }
>
>    tls-config tls-common {
>
>    rsa_key_exchange = no
>
>    dh_key_exchange = yes
>
>    rsa_key_length = 512
>
>    dh_key_length = 512
>
>    verify_depth = 0
>
>    ca_path = "/etc/freeradius/certs"
>
>    pem_file_type = yes
>
>    private_key_file = "/etc/freeradius/certs/server.pem"
>
>    certificate_file = "/etc/freeradius/certs/server.pem"
>
>    ca_file = "/etc/freeradius/certs/ca.pem"
>
>    private_key_password = "whatever"
>
>    dh_file = "/etc/freeradius/certs/dh"
>
>    fragment_size = 1024
>
>    include_length = yes
>
>    check_crl = no
>
>    cipher_list = "DEFAULT"
>
>    ecdh_curve = "prime256v1"
>
>     cache {
>
>     enable = yes
>
>     lifetime = 24
>
>     max_entries = 255
>
>     }
>
>     verify {
>
>     }
>
>     ocsp {
>
>     enable = no
>
>     override_cert_url = yes
>
>     url = "http://127.0.0.1/ocsp/"
>
>     use_nonce = yes
>
>     timeout = 0
>
>     softfail = yes
>
>     }
>
>    }
>
>    # Linked to sub-module rlm_eap_ttls
>
>    ttls {
>
>    tls = "tls-common"
>
>    default_eap_type = "md5"
>
>    copy_request_to_tunnel = no
>
>    use_tunneled_reply = no
>
>    virtual_server = "inner-tunnel"
>
>    include_length = yes
>
>    require_client_cert = no
>
>    }
>
> Using cached TLS configuration from previous invocation
>
>    # Linked to sub-module rlm_eap_peap
>
>    peap {
>
>    tls = "tls-common"
>
>    default_method = "mschapv2"
>
>    copy_request_to_tunnel = no
>
>    use_tunneled_reply = no
>
>    proxy_tunneled_request_as_eap = yes
>
>    virtual_server = "inner-tunnel"
>
>    soh = no
>
>    require_client_cert = no
>
>    }
>
> Using cached TLS configuration from previous invocation
>
>    # Linked to sub-module rlm_eap_mschapv2
>
>    mschapv2 {
>
>    with_ntdomain_hack = no
>
>    send_error = no
>
>    }
>
>   # Loaded module rlm_always
>
>   # Instantiating module "fail" from file
/etc/freeradius/mods-enabled/always
>
>   always fail {
>
>   rcode = "fail"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "reject" from file
/etc/freeradius/mods-enabled/always
>
>   always reject {
>
>   rcode = "reject"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "noop" from file
/etc/freeradius/mods-enabled/always
>
>   always noop {
>
>   rcode = "noop"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "handled" from file
/etc/freeradius/mods-enabled/always
>
>   always handled {
>
>   rcode = "handled"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "updated" from file
/etc/freeradius/mods-enabled/always
>
>   always updated {
>
>   rcode = "updated"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "notfound" from file
/etc/freeradius/mods-enabled/always
>
>   always notfound {
>
>   rcode = "notfound"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Instantiating module "ok" from file
/etc/freeradius/mods-enabled/always
>
>   always ok {
>
>   rcode = "ok"
>
>   simulcount = 0
>
>   mpp = no
>
>   }
>
>   # Loaded module rlm_dynamic_clients
>
>   # Instantiating module "dynamic_clients" from file
/etc/freeradius/mods-enabled/dynamic_clients
>
>   # Loaded module rlm_detail
>
>   # Instantiating module "auth_log" from file
/etc/freeradius/mods-enabled/detail.log
>
>   detail auth_log {
>
>   filename =
"/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d"
>
>   header = "%t"
>
>   permissions = 384
>
>   dir_permissions = 493
>
>   locking = no
>
>   log_packet_header = no
>
>   }
>
> rlm_detail (auth_log): 'User-Password' suppressed, will not appear in
detail output
>
>   # Instantiating module "reply_log" from file
/etc/freeradius/mods-enabled/detail.log
>
>   detail reply_log {
>
>   filename =
"/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d"
>
>   header = "%t"
>
>   permissions = 384
>
>   dir_permissions = 493
>
>   locking = no
>
>   log_packet_header = no
>
>   }
>
>   # Instantiating module "pre_proxy_log" from file
/etc/freeradius/mods-enabled/detail.log
>
>   detail pre_proxy_log {
>
>   filename =
"/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d"
>
>   header = "%t"
>
>   permissions = 384
>
>   dir_permissions = 493
>
>   locking = no
>
>   log_packet_header = no
>
>   }
>
>   # Instantiating module "post_proxy_log" from file
/etc/freeradius/mods-enabled/detail.log
>
>   detail post_proxy_log {
>
>   filename =
"/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d"
>
>   header = "%t"
>
>   permissions = 384
>
>   dir_permissions = 493
>
>   locking = no
>
>   log_packet_header = no
>
>   }
>
>   # Instantiating module "detail" from file
/etc/freeradius/mods-enabled/detail
>
>   detail {
>
>   filename =
"/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d"
>
>   header = "%t"
>
>   permissions = 384
>
>   dir_permissions = 493
>
>   locking = no
>
>   log_packet_header = no
>
>   }
>
>   # Loaded module rlm_radutmp
>
>   # Instantiating module "sradutmp" from file
/etc/freeradius/mods-enabled/sradutmp
>
>   radutmp sradutmp {
>
>   filename = "/var/log/freeradius/sradutmp"
>
>   username = "%{User-Name}"
>
>   case_sensitive = yes
>
>   check_with_nas = yes
>
>   permissions = 420
>
>   caller_id = no
>
>   }
>
>   # Loaded module rlm_expiration
>
>   # Instantiating module "expiration" from file
/etc/freeradius/mods-enabled/expiration
>
>   # Loaded module rlm_preprocess
>
>   # Instantiating module "preprocess" from file
/etc/freeradius/mods-enabled/preprocess
>
>   preprocess {
>
>   huntgroups = "/etc/freeradius/mods-config/preprocess/huntgroups"
>
>   hints = "/etc/freeradius/mods-config/preprocess/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
>
>   }
>
> reading pairlist file /etc/freeradius/mods-config/preprocess/huntgroups
>
> reading pairlist file /etc/freeradius/mods-config/preprocess/hints
>
>   # Loaded module rlm_logintime
>
>   # Instantiating module "logintime" from file
/etc/freeradius/mods-enabled/logintime
>
>   logintime {
>
>   minimum_timeout = 60
>
>   }
>
>   # Loaded module rlm_soh
>
>   # Instantiating module "soh" from file /etc/freeradius/mods-enabled/soh
>
>   soh {
>
>   dhcp = yes
>
>   }
>
>   # Loaded module rlm_dhcp
>
>   # Instantiating module "dhcp" from file
/etc/freeradius/mods-enabled/dhcp
>
>   # Instantiating module "radutmp" from file
/etc/freeradius/mods-enabled/radutmp
>
>   radutmp {
>
>   filename = "/var/log/freeradius/radutmp"
>
>   username = "%{User-Name}"
>
>   case_sensitive = yes
>
>   check_with_nas = yes
>
>   permissions = 384
>
>   caller_id = yes
>
>   }
>
>   # Loaded module rlm_digest
>
>   # Instantiating module "digest" from file
/etc/freeradius/mods-enabled/digest
>
>   # Loaded module rlm_exec
>
>   # Instantiating module "exec" from file
/etc/freeradius/mods-enabled/exec
>
>   exec {
>
>   wait = no
>
>   input_pairs = "request"
>
>   shell_escape = yes
>
>   timeout = 10
>
>   }
>
>   # Instantiating module "echo" from file
/etc/freeradius/mods-enabled/echo
>
>   exec echo {
>
>   wait = yes
>
>   program = "/bin/echo %{User-Name}"
>
>   input_pairs = "request"
>
>   output_pairs = "reply"
>
>   shell_escape = yes
>
>   }
>
>   # Loaded module rlm_replicate
>
>   # Instantiating module "replicate" from file
/etc/freeradius/mods-enabled/replicate
>
>   # Loaded module rlm_cache
>
>   # Instantiating module "cache_eap" from file
/etc/freeradius/mods-enabled/cache_eap
>
>   cache cache_eap {
>
>   key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}"
>
>   ttl = 15
>
>   max_entries = 16384
>
>   epoch = 0
>
>   add_stats = no
>
>   }
>
>   # Loaded module rlm_linelog
>
>   # Instantiating module "linelog" from file
/etc/freeradius/mods-enabled/linelog
>
>   linelog {
>
>   filename = "/var/log/freeradius/linelog"
>
>   permissions = 384
>
>   format = "This is a log message for %{User-Name}"
>
>   reference = "%{%{Packet-Type}:-format}"
>
>   }
>
>   # Loaded module rlm_utf8
>
>   # Instantiating module "utf8" from file
/etc/freeradius/mods-enabled/utf8
>
>   # Loaded module rlm_attr_filter
>
>   # Instantiating module "attr_filter.post-proxy" from file
/etc/freeradius/mods-enabled/attr_filter
>
>   attr_filter attr_filter.post-proxy {
>
>   filename = "/etc/freeradius/mods-config/attr_filter/post-proxy"
>
>   key = "%{Realm}"
>
>   relaxed = no
>
>   }
>
> reading pairlist file /etc/freeradius/mods-config/attr_filter/post-proxy
>
>   # Instantiating module "attr_filter.pre-proxy" from file
/etc/freeradius/mods-enabled/attr_filter
>
>   attr_filter attr_filter.pre-proxy {
>
>   filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy"
>
>   key = "%{Realm}"
>
>   relaxed = no
>
>   }
>
> reading pairlist file /etc/freeradius/mods-config/attr_filter/pre-proxy
>
>   # Instantiating module "attr_filter.access_reject" from file
/etc/freeradius/mods-enabled/attr_filter
>
>   attr_filter attr_filter.access_reject {
>
>   filename = "/etc/freeradius/mods-config/attr_filter/access_reject"
>
>   key = "%{User-Name}"
>
>   relaxed = no
>
>   }
>
> reading pairlist file
/etc/freeradius/mods-config/attr_filter/access_reject
>
>   # Instantiating module "attr_filter.access_challenge" from file
/etc/freeradius/mods-enabled/attr_filter
>
>   attr_filter attr_filter.access_challenge {
>
>   filename = "/etc/freeradius/mods-config/attr_filter/access_challenge"
>
>   key = "%{User-Name}"
>
>   relaxed = no
>
>   }
>
> reading pairlist file
/etc/freeradius/mods-config/attr_filter/access_challenge
>
>   # Instantiating module "attr_filter.accounting_response" from file
/etc/freeradius/mods-enabled/attr_filter
>
>   attr_filter attr_filter.accounting_response {
>
>   filename = "/etc/freeradius/mods-config/attr_filter/accounting_response"
>
>   key = "%{User-Name}"
>
>   relaxed = no
>
>   }
>
> reading pairlist file
/etc/freeradius/mods-config/attr_filter/accounting_response
>
>   # Loaded module rlm_chap
>
>   # Instantiating module "chap" from file
/etc/freeradius/mods-enabled/chap
>
>   # Loaded module rlm_realm
>
>   # Instantiating module "IPASS" from file
/etc/freeradius/mods-enabled/realm
>
>   realm IPASS {
>
>   format = "prefix"
>
>   delimiter = "/"
>
>   ignore_default = no
>
>   ignore_null = no
>
>   }
>
>   # Instantiating module "suffix" from file
/etc/freeradius/mods-enabled/realm
>
>   realm suffix {
>
>   format = "suffix"
>
>   delimiter = "@"
>
>   ignore_default = no
>
>   ignore_null = no
>
>   }
>
>   # Instantiating module "realmpercent" from file
/etc/freeradius/mods-enabled/realm
>
>   realm realmpercent {
>
>   format = "suffix"
>
>   delimiter = "%"
>
>   ignore_default = no
>
>   ignore_null = no
>
>   }
>
>   # Instantiating module "ntdomain" from file
/etc/freeradius/mods-enabled/realm
>
>   realm ntdomain {
>
>   format = "prefix"
>
>   delimiter = "\"
>
>   ignore_default = no
>
>   ignore_null = no
>
>   }
>
>   # Loaded module rlm_passwd
>
>   # Instantiating module "etc_passwd" from file
/etc/freeradius/mods-enabled/passwd
>
>   passwd etc_passwd {
>
>   filename = "/etc/passwd"
>
>   format = "*User-Name:Crypt-Password:"
>
>   delimiter = ":"
>
>   ignore_nislike = no
>
>   ignore_empty = yes
>
>   allow_multiple_keys = no
>
>   hash_size = 100
>
>   }
>
> rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no
>
>   # Instantiating module "ntlm_auth" from file
/etc/freeradius/mods-enabled/ntlm_auth
>
>   exec ntlm_auth {
>
>   wait = yes
>
>   program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN
--username=%{mschap:User-Name} --password=%{User-Password}"
>
>   shell_escape = yes
>
>   }
>
>   # Loaded module rlm_sql
>
>   # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql
>
>   sql {
>
>   driver = "rlm_sql_mysql"
>
>   server = "localhost"
>
>   port = "3306"
>
>   login = "radius"
>
>   password = "fheman"
>
>   radius_db = "radius"
>
>   read_groups = yes
>
>   read_clients = yes
>
>   delete_stale_sessions = yes
>
>   sql_user_name = "%{User-Name}"
>
>   default_user_profile = ""
>
>   client_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"
>
>   group_membership_query = "SELECT groupname FROM radusergroup WHERE
username = '%{SQL-User-Name}' ORDER BY priority"
>
>   simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username =
'%{SQL-User-Name}' AND acctstoptime IS NULL"
>
>   simul_verify_query = "SELECT radacctid, acctsessionid, username,
nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol
FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL"
>
>   safe_characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
>
>   }
>
>    accounting {
>
>    reference = "%{tolower:type.%{Acct-Status-Type}.query}"
>
>    }
>
>    post-auth {
>
>    reference = ".query"
>
>    }
>
>    mysql {
>
>     tls {
>
>     }
>
>    }
>
> rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
>
> rlm_sql (sql): Attempting to connect to database "radius"
>
> rlm_sql (sql): Initialising connection pool
>
>    pool {
>
>    start = 5
>
>    min = 4
>
>    max = 10
>
>    spare = 3
>
>    uses = 0
>
>    lifetime = 0
>
>    cleanup_delay = 5
>
>    idle_timeout = 60
>
>    spread = no
>
>    }
>
> rlm_sql (sql): Opening additional connection (0)
>
> rlm_sql_mysql: Starting connect to MySQL server
>
> ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20140512/af696d67/attachment-0001.html>


More information about the Freeradius-Users mailing list