Re: Access ODBC fields

Scott Lagos ( )
Sat, 22 Mar 1997 11:29:57 -0500

At 08:54 AM 3/22/97 +0000, you wrote:
>I have Radius working with Acess but I need some help with soem of
>the Acess fields. Is there documentation somewhere that describes
>what each of the fields are and what values are allowed. Most of the
>fields are self explanatory, but some are vague to me. These
>1. The ma and saEXPIRE fields. I know these are for specific
>expiration dates, but what can I enter her for no expiration?

I think the saExpire field is no longer used, but should be left blank. It
had something to do with prorating a subaccount subscription if the
MasterAccount was already active. The maExpire is the date when the
account will no longer be allowed to log in. My system automatically adjust
this based on the payment of the customers invoice.

>2. What is the "extension" field for?

This is then number of days past the maExpire date that the customer will
still be allowed to login. I use it as a grace period.

>3. In the sub accounts table, is there a field I can use or add so
>that I may assign a static IP address to a specific login?

You do this via the RadConfigs table.

The bottom of the changes.txt that comes with radiusnt explains most of
these things. (I was told that about 50 times when I was getting started!!!
When I finally read it things made a whole lot of sense.

>I also have the need to setup some "e-mail only" type accounts. If I
>choose this type of account what does that actually do? Does radius
>somehow only allow them access to a pop 3 mail server, or what?

I assume what this will do is not allow them to login because the PPP
attributes for the account will not be set. You could also set up a filter
and allow the user to login but only give them access to the DNS and mail
server. I havent played around with this myself so this may not be accurate.

>Also if anyone has any example queries for Acess 7.0 that would help
>me set up some reports, etc... They would be appreciated.

I have tons, what are you looking for? Lots of mine are specific because I
have written a custom package, but seeing as I use Dale's RadiusNT lots of
them will work with what you have there. These two are very basic but will
give you an idea.

Show Who's On
Accounts Expired
Total Time Used by Date Range

I'll send them to you off list if you like.

If you need more information you can contact me on or off list, whichever
you feel is more appropriate.


You're welcome.

> ----------------------------------------------------------
> RadiusNT Mailing List