[RADIATOR] refresh time on clientlistsql

[Mike McCauley]

Hello Alex,

Thanks for the log.
Can we pls see a bit more of the log, maybe a few hundred lines before the 
error.
Are you quite sure you dant have a 4.7 patch set installed?

Cheers.

On Thursday 14 October 2010 09:01:09 pm Alexander Hartmaier wrote:
> Hi Mike,
>
> the config section
>
> <ClientListSQL>
>     DBSource        dbi:Oracle:NAC
>     DBUsername      foo
>     DBAuth          bar
>
>     ConnectionHook  sub { \
>         $_[1]->do("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD
> HH24:MI:SS'"); \ $_[1]->do("ALTER SESSION SET CURRENT_SCHEMA  = nacadm"); \
> }
>
>     # store the supportgroup from the CMDB in the OSC-Group-Identifier
> attribute GetClientQuery SELECT device.ipaddr, 'key', NULL, NULL, NULL,
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, device.hostid, NULL,
> NULL, NULL, NULL, NULL, NULL, NULL, 'OSC-Group-Identifier=' || tblhost.hsup
> FROM device JOIN core.tblhost at PCMSAT01 ON (device.hostid = tblhost.hostid)
> WHERE device.fk_collector = 5
>
>     # Reread the client list every hour
>     RefreshPeriod 3600
> </ClientListSQL>
>
>
> the error from the level 3 logfile:
>
> Thu Oct 14 12:57:42 2010: ERR: Execute failed for 'SELECT device.ipaddr,
> 'key', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
> NULL, device.hostid, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
> 'OSC-Group-Identifier=' || tblhost.hsup FROM device JOIN
> core.tblhost at PCMSAT01 ON (device.hostid = tblhost.hostid) WHERE
> device.fk_collector = 5': SQL Timeout
>
>
>
> --
> Best regards, Alex
>
>
>
>
> Am Montag, den 11.10.2010, 23:27 +0200 schrieb Mike McCauley:
>
>
> Hello Alexander,
>
> On Tuesday 12 October 2010 03:07:16 am Alexander Hartmaier wrote:
> > Hi Mike,
> >
> > 4.7 rpm, without patches.
>
> OK, so we will need to see the config file and the log file showing the
> error and what happens before.
>
> Cheers.
>
>
>
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
> Handelsgericht Wien, FN 79340b
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"* Notice: This e-mail contains information that is confidential and may be
> privileged. If you are not the intended recipient, please notify the sender
> and then delete this e-mail immediately.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
>"*



-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd
9 Bulbul Place Currumbin Waters QLD 4223 Australia   http://www.open.com.au
Phone +61 7 5598-7474                       Fax   +61 7 5598-7070

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.