(RADIATOR) authsql failure?

[Hugh Irvine]

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.