Probably there is a type mismatch for the table field and the cisco attribute. Can you give us the describtion of the table. Like "Desc tablename" for oracle. I made the same mistake for the terminatecause field and changed the type to integer on radius.cfg
Have a look at the ACCTTERMINATECAUSE NASIDENTIFIER fields. Check the types!!!
Tuncay Margilic
Tel:+90 216 459 27 44
SIEMENS BUSINESS SERVICES
-----Original Message-----
From: OKAN ARISU [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2000 5:43 PM
To: [EMAIL PROTECTED]
Subject: (RADIATOR) Accounting Stop error;
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.
