Re: compile w/ mysql
I now have freeradius running and loading the mysql module, but it
doesn't actually write log entries to the database. I installed db_mysql.sql
into the mysql database. I can see radiusd log in to mysql, but it does not
make any log entries into the database. Users still authenticate just fine
and the logs go to /var/log/radacct/ipaddy/detail
and
/var/log/radius.log
Here is what I have in my logs referring to sql:
Info: rlm_sql: Driver rlm_sql_mysql loaded and linked
Info: rlm_sql: Attempting to connect to root@xxx:/dbname
Debug: rlm_sql: Connected new DB handle, #0
Debug: rlm_sql: Connected new DB handle, #1
Debug: rlm_sql: Connected new DB handle, #2
Debug: rlm_sql: Connected new DB handle, #3
Debug: rlm_sql: Connected new DB handle, #4
I might be missing something simple. Here is where radiusd -xx shows
where it is set to log:
Module: Instantiated files (files)
Module: Loaded detail
detail: detailfile = /var/log/radacct/%{Client-IP-Address}/detail
detail: detailperm = 384
detail: dirperm = 493
Module: Instantiated detail (detail)
It looks like I need to tell radiusd that it needs to use mysql for the
details logs, but how do I do that?
Can someone provide some insite for me? Does anyone have a radiusd.conf that
works with mysql, that I can use for reference?
Thanks,
Nick
--
Nick Davis
Associate Systems Administrator
[EMAIL PROTECTED]
Internet Exposure, Inc.
http://www.iexposure.com
(612)676-1946
Web Development-Web Marketing-ISP Services
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: compile w/ mysql
Here is what the output of the ./configure script says: checking for mysql/mysql.h... yes checking for mysql_init in -lmysqlclient... no configure: warning: mysql libraries not found. Use --with-mysql-lib-dir=path. configure: warning: sql submodule 'mysql' disabled Here is the command that I am trying to run: ./configure --with-thread-pool --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/mysql/ --with-mysql-dir=/usr/bin/ I finally figured this one out. It seems that when I installed the mysql.gz slackware package that the slackware packagetool pkgtool didn't check the dependencies. This lead to the problem that when the configure script from freeradius tried to check for mysql_init in the libmysqlclient that the glibc version was wrong, so it couldn't work. I then compiled mysql from source and did the same configure script that I was trying to do all along and it worked fine:) Alan, thanks for the help. If anyone has any tips on using mysql w/ freeradius or any neat scripts to monitor usage, my ears are open. Nick -- Nick Davis Associate Systems Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 Web Development-Web Marketing-ISP Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: compile w/ mysql
I am trying to compile freeradius-snapshot-20010730 with mysql. For some reason I am unable to get it to work properly. I hope someone can assist me with this problem. Here is what the output of the ./configure script says: checking for mysql/mysql.h... yes checking for mysql_init in -lmysqlclient... no configure: warning: mysql libraries not found. Use --with-mysql-lib-dir=path. configure: warning: sql submodule 'mysql' disabled Here is the command that I am trying to run: ./configure --with-thread-pool --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/mysql/ --with-mysql-dir=/usr/bin/ After doing the top-level compile, try doing: cd src/modules/rlm_sql/drivers/rlm_sql_mysql ./configure --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/mysql/ --with-mysql-dir=/usr/bin/ The output of this is the same as I get from the top-level compile. Is there a way I can just make it work? Can I edit the Makefile such that it will make the mysql module and work properly? Do you have any other ideas? Thanks for the help thus far! -- Nick Davis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: compile w/ mysql
Nick Davis [EMAIL PROTECTED] wrote: Is there a way I can just make it work? Can I edit the Makefile such that it will make the mysql module and work properly? Do you have any other ideas? Edit the Makefile. It's your only hope for now. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
