>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.
I figured, but I thought I'd post something quick to see
if it's a known issue. There are no errors printed out on
the console. It just dumps core when the accounting stop
packet arrives.
(it's truly mysterious)
Here's my radiusd.cfg file and a trace at level 4:
-- trace at log level 4 --
Sun Jul 18 23:15:31 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 443
Ignored
Sun Jul 18 23:15:31 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 444
Ignored
Sun Jul 18 23:15:32 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
773 Ignored
Sun Jul 18 23:15:32 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
774 Ignored
Sun Jul 18 23:15:32 1999: INFO: Server started
Sun Jul 18 23:16:03 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 443
Ignored
Sun Jul 18 23:16:03 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 444
Ignored
Sun Jul 18 23:16:03 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
773 Ignored
Sun Jul 18 23:16:03 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
774 Ignored
Sun Jul 18 23:16:03 1999: INFO: Server started
Sun Jul 18 23:16:45 1999: DEBUG: Packet dump:
*** Received from 209.12.0.130 port 1028 ....
Code: Accounting-Request
Identifier: 100
Authentic: <216><26><183><184><191>x<226><20><163><136>>6<246><143><217><170>
Attributes:
User-Name = "jcoy"
NAS-Identifier = 209.12.0.130
NAS-Port = 20123
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "294768824"
Acct-Authentic = RADIUS
Ascend-Modem-PortNo = 3
Ascend-Modem-SlotNo = 5
Framed-Protocol = PPP
Framed-Address = 209.12.0.140
Sun Jul 18 23:16:45 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sun Jul 18 23:16:45 1999: ERR: Attribute number 33 (vendor ) is not defined
in your dictionary
Sun Jul 18 23:16:45 1999: DEBUG: Handling with Radius::AuthSQL
Sun Jul 18 23:19:11 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 443
Ignored
Sun Jul 18 23:19:11 1999: WARNING: There is no attribute named
Framed_Protocol in file '/usr/local/etc/raddb/dictionary' before line 444
Ignored
Sun Jul 18 23:19:12 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
773 Ignored
Sun Jul 18 23:19:12 1999: WARNING: There is no attribute named
Ascend-Temporary-Rtes in file '/usr/local/etc/raddb/dictionary' before line
774 Ignored
Sun Jul 18 23:19:12 1999: INFO: Server started
Sun Jul 18 23:19:22 1999: DEBUG: Packet dump:
*** Received from 209.12.0.130 port 1028 ....
Code: Accounting-Request
Identifier: 127
Authentic: <149>Q<203><194><11>Qk<203>~<197>=<210><142>Nr<141>
Attributes:
User-Name = "jcoy"
NAS-Identifier = 209.12.0.130
NAS-Port = 20123
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 126
Acct-Session-Id = "294768824"
Acct-Authentic = RADIUS
Acct-Session-Time = 32
Acct-Input-Octets = 17
Acct-Output-Octets = 468
Acct-Input-Packets = 2
Acct-Output-Packets = 9
Ascend-Disconnect-Cause = 185
Ascend-Connect-Progress = 75
Ascend-Xmit-Rate = 14400
Ascend-Data-Rate = 14400
Ascend-PreSession-Time = 18
Ascend-Pre-Input-Octets = 15
Ascend-Pre-Output-Octets = 79
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-Modem-PortNo = 3
Ascend-Modem-SlotNo = 5
Framed-Protocol = PPP
Framed-Address = 209.12.0.140
Sun Jul 18 23:19:22 1999: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sun Jul 18 23:19:22 1999: ERR: Attribute number 33 (vendor ) is not defined
in your dictionary
Sun Jul 18 23:19:22 1999: DEBUG: Handling with Radius::AuthSQL
<dumps core here>
-- radiusd.cfg --
LogDir /usr/local/radiator/log
# Set this to the database directory. It should contain these files:
# users The user database
# dictionary The dictionary for your NAS
DbDir /usr/local/etc/raddb
AuthPort 1812
AcctPort 1813
Trace 4
<Client DEFAULT>
Secret XXX
</Client>
#
# PowerUser.Net
#
<Realm pt>
AuthByPolicy ContinueAlways
<AuthBy SQL>
AuthSelect
# DBSource dbi:Oracle:WG73
DBSource dbi:Oracle:reliant_tcp_WG73
DBUsername XXX
DBAuth YYY
AccountingTable RADIUS
AccountingStopsOnly
AcctSQLStatement \
INSERT INTO radius \
( session_id, \
username, \
login_time, \
logout_time, \
session_time, \
server, \
input_packets, \
output_packets, \
xmit_data_rate, \
data_rate, \
framed_address, \
caller_id, \
disconnect_code, \
progress_code ) \
VALUES \
( '%{Acct-Session-Id}', \
LOWER('%{User-Name}'), \
(NVL((%{Timestamp}-0), 0) - \
NVL((%{Acct-Session-Time}-0), 0)), \
NVL((%{Timestamp}-0), 0), \
NVL((%{Acct-Session-Time}-0), 0), \
'%{NAS-Identifier}', \
NVL((%{Acct-Input-Packets}-0), 0), \
NVL((%{Acct-Output-Packets}-0), 0), \
NVL((%{Ascend-Xmit-Rate}-0), 0), \
NVL((%{Ascend-Data-Rate}-0), 0), \
'%{Framed-Address}', \
'%{Caller-Id}', \
NVL((%{Ascend-Disconnect-Cause}-0), 0), \
NVL((%{Ascend-Connect-Progress}-0), 0) )
</AuthBy>
<AuthBy RADIUS>
Host 204.128.175.6
AuthPort 1645
Secret XXX
</AuthBy>
</Realm>
# This clause handles all the other realms
<Realm DEFAULT>
AuthByPolicy ContinueAlways
<AuthBy SQL>
AuthSelect
DBSource dbi:Oracle:WG73
DBUsername XXX
DBAuth YYY
AccountingTable RADIUS
AccountingStopsOnly
AcctSQLStatement \
INSERT INTO radius \
( session_id, \
username, \
login_time, \
logout_time, \
session_time, \
server, \
input_packets, \
output_packets, \
xmit_data_rate, \
data_rate, \
framed_address, \
caller_id, \
disconnect_code, \
progress_code ) \
VALUES \
( '%{Acct-Session-Id}', \
LOWER('%{User-Name}'), \
(NVL((%{Timestamp}-0), 0) - \
NVL((%{Acct-Session-Time}-0), 0)), \
NVL((%{Timestamp}-0), 0), \
NVL((%{Acct-Session-Time}-0), 0), \
'%{NAS-Identifier}', \
NVL((%{Acct-Input-Packets}-0), 0), \
NVL((%{Acct-Output-Packets}-0), 0), \
NVL((%{Ascend-Xmit-Rate}-0), 0), \
NVL((%{Ascend-Data-Rate}-0), 0), \
'%{Framed-Address}', \
'%{Caller-Id}', \
NVL((%{Ascend-Disconnect-Cause}-0), 0), \
NVL((%{Ascend-Connect-Progress}-0), 0) )
</AuthBy>
<AuthBy RADIUS>
Host reliant.anc.net
Secret XXX
AuthPort 1645
AcctPort 1646
Host defiant.anc.net
Secret XXX
AuthPort 1645
AcctPort 1646
</AuthBy>
</Realm>
-- 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.
