debug?

2001-09-11 Thread Nick Davis
Hi, I have a question.. Tue Sep 11 17:45:25 2001 : Debug: rlm_sql: Reserving sql socket id: 4 Tue Sep 11 17:45:25 2001 : Debug: rlm_sql: Released sql socket id: 4 Tue Sep 11 17:46:37 2001 : Debug: rlm_sql: Reserving sql socket id: 4 Tue Sep 11 17:46:37 2001 : Debug: rlm_sql: Released sql socket

Re: schema for SQL interface

2001-09-11 Thread Mike Machado
There is a file in the rlm_sql_mysql directory called db_mysql.sql that contains the schema. Scott Wood wrote: > I am fairly new to radius, and I am setting up freeradius for use with > mysql and I have not found anywhere the schema for creating the tables > that freeradius expects to use. Do

Re: Re(2): Freeradius SQL Schema

2001-09-11 Thread Scott Wood
Sorry to keep cluttering up the list like this, but I was having permissions errors with the user setup script I sent. Here is a fixed version (only can connect from localhost, for some reason the % host substitutions did not work properly): INSERT INTO user (Host, User, Password, Select_priv

Re: Re(2): Freeradius SQL Schema

2001-09-11 Thread Scott Wood
Update on my last post, GRANT ALL... should come after the database is created. --Scott CREATE DATABASE FREERADIUS; GRANT ALL on FREERADIUS.* TO "radius@%" IDENTIFIED BY "radius"; - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Re(2): Freeradius SQL Schema

2001-09-11 Thread Scott Wood
Sorry Scott, (forgot to CC: the list ;-) Actually, the .sql file is pretty well self-documenting. I setup mysql by creating a user (radius), a database (FREERADIUS), and giving that user full permissions to that database (substitute FREERADIUS for 'radius' to use the default freeradius setup)

Re: NEW Issue: Dropping conflicting authentication packet

2001-09-11 Thread VISP Systems Administration
At 06:02 PM 9/10/2001 -0400, you wrote: >VISP Systems Administration <[EMAIL PROTECTED]> wrote: > > The infamous line: > > datestamp : Error: Dropping conflicting authentication packet from client > > clientname.realm.net:1645 - ID: xxx > > Argh... I put a fix in the other day for non-threaded

schema for SQL interface

2001-09-11 Thread Scott Wood
I am fairly new to radius, and I am setting up freeradius for use with mysql and I have not found anywhere the schema for creating the tables that freeradius expects to use. Does anyone have the schema or a reference where I can find it? Thanks in advance, Scott Wood [EMAIL PROTECTED] - Li

FreeRadius 0.2, MySQL - Accept mode and Realms

2001-09-11 Thread freeradius-users
Greetings all, I'm kinda new to this list and to FreeRadius (and to installing/compiling stuff), so if this is old list news I apologise now. ;-) I've been playing with FreeRadius on a test box and test NAS, and so far so good: I'm running 0.2 on Redhat 6.2 Intel authenticating to MySQL (3.23.4

MySQL accounting failover

2001-09-11 Thread Thomas Jalsovsky
Hello, I configured FreeRADIUS (20010909 CVS) with MySQL. I would like to configre fail-over for MySQL accounting. I tryed: accounting { acct_unique detail group { sql_primary { fail = 1 notfound = 2

Re: How to retrict telnet access to my machine?

2001-09-11 Thread Jamshed Jadoon
if you are using linux then try to add your own shell in /etc/default/adduser file - Original Message - From: VISP Systems Administration <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 11:33 PM Subject: Re: How to retrict telnet access to my machine? > R

how make freeradius0.2 using oracle8i not file?

2001-09-11 Thread sunny
hi, I tried installing freeradius0.2 for oracle8i. Now it has instantiated sql module. But it seemed the freeradius not using oracle at all, it only read file. The msg is: (I have add the nas in /etc/raddb/client file. otherwise it will show unknow client. But I am sure I have input some da