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.tblh...@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.tblh...@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 mi...@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.
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
