Hi Everbody,
We use Cisco 5300 and Radiator 2.14.1. Users are able to authenticate. Radiator
writes the "start" record into the accounting table. But when the connection finished
by the remote client it gives an insert error about stop record like below; Should i
change my cfg file or can it be another reason causing this problem?
Thanks alot.
Best Regards.
****
Mon Mar 13 00:01:19 2000: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, NASIDENTIFIER,
NASPORT, FRAMEDIPADDRESS)
values
('BRAVEHEART', 952898478, 'Stop', 1, 4754, 1785, '289619229', 124,
'User-Request', 'RAN53', 20127, '212.156.205.242')': ORA-01722: invalid number (DBD
ERROR: OCIStmtExecute)
Mon Mar 13 00:01:19 2000: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, NASIDENTIFIER,
NASPORT, FRAMEDIPADDRESS)
values
('BRAVEHEART', 952898478, 'Stop', 1, 4754, 1785, '289619229', 124,
'User-Request', 'RAN53', 20127, '212.156.205.242')': ORA-01722: invalid number (DBD
ERROR: OCIStmtExecute)
Mon Mar 13 00:01:49 2000: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, NASPORT,
FRAMEDIPADDRESS)
values
('ikula', 952898509, 'Stop', 0, 649055, 5356976, '00001186', 6335,
'Lost-Carrier', 87, '10.10.1.92')': ORA-01722: invalid number (DBD ERROR:
OCIStmtExecute)
Mon Mar 13 00:01:49 2000: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, NASPORT,
FRAMEDIPADDRESS)
values
('ikula', 952898509, 'Stop', 0, 649055, 5356976, '00001186', 6335,
'Lost-Carrier', 87, '10.10.1.92')': ORA-01722: invalid number (DBD ERROR:
OCIStmtExecute)
****************
Our cfg file is;
**********************************
Foreground
LogStdout
Trace 4
LogDir /software/Radiator-2.14.1/Logfiles/
LogFile %L/%d-%m-%Y-logfile
DbDir .
<Client xx.xx.xx.xx>
Secret mysecret
# Her bir RAS client icin baska bir havuz yapilabilir
FramedGroupBaseAddress xx.xx.xx.xx
FramedGroupBaseAddress xx.xx.xx.xx
NasType Cisco
DupInterval 2
</Client>
<ClientListSQL>
DBSource dbi:Oracle:basari.world
DBUsername gizli
DBAuth gizli123
</ClientListSQL>
<SessionDatabase SQL>
DBSource dbi:Oracle:basari.world
DBUsername
DBAuth
</SessionDatabase>
<Realm>
PasswordLogFileName %L/%d-%m-%Y-password.log
AuthByPolicy ContinueWhileReject
<AuthBy SQL>
AddToReply Service-Type = Framed-User,
DefaultSimultaneousUse 1
FramedGroup 0
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:Oracle:basari.world
DBUsername
DBAuth
# You may want to tailor these for your ACCOUNTING table
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy >
<AuthBy FILE>
FramedGroup 0
Filename ./userlistbasar
DefaultSimultaneousUse 3
</AuthBy>
</Realm>
*****************
ÿ
Archive at http://www.starport.net/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
