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