radiusd.conf[14]: sql: Module instantiation failed.

Discussion in 'Installation/Configuration' started by euslemoc, Aug 4, 2006.

  1. euslemoc

    euslemoc New Member

    how to settle this problem..please help me..i'm newbiz in linux..
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Can you explain your problem in more detail? Which distribution do you use, what did you do before you got this error, what's in the logs, etc...
     
  3. euslemoc

    euslemoc New Member

    i'm run debug "radiusd -X" this problem appear...i install mysql from linux package
     
  4. euslemoc

    euslemoc New Member

    this debug when i run radiusd -X...

    [root@localhost ~]# radiusd -X
    Starting - reading configuration files ...
    reread_config: reading radiusd.conf
    Config: including file: /etc/raddb/proxy.conf
    Config: including file: /etc/raddb/clients.conf
    Config: including file: /etc/raddb/snmp.conf
    Config: including file: /etc/raddb/eap.conf
    Config: including file: /etc/raddb/sql.conf
    main: prefix = "/usr"
    main: localstatedir = "/var"
    main: logdir = "/var/log/radius"
    main: libdir = "/usr/lib"
    main: radacctdir = "/var/log/radius/radacct"
    main: hostname_lookups = no
    main: max_request_time = 30
    main: cleanup_delay = 5
    main: max_requests = 1024
    main: delete_blocked_requests = 0
    main: port = 0
    main: allow_core_dumps = no
    main: log_stripped_names = no
    main: log_file = "/var/log/radius/radius.log"
    main: log_auth = no
    main: log_auth_badpass = no
    main: log_auth_goodpass = no
    main: pidfile = "/var/run/radiusd/radiusd.pid"
    main: user = "radiusd"
    main: group = "radiusd"
    main: usercollide = no
    main: lower_user = "no"
    main: lower_pass = "no"
    main: nospace_user = "no"
    main: nospace_pass = "no"
    main: checkrad = "/usr/sbin/checkrad"
    main: proxy_requests = yes
    proxy: retry_delay = 5
    proxy: retry_count = 3
    proxy: synchronous = no
    proxy: default_fallback = yes
    proxy: dead_time = 120
    proxy: post_proxy_authorize = yes
    proxy: wake_all_if_all_dead = no
    security: max_attributes = 200
    security: reject_delay = 1
    security: status_server = no
    main: debug_level = 0
    read_config_files: reading dictionary
    read_config_files: reading naslist
    Using deprecated naslist file. Support for this will go away soon.
    read_config_files: reading clients
    read_config_files: reading realms
    radiusd: entering modules setup
    Module: Library search path is /usr/lib
    Module: Loaded exec
    exec: wait = yes
    exec: program = "(null)"
    exec: input_pairs = "request"
    exec: output_pairs = "(null)"
    exec: packet_type = "(null)"
    rlm_exec: Wait=yes but no output defined. Did you mean output=none?
    Module: Instantiated exec (exec)
    Module: Loaded expr
    Module: Instantiated expr (expr)
    Module: Loaded PAP
    pap: encryption_scheme = "crypt"
    Module: Instantiated pap (pap)
    Module: Loaded CHAP
    Module: Instantiated chap (chap)
    Module: Loaded MS-CHAP
    mschap: use_mppe = yes
    mschap: require_encryption = no
    mschap: require_strong = no
    mschap: with_ntdomain_hack = no
    mschap: passwd = "(null)"
    mschap: authtype = "MS-CHAP"
    mschap: ntlm_auth = "(null)"
    Module: Instantiated mschap (mschap)
    Module: Loaded eap
    eap: default_eap_type = "md5"
    eap: timer_expire = 60
    eap: ignore_unknown_eap_types = no
    eap: cisco_accounting_username_bug = no
    rlm_eap: Loaded and initialized type md5
    rlm_eap: Loaded and initialized type leap
    gtc: challenge = "Password: "
    gtc: auth_type = "PAP"
    rlm_eap: Loaded and initialized type gtc
    mschapv2: with_ntdomain_hack = no
    rlm_eap: Loaded and initialized type mschapv2
    Module: Instantiated eap (eap)
    Module: Loaded preprocess
    preprocess: huntgroups = "/etc/raddb/huntgroups"
    preprocess: hints = "/etc/raddb/hints"
    preprocess: with_ascend_hack = no
    preprocess: ascend_channels_per_line = 23
    preprocess: with_ntdomain_hack = no
    preprocess: with_specialix_jetstream_hack = no
    preprocess: with_cisco_vsa_hack = no
    Module: Instantiated preprocess (preprocess)
    Module: Loaded files
    files: usersfile = "/etc/raddb/users"
    files: acctusersfile = "/etc/raddb/acct_users"
    files: preproxy_usersfile = "/etc/raddb/preproxy_users"
    files: compat = "no"
    Module: Instantiated files (files)
    Module: Loaded SQL
    sql: driver = "rlm_sql_mysql"
    sql: server = "localhost"
    sql: port = ""
    sql: login = "root"
    sql: password = "123456"
    sql: radius_db = "radius"
    sql: acct_table = "radacct"
    sql: acct_table2 = "radacct"
    sql: authcheck_table = "radcheck"
    sql: authreply_table = "radreply"
    sql: groupcheck_table = "radgroupcheck"
    sql: groupreply_table = "radgroupreply"
    sql: usergroup_table = "usergroup"
    sql: nas_table = "nas"
    sql: dict_table = "dictionary"
    sql: sqltrace = no
    sql: sqltracefile = "/var/log/radius/sqltrace.sql"
    sql: readclients = no
    sql: deletestalesessions = yes
    sql: num_sql_socks = 5
    sql: sql_user_name = "%{User-Name}"
    sql: default_user_profile = ""
    sql: query_on_not_found = no
    sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id"
    sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"
    sql: authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id"
    sql: authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id"
    sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
    sql: accounting_update_query = "UPDATE radacct ? SET FramedIPAddress = '%{Framed-IP-Address}', ? AcctSessionTime = '%{Acct-Session-Time}', ? AcctInputOctets = '%{Acct-Input-Octets}', ? AcctOutputOctets = '%{Acct-Output-Octets}' ? WHERE AcctSessionId = '%{Acct-Session-Id}' ? AND UserName = '%{SQL-User-Name}' ? AND NASIPAddress= '%{NAS-IP-Address}'"
    sql: 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) 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-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')"
    sql: 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) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
    sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
    sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
    sql: 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-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
    sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'"
    sql: connect_failure_retry_delay = 60
    sql: simul_count_query = ""
    sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
    sql: postauth_table = "radpostauth"
    sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:packet-Type}', NOW())"
    sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
    rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory
    rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.
    radiusd.conf[14]: sql: Module instantiation failed.
     
  5. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Which distribution do you use? What's the output of
    Code:
    updatedb
    locate rlm_sql_mysql.so
    ?
     
  6. caliban

    caliban New Member

    Hijacking this thread

    Since it' been dead for a while, and it's exactly the problem I'm having, I'll pick up where it left off.

    My situation is probably slightly different in that I installed FreeRADIUS on a machine that did not have mySQL on it. The reason is that I am keeping my db on another machine. However, when I enabled sql auth, I get pretty much the same errors he was getting.

    I tried installing mySQL to see if there were just missing libraries, but that didn't work.

    Can someone offer some help? (I'm not against saving my config files and starting over.)

    Thank you.

    -Doc
     
  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Are there any errors in your logs?
     
  8. caliban

    caliban New Member


    Hi there,

    Actually I started from scratch again last night. I am now past this problem and troubleshooting the dreaded "There are no DB handles to use!" problem. :-(

    Wish me luck!

    -Doc.
     
  9. ghalban

    ghalban New Member

    you still need help ?

    this messege means you did not make a database to store tables in !
     

Share This Page