MySQL - support - module not loaded - radacct
Hello, I want to use freeradius 2.1.6 to store accounting data from a NAS in MySQL. First of all I installed mysql from source. Then I tried to install freeradius in the following both ways: ----------------- ./configure make make install ----------------- ./configure --with-mysql-include-dir=/usr/local/mysql/include/mysql --with-mysql-lib-dir=/usr/local/mysql/lib/mysql make make install ----------------- In both ways the configure looks as it should, I believe. I can also find the /usr/local/lib/rlm_sql_mysql.so. So I deleted the comment out sign in front of "$INCLUDE sql.conf" in radiusd.conf and also modified the access data of the mysql-server in sql.conf. However when I start the radius-server I can not see, that the rlm_sql_mysql - module is loading. I believe it is the certain module for store data to radacct - mysql - table. Please correct me, if I'm wrong (Sorry, I'm new to freeradius). In conclusion the radius-server is storing the account-data only on filesystem (/usr/local/var/log/radius/radacct/CLIENT-IP/detail-date) and not to mysql. :-( So I ask you, how can I enable radacct - mysql (how can I encourage freeradius to load rlm_sql_mysql)? Thanks for your answer in advance. Best regards, Bernd
Hello, I believe, that I found my answer in the http://www.mail-archive.com/freeradius-users@lists.freeradius.org/msg46743.h tml . ;-) Best regards, Bernd
-----Ursprüngliche Nachricht----- Von: freeradius-users-bounces+b.hoffmann=satspeed.de@lists.freeradi us.org [mailto:freeradius-users-bounces+b.hoffmann=satspeed.de@lists. freeradius.org] Im Auftrag von Bernd Hoffmann Gesendet: Dienstag, 14. Juli 2009 11:56 An: freeradius-users@lists.freeradius.org Betreff: MySQL - support - module not loaded - radacct
Hello,
I want to use freeradius 2.1.6 to store accounting data from a NAS in MySQL.
First of all I installed mysql from source. Then I tried to install freeradius in the following both ways:
----------------- ./configure make make install ----------------- ./configure --with-mysql-include-dir=/usr/local/mysql/include/mysql --with-mysql-lib-dir=/usr/local/mysql/lib/mysql make make install -----------------
In both ways the configure looks as it should, I believe. I can also find the /usr/local/lib/rlm_sql_mysql.so. So I deleted the comment out sign in front of "$INCLUDE sql.conf" in radiusd.conf and also modified the access data of the mysql-server in sql.conf.
However when I start the radius-server I can not see, that the rlm_sql_mysql - module is loading. I believe it is the certain module for store data to radacct - mysql - table. Please correct me, if I'm wrong (Sorry, I'm new to freeradius).
In conclusion the radius-server is storing the account-data only on filesystem (/usr/local/var/log/radius/radacct/CLIENT-IP/detail-date) and not to mysql. :-(
So I ask you, how can I enable radacct - mysql (how can I encourage freeradius to load rlm_sql_mysql)?
Thanks for your answer in advance.
Best regards,
Bernd
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hello, when I uncomment the sql in the accounting section, the logging seems to work. However the server does no more start with the init.d script. I can see a radiusd process per "ps aux", but the server doesn't listen on the certain ports (netstat -lnpe shows not the wished result). When I start the server on commandline with the -X option, all works. Have someone an idea? Best regards, Bernd
-----Ursprüngliche Nachricht----- Von: freeradius-users-bounces+b.hoffmann=satspeed.de@lists.freeradi us.org [mailto:freeradius-users-bounces+b.hoffmann=satspeed.de@lists. freeradius.org] Im Auftrag von Ivan Kalik Gesendet: Dienstag, 14. Juli 2009 12:21 An: FreeRadius users mailing list Betreff: Re: MySQL - support - module not loaded - radacct
So I ask you, how can I enable radacct - mysql (how can I encourage freeradius to load rlm_sql_mysql)?
Uncomment $INCLUDE for sql.conf in radiusd.conf. Uncomment sql in sections you want to use it in default (and others if needed) virtual server.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
when I uncomment the sql in the accounting section, the logging seems to work. However the server does no more start with the init.d script. I can see a radiusd process per "ps aux", but the server doesn't listen on the certain ports (netstat -lnpe shows not the wished result). When I start the server on commandline with the -X option, all works.
Have someone an idea?
what happends when you run with "radiusd -X" - does it all work? what does /var/log/radius/radiusd.log show? what is your current SELinux setting? 'getenforce' is the name of the command. if its set to 'enforce' then set it to permissive and try running the init.d script again. I think prehaps that either a file is owned by root from when you were running it as root and therefore the daemon cannot run properly when started as a lower user - or SELinux is getting in the way alan
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Bernd Hoffmann -
Ivan Kalik