Message 2: Re: Problems with Emerald
from "Alan D. Criado" <ACriado@elink.net>
Message 3: Re: Problems with Emerald
from "Josh Hillman" <admin-maillist@talstar.com>
Message 4: Re: Problems with Emerald
from "Alan D. Criado" <ACriado@elink.net>
Message 5: Re: Problems with Emerald
from "Josh Hillman" <admin-maillist@talstar.com>
Message 6: Re: Problems with Emerald
from "Alan D. Criado" <ACriado@elink.net>
Message 7: Re: Problems with Emerald
from "Alan D. Criado" <ACriado@elink.net>
Message 8: Install Problems with Emerald
from "Rick Morgan" <eval2@gtn.net>
Message 9: Re: Install Problems with Emerald
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 10: Re: Credit Card Expiration Date Question
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 11: Time limited account
from " Olivier Astier " <astier@EchoWeb.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Problems with Emerald
From: "Alan D. Criado" <ACriado@elink.net>
Date: Mon, 10 Aug 1998 10:16:25 -0400
Hello Dale and anyone else that may be able to help.
I'm using Emerald 2.2.38.
Several things are going wrong with my Emerald:
1. When I go the ONLINE section, it shows users being online that are NOT
currently online.
In addition, it shows them as being online for over 2,000 minutes.
2. When I try to do a test login via the RADLOGIN [username] [password],
instead of getting
a GOOD result, I get T/O: 1 result, even though the account is good.
3. I am unable to make any changes to any MBRs.
4. Emerald is running very sluggish.
I will appreciate any help I can get, the sooner the better (grin).
Thank you.
Alan D. Criado
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Alan D. Criado" <ACriado@elink.net>
Date: Mon, 10 Aug 1998 11:11:54 -0400
Ok, I think I've found the source to my problems, but I am uncertain as to
how to correct it.
It appears that my TRANSACTION LOG is full.
1. I see the option of truncating it within SQL Enterprise Manager but I
don't know if truncating the log will have an affect on our billing.
2. I believe another option is to expand the log size, but I don't know how
this is done and don't want to make a mistake that can damage the database.
Any ideas?
Thank you.
Alan
At 10:16 AM 8/10/98 -0400, Alan D. Criado wrote:
>
>Hello Dale and anyone else that may be able to help.
>
>I'm using Emerald 2.2.38.
>
>Several things are going wrong with my Emerald:
>
>1. When I go the ONLINE section, it shows users being online that are NOT
>currently online.
> In addition, it shows them as being online for over 2,000 minutes.
>
>2. When I try to do a test login via the RADLOGIN [username] [password],
>instead of getting
> a GOOD result, I get T/O: 1 result, even though the account is good.
>
>3. I am unable to make any changes to any MBRs.
>
>4. Emerald is running very sluggish.
>
>I will appreciate any help I can get, the sooner the better (grin).
>
>Thank you.
>
>Alan D. Criado
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Mon, 10 Aug 1998 11:53:16 -0400
> From: Alan D. Criado <ACriado@elink.net>
> It appears that my TRANSACTION LOG is full.
>
> 1. I see the option of truncating it within SQL Enterprise Manager but I
> don't know if truncating the log will have an affect on our billing.
Double-click on Emerald (in the Database tree). Click on the Options tab.
Make sure "Truncate Log on Checkpoint" is checked. Click back on the
Database tab, then click on the Truncate button. I seem to remember it
telling you that it's a good idea to back it up, but I don't remember. I
haven't had to click on that button in ages (since I checked that option
that I mentioned).
This will have no effect on your data, so billing should not be affected.
> 2. I believe another option is to expand the log size, but I don't know
how
> this is done and don't want to make a mistake that can damage the
database.
Your best bet is to create a new Database Device (call it EmeraldTransLogs
or something) and allocate something like 25MB (that's what mine is and I
never have a problem). Then double-click on your Emerald database again
and choose Expand. Click on the "Log Device" selection menu and choose the
new device you just created. Next to it, enter in the size you just
created. Click on Expand Now. Now your Transaction Logs will no longer be
stored in the same place as your Emerald database data. More importantly,
if your logs should ever fill up again (possible if you do a lot of big
data-manipulation stuff at once), it WON'T affect the size of your
database, so data can still be entered into it. This is what caused your
problem before becaue data and logs were mixed on the same device.
Josh Hillman
hillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Alan D. Criado" <ACriado@elink.net>
Date: Mon, 10 Aug 1998 12:21:03 -0400
Thank you Josh, this is not the first time you've been really helpful and I
really appreciate it.
I've done as you suggested below and everything seemed to work ok.
There's only one thing left which is very peculiar. Before making the
changes, the ONLINE section of emerald showed a list of users online for
over 2,000 minutes when they were not online at all. After making the
changes most of those disappeared, but not all. There are still five users
showing over 2 days of online connection.
Do you know why the ONLINE section is still showing these users online,
even though they are not? In addition, the ghost users are shown as having
been assigned an IP (which is normal), however new users logging on are
being shown has getting some of the same IPs as the ghost users. The five
ghost accounts which remain in the ONLINE section are also preventing the
real users of these accounts from logging in since radius says they are
already online.
Thanks.
Alan
At 11:53 AM 8/10/98 -0400, Josh Hillman wrote:
>> From: Alan D. Criado <ACriado@elink.net>
>> It appears that my TRANSACTION LOG is full.
>>
>> 1. I see the option of truncating it within SQL Enterprise Manager but I
>> don't know if truncating the log will have an affect on our billing.
>
>Double-click on Emerald (in the Database tree). Click on the Options tab.
>Make sure "Truncate Log on Checkpoint" is checked. Click back on the
>Database tab, then click on the Truncate button. I seem to remember it
>telling you that it's a good idea to back it up, but I don't remember. I
>haven't had to click on that button in ages (since I checked that option
>that I mentioned).
>This will have no effect on your data, so billing should not be affected.
>
>> 2. I believe another option is to expand the log size, but I don't know
>how
>> this is done and don't want to make a mistake that can damage the
>database.
>
>Your best bet is to create a new Database Device (call it EmeraldTransLogs
>or something) and allocate something like 25MB (that's what mine is and I
>never have a problem). Then double-click on your Emerald database again
>and choose Expand. Click on the "Log Device" selection menu and choose the
>new device you just created. Next to it, enter in the size you just
>created. Click on Expand Now. Now your Transaction Logs will no longer be
>stored in the same place as your Emerald database data. More importantly,
>if your logs should ever fill up again (possible if you do a lot of big
>data-manipulation stuff at once), it WON'T affect the size of your
>database, so data can still be entered into it. This is what caused your
>problem before becaue data and logs were mixed on the same device.
>
>Josh Hillman
>hillman@talstar.com
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Mon, 10 Aug 1998 12:50:16 -0400
> From: Alan D. Criado <ACriado@elink.net>
> Thank you Josh, this is not the first time you've been really helpful and
I
> really appreciate it.
No problem :)
> There's only one thing left which is very peculiar. Before making the
> changes, the ONLINE section of emerald showed a list of users online for
> over 2,000 minutes when they were not online at all. After making the
> changes most of those disappeared, but not all. There are still five
users
> showing over 2 days of online connection.
>
> Do you know why the ONLINE section is still showing these users online,
> even though they are not? In addition, the ghost users are shown as
having
> been assigned an IP (which is normal), however new users logging on are
> being shown has getting some of the same IPs as the ghost users. The
five
> ghost accounts which remain in the ONLINE section are also preventing the
> real users of these accounts from logging in since radius says they are
> already online.
When your transaction logs filled up, it filled up the database device and
because at the time, your data and transaction logs were occupying the same
space, that prevented any more data from being entered into your database.
This affected your "online" info because the database had no way of
accepting the STOP records being sent out by your NAS via radius. If there
are only a few people affected by this, you can click on a username in the
"online" area and then click on the Clear button. That'll take care of
them. If there are a lot of these and you don't to deal with it by only
being able to do one at a time, you can also run a script to wipe them out.
Every once in a while, I'll run the following script if I need to reset
our Maxes or something (though normally, I unplug the dial-up T1s so that
the Max sends out Stop records for all sessions and knocks them offline).
The script, nor clicking on Clear, will actually disconnect a user. It
just removes them from the online list and if you're using concurrency
control, will alow that user to login.
If you use this, make sure you change the ServerID to whatever number
matches your NAS (SELECT * from Servers)
/* Clear all Max users from CallsOnline */
UPDATE ServerPorts
SET AcctStatusType=2
WHERE ServerID=3 /* Max1 */
OR ServerID=5 /* Max2 */
OR ServerID=9 /* Max3 */
Josh Hillman
hillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Alan D. Criado" <ACriado@elink.net>
Date: Mon, 10 Aug 1998 13:00:55 -0400
Josh you're good! It worked.
This SQL stuff is something I need to get a better handle on.
Thank you for your assistance.
Alan
At 12:50 PM 8/10/98 -0400, Josh Hillman wrote:
>> From: Alan D. Criado <ACriado@elink.net>
>> Thank you Josh, this is not the first time you've been really helpful and
>I
>> really appreciate it.
>
>No problem :)
>
>> There's only one thing left which is very peculiar. Before making the
>> changes, the ONLINE section of emerald showed a list of users online for
>> over 2,000 minutes when they were not online at all. After making the
>> changes most of those disappeared, but not all. There are still five
>users
>> showing over 2 days of online connection.
>>
>> Do you know why the ONLINE section is still showing these users online,
>> even though they are not? In addition, the ghost users are shown as
>having
>> been assigned an IP (which is normal), however new users logging on are
>> being shown has getting some of the same IPs as the ghost users. The
>five
>> ghost accounts which remain in the ONLINE section are also preventing the
>> real users of these accounts from logging in since radius says they are
>> already online.
>
>When your transaction logs filled up, it filled up the database device and
>because at the time, your data and transaction logs were occupying the same
>space, that prevented any more data from being entered into your database.
>This affected your "online" info because the database had no way of
>accepting the STOP records being sent out by your NAS via radius. If there
>are only a few people affected by this, you can click on a username in the
>"online" area and then click on the Clear button. That'll take care of
>them. If there are a lot of these and you don't to deal with it by only
>being able to do one at a time, you can also run a script to wipe them out.
> Every once in a while, I'll run the following script if I need to reset
>our Maxes or something (though normally, I unplug the dial-up T1s so that
>the Max sends out Stop records for all sessions and knocks them offline).
>The script, nor clicking on Clear, will actually disconnect a user. It
>just removes them from the online list and if you're using concurrency
>control, will alow that user to login.
>
>If you use this, make sure you change the ServerID to whatever number
>matches your NAS (SELECT * from Servers)
>
>/* Clear all Max users from CallsOnline */
>UPDATE ServerPorts
>SET AcctStatusType=2
>WHERE ServerID=3 /* Max1 */
>OR ServerID=5 /* Max2 */
>OR ServerID=9 /* Max3 */
>
>Josh Hillman
>hillman@talstar.com
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Problems with Emerald
From: "Alan D. Criado" <ACriado@elink.net>
Date: Mon, 10 Aug 1998 13:02:31 -0400
Hey Josh, I forgot.
If you are ever down here in Miami, let me know and I'll take you out
fishing. If you don't like fishing, then dinner.
Take care.
Alan
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Install Problems with Emerald
From: "Rick Morgan" <eval2@gtn.net>
Date: Mon, 10 Aug 1998 15:17:48 -0400
We have successfully installed Emerald on Win95 stations, but We are
encountering problems installing on our NT 4.0 (SP3) systems (both server
and workstation).
Emerald Version is 2.1.11
Error message when loading client is " 53:File not found"
Error message when loading administrator is "Can't load (or register)
customcontrol 'VBSQL.OCX'. "
We have made attempts on 3 different systems 2 Wkstations and 1 server (New
installation) results were identical on all systems.
Suggestions?
Rick Morgan
GTN Communications
www.gtn.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 9 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Install Problems with Emerald
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 10 Aug 1998 13:33:37 -0700
Rick Morgan wrote:
>
> We have successfully installed Emerald on Win95 stations, but We are
> encountering problems installing on our NT 4.0 (SP3) systems (both server
> and workstation).
>
> Emerald Version is 2.1.11
> Error message when loading client is " 53:File not found"
> Error message when loading administrator is "Can't load (or register)
> customcontrol 'VBSQL.OCX'. "
You need to install the SQL Client. This is outlined in the client
installation on the website. Emerald itself does NOT use ODBC, it
talks to SQL Server directly and therefore requires the client libraries
to be installed or will not work.
> We have made attempts on 3 different systems 2 Wkstations and 1 server (New
> installation) results were identical on all systems.
See this URL, specially the "install the SQL Client" section:
http://www.iea-software.com/emerald/docs/gettingstarted.html
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Credit Card Expiration Date QuestionFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Mon, 10 Aug 1998 08:22:35 -0700
Vance Duke wrote:> > In the MasterAccounts table can I input a date that is 'mmyyyy' without> messing anything up?
You should enter itas mmyy. There are some notes that IC Verifyrequires credit cards that expire after the year 1999 to be enteredin yymm format for it to work correctly.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Time limited accountFrom: " Olivier Astier " <astier@EchoWeb.net>Date: Mon, 10 Aug 1998 18:26:49 PDT
Hi all,
I have set an account limited to 9 hours with no overtime(the "rate" settings are : "allow overtime" unchecked and "standard hours" 9).With this account I already logged on more than 9 hours and I can still log on.Furthermore, in Debug mode, I saw that Radius doesn't send any "session-timeout" attribute to the NAS (I didn't configured it but I assume that radius should send it according to the time left).
Any idea?
Thank you for your attention
Oliver Astier EchoWeb LLC