List,
I know this thread is about dead, but I wanted to correct some things.

On Monday 16 June 2003 11:35, [EMAIL PROTECTED] wrote:
> Hi Michael,
>
>       The rlm_sql_mysql file is for building the mysql database. Under the
> /freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql directory you
> will find the "configure" file. Just run this script by entering
> "./configure" and it will create your mysql database for you.

 rlm_sql is a module that freeradius uses to interact with databases.
 rlm_sql_mysql is a module that rlm_sql uses to interact with a mysql 
database. Running configure builds that module for you, it does not build the 
database. The database must by built by you, by hand! The tricky part is the 
fact that you must have the mysql development libraries installed on your 
system before these modules will build. 
 The file 
"~/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql" 
is the file you pass into mysql to create the tables in the database for you. 
However, you must have created the database itself prior to trying to create 
the tables.
 If you look the the first few lines of "db_mysql.sql" you will see this:
########################################################
#  db_mysql.sql                     rlm_sql - FreeRADIUS SQL Module       #
#                                                                         #
#     Database schema for MySQL rlm_sql module                            #
#                                                                         #
#     To load:                                                            #
#         mysql -uroot -prootpass radius < db_mysql.sql                   #

This is assuming that you create a database called "radius" by hand before you 
run the above mysql command.


> The mysql libraries are kept in /usr/lib/mysql. The database is kept in
> /var/lib/mysql. Here you will find a directory for "mysql" and the
> mysql.sock driver file. If you create a new database, it will be stored in
> this directory under the database name.

These above paths may be correct on your system, but different linux 
distributions and other OS's can have different paths.

I don't want to sound like an a$$, I just wanted to make some clarifications.

Hope this helps!

Nick

> 
> Kenneth L. Miller
> Information Technology Specialist
> CENWP-IM-C
> Portland, Oregon
> (503) 808-5056


-- 
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

Reply via email to