Instantiation failed for module "sql" Errors initializing modules

Elizabeth Fife fifeeliz1 at hotmail.com
Wed Jan 9 07:29:53 CET 2013


Hi 
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

radiusd -X 

The following error was received
FreeRADIUS Version 2.1.3, for host i386-apple-darwin10.0, built on Apr 11 2011 at 17:19:07
Copyright (C) 1999-2008 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 /private/etc/raddb/radiusd.conf
including configuration file /private/etc/raddb/proxy.conf
including configuration file /private/etc/raddb/clients.conf
including files in directory /private/etc/raddb/modules/
including configuration file /private/etc/raddb/modules/acct_unique
including configuration file /private/etc/raddb/modules/always
including configuration file /private/etc/raddb/modules/attr_filter
including configuration file /private/etc/raddb/modules/attr_rewrite
including configuration file /private/etc/raddb/modules/chap
including configuration file /private/etc/raddb/modules/checkval
including configuration file /private/etc/raddb/modules/counter
including configuration file /private/etc/raddb/modules/detail
including configuration file /private/etc/raddb/modules/detail.example.com
including configuration file /private/etc/raddb/modules/detail.log
including configuration file /private/etc/raddb/modules/digest
including configuration file /private/etc/raddb/modules/echo
including configuration file /private/etc/raddb/modules/etc_group
including configuration file /private/etc/raddb/modules/exec
including configuration file /private/etc/raddb/modules/expiration
including configuration file /private/etc/raddb/modules/expr
including configuration file /private/etc/raddb/modules/files
including configuration file /private/etc/raddb/modules/inner-eap
including configuration file /private/etc/raddb/modules/ippool
including configuration file /private/etc/raddb/modules/krb5
including configuration file /private/etc/raddb/modules/ldap
including configuration file /private/etc/raddb/modules/linelog
including configuration file /private/etc/raddb/modules/logintime
including configuration file /private/etc/raddb/modules/mac2ip
including configuration file /private/etc/raddb/modules/mac2vlan
including configuration file /private/etc/raddb/modules/mschap
including configuration file /private/etc/raddb/modules/opendirectory
including configuration file /private/etc/raddb/modules/pam
including configuration file /private/etc/raddb/modules/pap
including configuration file /private/etc/raddb/modules/passwd
including configuration file /private/etc/raddb/modules/perl
including configuration file /private/etc/raddb/modules/policy
including configuration file /private/etc/raddb/modules/preprocess
including configuration file /private/etc/raddb/modules/radutmp
including configuration file /private/etc/raddb/modules/realm
including configuration file /private/etc/raddb/modules/smbpasswd
including configuration file /private/etc/raddb/modules/sql_log
including configuration file /private/etc/raddb/modules/sqlcounter_expire_on_login
including configuration file /private/etc/raddb/modules/sradutmp
including configuration file /private/etc/raddb/modules/unix
including configuration file /private/etc/raddb/modules/wimax
including configuration file /private/etc/raddb/eap.conf
including configuration file /private/etc/raddb/sql.conf
including configuration file /private/etc/raddb/sql/sqlite/dialup.conf
including configuration file /private/etc/raddb/sql/mysql/counter.conf
including configuration file /private/etc/raddb/policy.conf
including files in directory /private/etc/raddb/sites-enabled/
including configuration file /private/etc/raddb/sites-enabled/default
including configuration file /private/etc/raddb/sites-enabled/inner-tunnel
including dictionary file /private/etc/raddb/dictionary
main {
    prefix = "/usr"
    localstatedir = "/private/var"
    logdir = "/private/var/log/radius"
    libdir = "/usr/lib/freeradius"
    radacctdir = "/private/var/log/radius/radacct"
    hostname_lookups = no
    max_request_time = 30
    cleanup_delay = 5
    max_requests = 1024
    allow_core_dumps = no
    pidfile = "/private/var/run/radiusd/radiusd.pid"
    checkrad = "/usr/sbin/checkrad"
    debug_level = 0
    proxy_requests = yes
 log {
    stripped_names = no
    auth = no
    auth_badpass = no
    auth_goodpass = no
 }
 security {
    max_attributes = 200
    reject_delay = 1
    status_server = yes
 }
}
 client localhost {
    ipaddr = 127.0.0.1
    require_message_authenticator = no
    secret = "testing123"
    nastype = "other"
 }
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
    num_pings_to_alive = 3
    revive_interval = 120
    status_check_timeout = 4
 }
 home_server_pool my_auth_failover {
    type = fail-over
    home_server = localhost
 }
 realm example.com {
    auth_pool = my_auth_failover
 }
 realm LOCAL {
 }
radiusd: #### Instantiating modules ####
 instantiate {
 Module: Linked to module rlm_exec
 Module: Instantiating exec
  exec {
    wait = no
    input_pairs = "request"
    shell_escape = yes
  }
 Module: Linked to module rlm_expr
 Module: Instantiating expr
 Module: Linked to module rlm_expiration
 Module: Instantiating expiration
  expiration {
    reply-message = "Password Has Expired  "
  }
 Module: Linked to module rlm_logintime
 Module: Instantiating logintime
  logintime {
    reply-message = "You are calling outside your allowed timespan  "
    minimum-timeout = 60
  }
 Module: Linked to module rlm_sql
 Module: Instantiating sql
  sql {
    driver = "rlm_sql_sqlite"
    server = "localhost"
    port = ""
    login = "radius"
    password = "radpass"
    radius_db = "radius"
    read_groups = yes
    sqltrace = no
    sqltracefile = "/private/var/log/radius/sqltrace.sql"
    readclients = yes
    deletestalesessions = yes
    num_sql_socks = 5
    sql_user_name = "%{User-Name}"
    default_user_profile = ""
    nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
    authorize_check_query = ""
    authorize_group_check_query = ""
    authorize_group_reply_query = ""
    accounting_onoff_query = ""
    accounting_update_query = ""
    accounting_update_query_alt = ""
    accounting_start_query = ""
    accounting_start_query_alt = ""
    accounting_stop_query = ""
    accounting_stop_query_alt = ""
    connect_failure_retry_delay = 60
    simul_count_query = ""
    simul_verify_query = ""
    postauth_query = ""
    safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
  }
rlm_sql (sql): Driver rlm_sql_sqlite (module rlm_sql_sqlite) loaded and linked
rlm_sql (sql): Attempting to connect to radius at localhost:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #0
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #0
rlm_sql_sqlite: sqlite3_open() = 0 
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #1
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #1
rlm_sql_sqlite: sqlite3_open() = 0 
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #2
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #2
rlm_sql_sqlite: sqlite3_open() = 0 
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #3
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #3
rlm_sql_sqlite: sqlite3_open() = 0 
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #4
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #4
rlm_sql_sqlite: sqlite3_open() = 0 
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 FROM nas
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_sqlite: sqlite3_prepare() = 1 
rlm_sql (sql): Attempting to connect rlm_sql_sqlite #4
rlm_sql_sqlite: Opening sqlite database /private/etc/raddb/sqlite_radius_client_database for #4
rlm_sql_sqlite: sqlite3_open() = 0 
rlm_sql (sql): Connected new DB handle, #4
rlm_sql_sqlite: sqlite3_prepare() = 1 
rlm_sql (sql): failed after re-connect
rlm_sql (sql): database query error, SELECT id,nasname,shortname,type,secret FROM nas: (null)
rlm_sql (sql): Released sql socket id: 4
Failed to load clients from SQL.
rlm_sql (sql): Closing sqlsocket 4
rlm_sql_sqlite: sql_destroy_socket noop. 
rlm_sql (sql): Closing sqlsocket 3
rlm_sql_sqlite: sql_destroy_socket noop. 
rlm_sql (sql): Closing sqlsocket 2
rlm_sql_sqlite: sql_destroy_socket noop. 
rlm_sql (sql): Closing sqlsocket 1
rlm_sql_sqlite: sql_destroy_socket noop. 
rlm_sql (sql): Closing sqlsocket 0
rlm_sql_sqlite: sql_destroy_socket noop. 
/private/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
Errors initializing modules


Never having used the service before I am surprised. Is there something I should do first to prepare before running radius -X

Thanks
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130109/d541c4f3/attachment-0001.html>


More information about the Freeradius-Users mailing list