<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Folks, I have freebsd 4.10-RELEASE
with mysql 4.1.1-alpha and freeradius 1.1.0</FONT></DIV>
<DIV><FONT face=Arial size=2>Radius give me this error: </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>There are no DB handles to use!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>what this error means ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>radiusd -X</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ql: group_membership_query = "SELECT GroupName FROM
usergroup WHERE 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, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId,
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime =
0"<BR> sql: postauth_table = "radpostauth"<BR> sql: postauth_query =
"INSERT into radpostauth (id, user, pass, reply, date) values ('',
'%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}',
NOW())"<BR> sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"<BR>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked<BR>rlm_sql (sql): Attempting to connect to <A
href="mailto:root@localhost:/radius">root@localhost:/radius</A><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>Module: Instantiated sql (sql) <BR>Module: Loaded
Acct-Unique-Session-Id <BR> acct_unique: key = "User-Name, Acct-Session-Id,
NAS-IP-Address, Client-IP-Address, NAS-Port"<BR>Module: Instantiated acct_unique
(acct_unique) <BR>Module: Loaded radutmp <BR> radutmp: filename =
"/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>Listening on authentication
*:1845<BR>Listening on accounting *:1846<BR>Listening on proxy *:1847<BR>Ready
to process requests.</FONT></DIV>
<DIV><FONT face=Arial size=2><BR>rad_recv: Access-Request packet from host
192.168.1.11:2919, id=83,
length=57<BR> User-Name =
"teste"<BR> User-Password =
"teste"<BR> NAS-IP-Address =
192.168.1.11<BR> NAS-Port =
0<BR> Processing the authorize section of radiusd.conf<BR>modcall:
entering group authorize for request 0<BR> modcall[authorize]: module
"preprocess" returns ok for request 0<BR> modcall[authorize]: module
"chap" returns noop for request 0<BR> rlm_realm: No <A
href="mailto:'@'">'@'</A> in User-Name = "teste", looking up realm
NULL<BR> rlm_realm: Found realm "NULL"<BR>
rlm_realm: Proxying request from user teste to realm NULL<BR>
rlm_realm: Adding Realm = "NULL"<BR> rlm_realm: Authentication
realm is LOCAL.<BR> modcall[authorize]: module "suffix" returns noop for
request 0<BR>radius_xlat: 'teste'<BR>rlm_sql (sql): sql_set_user escaped
user --> 'teste'<BR>radius_xlat: 'SELECT id, UserName, Attribute,
Value, op FROM radcheck WHERE Username = 'teste' ORDER BY id'<BR>rlm_sql (sql):
There are no DB handles to use! skipped 0, tried to connect 0<BR>
modcall[authorize]: module "sql" returns fail for request 0<BR>modcall: leaving
group authorize (returns fail) for request 0<BR>Finished request 0</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My mysql.log show only connections but querys
no.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What is the min System Requerements to freeradius
work, mem and processor ?</FONT></DIV>
<DIV><FONT face=Arial size=2>Try to install a old version of
radius?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>