Hi Jeremy,
We also noticed occasional strange things with Oracle in some earlier versions.
It seems to be related to the SIGCHLD handler that Radiator establishes. Oracle
would periodically change or corrupt the SIGCHLD handler. You will see a change
in recent SqlDb.pm that specifically mentions Oracle.
Hope that helps.
Cheers.
On Aug 5, 10:09am, Jeremy Burton wrote:
> Subject: (RADIATOR) wierd things happening...
> Hi all,
> I have some weird unexplained phenomena happening with Radiator
> which I'm wondering if anyone can explain.
> In our situation, we have an AuthBy FILE, then either the user is
authenticated
> or (by default) the auth is passed onto Identifier System, which does an
> AuthBy SYSTEM and an AuthBy SQL.
> We were using Radiator 2.13.1, and my problem (i'm getting to that bit :)
> was happening with both the old SqlDb.pm and the new one (ie the patch).
> What was happening was:
> 1) User tries to auth, password in users file.. access accepted. fine.
> 2) User tries to auth, password is wrong. rejected by AuthSYSTEM before
> AuthSQL. fine.
> 3) User tries to auth, password is right, passed by AuthSYSTEM, AuthSQL
> just hangs. I then need to kill radiusd will kill -9 pid - or else it
> just doesn't respond to anything.
>
> Trying this with trace level 4 showed nothing - it just said
> "Handling by AuthSQL" and then went dead... We are using an Oracle8
database...
> this has worked pretty much fine for about a month.. (although with similar
> problems to this randomly - but a restart usually fixed that).
> The database connection in general was fine - I have a perl script which
> connects and does a transaction using DBI which I can run to test htis...
> and that worked fine... I was able to connect and execute a query using the
> same username, password, etc... basically, same conditions to radiator...
>
> Upgrading the system to 2.14.1 seems to have fixed this problem.. but I am
> wondering if anyone knows what was causing this in 2.13.1? I would like to
make
> sure that it is not something that is going to raise its ugly head again :)
>
> thanks,
>
> Jeremy
> --
> Jeremy Burton
> Database Administrator, Netspace Online Systems
> [EMAIL PROTECTED]
> [EMAIL PROTECTED], [EMAIL PROTECTED]
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Jeremy Burton
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
