Re: (RADIATOR) radiator dumps core when using dbi:Oracle:remote_database

1999-07-19 Thread John Coy 
end-Disconnect-Cause}-0), 0),\
 NVL((%{Ascend-Connect-Progress}-0), 0) )
 


Host reliant.anc.net
Secret XXX
 AuthPort 1645
 AcctPort 1646

Host defiant.anc.net
Secret XXX
 AuthPort 1645
 AcctPort 1646



-- end --

I thought it would also be helpful to include the test program
I wrote to test remote database connectivity:

#! /usr/bin/perl
#
use DBD::Oracle;

$ORACLE_DSN = "dbi:Oracle:";
$ORACLE_UNAME   = "XXX";
$ORACLE_PWORD   = "YYY";
$ORACLE_DB  = "reliant_tcp_WG73";
$ORACLE_MAX_RETRIES = 10;

{
 $dbh = DbLogin();

 $query = qq{
 SELECT * FROM radius WHERE username = 'jcoy'
 ORDER BY login_time
 };

 $sth = $dbh->prepare($query);
 $sth->execute;

 while (@data = $sth->fetchrow_array) {
 print join(" -- ", @data), "\n";
 }
}


sub DbLogin {
 my($dbname, $uname, $pword) = @_;
 my($retries);

 if ($dbname) {
 $dbname = $ORACLE_DSN . $dbname;
 }
     else {
     $dbname = $ORACLE_DSN . $ORACLE_DB;
 }

 $uname = $ORACLE_UNAME if (! $uname);
 $pword = $ORACLE_PWORD if (! $pword);

 while ((! $dbh) && ($retries < $ORACLE_MAX_RETRIES)) {
 $dbh = DBI->connect($dbname, $uname, $pword, {PrintError=>0} );
 $retries++;
 }

 if (! $dbh) {
 die($DBI::errstr);
 }
 else {
 warn("Retries:  $dbname $retries\n");
 return $dbh;
 }
}


-- original post and reply for reference --

Re: (RADIATOR) radiator dumps core when using dbi:Oracle:remote_database



Cheers.

On Jul 18, 11:30pm, John Coy wrote:
 > Subject: (RADIATOR) radiator dumps core when using dbi:Oracle:remote_datab
 > I'm running Radiator version 2.13.1 on a Sun Sparc Solaris
 > 2.5.1 machine.  I have an exact copy of Radiator running
 > on two machines,  one of which has a local copy of Oracle running,
 > the other accesses the database server remotely using SQL*Net v2


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) radiator dumps core when using dbi:Oracle:remote_database

1999-07-18 Thread Mike McCauley 

Hi John,

We dont know what's causing this problem. In order to form an opinion, we will
need to see your Radiator config file (no secrets, please) and your Radiator
log file at trace level 4 showing what happens at the time, especially any
error messages you see.

Cheers.

On Jul 18, 11:30pm, John Coy wrote:
> Subject: (RADIATOR) radiator dumps core when using dbi:Oracle:remote_datab
> I'm running Radiator version 2.13.1 on a Sun Sparc Solaris
> 2.5.1 machine.  I have an exact copy of Radiator running
> on two machines,  one of which has a local copy of Oracle running,
> the other accesses the database server remotely using SQL*Net v2
>
> On the radius server with the local database, everything
> works fine.  I am able to log accounting packets without
> any problems.
>
> However, on the radius server with the remote database,
> it dumps core every time an accounting packet arrives.  I
> can see it authenticate (when using Trace level 4) and
> then dumps core when the accounting packet arrives.
>
> I tested Perl's ability to connect to my remote database
> without any problem using a test perl program.  It was
> able to reliably connect, login, and retrieve data.
>
> Is anyone else experiencing this (or a similar) problem?
> I know there is a lot more information required to help
> me troubleshoot the problem.  I just wanted to get a feel
> for anyone else trying something similar.
>
> If this is a bug with the program, what is the procedure
> to get it resolved?
>
>
>
>
> ===
> 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 John Coy



-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, 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.