Hi Folks, I have freebsd 4.10-RELEASE
with mysql 4.1.1-alpha and freeradius 1.1.0
Radius give me this error:
There are no DB handles to use!
what this error means ?
radiusd -X
ql: 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): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked
rlm_sql (sql): Attempting to connect to root@localhost:/radius
rlm_sql
(sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql
#0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql):
Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql):
Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to
MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql
(sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql
#2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql):
Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql):
Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to
MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql
(sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql
#4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql):
Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded
Acct-Unique-Session-Id
acct_unique: key = "User-Name, Acct-Session-Id,
NAS-IP-Address, Client-IP-Address, NAS-Port"
Module: Instantiated acct_unique
(acct_unique)
Module: Loaded radutmp
radutmp: filename =
"/var/log/radius/radutmp"
radutmp: username =
"%{User-Name}"
radutmp: case_sensitive = yes
radutmp:
check_with_nas = yes
radutmp: perm = 384
radutmp: callerid =
yes
Module: Instantiated radutmp (radutmp)
Listening on authentication
*:1845
Listening on accounting *:1846
Listening on proxy *:1847
Ready
to process requests.
rad_recv: Access-Request packet from host
192.168.1.11:2919, id=83,
length=57
User-Name =
"teste"
User-Password =
"teste"
NAS-IP-Address =
192.168.1.11
NAS-Port =
0
Processing the authorize section of radiusd.conf
modcall:
entering group authorize for request 0
modcall[authorize]: module
"preprocess" returns ok for request 0
modcall[authorize]: module
"chap" returns noop for request 0
rlm_realm: No '@' in User-Name = "teste", looking up realm
NULL
rlm_realm: Found realm "NULL"
rlm_realm: Proxying request from user teste to realm NULL
rlm_realm: Adding Realm = "NULL"
rlm_realm: Authentication
realm is LOCAL.
modcall[authorize]: module "suffix" returns noop for
request 0
radius_xlat: 'teste'
rlm_sql (sql): sql_set_user escaped
user --> 'teste'
radius_xlat: 'SELECT id, UserName, Attribute,
Value, op FROM radcheck WHERE Username = 'teste' ORDER BY id'
rlm_sql (sql):
There are no DB handles to use! skipped 0, tried to connect 0
modcall[authorize]: module "sql" returns fail for request 0
modcall: leaving
group authorize (returns fail) for request 0
Finished request 0
My mysql.log show only connections but querys
no.
What is the min System Requerements to freeradius
work, mem and processor ?
Try to install a old version of
radius?