Message 2: Re: Credit Card Expiration Date Question
from "Vance Duke" <vduke@sanantonio.net>
Message 3: Re: Time limited account
from "Olivier Astier (Echoweb)" <astier@echoweb.net>
Message 4: delete charges
from Tommy Cheng <tommycheng@pcmagic.net>
Message 5: Re: delete charges
from "Josh Hillman" <admin-maillist@talstar.com>
Message 6: RE: Sub Accounts Problem
from Rafael Gomez <rgomez@c-com.net>
Message 7: Re: Time limited account
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Re: delete charges
from Tommy Cheng <tommycheng@pcmagic.net>
Message 9: IP pooling and Bay Secure Access
from "Joe Bissot" <jblist@pcinternet.net>
Message 10: Re: Credit Card Expiration Date Question
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 11: Re: Sub Accounts Problem
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 12: Re: delete charges
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Time limited account
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 14: Re: Fwd: Emerald & ASP
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: unsubscribe
from "Sean Cook" <scook@centramedia.com>
Message 16: unsubscribe
from webmaster <bob@kep.net>
Message 17: Sendmail
from "Ken Sorenson" <ksoren@tsi-online.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Time limited account
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Tue, 11 Aug 1998 09:22:27 -0400
> From: Olivier Astier <astier@EchoWeb.net>
> 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).
Are you sure you're using the correct Radius attribute? If you're trying
to set a maximum session time of 9 hours through an Ascend Max, you'd set:
Ascend-Maximum-Time = 32400 (seconds)
If you're using Ascend and decide to use the above attribute, the person
will be disconnected within a couple minutes of that time and the
Ascend-Disconnect-Cause will be 100 (session timed out) as if they were
idle.
Josh Hillman
hillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Credit Card Expiration Date Question
From: "Vance Duke" <vduke@sanantonio.net>
Date: Tue, 11 Aug 1998 08:31:52 -0500
Ok. But we are using CF and Cybercash for our credit card processing. Will
using 'mmyyyy' have any adverse affects on the Emerald system?
Thanks.
____________________________________________________________
Vance Duke
Senior Programmer
Allison Royce & Assoc.
http://AllisonRoyce.com/
11118 Watt Circle San Antonio, TX 78233 (210)564-7000 ext.
604
____________________________________________________________
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Monday, August 10, 1998 4:20 PM
Subject: Re: Credit Card Expiration Date Question
>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 Verify
>requires credit cards that expire after the year 1999 to be entered
>in 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 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Time limited account
From: "Olivier Astier (Echoweb)" <astier@echoweb.net>
Date: Tue, 11 Aug 1998 10:07:49 -0800
Thank you for your help but I don't want a session timeout of 9 hours : I
want to limit the account to 9 hours a month.
I'm sorry if I didn't explain it the right way (I am not american).
Oliver Astier
EchoWeb LLC
astier@echoweb.net
-----Original Message-----
From: Josh Hillman <admin-maillist@talstar.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, August 11, 1998 5:20 AM
Subject: Re: Time limited account
>> From: Olivier Astier <astier@EchoWeb.net>
>> 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).
>
>Are you sure you're using the correct Radius attribute? If you're trying
>to set a maximum session time of 9 hours through an Ascend Max, you'd set:
> Ascend-Maximum-Time = 32400 (seconds)
>
>Josh Hillman
>hillman@talstar.com
>
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: delete charges
From: Tommy Cheng <tommycheng@pcmagic.net>
Date: Tue, 11 Aug 1998 12:40:53 -0700
Dale,
How do I delete charges which was created by consolidation process?
After I did consolidation, there are few charges created for some of my
users which I need to delete. Thanks.
Tommy Cheng
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: delete charges
From: "Josh Hillman" <admin-maillist@talstar.com>
Date: Tue, 11 Aug 1998 15:56:48 -0400
> From: Tommy Cheng <tommycheng@pcmagic.net>
> How do I delete charges which was created by consolidation process?
> After I did consolidation, there are few charges created for some of my
> users which I need to delete. Thanks.
Using ISQL, run the following, but make sure that these charges are NOT
already part of an existing invoice.
DELETE FROM Charges
WHERE ChargeID = 1234 /* the number you see next to the Charge in
a user's MBR under the History tab */
Josh Hillman
hillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Sub Accounts Problem
From: Rafael Gomez <rgomez@c-com.net>
Date: Tue, 11 Aug 1998 16:27:47 -0400
------ =_NextPart_000_01BDC544.FAA7F080
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Can anybody help me with this. Dale, Are you there?
Rafael Gomez
-----Mensaje original-----
De: Josh Hillman [SMTP:admin-maillist@talstar.com]
Enviado el: Tuesday, August 04, 1998 6:07 PM
Para: emerald@iea-software.com
Asunto: Re: Sub Accounts Problem
From: Rafael Gomez <rgomez@c-com.net>
Is possible Emerald response the message below because I have two user with
the same password?
I don't know what's causing the problem that you're running into, but users
can have the same passwords. It's login/shell names that can't be the
same.
Josh Hillman
hillman@talstar.com
-----Mensaje original-----
De: Rafael Gomez
Enviado el: Tuesday, August 04, 1998 4:57 PM
Para: 'emerald@iea-software.com'
Asunto: Sub Accounts Problem
Hi all
I'm having edit problems with the subaccount table. When I try to edit one
account with the Emerald software the system answer is a "error type
mistmatch 13". I added more space to the database device. Can any of you
help me with this, please?
Thanks in advance
Rafael Gomez
rgomez@c-com.net
----------
------ =_NextPart_000_01BDC544.FAA7F080
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjEUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAARAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAEGVtZXJhbGRAaWVhLXNv
ZnR3YXJlLmNvbQBTTVRQAGVtZXJhbGRAaWVhLXNvZnR3YXJlLmNvbQAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABkAAABlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20AAAAAAwAVDAEAAAADAP4P
BgAAAB4AATABAAAAGwAAACdlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20nAAACAQswAQAAAB4AAABT
TVRQOkVNRVJBTERASUVBLVNPRlRXQVJFLkNPTQAAAAMAADkAAAAACwBAOgEAAAADAHE6AAAAAB4A
9l8BAAAAGQAAAGVtZXJhbGRAaWVhLXNvZnR3YXJlLmNvbQAAAAACAfdfAQAAAE8AAAAAAAAAgSsf
pL6jEBmdbgDdAQ9UAgAAABBlbWVyYWxkQGllYS1zb2Z0d2FyZS5jb20AU01UUABlbWVyYWxkQGll
YS1zb2Z0d2FyZS5jb20AAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACIGUBBIABABkA
AABSRTogU3ViIEFjY291bnRzIFByb2JsZW0AbAgBBYADAA4AAADOBwgACwAQABsALwACAEQBASCA
AwAOAAAAzgcIAAsAEAAbABIAAgAnAQEJgAEAIQAAADMxQUMyREQyMzIzMUQyMTE4RUE4MDBBMDI0
OTgxM0Y2APMGAQOQBgC8BwAAIgAAAAsAAgABAAAACwAjAAEAAAADACYAAAAAAAsAKQABAAAAAwAu
AAAAAAACATEAAQAAAMcAAABQQ0RGRUIwOQABAAIASQAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABt
c3BzdC5kbGwAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lORE9XU1xyYWZhLnBzdAAYAAAAAAAA
APmD4gZw2NERjp0AoCSYE/aigAAAAAAAABgAAAAAAAAA+YPiBnDY0RGOnQCgJJgT9sKAAAAQAAAA
Mawt0jIx0hGOqACgJJgT9hkAAABSRTogU3ViIEFjY291bnRzIFByb2JsZW0AAAMANgAAAAAAQAA5
ACBd34Bmxb0BHgBwAAEAAAAZAAAAUkU6IFN1YiBBY2NvdW50cyBQcm9ibGVtAAAAAAIBcQABAAAA
FgAAAAG9xWaArdItrDMxMhHSjqgAoCSYE/YAAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEAAAAR
AAAAcmdvbWV6QGMtY29tLm5ldAAAAAADAAYQURF7pgMABxBVAwAAHgAIEAEAAABlAAAAQ0FOQU5Z
Qk9EWUhFTFBNRVdJVEhUSElTREFMRSxBUkVZT1VUSEVSRT9SQUZBRUxHT01FWi0tLS0tTUVOU0FK
RU9SSUdJTkFMLS0tLS1ERTpKT1NISElMTE1BTlNNVFA6QURNSQAAAAACAQkQAQAAAMsDAADHAwAA
bwYAAExaRnVAR3hvdwAKAQMB9yACpAPjAgBjgmgKwHNldDAgBxOPAoMAUALyD1lUYWgDcYUCgzIO
53BycTIP9iZ9CoAIyCA7CW8yNWY1AoAKgXVjAFALA2ODAEELYG5nMzA4EmFZC8QgQwORAHB5BuBk
gHkgaGVscCAHgGIgA/B0aCAZgAQALmQgRAdAZSwP8RlAeecIYBmhBJBlPwqiCoQbn4cWowFAFxIx
MDMzEIOIczE3B/BhZmEY8CQgRwNwZXocemxpnDM2HVQXUxMAb3QFkEJ0EkQxNiAtIfJNMQnwc2Fq
GUAFsGln/wuAB0Ah8xu2IQQBQAsEIQYgaS0xNDQdUWkxXDgwAUAM0CWTYhoAZYo6DINiD+BKb3MZ
kApIAxBsA4JbU01UoFA6YWRtC4AtAMDTJ/EEAHRAAZBsKYAKwDIuBaBtXRu1JsBFbmJ2BzBkbyAY
8CcHVCEKUHNkYXkaUXVnInUpgCAwNBpQMTlAOTggNjowHmBQqk0qd1AKwGEnB2UHgBEu4GxkQAiQ
YS1zam8BgHcKwGUqIip3QdRzdQIwbycHUibwBgC6dTGBYwWgMcEEIFADYP8CYC+QI58kqiAIHbQL
xRvDDkYDYTKwHoogPHJnkR8CQGMtKjEubg/A6j4btEkEIHAnoACQM9HrKvAvpCAJcHM6gACAGUCn
GvEZIQQQYWcZQGIY8GZvB+A84GNhLPAZQEnpGNBhdjwBdytgPYEFwP8ZYhu0PCIicBkxCrAEED5A
TwsgG0s9wCtQbicFQGvKbj0Rdw+AdCcEID1i/QuAZzwTIPEz0hmhQjAaovonGoFyMcADAELRC4Ax
4PkaUGJ1BUA+cg9AG8M9YP8DoD3kP34Z4T2wQkIJACLx/i8nsBjwAyAjEAeCQ8NGUd9BkTzgGuIb
tD+iLhu6J5r/G7QZwCgDKaobuiH/Iw0m5R83/Bu0Kw0sLy03NDo1sy34LscgJy+fMKUnG7T/Maky
zzPaG9In4BhQKAAbtflRckknQ6A94ULCCYAZcP9DNgQgGWU/gVmwANBaAxmgdwGgGjAZ8FcY4AOg
PcB0/nIYwDHgXVQCIEqlXwZeR3c7FjBWRtR5KYBDkQBxd+c+kQQAGFAgIgSQA2AFwHh0eXBKpSjg
KYAAwHTzD3AtYDMiGfA9wCjAAQD/O3AEYBqBO7AA0DwBK2A8Iu9UIAGRQABowWUrIGhAGfD7GCVP
8GYaokzlGP4aUAtQlzAgD7AbS1QPgG5rBCB7C4BnUXYAcGhAG7oejwpfOO5O2SNLG9gTwQBz4AAD
ABAQAAAAAAMAERAAAAAAAwCAEP////9AAAcwgIO/b2bFvQFAAAgwgIO/b2bFvQELAAGACCAGAAAA
AADAAAAAAAAARgAAAAADhQAAAAAAAAMAA4AIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAG
gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAAeACaACCAGAAAAAADAAAAAAAAARgAAAABUhQAA
AQAAAAQAAAA4LjAAAwAngAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALADCACCAGAAAAAADA
AAAAAAAARgAAAAAOhQAAAAAAAAMAMYAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAzgAgg
BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEKACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA
AAEAAAAAAAAAHgBDgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4ARIAIIAYA
AAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAeAD0AAQAAAAUAAABSRTogAAAAAAMADTT9
NwAAYuw=
------ =_NextPart_000_01BDC544.FAA7F080--
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Time limited account
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Tue, 11 Aug 1998 13:29:51 -0700
Olivier Astier (Echoweb) wrote:
>
> Thank you for your help but I don't want a session timeout of 9 hours : I
> want to limit the account to 9 hours a month.
> I'm sorry if I didn't explain it the right way (I am not american).
Currently Emerlad doesn't support recurring time limits, but it does
support time banking. You can use time banking to accomplish this, but
have to create an external "reset" for it.
Here is one way I have accomplished this.
1. Create a table called AccountTypeTimeLimits with two fields. The
first field is a AccountType varchar(12), and the second is TimeLeft
int.
2. Populate the table with those AccountTypes that will be using the
recurring timebanking and the number of minutes per month they will get.
3. Execute an SQL Statement from SQL Executive's scehduled tasks the
first day of each month to reset the totals based on the user's
account type.
For those who don't want to go through the trouble of the above, here
is the script to do it. :) As always, check carefully and use at
your own risk.
------------------------------------------------------------
Use Emerald
CREATE TABLE AccountTypeTimeLimits (
AccountType varchar (15) NOT NULL ,
TimeLeft int NOT NULL ,
CONSTRAINT pk_ATTimeLImits PRIMARY KEY ( AccountType, TimeLeft )
)
GO
Insert AccountTypeTimeLimits VALUES ('PPP 20 Hour', 1200)
GO
Use master
go
Exec msdb..sp_addtask 'Monthly Time Limit Reset', @subsystem = 'TSQL',
@server = null, @username = null, @databasename = 'Emerald', @enabled =
1, @freqtype = 16, @freqinterval = 1, @freqsubtype = 1, @freqsubinterval
= 0, @freqrelativeinterval = 1, @freqrecurrencefactor = 1,
@activestartdate = 19980811, @activeenddate = 99991231,
@activestarttimeofday = 0, @activeendtimeofday = 235959, @runpriority =
0, @emailoperatorname = null, @retryattempts = 0, @retrydelay = 0,
@loghistcompletionlevel = 2, @emailcompletionlevel = 0, @command =
'Update sa
Set sa.TimeLeft = tl.TimeLeft