RE: (RADIATOR) having problem talking to Oracle
Hello Stephen - On Sat, 25 Mar 2000, Stephen Chen wrote: Hi Hugh, Thanks for your advice, but reinstalling DBI and DBD:Oracle didn't make any difference. The logfile shows: Fri Mar 24 10:42:10 2000: ERR: Could not connect to SQL database with DBI-connect dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ent-db.flashcom.com)(PO RT=1521))(CONNECT_DATA=(SID=qip))), db_name, password: Fri Mar 24 10:42:10 2000: ERR: Could not connect to SQL database with DBI-connect dbi:Oracle:qip, , : Fri Mar 24 10:42:10 2000: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 10 seconds where db_name and password were replaced. But notice the second error message, it attempts to make connection to database without the username and password. Any idea why? I would suggest you also check the ORACLE_HOME environment variable and the location of the tsnames.ora file. hth Hugh -- 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.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) having problem talking to Oracle
Hello Stephen - On Fri, 24 Mar 2000, Stephen Chen wrote: We had Radiator setup to authenticate through a remote Oracle server, everything was working happily, until this morning when I restarted radiator. radpwtst kept on returning these error messages: Can't read $DBI::errstr, last handle unknown or destroyed at Radius/SqlDb.pm line 127. Thu Mar 23 10:44:00 2000: ERR: Could not connect to SQL database with DBI-connect dbi:Oracle:our_db_name, USERNAME, PASSWORD: Thu Mar 23 10:44:00 2000: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds The usual question at this point is "what did you change?". Have you installed a new version of Radiator? a new version of Perl? was the configuration file changed? have the passwords on the database changed? has your ORACLE_HOME environment variable changed? has the tsnames.ora file changed? There is also a very good FAQ on this topic here: http://www.open.com.au/radiator/faq.html#58 hth Hugh -- 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.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) having problem talking to Oracle
Title: RE: (RADIATOR) having problem talking to Oracle I took out 2 comment lines in the config file, but later restored it and it still didn't work. There are multiple users on this box, so they might have changed something in the environment. Any suggestion where I can start to look? Thanks. -S. -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 23, 2000 1:27 PM To: Stephen Chen; [EMAIL PROTECTED] Subject: Re: (RADIATOR) having problem talking to Oracle Hello Stephen - On Fri, 24 Mar 2000, Stephen Chen wrote: We had Radiator setup to authenticate through a remote Oracle server, everything was working happily, until this morning when I restarted radiator. radpwtst kept on returning these error messages: Can't read $DBI::errstr, last handle unknown or destroyed at Radius/SqlDb.pm line 127. Thu Mar 23 10:44:00 2000: ERR: Could not connect to SQL database with DBI-connect dbi:Oracle:our_db_name, USERNAME, PASSWORD: Thu Mar 23 10:44:00 2000: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds The usual question at this point is what did you change?. Have you installed a new version of Radiator? a new version of Perl? was the configuration file changed? have the passwords on the database changed? has your ORACLE_HOME environment variable changed? has the tsnames.ora file changed? There is also a very good FAQ on this topic here: http://www.open.com.au/radiator/faq.html#58 hth Hugh -- 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.
RE: (RADIATOR) having problem talking to Oracle
Hello Stephen - On Fri, 24 Mar 2000, Stephen Chen wrote: I took out 2 comment lines in the config file, but later restored it and it still didn't work. There are multiple users on this box, so they might have changed something in the environment. Any suggestion where I can start to look? I would suggest reinstalling DBI and DBD-Oracle. You could also completely reinstall a separate copy of Perl and Radiator and compare the two installations at each step of the way. hth Hugh -- 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.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.