[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Mysql startup
From:       System Administrator <web () gct-us ! com>
Date:       2001-03-26 22:54:52
[Download RAW message or body]

Hi all:
Having a little trouble getting freeradius to run in mysql mode.
Compilation went alright.
Startup with radiusd -X indicates the following:
Module: Loaded SQL
  sql: driver = "rlm_sql_mysql"
  sql: server = "localhost"
  sql: login = "radiusd"
  sql: password = "authent*icate"
  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 = yes
  sql: sqltracefile = "/var/log/sqltrace.sql"
  sql: deletestalesessions = yes
  sql: num_sql_socks = 5
  sql: authorize_check_query = "SELECT id,UserName,Attribute,Value FROM 
radcheck
WHERE Username = '%{User-Name}' ORDER BY id"
  sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM 
radreply
WHERE Username = '%{User-Name}' ORDER BY id"
etc.

So it sounds like its starting OK.
However, queries to the server using radtest return reject
and sqltrace.sql is blank.

 From reading the archives, it sounds like a library for with mysql or 
mysqlclient may not be linking properly, but I'm not exactly sure how to 
debug from here.

ANy ideas would be welcome.

GCT System Administrator



[prev in list] [next in list] [prev in thread] [next in thread]