------=_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">
------=_NextPart_000_0003_01C257FF.00593B00-------Original Message-----Hi=20 Todd,
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
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