<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi <br>I am using MAC OSX server. I was checking out the inbuilt freeradius. I have not altered files related to this service and simply tried<br><br>radiusd -X <br><br>The following error was received<br>FreeRADIUS Version 2.1.3, for host i386-apple-darwin10.0, built on Apr 11 2011 at 17:19:07<br>Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. <br>There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A <br>PARTICULAR PURPOSE. <br>You may redistribute copies of FreeRADIUS under the terms of the <br>GNU General Public License v2. <br>Starting - reading configuration files ...<br>including configuration file /private/etc/raddb/radiusd.conf<br>including configuration file /private/etc/raddb/proxy.conf<br>including configuration file /private/etc/raddb/clients.conf<br>including files in directory /private/etc/raddb/modules/<br>including configuration file /private/etc/raddb/modules/acct_unique<br>including configuration file /private/etc/raddb/modules/always<br>including configuration file /private/etc/raddb/modules/attr_filter<br>including configuration file /private/etc/raddb/modules/attr_rewrite<br>including configuration file /private/etc/raddb/modules/chap<br>including configuration file /private/etc/raddb/modules/checkval<br>including configuration file /private/etc/raddb/modules/counter<br>including configuration file /private/etc/raddb/modules/detail<br>including configuration file /private/etc/raddb/modules/detail.example.com<br>including configuration file /private/etc/raddb/modules/detail.log<br>including configuration file /private/etc/raddb/modules/digest<br>including configuration file /private/etc/raddb/modules/echo<br>including configuration file /private/etc/raddb/modules/etc_group<br>including configuration file /private/etc/raddb/modules/exec<br>including configuration file /private/etc/raddb/modules/expiration<br>including configuration file /private/etc/raddb/modules/expr<br>including configuration file /private/etc/raddb/modules/files<br>including configuration file /private/etc/raddb/modules/inner-eap<br>including configuration file /private/etc/raddb/modules/ippool<br>including configuration file /private/etc/raddb/modules/krb5<br>including configuration file /private/etc/raddb/modules/ldap<br>including configuration file /private/etc/raddb/modules/linelog<br>including configuration file /private/etc/raddb/modules/logintime<br>including configuration file /private/etc/raddb/modules/mac2ip<br>including configuration file /private/etc/raddb/modules/mac2vlan<br>including configuration file /private/etc/raddb/modules/mschap<br>including configuration file /private/etc/raddb/modules/opendirectory<br>including configuration file /private/etc/raddb/modules/pam<br>including configuration file /private/etc/raddb/modules/pap<br>including configuration file /private/etc/raddb/modules/passwd<br>including configuration file /private/etc/raddb/modules/perl<br>including configuration file /private/etc/raddb/modules/policy<br>including configuration file /private/etc/raddb/modules/preprocess<br>including configuration file /private/etc/raddb/modules/radutmp<br>including configuration file /private/etc/raddb/modules/realm<br>including configuration file /private/etc/raddb/modules/smbpasswd<br>including configuration file /private/etc/raddb/modules/sql_log<br>including configuration file /private/etc/raddb/modules/sqlcounter_expire_on_login<br>including configuration file /private/etc/raddb/modules/sradutmp<br>including configuration file /private/etc/raddb/modules/unix<br>including configuration file /private/etc/raddb/modules/wimax<br>including configuration file /private/etc/raddb/eap.conf<br>including configuration file /private/etc/raddb/sql.conf<br>including configuration file /private/etc/raddb/sql/sqlite/dialup.conf<br>including configuration file /private/etc/raddb/sql/mysql/counter.conf<br>including configuration file /private/etc/raddb/policy.conf<br>including files in directory /private/etc/raddb/sites-enabled/<br>including configuration file /private/etc/raddb/sites-enabled/default<br>including configuration file /private/etc/raddb/sites-enabled/inner-tunnel<br>including dictionary file /private/etc/raddb/dictionary<br>main {<br> prefix = "/usr"<br> localstatedir = "/private/var"<br> logdir = "/private/var/log/radius"<br> libdir = "/usr/lib/freeradius"<br> radacctdir = "/private/var/log/radius/radacct"<br> hostname_lookups = no<br> max_request_time = 30<br> cleanup_delay = 5<br> max_requests = 1024<br> allow_core_dumps = no<br> pidfile = "/private/var/run/radiusd/radiusd.pid"<br> checkrad = "/usr/sbin/checkrad"<br> debug_level = 0<br> proxy_requests = yes<br> log {<br> stripped_names = no<br> auth = no<br> auth_badpass = no<br> auth_goodpass = no<br> }<br> security {<br> max_attributes = 200<br> reject_delay = 1<br> status_server = yes<br> }<br>}<br> client localhost {<br> ipaddr = 127.0.0.1<br> require_message_authenticator = no<br> secret = "testing123"<br> nastype = "other"<br> }<br>radiusd: #### Loading Realms and Home Servers ####<br> proxy server {<br> retry_delay = 5<br> retry_count = 3<br> default_fallback = no<br> dead_time = 120<br> wake_all_if_all_dead = no<br> }<br> home_server localhost {<br> ipaddr = 127.0.0.1<br> port = 1812<br> type = "auth"<br> secret = "testing123"<br> response_window = 20<br> max_outstanding = 65536<br> zombie_period = 40<br> status_check = "status-server"<br> ping_interval = 30<br> check_interval = 30<br> num_answers_to_alive = 3<br> num_pings_to_alive = 3<br> revive_interval = 120<br> status_check_timeout = 4<br> }<br> home_server_pool my_auth_failover {<br> type = fail-over<br> home_server = localhost<br> }<br> realm example.com {<br> auth_pool = my_auth_failover<br> }<br> realm LOCAL {<br> }<br>radiusd: #### Instantiating modules ####<br> instantiate {<br> Module: Linked to module rlm_exec<br> Module: Instantiating exec<br> exec {<br> wait = no<br> input_pairs = "request"<br> shell_escape = yes<br> }<br> Module: Linked to module rlm_expr<br> Module: Instantiating expr<br> Module: Linked to module rlm_expiration<br> Module: Instantiating expiration<br> expiration {<br> reply-message = "Password Has Expired "<br> }<br> Module: Linked to module rlm_logintime<br> Module: Instantiating logintime<br> logintime {<br> reply-message = "You are calling outside your allowed timespan "<br> minimum-timeout = 60<br> }<br> Module: Linked to module rlm_sql<br> Module: Instantiating sql<br> sql {<br> driver = "rlm_sql_sqlite"<br> server = "localhost"<br> port = ""<br> login = "radius"<br> password = "radpass"<br> radius_db = "radius"<br> read_groups = yes<br> sqltrace = no<br> sqltracefile = "/private/var/log/radius/sqltrace.sql"<br> readclients = yes<br> deletestalesessions = yes<br> num_sql_socks = 5<br> sql_user_name = "%{User-Name}"<br> default_user_profile = ""<br> nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"<br> authorize_check_query = ""<br> authorize_group_check_query = ""<br> authorize_group_reply_query = ""<br> accounting_onoff_query = ""<br> accounting_update_query = ""<br> accounting_update_query_alt = ""<br> accounting_start_query = ""<br> accounting_start_query_alt = ""<br> accounting_stop_query = ""<br> accounting_stop_query_alt = ""<br> connect_failure_retry_delay = 60<br> simul_count_query = ""<br> simul_verify_query = ""<br> postauth_query = ""<br> safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br> }<br>rlm_sql (sql): Driver rlm_sql_sqlite (module rlm_sql_sqlite) loaded and linked<br>rlm_sql (sql): Attempting to connect to radius@localhost:/radius<br>rlm_sql (sql): starting 0<br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #0<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #0<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #0<br>rlm_sql (sql): starting 1<br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #1<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #1<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #1<br>rlm_sql (sql): starting 2<br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #2<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #2<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #2<br>rlm_sql (sql): starting 3<br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #3<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #3<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #3<br>rlm_sql (sql): starting 4<br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #4<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #4<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #4<br>rlm_sql (sql): Processing generate_sql_clients<br>rlm_sql (sql) in generate_sql_clients: query is SELECT id,nasname,shortname,type,secret FROM nas<br>rlm_sql (sql): Reserving sql socket id: 4<br>rlm_sql_sqlite: sqlite3_prepare() = 1 <br>rlm_sql (sql): Attempting to connect rlm_sql_sqlite #4<br>rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #4<br>rlm_sql_sqlite: sqlite3_open() = 0 <br>rlm_sql (sql): Connected new DB handle, #4<br>rlm_sql_sqlite: sqlite3_prepare() = 1 <br>rlm_sql (sql): failed after re-connect<br>rlm_sql (sql): database query error, SELECT id,nasname,shortname,type,secret FROM nas: (null)<br>rlm_sql (sql): Released sql socket id: 4<br>Failed to load clients from SQL.<br>rlm_sql (sql): Closing sqlsocket 4<br>rlm_sql_sqlite: sql_destroy_socket noop. <br>rlm_sql (sql): Closing sqlsocket 3<br>rlm_sql_sqlite: sql_destroy_socket noop. <br>rlm_sql (sql): Closing sqlsocket 2<br>rlm_sql_sqlite: sql_destroy_socket noop. <br>rlm_sql (sql): Closing sqlsocket 1<br>rlm_sql_sqlite: sql_destroy_socket noop. <br>rlm_sql (sql): Closing sqlsocket 0<br>rlm_sql_sqlite: sql_destroy_socket noop. <br>/private/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"<br>Errors initializing modules<br><br><br>Never having used the service before I am surprised. Is there something I should do first to prepare before running radius -X<br><br>Thanks<br> </div></body>
</html>