<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Freeradius + Mysql</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hello i'm use freeradius and mu system is gentoo.<BR>
When i try radiusd -X -A i see this:<BR>
<BR>
Starting - reading configuration files ...<BR>
reread_config: reading radiusd.conf<BR>
Config: including file: /usr/local/etc/raddb/clients.conf<BR>
Config: including file: /usr/local/etc/raddb/eap.conf<BR>
Config: including file: /usr/local/etc/raddb/sql.conf<BR>
main: prefix = "/usr/local"<BR>
main: localstatedir = "/usr/local/var"<BR>
main: logdir = "/usr/local/var/log/radius"<BR>
main: libdir = "/usr/local/lib"<BR>
main: radacctdir = "/usr/local/var/log/radius/radacct"<BR>
main: hostname_lookups = no<BR>
main: max_request_time = 30<BR>
main: cleanup_delay = 5<BR>
main: max_requests = 1024<BR>
main: delete_blocked_requests = 0<BR>
main: port = 0<BR>
main: allow_core_dumps = no<BR>
main: log_stripped_names = no<BR>
main: log_file = "/usr/local/var/log/radius/radius.log"<BR>
main: log_auth = no<BR>
main: log_auth_badpass = no<BR>
main: log_auth_goodpass = no<BR>
main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"<BR>
main: user = "(null)"<BR>
main: group = "(null)"<BR>
main: usercollide = no<BR>
main: lower_user = "no"<BR>
main: lower_pass = "no"<BR>
main: nospace_user = "no"<BR>
main: nospace_pass = "no"<BR>
main: checkrad = "/usr/local/sbin/checkrad"<BR>
main: proxy_requests = yes<BR>
security: max_attributes = 200<BR>
security: reject_delay = 1<BR>
security: status_server = no<BR>
main: debug_level = 0<BR>
read_config_files: reading dictionary<BR>
read_config_files: reading naslist<BR>
Using deprecated naslist file. Support for this will go away soon.<BR>
read_config_files: reading clients<BR>
read_config_files: reading realms<BR>
radiusd: entering modules setup<BR>
Module: Library search path is /usr/local/lib<BR>
Module: Loaded exec<BR>
exec: wait = yes<BR>
exec: program = "(null)"<BR>
exec: input_pairs = "request"<BR>
exec: output_pairs = "(null)"<BR>
exec: packet_type = "(null)"<BR>
rlm_exec: Wait=yes but no output defined. Did you mean output=none?<BR>
Module: Instantiated exec (exec)<BR>
Module: Loaded expr<BR>
Module: Instantiated expr (expr)<BR>
Module: Loaded PAP<BR>
pap: encryption_scheme = "crypt"<BR>
Module: Instantiated pap (pap)<BR>
Module: Loaded CHAP<BR>
Module: Instantiated chap (chap)<BR>
Module: Loaded MS-CHAP<BR>
mschap: use_mppe = yes<BR>
mschap: require_encryption = no<BR>
mschap: require_strong = no<BR>
mschap: with_ntdomain_hack = no<BR>
mschap: passwd = "(null)"<BR>
mschap: authtype = "MS-CHAP"<BR>
mschap: ntlm_auth = "(null)"<BR>
Module: Instantiated mschap (mschap)<BR>
Module: Loaded System<BR>
unix: cache = no<BR>
unix: passwd = "(null)"<BR>
unix: shadow = "(null)"<BR>
unix: group = "(null)"<BR>
unix: radwtmp = "/usr/local/var/log/radius/radwtmp"<BR>
unix: usegroup = no<BR>
unix: cache_reload = 600<BR>
Module: Instantiated unix (unix)<BR>
Module: Loaded eap<BR>
eap: default_eap_type = "md5"<BR>
eap: timer_expire = 60<BR>
eap: ignore_unknown_eap_types = no<BR>
eap: cisco_accounting_username_bug = no<BR>
rlm_eap: Loaded and initialized type md5<BR>
rlm_eap: Loaded and initialized type leap<BR>
gtc: challenge = "Password: "<BR>
gtc: auth_type = "PAP"<BR>
rlm_eap: Loaded and initialized type gtc<BR>
mschapv2: with_ntdomain_hack = no<BR>
rlm_eap: Loaded and initialized type mschapv2<BR>
Module: Instantiated eap (eap)<BR>
Module: Loaded preprocess<BR>
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"<BR>
preprocess: hints = "/usr/local/etc/raddb/hints"<BR>
preprocess: with_ascend_hack = no<BR>
preprocess: ascend_channels_per_line = 23<BR>
preprocess: with_ntdomain_hack = no<BR>
preprocess: with_specialix_jetstream_hack = no<BR>
preprocess: with_cisco_vsa_hack = no<BR>
Module: Instantiated preprocess (preprocess)<BR>
Module: Loaded realm<BR>
realm: format = "suffix"<BR>
realm: delimiter = "@"<BR>
realm: ignore_default = no<BR>
realm: ignore_null = no<BR>
Module: Instantiated realm (suffix)<BR>
Module: Loaded files<BR>
files: usersfile = "/usr/local/etc/raddb/users"<BR>
files: acctusersfile = "/usr/local/etc/raddb/acct_users"<BR>
files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users"<BR>
files: compat = "no"<BR>
Module: Instantiated files (files)<BR>
Module: Loaded SQL<BR>
sql: driver = "rlm_sql_mysql"<BR>
sql: server = "localhost"<BR>
sql: port = ""<BR>
sql: login = "root"<BR>
sql: password = "root"<BR>
sql: radius_db = "radius"<BR>
sql: acct_table = "radacct"<BR>
sql: acct_table2 = "radacct"<BR>
sql: authcheck_table = "radcheck"<BR>
sql: authreply_table = "radreply"<BR>
sql: groupcheck_table = "radgroupcheck"<BR>
sql: groupreply_table = "radgroupreply"<BR>
sql: usergroup_table = "usergroup"<BR>
sql: nas_table = "nas"<BR>
sql: dict_table = "dictionary"<BR>
sql: sqltrace = no<BR>
sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"<BR>
sql: readclients = yes<BR>
sql: deletestalesessions = yes<BR>
sql: num_sql_socks = 5<BR>
sql: sql_user_name = "%{User-Name}"<BR>
sql: default_user_profile = ""<BR>
sql: query_on_not_found = no<BR>
sql: authorize_check_query = "SELECT id, UserName, Attribute, Value,<BR>
op FROM radcheck WHERE Username =<BR>
'%{SQL-User-Name}' ORDER BY id"<BR>
sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value,<BR>
op FROM radreply WHERE Username =<BR>
'%{SQL-User-Name}' ORDER BY id"<BR>
sql: authorize_group_check_query = "SELECT<BR>
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op<BR>
FROM radgroupcheck,usergroup WHERE usergroup.Username =<BR>
'%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName<BR>
ORDER BY radgroupcheck.id"<BR>
sql: authorize_group_reply_query = "SELECT<BR>
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op<BR>
FROM radgroupreply,usergroup WHERE usergroup.Username =<BR>
'%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName<BR>
ORDER BY radgroupreply.id"<BR>
sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',<BR>
AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime),<BR>
AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay =<BR>
'%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND<BR>
NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"<BR>
sql: accounting_update_query = "UPDATE radacct SET<BR>
FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime =<BR>
'%{Acct-Session-Time}', AcctInputOctets =<BR>
'%{Acct-Input-Octets}', AcctOutputOctets =<BR>
'%{Acct-Output-Octets}' WHERE AcctSessionId =<BR>
'%{Acct-Session-Id}' AND UserName =<BR>
'%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'"<BR>
sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId,<BR>
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,<BR>
AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,<BR>
AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,<BR>
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay)<BR>
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',<BR>
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<BR>
'%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} +<BR>
%{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}',<BR>
'%{Acct-Authentic}', '', '%{Acct-Input-Octets}',<BR>
'%{Acct-Output-Octets}', '%{Called-Station-Id}',<BR>
'%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}',<BR>
'%{Framed-IP-Address}', '0')"<BR>
sql: accounting_start_query = "INSERT into radacct (AcctSessionId,<BR>
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,<BR>
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,<BR>
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,<BR>
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,<BR>
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)<BR>
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',<BR>
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<BR>
'%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}',<BR>
'%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}',<BR>
'%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}',<BR>
'%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"<BR>
sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime =<BR>
'%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start =<BR>
'%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND<BR>
UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"<BR>
sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S',<BR>
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =<BR>
'%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}',<BR>
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =<BR>
'%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE<BR>
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'<BR>
AND NASIPAddress = '%{NAS-IP-Address}'"<BR>
sql: accounting_stop_query_alt = "INSERT into radacct (AcctSessionId,<BR>
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,<BR>
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,<BR>
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,<BR>
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,<BR>
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)<BR>
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',<BR>
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',<BR>
'%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} +<BR>
%{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}',<BR>
'%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}',<BR>
'%{Acct-Output-Octets}', '%{Called-Station-Id}',<BR>
'%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}',<BR>
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"<BR>
sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE<BR>
UserName='%{SQL-User-Name}'"<BR>
sql: connect_failure_retry_delay = 60<BR>
sql: simul_count_query = ""<BR>
sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName,<BR>
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId,<BR>
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND<BR>
AcctStopTime = 0"<BR>
sql: postauth_table = "radpostauth"<BR>
sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply,<BR>
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',<BR>
'%{reply:Packet-Type}', NOW())"<BR>
sql: safe-characters =<BR>
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<BR>
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked<BR>
rlm_sql (sql): Attempting to connect to root@localhost:/radius<BR>
rlm_sql (sql): starting 0<BR>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0<BR>
rlm_sql_mysql: Starting connect to MySQL server for #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_mysql #1<BR>
rlm_sql_mysql: Starting connect to MySQL server for #1<BR>
rlm_sql (sql): Connected new DB handle, #1<BR>
rlm_sql (sql): starting 2<BR>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2<BR>
rlm_sql_mysql: Starting connect to MySQL server for #2<BR>
rlm_sql (sql): Connected new DB handle, #2<BR>
rlm_sql (sql): starting 3<BR>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3<BR>
rlm_sql_mysql: Starting connect to MySQL server for #3<BR>
rlm_sql (sql): Connected new DB handle, #3<BR>
rlm_sql (sql): starting 4<BR>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4<BR>
rlm_sql_mysql: Starting connect to MySQL server for #4<BR>
rlm_sql (sql): Connected new DB handle, #4<BR>
rlm_sql (sql): - generate_sql_clients<BR>
rlm_sql (sql): Query: SELECT * FROM nas<BR>
rlm_sql (sql): Reserving sql socket id: 4<BR>
rlm_sql (sql): Released sql socket id: 4<BR>
Module: Instantiated sql (sql)<BR>
Module: Loaded Acct-Unique-Session-Id<BR>
acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address,<BR>
Client-IP-Address, NAS-Port"<BR>
Module: Instantiated acct_unique (acct_unique)<BR>
Module: Loaded detail<BR>
detail: detailfile =<BR>
"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"<BR>
detail: detailperm = 384<BR>
detail: dirperm = 493<BR>
detail: locking = no<BR>
Module: Instantiated detail (detail)<BR>
Module: Loaded radutmp<BR>
radutmp: filename = "/usr/local/var/log/radius/radutmp"<BR>
radutmp: username = "%{User-Name}"<BR>
radutmp: case_sensitive = yes<BR>
radutmp: check_with_nas = yes<BR>
radutmp: perm = 384<BR>
radutmp: callerid = yes<BR>
Module: Instantiated radutmp (radutmp)<BR>
ERROR: Cannot find a configuration entry for module "sql_log".<BR>
radiusd.conf[1961] Unknown module "sql_log".<BR>
radiusd.conf[1927] Failed to parse accounting section.<BR>
<BR>
My Ap is D-Link DWL-900AP+ it's true for this? To see in the screenshot<BR>
the configuration...<BR>
<BR>
Please help me..<BR>
<BR>
Matteo</FONT>
</P>
</BODY>
</HTML>