Re: Radius error

2002-04-25 Thread Chris Parker 

At 09:13 AM 4/25/2002 -1000, Gillou wrote:
>I have a problem with SQL queries that taking a *huge* length of time and i
>need to replace the UPDATE statement by INSERT
>My SQL table is 1.000.000 entries and an UPDATE statement take 1 or 2
>minutes long.
>Too long for authentication.

Wow.  You need to fix your database.

>Alan said that indexing the table would help. I don't know how indexing
>works. Can somebody write a little tutorial on indexing SQL tables to be
>used with freeradius ?

That's really outside of the scope of freeradius, and in the scope of
general "how to use a database".

See some examples at:

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html

You really need to learn how to admin a relational database.  That requires
a knowledge of how they work, and cannot be accomplished with a simple
readme file.

-Chris
--
\\\|||///  \  StarNet Inc.  \Chris Parker
\ ~   ~ /   \   WX *is* Wireless!\   Director, Engineering
| @   @ |\   http://www.starnetwx.net \  (847) 963-0116
oOo---(_)---oOo--\--
   \ Wholesale Internet Services - http://www.megapop.net



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Radius error

2002-04-25 Thread Gillou 

I have a problem with SQL queries that taking a *huge* length of time and i
need to replace the UPDATE statement by INSERT
My SQL table is 1.000.000 entries and an UPDATE statement take 1 or 2
minutes long.
Too long for authentication.

Alan said that indexing the table would help. I don't know how indexing
works. Can somebody write a little tutorial on indexing SQL tables to be
used with freeradius ?

- Original Message -
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 8:44 AM
Subject: Re: Radius error


> "Justin Ainsworth" <[EMAIL PROTECTED]> wrote:
> > Would it be possible to make it so radiusd will refuse packets when it
> > is out of sockets, instead of dieing?
>
>   Yes, but that wouldn't help.
>
>   The problem is that your SQL queries are taking a *huge* length of
> time.  That's why the server is locking.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Radius error

2002-04-25 Thread Alan DeKok 

"Justin Ainsworth" <[EMAIL PROTECTED]> wrote:
> Would it be possible to make it so radiusd will refuse packets when it
> is out of sockets, instead of dieing?

  Yes, but that wouldn't help.

  The problem is that your SQL queries are taking a *huge* length of
time.  That's why the server is locking.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius error

2002-03-04 Thread Alan DeKok 

"Peter Santiago" <[EMAIL PROTECTED]> wrote:
> Mar  4 10:01:47 psinergybbs port[S100]: radius@[127.0.0.1]1813 not
> responding
...
> Could anyone tell me what's wrong?  TIA

  You didn't read the message you posted to the list.

  You posted the message to the wrong list.

  Those errors were NOT from FreeRADIUS.

  Alan DeKok.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html