Dear All
I would like to use mysql module in freeradius0.7 and
run the "configure" commend as:
****************************************
#./configure --with-mysql-lib-dir=/usr/local/mysql/lib
--with-mysql-include-dir=/usr/local/mysql/include
****************************************
as well as MySql has been installed in
/usr/local/mysql
Here is the warning in configuring rlm_sql_mysql:
*****************************************
#configuring in
rc/modules/rlm_sql/drivers/rlm_sql_mysql
running /bin/sh ./configure
--with-mysql-lib-dir=/usr/local/mysql/lib
--with-mysql-include
-dir=/usr/local/mysql/include --enable-ltdl-install
--enable-ltdl-install --cache-file=../.
./../../.././config.cache --srcdir=.
loading cache ../../../../.././config.cache
checking for gcc... (cached) gcc
checking whether the C compiler (gcc -g -O2
-D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -
D_GNU_SOURCE -DNDEBUG ) works... yes
checking whether the C compiler (gcc -g -O2
-D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -
D_GNU_SOURCE -DNDEBUG ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking how to run the C preprocessor... (cached) gcc
-E
checking for compress in -lz... (cached) no
checking for mysql/mysql.h... no
configure: warning: mysql headers not found. Use
--with-mysql-include-dir=<path>.
configure: warning: sql submodule 'mysql' disabled
creating ./config.status
creating Makefile
****************************************
I neglect the warning and run make, make install.
and the radiusd.conf be modified as
**********************************
authorize {
preprocess
suffix
sql
files
RAS
}
authenticate {
sql
}
preacct {
preprocess
suffix
files
}
accounting {
detail
unix
sql
RAS
radutmp
}
session {
radutmp
}
******************************************
and then starting radius -X, Here is the ouput
**********************************************
read_config_files: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "root"
sql: password = "rootpass"
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 =
"/usr/local/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: authorize_check_query = "SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE Us
ername = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_reply_query = "SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE Us
ername = '%{SQL-User-Name}' ORDER BY id"
.......
rlm_sql: Could not link driver rlm_sql_mysql: file not
found
rlm_sql: Make sure it (and all its dependent
libraries!) are in the search path of your sys
tem's ld.
radiusd.conf[11]: sql: Module instantiation failed.
*********************************************
Can you help me to solve the problem?
Regards
K
_______________________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
