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=. > 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
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
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=. >> 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: > 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=. > 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/ That may help. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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=. 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/ Here is an "ls -al" of /usr/lib/mysql/ : -rw-r--r-- 1 root root11562 Jun 13 01:44 libdbug.a -rw-r--r-- 1 root root34546 Jun 13 01:44 libheap.a -rw-r--r-- 1 root root15274 Jun 13 01:44 libmerge.a -rw-r--r-- 1 root root 227836 Jun 13 01:44 libmyisam.a -rw-r--r-- 1 root root23018 Jun 13 01:44 libmyisammrg.a -rw-r--r-- 1 root root 179634 Jun 13 01:44 libmysqlclient.a -rwxr-xr-x 1 root root 709 Jun 13 01:44 libmysqlclient.la lrwxrwxrwx 1 root root 24 Aug 14 10:43 libmysqlclient.so -> libmysqlclient.so.10.0.0 lrwxrwxrwx 1 root root 24 Aug 14 10:43 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0 -rwxr-xr-x 1 root root 110812 Jun 13 01:52 libmysqlclient.so.10.0.0 -rw-r--r-- 1 root root 186268 Jun 13 01:44 libmysqlclient_r.a -rwxr-xr-x 1 root root 741 Jun 13 01:44 libmysqlclient_r.la lrwxrwxrwx 1 root root 26 Aug 14 10:43 libmysqlclient_r.so -> libmysqlclient_r.so.10.0.0 lrwxrwxrwx 1 root root 26 Aug 14 10:43 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0 -rwxr-xr-x 1 root root 115132 Jun 13 01:52 libmysqlclient_r.so.10.0.0 -rw-r--r-- 1 root root35152 Jun 13 01:44 libmystrings.a -rw-r--r-- 1 root root 204470 Jun 13 01:44 libmysys.a -rw-r--r-- 1 root root 100348 Jun 13 01:44 libnisam.a This machine is running slackware 7.0.0, but the mysql is from slackware 8.0. It is version mysql-3.23.39 from the slackware package mysql.tgz. I ran ldconfig and that didn't help either. Can anyone see what I might be doing wrong? I'm sure mysql_init has been in libmysqlclient for some time, so I can't imagine that it wouldn't be in this one. 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
