mysql -uroot -prootpass radius < db_mysql.sqlyou can find db_mysql.sql in the path where you unpacked tarball of freeradius then
it's in these directory
freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
because in that .sql there are all options for accouting and something like that
bye
At 11:35 AM 3/14/2003 +0100, you wrote:
Hello,
I'm having problems with configuring freeRADIUS with MySQL.
I have done (Linux RH 7.3):
- Installed MySQL
- freeRADIUS:
./configure --localstatedir=/var --sysconfdir=/etc
--with-mysql-include-dir=/usr/local/mysql/include
--with-mysql-lib-dir=/usr/local/mysql/lib
--with-mysql-dir=/usr/local/mysql
make
make install
- Added sql to the authorize and accounting sections in radiusd.conf
- Added user information to the following tables in radius database: usergroup,
radcheck, radreply, radgroupreply
- Added "/usr/local/mysql/lib" and "/usr/local " to "/etc/ld.so.conf" and
executed ldconfig
When starting freeRADIUS, apparently everythig is ok until the following error
occurs:
rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search
path of your system's ld.
radiusd.conf[14]: sql: Module instantiation failed.
I would really like to know which is exactly the library(ies) it is attempting to
load at runtime. I really don't know what I'm doing wrong.
Thanks in advance for your help.
Pedro
