Re: [Rabbit-proxy-users] SQL authentication

[Luis S. <lso...@gl...>]

Hi Robo,

We use gnu-radius and mysql here to do the authentication=2E when configur=
ing gnu-radius for use with sql you specify the connect string and the que=
ry strings in the config file=2E  The program does no caching=2E  It queri=
es the db for every request=2E  I would think that making a query for ever=
y request should work fine=2E  The incoming connections are slow and sql d=
atabases do caching to enhance performance so no caching should not impact=
 performance very much=2E  I would try no caching at all to start with and=
 only implement caching if performance is found to be lacking=2E

Another alternative might be to only cache 'good' responses=2E  A negative=
 response causes a query to the db=2E  good responses should be flushed ev=
ery X minutes=2E  The flush time could be configured in the config file=2E=
  I see no reason to cache negative responses=2E

Here are some sample sql configuration stanzas from the gnu-radius config =
file=2E  gnu-radius substitues %u by the login users id=2E

# The interface statement specifies which SQL interface to use=2E It is
# needed only if the package is configured with both --with-mysql and
# --with-postgres options=2E
interface mysql

server localhost
port 3306
login dbuser
password dbpassword

auth_query  SELECT password FROM table WHERE user=3D'%u'


Thanks,

--luis

---------- Original Message ----------
To: Luis Soltero (lsoltero@globalmarinenet=2Enet)
From: Robert Olofsson (robo@khelekore=2Eorg)
Subject: Re: [Rabbit-proxy-users] SQL authentication
Date: 5/5/2005 7:49:47a

> Luis Soltero wrote:
> 
> >Specifying a connection string and an sql query string in rabbit the co=
nf 
> >would be wonderful=2E
> >  
> >
> This is not possible right now=2E Writing a filter to handle it will not=
 
> take long=2E
> 
> How long should the data be cached in rabbit? or do you want rabbit to
> ask the database for every request it gets? Should negative responses
> be cached as well?
> 
> /robo
> 
> 
> 
> -------------------------------------------------------
> This SF=2ENet email is sponsored by: NEC IT Guy Games=2E
> Get your fingers limbered up and give it your best shot=2E 4 great event=
s, 4
> opportunities to win big! Highest score wins=2ENEC IT Guy Games=2E Play =
to
> win an NEC 61 plasma display=2E Visit http://www=2Enecitguy=2Ecom/?r=3D2=
0
> _______________________________________________
> Rabbit-proxy-users mailing list
> Rabbit-proxy-users@lists=2Esourceforge=2Enet
> https://lists=2Esourceforge=2Enet/lists/listinfo/rabbit-proxy-users


Luis Soltero, Ph=2ED=2E, MCS
Director of Software Development and CTO
Global Marine Networks, LLC
StarPilot, LLC
Tel: 865-379-8723
Fax: 865-681-5017
E-Mail: lsoltero@globalmarinenet=2Enet
Web: http://www=2Eglobalmarinenet=2Enet
Web: http://www=2Estarpilotllc=2Ecom

Wireless E-Mail, Web Hosting, Weather and more=2E=2E=2E
                                     and
StarPilot, the state of the art in navigation computations at your finger =
tips=2E=2E=2E