[RADIATOR] Typo in goodies/blocktime.txt

[Hugh Irvine]

Hi Jan -

Quite right - thanks.

regards

Hugh


On 15 Apr 2009, at 18:14, Jan Tomasek wrote:

> Hi,
>
> I belive, I've found typo in goodies/blocktime.txt in Radiator 4.4,  
> there is:
>
> <AuthBy SQL>
>
>    Identifier Block-Time-SQL
>
>    DBSource        %{GlobalVar:SQLServer1}
>    DBUsername      %{GlobalVar:SQLUser1}
>    DBAuth          %{GlobalVar:SQLAuth1}
>
>    AuthSelect TIMELEFT from BLOCK_USERS \
>        where USERNAME='%n'
>
> I belive it should be:
>
>    AuthSelect select TIMELEFT from BLOCK_USERS \
>        where USERNAME='%n'
>
> Without SELECT is SQL server complaining:
>
>> Wed Apr 15 10:08:53 2009: DEBUG: Query is: 'count(*) as count FROM  
>> RadOnline WHERE UserName='semik at tomasek.cz'': Wed Apr 15 10:08:53  
>> 2009: ERR: Execute failed for 'count(*) as count FROM RadOnline  
>> WHERE UserName='semik at tomasek.cz'': You have an error in your SQL  
>> syntax; check the manual that corresponds to your MySQL server  
>> version for the right syntax to use near 'count(*) as count FROM  
>> RadOnline WHERE UserName='semik at tomasek.cz'' at line 1
>
> Best regards
> -- 
> -----------------------
> Jan Tomasek aka Semik
> http://www.tomasek.cz/
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.