Primary Key Violation CALLS Table - Account Session ID TooLong
PSS ( (no email) )
Thu, 10 Sep 1998 11:54:29 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01BDDCB1.C4702D50
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0017_01BDDCB1.C4702D50"
------=_NextPart_001_0017_01BDDCB1.C4702D50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
We have just installed two Nortel Rapport (Shiva Boxes Repackaged).
We run radius 2.5 in ODBC Mode with a SQL Server Backend.
All works well but some records are not being inserted into the Calls =
Table.
Running Radius in Debug Mode There is a primary key violation. The =
Primary key is being violated because the Rapport Account Session ID is =
24 Characters long. We tried wideding the SQL Server's AccountSessiosnID =
field to Varchar(24) but the Radius is still Truncating the Record to =
the first 8 Characters. Hence Uniqueness is Not Happening.
Any Sugestions ?
Damian P Dunphy
Technical Director
CDA Inc / BIOS Inc
6,5th Ave. Bellvile
St. Michael =20
Barbados
Phone : (246) 430-1569
Fax: (246) 430-6330
damian@sunbeach.net
Web Page: http://www.sunbeach.net
------=_NextPart_001_0017_01BDDCB1.C4702D50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
We have just installed two Nortel =Rapport (Shiva=20Boxes Repackaged).
We run radius 2.5 in ODBC Mode with =a SQL Server=20Backend.
All works well but some records are not being =inserted into=20the Calls Table.
Running Radius in Debug Mode There is a primary key =violation.=20The Primary key is being violated because the Rapport Account Session ID =is 24=20Characters long. We tried wideding the SQL Server's AccountSessiosnID =field to=20Varchar(24) but the Radius is still Truncating the Record to the first 8 =Characters. Hence Uniqueness is Not Happening.
Any Sugestions ?
Damian P Dunphy
Technical Director
CDA Inc =/ BIOS=20Inc
6,5th Ave. Bellvile
St. Michael =20
Barbados
Phone : (246)=20430-1569
Fax: (246) =430-6330
damian@sunbeach.net
Web Page: =http://www.sunbeach.net
------=_NextPart_001_0017_01BDDCB1.C4702D50--------=_NextPart_000_0016_01BDDCB1.C4702D50Content-Type: text/x-vcard; name="Damian P Dunphy.vcf"Content-Transfer-Encoding: quoted-printableContent-Disposition: attachment; filename="Damian P Dunphy.vcf"BEGIN:VCARDVERSION:2.1N:Dunphy;Damian;PFN:Damian P DunphyORG:BIOS IncTITLE:Technical DirectorTEL;WORK;VOICE:(246) 430-1569TEL;WORK;FAX:(246) 430-6330ADR;WORK:;;6,5th Ave. Bellvile;St. Michael;;;BarbadosLABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:6,5th Ave. Bellvile=3D0D=3D0ASt. =Michael=3D0D=3D0ABarbadosURL:URL:http://www.sunbeach.netEMAIL;PREF;INTERNET:damian@sunbeach.netREV:19980910T155429ZEND:VCARD------=_NextPart_000_0016_01BDDCB1.C4702D50--