Re: Fw: [RadiusNT] CVX Nortel Accounting packets

hostmaster@interaxs.net
Wed, 27 Oct 1999 05:51:56 -0400

Go into SQL and see what the Primary Key is for the Calls table and compare
that to the data you are seeing in the text file. You may want, or need, to
change the Primary Key.

Jim

At 11:44 AM 10/27/1999 +0200, you wrote:
>We managed to get the accounting packets but we still can't get the calls
>online view . In odbc mode we get
>this error every time we connect. We set the timeout on the remote side to
>30 seconds but still we get
>
>Wed Oct 27 10:16:00 1999: ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
>constraint 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
>Wed Oct 27 10:17:01 1999: ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
>constraint 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
>
>
>If we switch to text mode we get the following.
>
>Wed Oct 27 10:38:25 1999
> Password = ""
> Acct-Status-Type = Start
> NAS-Identifier = "CVX1"
> NAS-Port = 1024
> NAS-Port-Type = ISDN
> NAS-Port-DNIS = "273111"
> Caller-Id = "456572"
> Acct-Delay-Time = 0
> Framed-Address = 194.235.193.178
> User-Name = "mourad"
> Framed-Protocol = PPP
> Acct-Session-Id = "BBB5A71B:000000DC"
> Acct-Authentic = RADIUS
>
>Wed Oct 27 10:38:55 1999
> Password = ""
> Acct-Status-Type = Stop
> NAS-Identifier = "CVX1"
> NAS-Port = 1024
> NAS-Port-Type = ISDN
> NAS-Port-DNIS = "27300011"
> Caller-Id = "456572"
> Acct-Delay-Time = 0
> Framed-Address = 194.235.193.178
> User-Name = "mourad"
> Framed-Protocol = PPP
> Acct-Input-Octets = 287
> Acct-Output-Octets = 323
> Acct-Session-Id = "BBB5A71B:000000DC"
> Acct-Session-Time = 30
> Acct-Input-Packets = 14
> Acct-Output-Packets = 16
> Acct-Authentic = RADIUS
> Ascend-Disconnect-Cause = 2
> Ascend-Data-Rate = 64000
> Ascend-PreSession-Time = 2
>
>
>
>----- Original Message -----
>From: Mourad Dahoumane <mdahoumane@interway.lu>
>To: <radiusnt@iea-software.com>
>Sent: Tuesday, October 26, 1999 9:54 PM
>Subject: Re: [RadiusNT] CVX Nortel Accounting packets
>
>
> > we are using Radius nt 2.5.175. against Emerald SQL 7 on the same server
>PII
> > 266 with 256MB Memory and 135 physical left
> > The general options are Ignore case, Trim name, allow malformed. In
>advanced
> > options we use the concurrency control,
> > variable login limit and time banking, nothing is selected in Accounting
> > advanced options nor Proxy.
> > Response time are between 16 and 45 for local NAS and 235 mostly for the
>cvx
> >
> > Mourad Dahoumane
> >
> >
> > ----- Original Message -----
> > From: Salman Karim <skarim@cubexs.net.pk>
> > To: <radiusnt@iea-software.com>
> > Sent: Wednesday, October 27, 1999 8:35 AM
> > Subject: Re: [RadiusNT] CVX Nortel Accounting packets
> >
> >
> > > What r the configurations of yr radiusnt
> > >
> > > Salman
> > >
> > >
> > > ---------- Original Message ----------------------------------
> > > From: "Mourad Dahoumane" <mdahoumane@interway.lu>
> > > Reply-To: radiusnt@iea-software.com
> > > Date: Tue, 26 Oct 1999 14:43:16 +0200
> > >
> > > >Hello,
> > >
> > > We are using a nortel CVX for our vpop only recently.
> > > Authentication is working fine ok but we do not get accounting packets.
> > >
> > > Any ideas where could be the problem ?
> > >
> > > Thanks for your help
> > >
> > > M.Dahoumane
> > >
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> > >
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> >
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

----------------------------
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart