Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Freeradius not starting

    Scheduled Pinned Locked Moved pfSense Packages
    2 Posts 1 Posters 1.7k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      anishpsla
      last edited by

      I installed latest version of Pfsense. It works without any problem. I want to install Freeradius2 for authenticating. But the problem is freeradius is not starting properly. Below is the output of radiusd -X

      
      FreeRADIUS Version 2.1.12, for host i386-portbld-freebsd8.1, built on Jun 19 2012 at 09:11:11
      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/modules/motp
      including configuration file /usr/local/etc/raddb/modules/datacounter_acct
      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 = no
      	auth = yes
      	auth_badpass = no
      	auth_goodpass = no
      	msg_badpass = ""
      	msg_goodpass = ""
       }
       security {
      	max_attributes = 200
      	reject_delay = 1
      	status_server = no
       }
      }
      radiusd: #### Loading Realms and Home Servers ####
      radiusd: #### Loading Clients ####
       client pfsense {
      	ipaddr = 127.0.0.1
      	require_message_authenticator = no
      	secret = "pfsense"
      	shortname = "pfsense"
       }
      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 = "/var/log/radacct/timecounter/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: 1359785081 [2013-02-02 11:34:41], Next reset 1359829800 [2013-02-03 00:00:00]
       Module: Instantiating module "weekly" from file /usr/local/etc/raddb/modules/counter
        counter weekly {
      	filename = "/var/log/radacct/timecounter/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: 1359785081 [2013-02-02 11:34:41], Next reset 1359829800 [2013-02-03 00:00:00]
       Module: Instantiating module "monthly" from file /usr/local/etc/raddb/modules/counter
        counter monthly {
      	filename = "/var/log/radacct/timecounter/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: 1359785081 [2013-02-02 11:34:41], Next reset 1362076200 [2013-03-01 00:00:00]
       Module: Instantiating module "forever" from file /usr/local/etc/raddb/modules/counter
        counter forever {
      	filename = "/var/log/radacct/timecounter/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: 1359785081 [2013-02-02 11:34:41], Next reset 0 [2013-02-02 11: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 = MOTP
        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: Instantiating module "motp" from file /usr/local/etc/raddb/modules/motp
        exec motp {
      	wait = yes
      	program = "/usr/local/bin/bash /usr/local/etc/raddb/scripts/otpverify.sh %{request:User-Name} %{request:User-Password} %{reply:MOTP-Init-Secret} %{reply:MOTP-PIN} %{reply:MOTP-Offset}"
      	input_pairs = "request"
      	shell_escape = 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 = "10.44.0.160"
      	port = "3306"
      	login = "root"
      	password = "itcell123"
      	radius_db = "aaa"
      	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 = 10
      	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 root@10.44.0.160:3306/aaa
      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: Instantiating module "datacounterdaily" from file /usr/local/etc/raddb/modules/datacounter_acct
        exec datacounterdaily {
      	wait = yes
      	program = "/bin/sh /usr/local/etc/raddb/scripts/datacounter_acct.sh %{request:User-Name} daily %{request:Acct-Input-Octets} %{request:Acct-Output-Octets}"
      	input_pairs = "request"
      	shell_escape = yes
        }
       Module: Instantiating module "datacounterweekly" from file /usr/local/etc/raddb/modules/datacounter_acct
        exec datacounterweekly {
      	wait = yes
      	program = "/bin/sh /usr/local/etc/raddb/scripts/datacounter_acct.sh %{request:User-Name} weekly %{request:Acct-Input-Octets} %{request:Acct-Output-Octets}"
      	input_pairs = "request"
      	shell_escape = yes
        }
       Module: Instantiating module "datacountermonthly" from file /usr/local/etc/raddb/modules/datacounter_acct
        exec datacountermonthly {
      	wait = yes
      	program = "/bin/sh /usr/local/etc/raddb/scripts/datacounter_acct.sh %{request:User-Name} monthly %{request:Acct-Input-Octets} %{request:Acct-Output-Octets}"
      	input_pairs = "request"
      	shell_escape = yes
        }
       Module: Instantiating module "datacounterforever" from file /usr/local/etc/raddb/modules/datacounter_acct
        exec datacounterforever {
      	wait = yes
      	program = "/bin/sh /usr/local/etc/raddb/scripts/datacounter_acct.sh %{request:User-Name} forever %{request:Acct-Input-Octets} %{request:Acct-Output-Octets}"
      	input_pairs = "request"
      	shell_escape = yes
        }
       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 ####
      The server is not configured to listen on any ports.  Cannot start.
      
      
      1 Reply Last reply Reply Quote 0
      • A
        anishpsla
        last edited by

        I think experts need some more information about my installation.

        It's a Xeon based server. I also installed Squid (not in transparent mode) and working well. Is squid causing problem with Freeradius ?

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.