[Emerald Digest]

emerald-digest-request@iea-software.com
Fri, 14 Aug 1998 00:00:12 -0700

Message 1: RE: Sendmail
from "Ken Sorenson" <ksoren@tsi-online.com>

Message 2: Re: Moving NAS ip's
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 3: CC Batch out locks up
from "Gregory White" <whiteg@dnc.net>

Message 4: Re: CC Batch out locks up
from "Pat Augustine" <ereth@ilnk.com>

Message 5: Emerald/radius config problems
from "Rick Morgan" <eval2@gtn.net>

Message 6: Re: Emerald/radius config problems
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Sendmail
From: "Ken Sorenson" <ksoren@tsi-online.com>
Date: Thu, 13 Aug 1998 10:45:02 -0500

Sounds like I am on my own...Any Idea where I might find these scripts?
Maybe I can use them as a model for an NT interface..

It's hard to believe no one has came across this.. Sendmail must be one of
the most installed mailers out there.
What the Dilleio!

Thanks,
Pioneer Ken

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Robert H. Clugston
Sent: Wednesday, August 12, 1998 1:51 PM
To: emerald@iea-software.com
Subject: RE: Sendmail

Dear Ken,
There is some work being done to export users to a samba share and have
them imported to your mail server. Currently there is a bunch of perl
scripts called EmerUnix that allow you to export users to a unix box. If you
are running on an NT box you will have to find some other way to get the
users out of the file emerald makes.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Ken Sorenson
Sent: Tuesday, August 11, 1998 10:44 PM
To: Emerald@Iea-Software. Com
Subject: Sendmail

Has anyone messed around with an automated email account set up with Emerald
and Sendmail? I am running them on NT.
Perhaps a script of some type? Maybe point me towards some information on
what config files I need to touch.. Cant seem to find anything about it in
the Sendmail Faq's and feeds.

Thanks!

Ken
Ksoren@tsilink.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Moving NAS ip's
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 13 Aug 1998 12:22:27 -0700

John Lange wrote:
>
> We need to re-shuffle our ip assignments for our remote POP's. If I enter
> the new ip's in Emerald Admin for the NAS's will I loose accounting data
> for the old ip's?
>
> Should I create new NAS's for the new ip's?

You won't loose the data, however, it won't match up correctly causing
Emerald not to display it correctly.

After you change the IPs, use a statement like this for each nas
to change the calls table over:

Update Calls
Set NASIdentifier = 'x.x.x.x'
Where NASIdentifier = 'y.y.y.y'

Replace x.x.x.x with the new NAS IP Address and y.y.y.y with the old
NAS IP Address.

-- 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: CC Batch out locks upFrom:    "Gregory White" <whiteg@dnc.net>Date:    Thu, 13 Aug 1998 14:15:31 -0700

Hello,

Back in February, Pat Augustine mentioned that he had a problem when tryingto write the output file for batching credit cards.  When he attempted tocreate the file, it would write about 40 records, then freeze.  We startedexperiencing this problem over about the last month or two.  Had anyoneever found a remedy for this?

We are using Emerald 2.1.11.  My machine has plenty of hard drive space andmemory, so this shouldn't be an issue.



Thank you,

Greg WhiteNetwork Operations ManagerDirect NET Communications



..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4                                                           |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: CC Batch out locks upFrom:    "Pat Augustine" <ereth@ilnk.com>Date:    Thu, 13 Aug 1998 17:15:28 -0400

>Back in February, Pat Augustine mentioned that he had a problem when trying>to write the output file for batching credit cards.  When he attempted to>create the file, it would write about 40 records, then freeze.  We started>experiencing this problem over about the last month or two.  Had anyone>ever found a remedy for this?



 It took a reinstall of Windows for me to cure it. The upgrade to Windows 98also cured it. I can only assume a corrupt .vxd or something similar thatwas only in use during that one activity, as nothing else was affected.

 Wish I could be more help.

Pat AugustineInterlink Americapata@ilnk.com







..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5                                                           |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald/radius config problemsFrom:    "Rick Morgan" <eval2@gtn.net>Date:    Thu, 13 Aug 1998 17:55:57 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0048_01BDC6E3.9FD23030Content-Type: text/plain;	charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

Dale:  I'm having problems authenticating with a new installation =running RadiusNT in OBDC mode. Login is rejected with "user has no =default attributes. New account setup with default attributes for the =service look OK in the tables. I suspect the Radius DSN is not reading =the database correctly.

I notice that initialization shows radius as and invalid database.  =Where to I look to correct this?  Cut and past attached:



Initializing Winsock...ODBC Datasource: 'Emerald'...Making ODBC Connection...MS SQL Server Mode EnabledODBC Datasource: 'Emerald'...Making ODBC Connection...MS SQL Server Mode Enabledradius: Invalid Database or Computer Date.Thu Aug 13 17:48:22 1998: Invalid Database or Computer Date.Invalid Database or Computer Date.

Accounting Column 0 (16): 'NASIdentifier'Accounting Column 1 (4): 'NASPort'Accounting Column 2 (10): 'AcctSessionID'Accounting Column 3 (1): 'AcctStatusType'Accounting Column 4 (16): 'CallDate'Accounting Column 5 (32): 'UserName'Accounting Column 6 (1): 'UserService'Accounting Column 7 (4): 'AcctDelayTime'Accounting Column 8 (4): 'AcctSessionTime'Accounting Column 9 (4): 'FramedProtocol'Accounting Column 10 (16): 'FramedAddress'Accounting Column 11 (4): 'AcctInputOctets'Accounting Column 12 (4): 'AcctOutputOctets'Accounting Column 13 (1): 'AcctTerminateCause'Accounting Column 14 (1): 'NASPortType'Accounting Column 15 (10): 'NASPortDNIS' 16 Accounting Columns LoadedThu Aug 13 17:48:22 1998:=20RadiusNT Enterprise Initialized...

RadiusNT Enterprise Initialized...

radrecv: Request from host 7f000001 code=3D1, id=3D15, length=3D61

    NAS-Identifier =3D 127.0.0.1    NAS-Port =3D 0    User-Name =3D "flatrate2"    Password =3D "\270{5"\312\0113\245\360\003XR\033I\327\205"rad_authenticate_ODBC()

    Password =3D "\270{5"\312\0113\245\360\003XR\033I\327\205"

 SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, =(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), =DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, =sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.TimeLeft, =sa.LoginLimit From MasterAccounts ma, SubAccounts sa  Where =(sa.Login=3D'flatrate2' or sa.Shell=3D'flatrate2') AND =ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and ma.Active<>0

 Decrypted Password: flatrate2 Database Password: flatrate2Checking for duplicate logins.

 SQL Statement: RadCheckOnline 'flatrate2'

ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadCheckOnline' not found.

Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadCheckOnline' not found.

 SQL Statement: RadGetConfigs 3

ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadGetConfigs' not found.

Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadGetConfigs' not found.Loading radius defaults for this type...

 SQL Statement: RadGetATConfigs 'Flat Rate'

ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadGetATConfigs' not found.

Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812: [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure ='RadGetATConfigs' not found.Sending Reject of id 15 to 7f000001 (Localhost)

flatrate2: Flat Rate has no RADIUS default attributes.



Thu Aug 13 17:49:04 1998: flatrate2: Flat Rate has no RADIUS default =attributes.

flatrate2: Flat Rate has no RADIUS default attributes.



 SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, =Data)  VALUES (19, GetDate(), 'flatrate2', 'flatrate2')

ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name ='Data'.

Thu Aug 13 17:49:04 1998: ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name ='Data'.

Resp Time: 271   Auth: 0/1 -> 1  Acct: 0/0/0 -> 0

Thanks

Rick Morganrick@gtn.net=20

------=_NextPart_000_0048_01BDC6E3.9FD23030Content-Type: text/html;	charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
Dale:  I'm having problems =authenticating=20with a new installation running RadiusNT in OBDC mode. Login is rejected =with=20"user has no default attributes. New account setup with default =attributes=20for the service look OK in the tables. I suspect the Radius DSN is not =reading=20the database correctly.
 
I notice that initialization shows =radius as and=20invalid database.  Where to I look to correct this?  Cut and =past=20attached:
 

Initializing Winsock...
ODBC =Datasource:=20'Emerald'...
Making ODBC Connection...
MS SQL Server Mode =Enabled
ODBC=20Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server =Mode=20Enabled
radius: Invalid Database or Computer Date.
Thu Aug 13 =17:48:22=201998: Invalid Database or Computer Date.
Invalid Database or Computer =Date.
 
Accounting Column 0 (16):=20'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting =Column 2=20(10): 'AcctSessionID'
Accounting Column 3 (1): ='AcctStatusType'
Accounting=20Column 4 (16): 'CallDate'
Accounting Column 5 (32): ='UserName'
Accounting=20Column 6 (1): 'UserService'
Accounting Column 7 (4):=20'AcctDelayTime'
Accounting Column 8 (4): ='AcctSessionTime'
Accounting=20Column 9 (4): 'FramedProtocol'
Accounting Column 10 (16):=20'FramedAddress'
Accounting Column 11 (4): ='AcctInputOctets'
Accounting=20Column 12 (4): 'AcctOutputOctets'
Accounting Column 13 (1):=20'AcctTerminateCause'
Accounting Column 14 (1): ='NASPortType'
Accounting=20Column 15 (10): 'NASPortDNIS'
 16 Accounting Columns =Loaded
Thu Aug=2013 17:48:22 1998: 
RadiusNT Enterprise Initialized...
 
RadiusNT Enterprise =Initialized...
 
radrecv: Request from host 7f000001 =code=3D1,=20id=3D15, length=3D61
 
    NAS-Identifier ==3D=20127.0.0.1
    NAS-Port =3D 0
    =User-Name =3D=20"flatrate2"
    Password =3D=20"\270{5"\312\0113\245\360\003XR\033I\327\205"
rad_authe=nticate_ODBC()
 
    Password =3D=20"\270{5"\312\0113\245\360\003XR\033I\327\205"
=
 
 SQL Statement: Select =DateDiff(Minute,=20GetDate(), DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate)),=20DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extension+1, saExpireDate)), =sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell, =sa.TimeLeft,=20sa.LoginLimit From MasterAccounts ma, SubAccounts sa  Where=20(sa.Login=3D'flatrate2' or sa.Shell=3D'flatrate2') AND =ma.CustomerID=3Dsa.CustomerID=20and sa.Active<>0 and ma.Active<>0
 
 Decrypted Password:=20flatrate2
 Database Password: flatrate2
Checking for =duplicate=20logins.
 
 SQL Statement: RadCheckOnline=20'flatrate2'
 
ODBC =Error:37000:2812:
 [Microsoft][ODBC=20SQL Server Driver][SQL Server]Stored procedure 'RadCheckOnline' not=20found.
 
Thu Aug 13 17:49:04 1998: ODBC=20Error:37000:2812:
 [Microsoft][ODBC SQL Server Driver][SQL =Server]Stored=20procedure 'RadCheckOnline' not found.
 
 SQL Statement: RadGetConfigs=203
 
ODBC =Error:37000:2812:
 [Microsoft][ODBC=20SQL Server Driver][SQL Server]Stored procedure 'RadGetConfigs' not=20found.
 
Thu Aug 13 17:49:04 1998: ODBC=20Error:37000:2812:
 [Microsoft][ODBC SQL Server Driver][SQL =Server]Stored=20procedure 'RadGetConfigs' not found.
Loading radius defaults for this =type...
 
 SQL Statement: RadGetATConfigs ='Flat=20Rate'
 
ODBC =Error:37000:2812:
 [Microsoft][ODBC=20SQL Server Driver][SQL Server]Stored procedure 'RadGetATConfigs' not=20found.
 
Thu Aug 13 17:49:04 1998: ODBC=20Error:37000:2812:
 [Microsoft][ODBC SQL Server Driver][SQL =Server]Stored=20procedure 'RadGetATConfigs' not found.
Sending Reject of id 15 to =7f000001=20(Localhost)
 
flatrate2: Flat Rate has no RADIUS =default=20attributes.
 

Thu Aug 13 17:49:04 1998: =flatrate2: Flat=20Rate has no RADIUS default attributes.
 
flatrate2: Flat Rate has no RADIUS =default=20attributes.
 

 SQL Statement: INSERT INTO =RadLogs(RadLogMsgID, LogDate, Username, Data)  VALUES (19, =GetDate(),=20'flatrate2', 'flatrate2')
 
ODBC =Error:S0022:207:
 [Microsoft][ODBC=20SQL Server Driver][SQL Server]Invalid column name 'Data'.
 
Thu Aug 13 17:49:04 1998: ODBC=20Error:S0022:207:
 [Microsoft][ODBC SQL Server Driver][SQL =Server]Invalid=20column name 'Data'.
 
Resp Time: 271   Auth: 0/1 =-> 1 =20Acct: 0/0/0 -> 0
Thanks
 
Rick Morgan
rick@gtn.net=20
------=_NextPart_000_0048_01BDC6E3.9FD23030--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6                                                           |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald/radius config problemsFrom:    "Dale E. Reed Jr." Date:    Thu, 13 Aug 1998 15:15:38 -0700> Rick Morgan wrote:> > Dale:  I'm having problems authenticating with a new installation> running RadiusNT in OBDC mode. Login is rejected with "user has no> default attributes. New account setup with default attributes for the> service look OK in the tables. I suspect the Radius DSN is not reading> the database correctly.With RadiusNT 2.5 (no matter whether you had a previous version ofRadiusNT installed or not) you still need to run the rad25_up2.sqlscript against your database.  This script is in the same directoryas you downloaded RadiusNT 2.5 from.  Once you run the script, thingsyou start working. >  SQL Statement: RadGetConfigs 3> > ODBC Error:37000:2812:>  [Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure> 'RadGetConfigs' not found.This is your problem.  The rad25_up2.sql script has these stored procedures in them. -- 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