--- Forwarded mail from [EMAIL PROTECTED]
Date: Thu, 13 Jul 2000 17:40:20 +1000 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from [Kurt
Richter <[EMAIL PROTECTED]>]
>From mikem Thu Jul 13 17:40:15 2000
Received: by oscar.open.com.au (8.9.0/8.9.0) id RAA23142
for [EMAIL PROTECTED]; Thu, 13 Jul 2000 17:40:15 +1000 (EST)
>Received: from exchange.fwi.com (exchange.fwi.com [209.84.166.146]) by
perki.connect.com.au with ESMTP id RAA24216
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Thu, 13 Jul 2000 17:35:18 +1000
(EST)
Received: from exchange.fwi.com (exchange.fwi.com [209.84.166.146]) by
perki.connect.com.au with ESMTP id RAA24216
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Thu, 13 Jul 2000 17:35:18 +1000
(EST)
Received: by exchange.fwi.com with Internet Mail Service (5.5.2650.21)
id <N224F890>; Thu, 13 Jul 2000 02:32:23 -0500
Message-ID: <[EMAIL PROTECTED]>
From: Kurt Richter <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: Duplicate Usernames
Date: Thu, 13 Jul 2000 02:32:22 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
charset="iso-8859-1"
We are cuurently using Platypus v2.9, and Radiator 2.16.
First the history:
Lately we have been acquiring other smaller ISP's. Corporate has decided to
merge all of our smaller Platypus Databse into one monster database. In the
process of the merges, Boardtown has obviously come across multiple
situations where a username is duplicated. Since Platypus won't allow this,
Boardtown has changed the usernames for those affected to their email
addresses, and created a new field in the customer table of our Platypus DB,
called emeralduid which contains the original username. All usernames that
weren't duplicated, were simply popped into that field unaffected.
Now the problems:
1.) How can I get Radiator to look at emeralduid instead of username?
2.) Even if I can get this part, HOW can I get Radiator to continue looking
thru the DB for the correct user?
Kurt Richter
Skyenet/FWI System Administrator
my radius.cfg file is as follows:
LogDir /var/log/radius
DbDir /etc/raddb
LogFile /var/log/radius/radius.log
DictionaryFile /etc/raddb/dictionary.all
Trace 4
# You will probably want to change this to suit your site.
<Client DEFAULT>
Secret XXXXX
DupInterval 0
</Client>
RewriteUsername s/^P//
#RewriteUsername s/^([^@]+).*/$1/
#RewriteUsername tr/A-Z/a-z/
<Realm DEFAULT>
PasswordLogFileName /var/log/radius/passwd.log
AcctLogFileName /var/log/radius/detail
AuthByPolicy ContinueUntilAccept
<AuthBy EMERALD>
# Change DBSource, DBUsername, DBAuth for your database
# See the reference manual
DBSource
dbi:FreeTDS:database=XXXXXXXX;host=XXXXXXXXXX;port=XXXX
# Default username and password for Platypus
DBUsername XXXXXXXXX
DBAuth XXXXXXXXX
# You can add to or change these if you want.
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef
AcctTerminateCause,Acct-Terminate-Cause,integer
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
# AuthSelect ,sa.LoginLimit
# AuthColumnDef 0,Simultaneous-Use,check
# Therefore you can add support for any number
# of additional columns, if you wish.
# Note that Platypus fixes LoginLimit at 1, so
# if you enable this with Platypus, all your
# users will be forced to a Sumultaneous-Use limit
# of 1
</AuthBy>
</Realm>
---End of forwarded mail from [EMAIL PROTECTED]
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
