<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi everybody,<br>I am trying to set up freeradius so that it authenticates off a myql database. sql.conf is being included in the config. But the rlm_sql is never loaded and I have been trying to figure out why. It does not appear to even try to connect to the database and I am stumped as to why. <br><br><span>I have also followed (<a target="_blank" href="http://wiki.freeradius.org/SQL_HOWTO">http://wiki.freeradius.org/SQL_HOWTO</a>) to no avail. </span><br style="font-style: italic;"><br style="font-style: italic;"><br style="font-style: italic;"><br style="font-style: italic;"><span style="font-style: italic;"># /usr/sbin/freeradius -X</span><br style="font-style: italic;"><span style="font-style: italic;">FreeRADIUS Version 2.0.4, for host
i486-pc-linux-gnu, built on Sep 7 2008 at 23:35:34</span><br style="font-style: italic;"><span style="font-style: italic;">Copyright (C) 1999-2008 The FreeRADIUS server project and contributors.</span><br style="font-style: italic;"><span style="font-style: italic;">There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A</span><br style="font-style: italic;"><span style="font-style: italic;">PARTICULAR PURPOSE.</span><br style="font-style: italic;"><span style="font-style: italic;">You may redistribute copies of FreeRADIUS under the terms of the</span><br style="font-style: italic;"><span style="font-style: italic;">GNU General Public License.</span><br style="font-style: italic;"><span style="font-style: italic;">Starting - reading configuration files ...</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/radiusd.conf</span><br style="font-style: italic;"><span
style="font-style: italic;">including configuration file /etc/freeradius/proxy.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/clients.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/snmp.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/eap.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/sql.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/sql/mysql/dialup.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/policy.conf</span><br style="font-style: italic;"><span style="font-style: italic;">including files in directory
/etc/freeradius/sites-enabled/</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/sites-enabled/default</span><br style="font-style: italic;"><span style="font-style: italic;">including configuration file /etc/freeradius/sites-enabled/inner-tunnel</span><br style="font-style: italic;"><span style="font-style: italic;">including dictionary file /etc/freeradius/dictionary</span><br style="font-style: italic;"><span style="font-style: italic;">main {</span><br style="font-style: italic;"><span style="font-style: italic;"> prefix = "/usr"</span><br style="font-style: italic;"><span style="font-style: italic;"> localstatedir = "/var"</span><br style="font-style: italic;"><span style="font-style: italic;"> logdir = "/var/log/freeradius"</span><br style="font-style:
italic;"><span style="font-style: italic;"> libdir = "/usr/lib/freeradius"</span><br style="font-style: italic;"><span style="font-style: italic;"> radacctdir = "/var/log/freeradius/radacct"</span><br style="font-style: italic;"><span style="font-style: italic;"> hostname_lookups = no</span><br style="font-style: italic;"><span style="font-style: italic;"> max_request_time = 30</span><br style="font-style: italic;"><span style="font-style: italic;"> cleanup_delay = 5</span><br style="font-style: italic;"><span style="font-style: italic;"> max_requests = 1024</span><br style="font-style: italic;"><span style="font-style: italic;"> allow_core_dumps = no</span><br
style="font-style: italic;"><span style="font-style: italic;"> pidfile = "/var/run/freeradius/freeradius.pid"</span><br style="font-style: italic;"><span style="font-style: italic;"> user = "freerad"</span><br style="font-style: italic;"><span style="font-style: italic;"> group = "freerad"</span><br style="font-style: italic;"><span style="font-style: italic;"> checkrad = "/usr/sbin/checkrad"</span><br style="font-style: italic;"><span style="font-style: italic;"> debug_level = 0</span><br style="font-style: italic;"><span style="font-style: italic;"> proxy_requests = no</span><br style="font-style: italic;"><span style="font-style: italic;"> security {</span><br style="font-style: italic;"><span
style="font-style: italic;"> max_attributes = 200</span><br style="font-style: italic;"><span style="font-style: italic;"> reject_delay = 1</span><br style="font-style: italic;"><span style="font-style: italic;"> status_server = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;"> client localhost {</span><br style="font-style: italic;"><span style="font-style: italic;"> ipaddr = 127.0.0.1</span><br style="font-style: italic;"><span style="font-style: italic;"> require_message_authenticator = no</span><br style="font-style: italic;"><span style="font-style:
italic;"> secret = "testing123"</span><br style="font-style: italic;"><span style="font-style: italic;"> nastype = "other"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">radiusd: #### Loading Realms and Home Servers ####</span><br style="font-style: italic;"><span style="font-style: italic;"> proxy server {</span><br style="font-style: italic;"><span style="font-style: italic;"> retry_delay = 5</span><br style="font-style: italic;"><span style="font-style: italic;"> retry_count = 3</span><br style="font-style: italic;"><span style="font-style: italic;"> default_fallback = no</span><br style="font-style: italic;"><span style="font-style:
italic;"> dead_time = 120</span><br style="font-style: italic;"><span style="font-style: italic;"> wake_all_if_all_dead = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> home_server localhost {</span><br style="font-style: italic;"><span style="font-style: italic;"> ipaddr = 127.0.0.1</span><br style="font-style: italic;"><span style="font-style: italic;"> port = 1812</span><br style="font-style: italic;"><span style="font-style: italic;"> type = "auth"</span><br style="font-style: italic;"><span style="font-style: italic;"> secret = "testing123"</span><br style="font-style: italic;"><span
style="font-style: italic;"> response_window = 20</span><br style="font-style: italic;"><span style="font-style: italic;"> max_outstanding = 65536</span><br style="font-style: italic;"><span style="font-style: italic;"> zombie_period = 40</span><br style="font-style: italic;"><span style="font-style: italic;"> status_check = "status-server"</span><br style="font-style: italic;"><span style="font-style: italic;"> ping_check = "none"</span><br style="font-style: italic;"><span style="font-style: italic;"> ping_interval = 30</span><br style="font-style: italic;"><span style="font-style: italic;"> check_interval = 30</span><br style="font-style: italic;"><span
style="font-style: italic;"> num_answers_to_alive = 3</span><br style="font-style: italic;"><span style="font-style: italic;"> num_pings_to_alive = 3</span><br style="font-style: italic;"><span style="font-style: italic;"> revive_interval = 120</span><br style="font-style: italic;"><span style="font-style: italic;"> status_check_timeout = 4</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> home_server_pool my_auth_failover {</span><br style="font-style: italic;"><span style="font-style: italic;"> type = fail-over</span><br style="font-style: italic;"><span style="font-style: italic;"> home_server =
localhost</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> realm example.com {</span><br style="font-style: italic;"><span style="font-style: italic;"> auth_pool = my_auth_failover</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> realm LOCAL {</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">radiusd: #### Instantiating modules ####</span><br style="font-style: italic;"><span style="font-style: italic;"> instantiate {</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_exec</span><br style="font-style: italic;"><span style="font-style:
italic;"> Module: Instantiating exec</span><br style="font-style: italic;"><span style="font-style: italic;"> exec {</span><br style="font-style: italic;"><span style="font-style: italic;"> wait = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> input_pairs = "request"</span><br style="font-style: italic;"><span style="font-style: italic;"> shell_escape = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_expr</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating expr</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_expiration</span><br
style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating expiration</span><br style="font-style: italic;"><span style="font-style: italic;"> expiration {</span><br style="font-style: italic;"><span style="font-style: italic;"> reply-message = "Password Has Expired "</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_logintime</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating logintime</span><br style="font-style: italic;"><span style="font-style: italic;"> logintime {</span><br style="font-style: italic;"><span style="font-style: italic;"> reply-message = "You are calling outside your allowed timespan "</span><br style="font-style:
italic;"><span style="font-style: italic;"> minimum-timeout = 60</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">radiusd: #### Loading Virtual Servers ####</span><br style="font-style: italic;"><span style="font-style: italic;">server inner-tunnel {</span><br style="font-style: italic;"><span style="font-style: italic;"> modules {</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking authenticate {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_pap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating pap</span><br style="font-style: italic;"><span
style="font-style: italic;"> pap {</span><br style="font-style: italic;"><span style="font-style: italic;"> encryption_scheme = "auto"</span><br style="font-style: italic;"><span style="font-style: italic;"> auto_header = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_chap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating chap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_mschap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating mschap</span><br style="font-style: italic;"><span style="font-style: italic;"> mschap {</span><br style="font-style: italic;"><span
style="font-style: italic;"> use_mppe = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> require_encryption = no</span><br style="font-style: italic;"><span style="font-style: italic;"> require_strong = no</span><br style="font-style: italic;"><span style="font-style: italic;"> with_ntdomain_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_unix</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating unix</span><br style="font-style: italic;"><span style="font-style: italic;"> unix {</span><br style="font-style: italic;"><span style="font-style:
italic;"> radwtmp = "/var/log/freeradius/radwtmp"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_eap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating eap</span><br style="font-style: italic;"><span style="font-style: italic;"> eap {</span><br style="font-style: italic;"><span style="font-style: italic;"> default_eap_type = "md5"</span><br style="font-style: italic;"><span style="font-style: italic;"> timer_expire = 60</span><br style="font-style: italic;"><span style="font-style: italic;"> ignore_unknown_eap_types = no</span><br style="font-style: italic;"><span style="font-style:
italic;"> cisco_accounting_username_bug = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to sub-module rlm_eap_md5</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating eap-md5</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to sub-module rlm_eap_leap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating eap-leap</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to sub-module rlm_eap_gtc</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating eap-gtc</span><br style="font-style: italic;"><span style="font-style: italic;"> gtc {</span><br
style="font-style: italic;"><span style="font-style: italic;"> challenge = "Password: "</span><br style="font-style: italic;"><span style="font-style: italic;"> auth_type = "PAP"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">rlm_eap: Ignoring EAP-Type/tls because we do not have OpenSSL support.</span><br style="font-style: italic;"><span style="font-style: italic;">rlm_eap: Ignoring EAP-Type/ttls because we do not have OpenSSL support.</span><br style="font-style: italic;"><span style="font-style: italic;">rlm_eap: Ignoring EAP-Type/peap because we do not have OpenSSL support.</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to sub-module rlm_eap_mschapv2</span><br style="font-style: italic;"><span style="font-style:
italic;"> Module: Instantiating eap-mschapv2</span><br style="font-style: italic;"><span style="font-style: italic;"> mschapv2 {</span><br style="font-style: italic;"><span style="font-style: italic;"> with_ntdomain_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking authorize {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_realm</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating suffix</span><br style="font-style: italic;"><span style="font-style: italic;"> realm suffix {</span><br style="font-style: italic;"><span style="font-style: italic;"> format = "suffix"</span><br
style="font-style: italic;"><span style="font-style: italic;"> delimiter = "@"</span><br style="font-style: italic;"><span style="font-style: italic;"> ignore_default = no</span><br style="font-style: italic;"><span style="font-style: italic;"> ignore_null = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_files</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating files</span><br style="font-style: italic;"><span style="font-style: italic;"> files {</span><br style="font-style: italic;"><span style="font-style: italic;"> compat = "cistron"</span><br style="font-style: italic;"><span
style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking session {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_radutmp</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating radutmp</span><br style="font-style: italic;"><span style="font-style: italic;"> radutmp {</span><br style="font-style: italic;"><span style="font-style: italic;"> filename = "/var/log/freeradius/radutmp"</span><br style="font-style: italic;"><span style="font-style: italic;"> username = "%{User-Name}"</span><br style="font-style: italic;"><span style="font-style: italic;"> case_sensitive = yes</span><br style="font-style: italic;"><span
style="font-style: italic;"> check_with_nas = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> perm = 384</span><br style="font-style: italic;"><span style="font-style: italic;"> callerid = yes</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking post-proxy {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking post-auth {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_attr_filter</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating attr_filter.access_reject</span><br
style="font-style: italic;"><span style="font-style: italic;"> attr_filter attr_filter.access_reject {</span><br style="font-style: italic;"><span style="font-style: italic;"> attrsfile = "/etc/freeradius/attrs.access_reject"</span><br style="font-style: italic;"><span style="font-style: italic;"> key = "%{User-Name}"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;">server {</span><br style="font-style: italic;"><span style="font-style: italic;"> modules {</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking authenticate {...} for more modules to load</span><br
style="font-style: italic;"><span style="font-style: italic;"> Module: Checking authorize {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_preprocess</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating preprocess</span><br style="font-style: italic;"><span style="font-style: italic;"> preprocess {</span><br style="font-style: italic;"><span style="font-style: italic;"> huntgroups = "/etc/freeradius/huntgroups"</span><br style="font-style: italic;"><span style="font-style: italic;"> hints = "/etc/freeradius/hints"</span><br style="font-style: italic;"><span style="font-style: italic;"> with_ascend_hack = no</span><br style="font-style: italic;"><span style="font-style:
italic;"> ascend_channels_per_line = 23</span><br style="font-style: italic;"><span style="font-style: italic;"> with_ntdomain_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> with_specialix_jetstream_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> with_cisco_vsa_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> with_alvarion_vsa_hack = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking preacct {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to
module rlm_acct_unique</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating acct_unique</span><br style="font-style: italic;"><span style="font-style: italic;"> acct_unique {</span><br style="font-style: italic;"><span style="font-style: italic;"> key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking accounting {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Linked to module rlm_detail</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Instantiating detail</span><br style="font-style: italic;"><span style="font-style: italic;"> detail {</span><br
style="font-style: italic;"><span style="font-style: italic;"> detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d"</span><br style="font-style: italic;"><span style="font-style: italic;"> header = "%t"</span><br style="font-style: italic;"><span style="font-style: italic;"> detailperm = 384</span><br style="font-style: italic;"><span style="font-style: italic;"> dirperm = 493</span><br style="font-style: italic;"><span style="font-style: italic;"> locking = no</span><br style="font-style: italic;"><span style="font-style: italic;"> log_packet_header = no</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span
style="font-style: italic;"> Module: Instantiating attr_filter.accounting_response</span><br style="font-style: italic;"><span style="font-style: italic;"> attr_filter attr_filter.accounting_response {</span><br style="font-style: italic;"><span style="font-style: italic;"> attrsfile = "/etc/freeradius/attrs.accounting_response"</span><br style="font-style: italic;"><span style="font-style: italic;"> key = "%{User-Name}"</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking session {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking post-proxy {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> Module: Checking
post-auth {...} for more modules to load</span><br style="font-style: italic;"><span style="font-style: italic;"> }</span><br style="font-style: italic;"><span style="font-style: italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;">radiusd: #### Opening IP addresses and Ports ####</span><br style="font-style: italic;"><span style="font-style: italic;">listen {</span><br style="font-style: italic;"><span style="font-style: italic;"> type = "auth"</span><br style="font-style: italic;"><span style="font-style: italic;"> ipaddr = *</span><br style="font-style: italic;"><span style="font-style: italic;"> port = 0</span><br style="font-style: italic;"><span style="font-style: italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;">listen {</span><br style="font-style:
italic;"><span style="font-style: italic;"> type = "acct"</span><br style="font-style: italic;"><span style="font-style: italic;"> ipaddr = *</span><br style="font-style: italic;"><span style="font-style: italic;"> port = 0</span><br style="font-style: italic;"><span style="font-style: italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;">main {</span><br style="font-style: italic;"><span style="font-style: italic;"> snmp = no</span><br style="font-style: italic;"><span style="font-style: italic;"> smux_password = ""</span><br style="font-style: italic;"><span style="font-style: italic;"> snmp_write_access = no</span><br style="font-style: italic;"><span style="font-style:
italic;">}</span><br style="font-style: italic;"><span style="font-style: italic;">Listening on authentication address * port 1812</span><br style="font-style: italic;"><span style="font-style: italic;">Listening on accounting address * port 1813</span><br style="font-style: italic;"><span style="font-style: italic;">Ready to process requests.</span><br style="font-style: italic;"><br></div>
</div><br>
</body></html>