(RADIATOR) authsql failure?

[Gabor Debreczeni-Kis]

Hello

It works fine for me.
Thanks for your fast and professional help.

Best regards
Gabor

On Mon, 8 Sep 2003, Hugh Irvine wrote:

>
> Hello Gabor -
>
> This is the default behaviour - you should add NoDefault to your AuthBy
> clause to change it.
>
> 	<AuthBy SQL>
> 		.....
> 		NoDefault
> 		.....
> 	</AuthBy>
>
> regards
>
> Hugh
>
>
> On Monday, Sep 8, 2003, at 21:35 Australia/Melbourne, Gabor
> Debreczeni-Kis wrote:
>
> > Hello
> >
> > I'm using Radiator to my Cisco Cabletv headend's telnet
> > authentication.
> > I'm using Radiator with authsql (postgresql).
> > This is work fine, my users can log into the cisco headends.
> > My problem is:
> > if an user mistype his password, the radiator going to insane.
> > this is in the log:
> >
> > Fri Sep  5 17:26:30 2003: DEBUG: Radius::AuthSQL looks for match with
> > DEFAULT57
> > Fri Sep  5 17:26:30 2003: DEBUG: Radius::AuthSQL REJECT: Bad Encrypted
> > password
> > Fri Sep  5 17:26:30 2003: DEBUG: Query is: 'select subscribers.password
> > from subscribers, radclientlist, szervezet_logins where
> > subscribers.username='sixday' an
> > d szervezet_logins.username='sixday' and
> > szervezet_logins.nasid=radclientlist.na
> > stype and radclientlist.nasidentifier='ubr's ip'':
> >
> > Fri Sep  5 17:26:30 2003: DEBUG: Radius::AuthSQL looks for match with
> > DEFAULT58
> > Fri Sep  5 17:26:30 2003: DEBUG: Radius::AuthSQL REJECT: Bad Encrypted
> > password
> > Fri Sep  5 17:26:30 2003: DEBUG: Query is: 'select subscribers.password
> > from subscribers, radclientlist, szervezet_logins where
> > subscribers.username='sixday' an
> > d szervezet_logins.username='sixday' and
> > szervezet_logins.nasid=radclientlist.na
> > stype and radclientlist.nasidentifier='ubr's ip'':
> >
> >
> > when the password is bad, the radiator query again the user's password
> > and
> > again and again and again and again...
> > the radiator do this 17000-18000 times in a minute.
> > this is going until i don't kill the radiator process.
> >
> > if the users don't mistype their password, everything going fine!
> >
> > Anybody know any solution for this?
> >
> >
> > Sixday
> >
> > ps: sorry for my bad englis
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
>
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.