RE: [Emerald] Online view not working

Todd H. Simmons ( (no email) )
Mon, 9 Sep 2002 12:46:59 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C257FF.00593B00
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Yes, I use Query Analyzer to run the script on the Emerald database.


Todd

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Ben Conner
Sent: Monday, September 09, 2002 11:32 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] Online view not working

Hi Todd,

Didn't find it in the release scripts, but found a copy on their ftp
site. I assume this is the one you are referring to? This will work
with the Emerald 2.5 database? Just don't want to screw something up.
:)

--Ben

At 09:50 AM 9/9/02, you wrote:
>Sounds like the ports need to be updated. This happens to us everytime
>we add lines. We just keep running the updtport.sql script once a day.
>They eventually come back up.
>
>
>Todd
>-----Original Message-----
>From: emerald-request@iea-software.com
>[mailto:emerald-request@iea-software.com] On Behalf Of Ben Conner
>Sent: Monday, September 09, 2002 10:37 AM
>To: emerald@iea-software.com
>Subject: [Emerald] Online view not working
>
>
>Hi,
>
>Not sure if this is a RadiusNT issue or Emerald, but here's what's
>happening:
>
>I switched providers recently and had to renumber. The RAS (PM3) was
>(is) behind a firewall in both locations, so the internal IP address it
>has didn't change (10.0.0.3).
>
>In the old location, the Online view showed users logged on. In the
new
>one, it doesn't. They don't have problems authenticating, but just
>don't show up.
>
>To make sure it wasn't a permissions issue, I've also tried logging in
>to Emerald with SA with no change.
>
>I'm using Emerald 2.5.342 w/ RadiusNT vsn 2.5.217.
>
>Details
>
> 1. PM3 is set to 10.0.0.3 behind a firewall. It goes out through
the
>firewall and is reported as 10.0.0.3 to RadiusNT (NAS-Identifier =
>10.0.0.3)
>
> 2. The entry I have in Emerald Admin for this NAS is:
>
> Server Address: 209.144.99.1 (The address of the firewall)
> Ports 47 Modems 47
> Pool Start: 209.144.99.65
> Pool End: 209.144.99.113
>
> 3. Server Ports have been defined (0-46) but have no activity on
them.
>
>Users are getting authenticated, and accounting records generated.
>Sample for both:
>
>Tue Sep 03 20:37:37 2002
> Acct-Session-Id = "08000159"
> User-Name = "citytow"
> NAS-Identifier = 10.0.0.3
> NAS-Port = 10
> NAS-Port-Type = Async
> Acct-Status-Type = Start
> Acct-Authentic = RADIUS
> Connect-Info = "40000 LAPM/V42BIS"
> NAS-Port-DNIS = "0164"
> Caller-Id = "7146365432"
> User-Service = Framed-User
> Framed-Protocol = PPP
> Framed-Address = 209.144.99.92
> Acct-Delay-Time = 0
>
>Tue Sep 03 20:38:22 2002
> Acct-Session-Id = "0800014B"
> User-Name = "tom"
> NAS-Identifier = 10.0.0.3
> NAS-Port = 4
> NAS-Port-Type = Async
> Acct-Status-Type = Stop
> Acct-Session-Time = 1246
> Acct-Authentic = RADIUS
> Connect-Info = "44000 LAPM/V42BIS"
> Acct-Input-Octets = 1091994
> Acct-Output-Octets = 153678
> NAS-Port-DNIS = "0164"
> Caller-Id = "7145346813"
> Acct-Terminate-Cause = Lost-Carrier
> LE-Terminate-Detail = "Lost Carrier"
> User-Service = Framed-User
> Framed-Protocol = PPP
> Framed-Address = 209.144.99.96
> Acct-Delay-Time = 0
>
>
>Any suggestions where to start looking for this one?
>
>Thanks much!
>
>--Ben
>
>+----------------------------------------------------------------------
-
>---+
>+ Ben Conner ben@webworldinc.com
>+
>+ Web World, Inc. (888) 206-6486 voice
>+
>+ PO Box 6548-107
>+
>+ Orange, Ca 92863
>+
>+----------------------------------------------------------------------
-
>---+
>
>
>------------
>
>This is a user supported list. If you require assistance from IEA
Software's
>Support Engineers, please check out our Support resources at
>http://www.iea-software.com/support.
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart

+-----------------------------------------------------------------------
---+
+ Ben Conner ben@webworldinc.com
+
+ Web World, Inc. (888) 206-6486 voice
+
+ PO Box 6548-107
+
+ Orange, Ca 92863
+
+-----------------------------------------------------------------------
---+

------=_NextPart_000_0003_01C257FF.00593B00
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Message

Yes, I use Query Analyzer to run the script on the Emerald =database.
 
 
Todd
-----Original Message-----
From:=20 emerald-request@iea-software.com =[mailto:emerald-request@iea-software.com]=20 On Behalf Of Ben Conner
Sent: Monday, September 09, =2002=20 11:32 AM
To: emerald@iea-software.com
Subject: RE: = [Emerald] Online view not working

Hi=20 Todd,

Didn't find it in the release scripts, but found a copy =on their=20 ftp site.  I assume this is the one you are referring to?  =This will=20 work with the Emerald 2.5 database?  Just don't want to screw =something=20 up. :)

--Ben

At 09:50 AM 9/9/02, you =wrote:
>Sounds like=20 the ports need to be updated.  This happens to us =everytime
>we add=20 lines.  We just keep running the updtport.sql script once a=20 day.
>They eventually come back=20 up.
>
>
>Todd
>-----Original =Message-----
>From:=20 emerald-request@iea-software.com
>[mailto:emerald-request@iea-software.com] On =Behalf Of Ben=20 Conner
>Sent: Monday, September 09, 2002 10:37 AM
>To:=20 emerald@iea-software.com
>Subject: [Emerald] Online view not=20 working
>
>
>Hi,
>
>Not sure if this is =a=20 RadiusNT issue or Emerald, but here's=20 what's
>happening:
>
>I switched providers recently =and had=20 to renumber.  The RAS (PM3) was
>(is) behind a firewall in =both=20 locations, so the internal IP address it
>has didn't change=20 (10.0.0.3).
>
>In the old location, the Online view showed =users=20 logged on.  In the new
>one, it doesn't.  They don't =have=20 problems authenticating, but just
>don't show =up.
>
>To make=20 sure it wasn't a permissions issue, I've also tried logging =in
>to=20 Emerald with SA with no change.
>
>I'm using Emerald =2.5.342 w/=20 RadiusNT vsn 2.5.217.
>
>Details
>
>  =1. =20 PM3 is set to 10.0.0.3 behind a firewall.  It goes out through=20 the
>firewall and is reported as 10.0.0.3 to RadiusNT =(NAS-Identifier=20 =3D
>10.0.0.3)
>
>  2.  The entry I have =in Emerald=20 Admin for this NAS =is:
>
>      =20 Server Address: 209.144.99.1   (The address of the=20 firewall)
>       Ports  =47 =20 Modems  47
>       Pool =Start:=20 209.144.99.65
>       Pool=20 End:   209.144.99.113
>
>  3. Server Ports =have=20 been defined (0-46) but have no activity on them.
>
>Users =are=20 getting authenticated, and accounting records generated.
>Sample =for=20 both:
>
>Tue Sep 03 20:37:37=20 2002
>       Acct-Session-Id =3D=20 "08000159"
>       User-Name =3D=20 "citytow"
>       NAS-Identifier ==3D=20 10.0.0.3
>       NAS-Port =3D=20 10
>       NAS-Port-Type =3D=20 Async
>       Acct-Status-Type =3D = Start
>       Acct-Authentic =3D=20 RADIUS
>       Connect-Info =3D ="40000=20 LAPM/V42BIS"
>       NAS-Port-DNIS ==3D=20 "0164"
>       Caller-Id =3D=20 "7146365432"
>       User-Service ==3D=20 Framed-User
>       =Framed-Protocol =3D=20 PPP
>       Framed-Address =3D=20 209.144.99.92
>       =Acct-Delay-Time =3D=20 0
>
>Tue Sep 03 20:38:22=20 2002
>       Acct-Session-Id =3D=20 "0800014B"
>       User-Name =3D=20 "tom"
>       NAS-Identifier =3D=20 10.0.0.3
>       NAS-Port =3D=20 4
>       NAS-Port-Type =3D=20 Async
>       Acct-Status-Type =3D = Stop
>       Acct-Session-Time =3D = 1246
>       Acct-Authentic =3D=20 RADIUS
>       Connect-Info =3D ="44000=20 LAPM/V42BIS"
>       =Acct-Input-Octets =3D=20 1091994
>       Acct-Output-Octets ==3D=20 153678
>       NAS-Port-DNIS =3D=20 "0164"
>       Caller-Id =3D=20 "7145346813"
>       =Acct-Terminate-Cause=20 =3D Lost-Carrier
>       =LE-Terminate-Detail=20 =3D "Lost Carrier"
>       =User-Service =3D=20 Framed-User
>       =Framed-Protocol =3D=20 PPP
>       Framed-Address =3D=20 209.144.99.96
>       =Acct-Delay-Time =3D=20 0
>
>
>Any suggestions where to start looking for =this=20 one?
>
>Thanks=20 =much!
>
>--Ben
>
>+------------------------------=-----------------------------------------
>---+
>+  =;=20 Ben=20 =Conner           &=nbsp;           &n=bsp;    =20 ben@webworldinc.com
>+
>+   Web World,=20 =Inc.           &nb=sp;           =20 (888) 206-6486 voice
>+
>+   PO Box=20 6548-107
>+
>+   Orange, Ca  =20 =92863
>+
>+--------------------------------------------------=---------------------
>---+=20
>
>
>------------
>
>This is a user =supported=20 list. If you require assistance from IEA Software's
>Support =Engineers,=20 please check out our Support resources at
>http://www.iea-software.com/support.
>
&g=t;For=20 more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststar=t
=

+----------------------------------------------------------=----------------+
+  =20 Ben=20 =Conner           &=nbsp;           &n=bsp;    =20 =ben@webworldinc.com         =   =20 +
+   Web World,=20 =Inc.           &nb=sp;           =20 (888) 206-6486=20 =voice           =20 +
+   PO Box=20 =6548-107           =;            =            &=nbsp;           &n=bsp;       =20 +
+   Orange, Ca  =20 =92863           &n=bsp;           &nb=sp;           &nbs=p;            =;    =20 =+
+-------------------------------------------------------------------=-------+=20

------=_NextPart_000_0003_01C257FF.00593B00--