Hello to all, I am using the latest version 2.1.8 and I am newbie. I was trying to configure sql (mysql) for this version, but I did not find any configuration help from any source. I cannot find the sql files that used to be in older version. So, can anyone locate these files for me or please tell me the changes in the sql files. If there is, please send the link that describes how to configure mysql with the latest version of freeradius 2.1.8. Thanks in advance. Pratik
On Thu, Feb 25, 2010 at 2:22 PM, Pratik Shrestha <pratikdbl@gmail.com> wrote:
Hello to all, I am using the latest version 2.1.8 and I am newbie. I was trying to configure sql (mysql) for this version, but I did not find any configuration help from any source.
Where did you look? See doc/rlm_sql Or (if you install from RPM) /usr/share/doc/freeradius-2.1.6/rlm_sql -- Fajar
Thanks. But is the database schema has changed from previous version? In previous version there used to be mysql.sql or db_mysql.sql. In this version I found rad.sql, cui.sql and so on. And do you know any site that describes the configuration for 2.1.8 with mysql? Pratik On Thu, Feb 25, 2010 at 3:31 PM, Fajar A. Nugraha <fajar@fajar.net> wrote:
On Thu, Feb 25, 2010 at 2:22 PM, Pratik Shrestha <pratikdbl@gmail.com> wrote:
Hello to all, I am using the latest version 2.1.8 and I am newbie. I was trying to configure sql (mysql) for this version, but I did not find any configuration help from any source.
Where did you look? See doc/rlm_sql Or (if you install from RPM) /usr/share/doc/freeradius-2.1.6/rlm_sql
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Pratik Shrestha wrote:
Thanks. But is the database schema has changed from previous version? In previous version there used to be mysql.sql or db_mysql.sql. In this version I found rad.sql, cui.sql and so on.
Have you bothered reading the documentation and config files that come with the server? Read raddb/sql.conf. It's explained.
And do you know any site that describes the configuration for 2.1.8 with mysql?
I'm continually amazed at the number of people who spend hours "googling" for solutions, instead of reading the documentation that comes with the server. Alan DeKok.
Thanks...I have already configured. Pratik On Thu, Feb 25, 2010 at 3:53 PM, Alan DeKok <aland@deployingradius.com>wrote:
Pratik Shrestha wrote:
Thanks. But is the database schema has changed from previous version? In previous version there used to be mysql.sql or db_mysql.sql. In this version I found rad.sql, cui.sql and so on.
Have you bothered reading the documentation and config files that come with the server?
Read raddb/sql.conf. It's explained.
And do you know any site that describes the configuration for 2.1.8 with mysql?
I'm continually amazed at the number of people who spend hours "googling" for solutions, instead of reading the documentation that comes with the server.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Thu, Feb 25, 2010 at 3:47 PM, Pratik Shrestha <pratikdbl@gmail.com> wrote:
Thanks. But is the database schema has changed from previous version? In previous version there used to be mysql.sql or db_mysql.sql. In this version I found rad.sql, cui.sql and so on.
where did you find rad.sql?
From /etc/raddb/sql.conf:
# Configuration for the SQL module # # The database schemas and queries are located in subdirectories: # # sql/DB/schema.sql Schema # sql/DB/dialup.conf Basic dialup (including policy) queries # sql/DB/counter.conf counter # sql/DB/ippool.conf IP Pools in SQL # sql/DB/ippool.sql schema for IP pools. # # Where "DB" is mysql, mssql, oracle, or postgresql.
And do you know any site that describes the configuration for 2.1.8 with mysql?
doc/rlm_sql and sql.conf is the best source. -- Fajar
participants (3)
-
Alan DeKok -
Fajar A. Nugraha -
Pratik Shrestha