>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.

Reply via email to