Hello, I need to configure freeradius to make accounting with Quintum. Where do I start ? What do I need to know in order to do that ? I already installed and tested version 1.1.7 and have a mysql or pgsql server but I dont know what steps to take yet. What structure should the tables in the database have in order to work with radius ? How do I include dictionary.quintum ? (as I read that it's needed) Is it enough to set this parameters in postgresql.conf ? server = ... login = ... password = ... radius_db = ... Thanks ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469
On 8/29/07, Pretty Woman <redrose_w@yahoo.com> wrote:
Hello,
I need to configure freeradius to make accounting with Quintum. Where do I start ? What do I need to know in order to do that ?
I already installed and tested version 1.1.7 and have a mysql or pgsql server but I dont know what steps to take yet.
What structure should the tables in the database have in order to work with radius ? How do I include dictionary.quintum ? (as I read that it's needed) Is it enough to set this parameters in postgresql.conf ? server = ... login = ... password = ... radius_db = ...
Thanks
Included in the source is mysql and pgsql database schemas. You will need to create the database yourself: (create database radius;) then import the schema. In mysql you can do the following: mysql -u root -p radius < schema.sql After the DB is setup you will then want to configure the *.conf with server, login, password, etc. If all is well, you can simply insert the respective sql module in the accounting section of radiusd.conf and watch as your table is populated. -- Nicholas Hall ngharo@gmail.com 262.208.6271
Ok, I imported the schema into a mysql database and I uncommented "sql" and "sql_log" in radiusd.conf in the accounting, session and post-auth. Now when I issue "radiusd" command it says "Starting - reading configuration files ..." but "ps -aux | grep radiusd" doesnt show it running... Did I miss anything ? Plz help. radiusd.conf looks like this : accounting { detail unix radutmp sql sql_log } session { radutmp # See "Simultaneous Use Checking Querie" in sql.conf sql } post-auth { sql sql_log } And in the sql.conf : server = "localhost" login = "root" password = "passofrootuser" radius_db = "radius" All the other settings are the same and mysqld is running. --- Nicholas Hall <ngharo@gmail.com> wrote:
On 8/29/07, Pretty Woman <redrose_w@yahoo.com> wrote:
Hello,
I need to configure freeradius to make accounting
with
Quintum. Where do I start ? What do I need to know in order to do that ?
I already installed and tested version 1.1.7 and have a mysql or pgsql server but I dont know what steps to take yet.
What structure should the tables in the database have in order to work with radius ? How do I include dictionary.quintum ? (as I read that it's needed) Is it enough to set this parameters in postgresql.conf ? server = ... login = ... password = ... radius_db = ...
Thanks
Included in the source is mysql and pgsql database schemas. You will need to create the database yourself: (create database radius;) then import the schema. In mysql you can do the following: mysql -u root -p radius < schema.sql
After the DB is setup you will then want to configure the *.conf with server, login, password, etc. If all is well, you can simply insert the respective sql module in the accounting section of radiusd.conf and watch as your table is populated.
-- Nicholas Hall ngharo@gmail.com 262.208.6271
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
____________________________________________________________________________________ Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545433
Hi,
Ok, I imported the schema into a mysql database and I uncommented "sql" and "sql_log" in radiusd.conf in the accounting, session and post-auth.
Now when I issue "radiusd" command it says "Starting - reading configuration files ..."
and 'radiusd -X' works? if so, what about 'radiusd -x' sounds very much like the server is unable to write its logging files - those directories must be writable by the radiusd process owner (usually radiusd or nobody). if you've installed as root or run things as root you may find these permissions incorrect. another issue is the run PID file - often the location is also wrong permission - eg /var/run/radius/radiusd.pid alan
I searched the archives and found a suggestion to make a symbolic link to mysql libraries so I did this : ln -s /opt/lampp/lib/mysql /usr/lib/mysql ... still doesnt work I think it has something to do with the changes I made to sql.conf, radiusd.conf since the radiusd worked initially. The problem occurred after I made those changes. Any ideas plz ? Here is what "radiusd -x" outputs : Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Module: Loaded SQL 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. radiusd.conf[2023] Unknown module "sql". radiusd.conf[1994] Failed to parse accounting section. --- A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Ok, I imported the schema into a mysql database and I uncommented "sql" and "sql_log" in radiusd.conf in the accounting, session and post-auth.
Now when I issue "radiusd" command it says "Starting - reading configuration files ..."
and 'radiusd -X' works? if so, what about 'radiusd -x'
sounds very much like the server is unable to write its logging files - those directories must be writable by the radiusd process owner (usually radiusd or nobody). if you've installed as root or run things as root you may find these permissions incorrect. another issue is the run PID file - often the location is also wrong permission - eg /var/run/radius/radiusd.pid
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
____________________________________________________________________________________ Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
Hi,
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. radiusd.conf[2023] Unknown module "sql". radiusd.conf[1994] Failed to parse accounting section.
err, you dont have a freeradius mysql/sql module. this is probably because it wasnt built. the reason it wasnt built? because freeradius couldnt find the required stuff to build mysql code when you ran ./configure when you run ./configure --with-whatever-options you should always run it again with a '| grep WARNING' at the end so you can see problems. do you have the mysql development package installed? if running, eg fedora, yum install mysql-devel otherwise, you need to tell ./configure where to look when it wants to see if it can build ./configure --help gives you the answers alan
I have XAMPP installed. You mean I have to reintall both mysql and freeradius or just freeradius ? Is there a way to reconfigure freeradius to see the current mysql installation ? Thanks --- A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
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. radiusd.conf[2023] Unknown module "sql". radiusd.conf[1994] Failed to parse accounting section.
err, you dont have a freeradius mysql/sql module. this is probably because it wasnt built. the reason it wasnt built? because freeradius couldnt find the required stuff to build mysql code when you ran ./configure
when you run ./configure --with-whatever-options you should always run it again with a '| grep WARNING' at the end so you can see problems. do you have the mysql development package installed? if running, eg fedora, yum install mysql-devel
otherwise, you need to tell ./configure where to look when it wants to see if it can build ./configure --help gives you the answers
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
____________________________________________________________________________________ Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Nicholas Hall -
Pretty Woman