[RADIATOR] SQL client error

[Heikki Vatiainen]

On 05/20/2011 02:59 PM, Roel Hoek wrote:

> We are in a process of migrating our radius servers to another host. On
> the old host we are running Radiator 3.17.1.
> On de new host we run 4.8
> 
> When starting Radiator on the new host SQL Client outputs errors:

Thanks for sending the log. GetClientQuery was changed a little in
version 4.8. From the history:

http://www.open.com.au/radiator/history.html

  GetClientQuery was incorrectly using field 25 instead of 27
  for flags. Documentation for GetClientQuery incorrectly
  decribed field 25 as being flags instead of ClientHook.

> Fri May 20 12:24:56 2011: DEBUG: Adding Clients from SQL database
> Fri May 20 12:24:56 2011: DEBUG: Query is: 'select
> nasidentifier,secret,null,null,null,null,null,null,null,null,null,null,null,null,
> clientidentifier,null,null,null,null,null,null,null,null,null,null,flags
> from RUNCLIENTLIST':
> Fri May 20 12:24:56 2011: ERR: Compilation error in ClientHook: Bareword
> "IgnoreAcctSignature" not allowed while "strict subs" in us
> e at (eval 417) line 1.

> <ClientListSQL>
>         DBSource        dbi:Oracle:netdb
>         DBUsername      blabla
>         DBAuth          bladibla
>         RefreshPeriod 43200 # 12 uur
> 
>         GetClientQuery select nasidentifier,secret,null,\
>         null,null,null,null,null,null,null,null,null,null,null,\
> clientidentifier,null,null,null,null,null,null,null,null,null,null,flags
> from RUNCLIENTLIST
> </ClientListSQL>
> 
> How to solve this problem? Another SQL Client in the config does not
> generate any error.

Radiator tries to use flags contents as a ClientHook. Replace flags with
null,null,flags and the problem should go away.

We apologise for any inconvenience.

About your config: do not use trialing comments such as "# 12 uur". The
comments. From ref.pdf:

   Caution: comments that do not start at the beginning of the line
   are likely to be taken as part of a parameter value:

   SomeParameter xxxx   # INCORRECT:this is not a comment


Have a good weekend!

Heikki


-- 
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.