> With regards to the duplicates, we've been working with an RA8000 for over
2
> years now, and we've noticed that the AcctSessionID returns the same
values
> after a while, especially if you have rebooted the NAS. To circumvent the
> problem we extended our Primary key to include the datetime. This allows
us
> to protect the calls table from real doubles (resends due to timeouts,
etc),
> and still enters the others.
>
> Herman
>
> -----Original Message-----
> From: Mourad Dahoumane [mailto:mdahoumane@interway.lu]
> Sent: donderdag 28 oktober 1999 8:17
> To: RadiusNT@iea-software.com
> Subject: Fw: Fw: [RadiusNT] CVX Nortel Accounting packets
>
>
> I re-send this mail as I don't know if it went through.
> Sorry if it already has.
>
> M.Dahoumane
> ----- Original Message -----
> From: Mourad Dahoumane <mdahoumane@interway.lu>
> To: <radiusnt@iea-software.com>
> Sent: Wednesday, October 27, 1999 3:12 PM
> Subject: Re: Fw: [RadiusNT] CVX Nortel Accounting packets
>
>
> > How did you managed to create that port ? It let me create 1024 ports
and
> > modems but it doesn't let me save it , it says overflow value=1024.
> >
> > The key on the pk_calls index for the calls table are:
> > AcctSessionID
> > NASIdentifier
> > AcctStatusType
> > NASPort
> >
> > Are you sure that removing this index will have no impact ?
> >
> > ----- Original Message -----
> > From: Charlie Cocuzza <charlie@megahits.com>
> > To: <radiusnt@iea-software.com>
> > Sent: Wednesday, October 27, 1999 1:12 PM
> > Subject: RE: Fw: [RadiusNT] CVX Nortel Accounting packets
> >
> >
> > > We had the same problem with Ascend blades. Couldn't see the calls on
> > line.
> > > It had to do with the way the NASPort was being identified. The
> > Callsonline
> > > view is a view off of the serverports table. If your NASports are not
> > > defined in serverports, or are not the same as what your NAS is
> reporting
> > > the serverports table will not be updated.
> > >
> > > In your accounting record below, your NASPort is 1024. Do you have a
> port
> > > defined as 1024 for this particular ServerID in serverports? After we
> > fixed
> > > the NASPort definitions our callsonline view started working.
> > >
> > > Your duplicate key in object 'Calls' is another issue. We had that
> > problem
> > > also with one of our NASs. This may sound funny, but our accounting
> > secret
> > > was defined incorrectly. We fixed that and this error went away.
> > >
> > > Charlie Cocuzza
> > >
> > > -----Original Message-----
> > > From: radiusnt-request@iea-software.com
> > > [mailto:radiusnt-request@iea-software.com]On Behalf Of
> > > hostmaster@interaxs.net
> > > Sent: Wednesday, October 27, 1999 5:52 AM
> > > To: radiusnt@iea-software.com
> > > Subject: Re: Fw: [RadiusNT] CVX Nortel Accounting packets
> > >
> > >
> > > 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
> > >
> > >
> > > 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart