Re: [RadiusNT] CVX Nortel Accounting packets

Mourad Dahoumane ( (no email) )
Fri, 29 Oct 1999 16:14:31 +0200

I tried to create manually a 1024 and 1025 port even though Emerald reports
128 ports.
Re-set permissions on the calls table.
Set Radius to 1)Manual Calls Update
2)Stop Record Only , without these settings nothing is
stored if in the database and I get the error mentionned at the end of
this mail

The result is that I do receive the accountings packet and they are stored
correctly, I can see them directly in the table with enterprise manager.

But still nothing on th call view.

Any thoughts on what to do on call view ?

M.Dahoumane
Connexion Interway
----- Original Message -----
From: Mourad Dahoumane <mdahoumane@interway.lu>
To: <RadiusNT@iea-software.com>
Sent: Thursday, October 28, 1999 4:54 PM
Subject: [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