(RADIATOR) DBD Error Problem!

[Hugh Irvine]

Hello Paul -

All of a sudden, lots of people seem to be having problems with Oracle.

When Radiator has a problem talking to the database, it marks the 
connection as down and will not retry it for 600 seconds (10 
minutes). This is the default behaviour and it can be altered in the 
AuthBy SQL clause with the FailureBackoffTime parameter.

I have copied this mail to Mike to see if he has any ideas.

regards

Hugh


At 10:46 -0500 01/8/31, Paul wrote:
>  Hi
>
>  I am having problem with radiator and oracle. We
>  have installed the most current version of DBI and DBD and even using
>  radiator 2.18.3
>  We are having a problem where it will work for a work and then suddenly
>
>  out of nowhere, it will reject every user.
>  It will give :
>
>  ERR: Could not connect to SQL database with DBI-> connect
>  dbi:Oracle:"dbname", username, password; Error while trying to
>  retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach)
>
>ERR: Could not conect to any SQL database. Request is ignored. Backing
>  off for 600 seconds
>
>  DEBUG: Handling with Radius::AuthFILE:
>
>  DEBUG: Radius::AuthFILE looks for match with "username"
>
>  ERR: Error in PostAuthHook(): Failed to use DBI to conenct to Oracle!
>at
>  (eval 65) line 19
>
>  Thisi s the error message. After this happens, i will see all the user
>  FAIL with logging in. Even i stop the process and restart it, it will
>  fail. until for quite a long time. What does it cost this to happen? We
>
>  have just installed the latest verison of DBI and DBD. Also, we are
>  using Oracle 8.1.16
>  This is causing us a lot of problem. What are we doing wrong?
>  Thanks in advanced
>
>Whenever this happens,  this message always appears:
>NOTICE: SIGTERM received: stopping
>Even we didn't send in any signal to stop it.
>
>Strange...
>
>Thanks you
>
>Paul
>
>===
>Archive at http://www.open.com.au/archives/radiator/
>Announcements on radiator-announce at open.com.au
>To unsubscribe, email 'majordomo at open.com.au' with
>'unsubscribe radiator' in the body of the message.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.