Re: (RADIATOR) problem with Simultaneous-Use
Hello Antonio -
On Thu, 11 Nov 1999, Antonio Navarro Navarro wrote:
At 11.10 11/11/99 +1100, [EMAIL PROTECTED] wrote:
Realm DEFAULT
MaxSessions 1
This will set a hard limit of one to all users in this realm. If
you want to be able to override a setting with per-user Simultaneous-Use, you
should use this:
# Configure this realm with a default value for Simultaneous-Use
# This can be overridden by per-user Simultaneous-Use check items
Realm DEFAULT
DefaultSimultaneousUse 1
...
/Realm
Hello.
I have modified the radiator.cfg file, adding DefaultSimultaneousUse 1 and
removing MaxSessions, and in the REPLUATTR I have added Simultaneous-Use=1,
burt the user still can connect using Multilink PPP.
I want to have three kind of users.
1.- Normal user (only one connection at a time)
2.- Multilink user (only two connections using Multilink)
3.- Multiple user ('n' connections from different machines without using Multi Link
PPP)
What must I do in order to configure this three kinds of users ?
What you are doing is the correct approach. DefaultSimultaneousUse 1 should
limit all users of a realm to one connection, then the Simultaneous-Use entries
for other users can be used to increase the number of connections for those
users.
Can you send me a trace 4 debug showing what is happening when you see the
problem? And send me a copy of the configuration file as well please.
thanks
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Question on auth by sql setup
Hello Jay - On Thu, 11 Nov 1999, Jay West wrote: - Original Message - From: Jay West [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 09, 1999 6:44 AM Subject: Question on auth by sql setup We're trying to switch from DBM user files to mySQL user files. I have one simple question... The script that is given to build the tables initially from flat files mentions something to the effect that it is a bare-bones sample, and that you will probably want to add additional fields, etc. Being fairly new to msSQL, I was wondering if it's easy to add these fields later after user records and accounting records are active in SQL, or - is it a much better idea to get all the requisit fields built initially. I thought someone with operational experience might have answered, but in any case here are my thoughts. This depends to a certain extent on the database you are using (and I don't know anything about msSQL). Some databases (like mysql) will allow you to modify tables on the fly, while others don't. You should probably try to get close to what you want to begin with, and even if you can't modify the tables on the fly, all that is required to make a modification is to dump the database, redefine the tables, and reload the data. Its a pretty normal exercise to dump and reload a database. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Configuration question
Hello Antonio - On Thu, 11 Nov 1999, Antonio Navarro Navarro wrote: Hi all. I have a Linux RedHat 6.1 with Radiator (latest version) + users and accounting in a MySQL Server. The configuration file of radiator follows (realm DEFAULT section only): Realm DEFAULT AcctLogFileName /var/log/radiator.log MaxSessions 1 AuthBy SQL DBSource dbi:mysql:radius DBUsername xxx DBAuth x AccountingTable ACCOUNTING AccountingStopsOnly AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type 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 AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from SUBSCRIBERS where USERNAME='%n' /AuthBy SQL /Realm In the subscribers table I have registries like this: USERNAME: usuario@bemarnet PASSWORD: x REPLYATTR: Service-Type = Framed-User Note that you can configure Radiator with Realms or Handlers to key on username suffixes of the form usuario@bemarnet: Realm bemarnet or Handler Realm = bemarnet And you can rewrite usernames to remove the suffixes as well. This can be very useful in some cases. I need several things: 1.- I have 256 IP addresses for my network, but want to define a 64 IPs pool from x.x.x.1 to x.x.x.64 in order to assign only this addresses to my users. How can this be done ? This depends on whether you want to do this in your NAS or in Radiator, either way you will need to define a pool. This shouldn't be a problem. 2.- I want to assign fixed IP addresses starting from x.x.x.65 for several users. Is this compatible with the 64 IPs pool ? Sure. As long as all of this is in the same network, it should be fine. You will just end up with a bunch of host routes inside your network and you can aggregrate them at your exit point (upstream ISP). 3.- I have three kind of users: ISDN, Async and mixed ( users that can use ISDN and Async with the same username). How can I restrict ISDN connections for certain users ? I want user A to be accepted only if connected with modem (Async), B only if connected with ISDN and C accepted in any case.Thanks in advance !! Again, this can be done either with Handlers, or with user definitions, and it will depend on what the NAS sends in its Access-Request to indicate what type of connection is being requested. You will probably have to do some experiments to find out what is going to work best. If you send me more detailled information I'll be happy to help. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) RADIUS and PAM for ftp-autehntication under Linux
I tryt to make my Linux-box authenticate all ftp-users via RADIUS, usinf proftpd and PAM. Does anybody have experience with this ? Especially I'm looking for information about how to pass uid and home-directory back to linux / proftpd, but any other hints would also be apreciated (including FAQ-URL's, ...). I already tried to search the archive, but since PAM ist part of the list-footer, search was not very effective. Regards Peter === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) how to assign static IP addresses
Having never used a RADIUS server before, I'm pleased to have found Radiator so easy to get up and running. I'm hoping one of you can help me with a simple query. We have a Bay Networks Versalar RAC 8000 which currently uses Bay's proprietary ACP protocol to communicate with an NT Server. ACP performs two functions for us at the moment: authentication from native NT user accounts, and it also reads a simple text file which lets me assign static IP addresses to specific dial-in users. It's this second task I need help with. Radiator is installed, tested, and using a config based on the provided /goodies/nt.cfg is succesfully authenticating dial-in users. The only thing stopping me from making the switch from ACP to RADIUS is how best to assign static IPs. From my reading of the reference manual, I need to AuthBy FILE, but I can't get my head around exactly how to do this when I -also- want the passwords to remain in NT (AuthBy NT). Can someone help by showing me the minimum change required to my nt.cfg (see below) and also the minimum amount of information I need to define in a USERS file, to make this possible. I guess I'm after a USERS file which only states two things: go look in NT for the password, and for certain users here's a static IP. Thanks in advance. Chris Core GPM Internet /// nt.cfg /// ForegroundLogStdoutLogDir .DbDir . Client DEFAULTSecret *** DupInterval 0/Client Realm DEFAULTAuthBy NT Domain DomainController DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP/AuthBy AcctLogFileName ./detail/Realm
Re: (RADIATOR) problem with Simultaneous-Use
On Thu, 11 Nov 1999, Antonio Navarro Navarro wrote:
I have modified the radiator.cfg file, adding DefaultSimultaneousUse 1
and removing MaxSessions, and in the REPLUATTR I have added
Simultaneous-Use=1, burt the user still can connect using Multilink PPP.
You need to add it as a check item, not a reply item.
I want to have three kind of users.
1.- Normal user (only one connection at a time)
2.- Multilink user (only two connections using Multilink)
3.- Multiple user ('n' connections from different machines without using Multi Link
PPP)
What must I do in order to configure this three kinds of users ?
Radiator (or any Radius) can't tell the difference between multilink users
and multiple users. Here, we wound up changing our billing to match this
limitation. For instance, we charge $x for a one-channel dialup. We
would then charge $x * n for n channels. That will allow either
multilink, or multiple users, for the same price-per-channel.
===
David M. Lloyd mailto:[EMAIL PROTECTED]
Administrator Phone: (608) 663-
Internet Express, Inc. http://www.inxpress.net
802 W. Broadway, Suite # 101
Madison, WI. 53713-1866
===
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Authenticating off of Platypus
Dear Fellow Radiator Users, We are in the process of moving/reinstalling Radiator from Windows NT back to a Unix box (RedHat 6.1 to be exact). However, we want to keep authenticating off of our Platypus Database on the NT server. There was some talk awhile back as well as a few web pages that dealt with this or listed software I needed on the unix box but I am unable to locate that information. If anyone if familiar with this could you please email me the links and or any hints, tips, pointers, etc. Thanks, Todd === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) how to assign static IP addresses
On Fri, 12 Nov 1999, Admin wrote: ... From my reading of the reference manual, I need to AuthBy FILE, but I can't get my head around exactly how to do this when I -also- want the passwords to remain in NT (AuthBy NT). Can someone help by showing me the minimum change required to my nt.cfg (see below) and also the minimum amount of information I need to define in a USERS file, to make this possible. I guess I'm after a USERS file which only states two things: "go look in NT for the password", and for certain users "here's a static IP". That's not too hard. I'll paraphrase from tha manual (Section 6.13.5): # This is where all your normal reals stuff goes Realm DEFAULT AuthBy FILE ... /AuthBy /Realm # The only purpose of this realm is to define # the System identifier for use with Auth-Type Realm Dummy_Realm AuthBy NT Identifier System ... /AuthBy /Realm Then in your file, you have this: UserAuth-Type = System reply items, incl. Framed-IP-Address DEFAULT Auth-Type = System default reply items === David M. Lloyd mailto:[EMAIL PROTECTED] Administrator Phone: (608) 663- Internet Express, Inc. http://www.inxpress.net 802 W. Broadway, Suite # 101 Madison, WI. 53713-1866 === === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Auth By NT help !
On Thu, 11 Nov 1999, Hugh Irvine wrote: You can download a new version of AuthNT.pm from here: http://www.open.com.au/radiator/downloads/patches-2.14.1/ I did Hugh, I downloaded the patch As to your other problems with authentication, this may be due to you trying to use CHAP authentication? AuthBy NT will *not* work with CHAP. And on the same topic, what format are your passwords in SQL? Now I see the log file and it shows me that its making authenticating via CHAP. I am trying to authenticate of a Windows 95. Can you tell me How I can avoid that ?? If I need make some change in configuration file, or how i cand do that in Windows. ? Well my password in SQL are text, and UNIXENCRYPTED because with the default encriptation of MySQL doesn't works. Jovanny Saravia System AdministratorFirstcom Colombia Voice: 57-1-6211873 Fax: 57-1-6210310 [EMAIL PROTECTED] UIN: 7393608 Calle 100 No. 8A-55 World Trade Center Torre C Oficina 811 Bogota - Colombia === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) problem with Simultaneous-Use
At 08.47 11/11/99 -0600, David Lloyd wrote: I have modified the radiator.cfg file, adding DefaultSimultaneousUse 1 and removing MaxSessions, and in the REPLYATTR I have added Simultaneous-Use=1, but the user still can connect using Multilink PPP. You need to add it as a check item, not a reply item. Hello again. I suppose that if I have added DefaultSimultaneousUse 1 to the default realm, and the SUBSCRIBERS table only have Service-Type=Framed-User in REPLYATTR the multiple user connection could not be accepted, isn't it ? I have this configuration and the user CAN connect using multilink PPP. What is wrong with my config ? Antonio Navarro Navarro BemarNet Management [EMAIL PROTECTED] http://www.bemarnet.es === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) problem with Simultaneous-Use
At 04:40 PM 11/11/99 +0100, Antonio Navarro Navarro wrote: At 08.47 11/11/99 -0600, David Lloyd wrote: I have modified the radiator.cfg file, adding DefaultSimultaneousUse 1 and removing MaxSessions, and in the REPLYATTR I have added Simultaneous-Use=1, but the user still can connect using Multilink PPP. You need to add it as a check item, not a reply item. Hello again. I suppose that if I have added DefaultSimultaneousUse 1 to the default realm, and the SUBSCRIBERS table only have Service-Type=Framed-User in REPLYATTR the multiple user connection could not be accepted, isn't it ? I have this configuration and the user CAN connect using multilink PPP. What is wrong with my config ? Antonio Navarro Navarro I answered this yesterday, and the article appeared on the list with this Date stamp: (Date: header line) Wed, 10 Nov 1999 15:11:05 -0500. Look out for it. Did you read what I wrote at all ? bye,Kai -- [EMAIL PROTECTED] "Just say No" to SpamKai Schlichting Palo Alto, New York, You name it Sophisticated Technical Peon Kai's SpamShield tm is FREE! http://SpamShield.Conti.nu | | LeasedLines-FrameRelay-IPLs-ISDN-PPP-Cisco-Consulting-VoiceFax-Data-Muxes WorldWideWebAnything-Intranets-NetAdmin-UnixAdmin-Security-ReallyHardMath === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Quick easy question....
We imported our database of users and info from a VFP database into platypus and all is great except for the fact all usersnames and passwords are listed UPPERCASe and i need a simple SQL query where i can change username and password to all lower case, then i will have everything running smoothly :) thanks in advance Kelly Hamlin [EMAIL PROTECTED] Network Administrator (941) 332.4900 http://www.neosmart.com === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Radiusd
Hello Kelly, On Nov 11, 2:58pm, Kelly Hamlin wrote: Subject: (RADIATOR) Radiusd Without specifing a port in the config file what is the default port in which the nas would point to for authenication and for accounting? i think it is 1645 and 1646. A quick reply would be great thanks Defaults to 1645 and 1646 Cheers. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, 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, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Authenticating off of Platypus
Hi Todd, On Nov 11, 9:39am, Todd Knaus wrote: Subject: (RADIATOR) Authenticating off of Platypus Dear Fellow Radiator Users, We are in the process of moving/reinstalling Radiator from Windows NT back to a Unix box (RedHat 6.1 to be exact). However, we want to keep authenticating off of our Platypus Database on the NT server. There was some talk awhile back as well as a few web pages that dealt with this or listed software I needed on the unix box but I am unable to locate that information. If anyone if familiar with this could you please email me the links and or any hints, tips, pointers, etc. There is some discussion on the Radiator FAQ about connecting Radiator on Unix to MS-SQL on NT: http://www.open.com.au/radiator/faq.html Cheers. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, 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, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) logging incoming requests
Is there any way we can configure Radiator to log an incoming radius request to a flatfile or SQL, say storing username and password (assuming both come thru in cleartext)? PasswordLogFileName passlog.%d%m%Y.txt. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Authenticating off of Platypus
On Thu, Nov 11, 1999 at 09:39:55AM -0500, Todd Knaus wrote: Dear Fellow Radiator Users, We are in the process of moving/reinstalling Radiator from Windows NT back to a Unix box (RedHat 6.1 to be exact). However, we want to keep authenticating off of our Platypus Database on the NT server. There was some talk awhile back as well as a few web pages that dealt with this or listed software I needed on the unix box but I am unable to locate that information. If anyone if familiar with this could you please email me the links and or any hints, tips, pointers, etc. There's 3 main choices: 1) use the Sybase libraries (this will worth with SQLserver 6.5 natively and with 7 if you apply some 'compatilibity' patches available from Microsoft) against the DBD-Sybase perl module. I posted a cookbook way of getting this done a few months ago. 2) use FreeTDS and DBD-Sybase - when I tried this it was an exciting mix of linking alpha software with alpha software :) It's probably much better now. 3) use OpenLink. I'm not very up on databases, so when I looked at this I just went "huh?". It was hard enough finding out whether the product would support Linux (glibc2) and SQLserver. [EMAIL PROTECTED] === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) how to assign static IP addresses
Thanks David. Our NAS is now using Radiator and all of the dial-ins are humming along. One thing that I've broken along the way is inbound telnet sessions, which I use from another office to manage the NAS. I assume this is because the default in my nt.cfg specifies that Radiator tells the NAS all incoming users are to use PPP. My telnet sessions work to the point of successful authentication and then telnet drops out altogether. I guess this is telnet's way of saying it doesn't talk PPP :) Here's my updated nt.cfg: --- Foreground LogStdout LogDir . DbDir . Client DEFAULT Secret * DupInterval 0 /Client Realm DEFAULT AuthBy FILE Filename ./rac1 /AuthBy AcctLogFileName ./detail PasswordLogFileName ./password /Realm Realm DUMMY_REALM AuthBy NT Identifier System Domain DomainController DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP /AuthBy /Realm -- and here's a snippet of my rac1 (user file) where I've tried to allow the username gpm_cc access via telnet: - gpm_cc Auth-Type = System Service-Type = Login-User, Login-Service = Telnet But gpm_cc can't use telnet. Any ideas? Regards, Chris Core GPM Internet -Original Message- From: David Lloyd [EMAIL PROTECTED] To: Admin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, November 12, 1999 3:17 AM Subject: Re: (RADIATOR) how to assign static IP addresses From my reading of the reference manual, I need to AuthBy FILE, but I can't get my head around exactly how to do this when I -also- want the passwords to remain in NT (AuthBy NT). Can someone help by showing me the minimum change required to my nt.cfg (see below) and also the minimum amount of information I need to define in a USERS file, to make this possible. I guess I'm after a USERS file which only states two things: "go look in NT for the password", and for certain users "here's a static IP". That's not too hard. I'll paraphrase from tha manual (Section 6.13.5): # This is where all your normal reals stuff goes Realm DEFAULT AuthBy FILE ... /AuthBy /Realm # The only purpose of this realm is to define # the System identifier for use with Auth-Type Realm Dummy_Realm AuthBy NT Identifier System ... /AuthBy /Realm Then in your file, you have this: User Auth-Type = System reply items, incl. Framed-IP-Address DEFAULT Auth-Type = System default reply items === David M. Lloyd mailto:[EMAIL PROTECTED] Administrator Phone: (608) 663- Internet Express, Inc. http://www.inxpress.net 802 W. Broadway, Suite # 101 Madison, WI. 53713-1866 === === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Auth By NT help !
Hello Jovanny - On Thu, 11 Nov 1999, Jovanny Saravia wrote: On Thu, 11 Nov 1999, Hugh Irvine wrote: You can download a new version of AuthNT.pm from here: http://www.open.com.au/radiator/downloads/patches-2.14.1/ I did Hugh, I downloaded the patch As to your other problems with authentication, this may be due to you trying to use CHAP authentication? AuthBy NT will *not* work with CHAP. And on the same topic, what format are your passwords in SQL? Now I see the log file and it shows me that its making authenticating via CHAP. I am trying to authenticate of a Windows 95. Can you tell me How I can avoid that ?? If I need make some change in configuration file, or how i cand do that in Windows. ? The PC will have to have its configuration changed (turn off encrypted password in the dialup networking properties. And you may also have to configure your NAS to use PAP instead of CHAP. Well my password in SQL are text, and UNIXENCRYPTED because with the default encriptation of MySQL doesn't works. To deal with this you will need to set the EncryptedPassword flag in the AuthBy SQL configuration: Handler ... AuthBy SQL EncryptedPassword ... /AuthBy /Handler hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Quick easy question....
update table_name set username = lower(username) SVRMGR create table test ( username varchar2(16) ); Statement processed. SVRMGR insert into test values ( 'JOHN' ); 1 row processed. SVRMGR update test set username = lower(username); 1 row processed. SVRMGR select * from test; USERNAME john 1 row selected. At 03:12 PM 11/11/99 -0500, Kelly Hamlin wrote: We imported our database of users and info from a VFP database into platypus and all is great except for the fact all usersnames and passwords are listed UPPERCASe and i need a simple SQL query where i can change username and password to all lower case, then i will have everything running smoothly :) thanks in advance Kelly Hamlin [EMAIL PROTECTED] Network Administrator (941) 332.4900 http://www.neosmart.com === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) logging incoming requests
On Thu, 11 Nov 1999 21:07:12 +, Stuart Henderson wrote: Is there any way we can configure Radiator to log an incoming radius request to a flatfile or SQL, say storing username and password (assuming both come thru in cleartext)? PasswordLogFileName passlog.%d%m%Y.txt. === Is there a way of adding calling-station-id to this file as well ?? Gary --- Ausmail Your virtual home on the net. Email, News Home pages. --- Coming soon !! === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) logging incoming requests
On Fri, 12 Nov 1999, Gary wrote: On Thu, 11 Nov 1999 21:07:12 +, Stuart Henderson wrote: Is there any way we can configure Radiator to log an incoming radius request to a flatfile or SQL, say storing username and password (assuming both come thru in cleartext)? PasswordLogFileName passlog.%d%m%Y.txt. === Is there a way of adding calling-station-id to this file as well ?? You would have to write a hook to do this (PreClientHook, PreHandlerHook, PreAuthHook or PostAuthHook). hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
