Re: MySQL Auth-Type

2003-02-01 Thread Alan DeKok
Michael Brininstool <[EMAIL PROTECTED]> wrote: > When I run in debug mode, I see the Auth-Type getting set to 'System' > somehow. I have not figured out exactly how. The 'users' file sets that, through the 'files' module. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freera

MySQL Auth-Type

2003-02-01 Thread Michael Brininstool
I was able to get Freeradius to compile, no errors, on a FreeBSD-4.7 system. Our MySQL DB is running on an NT box. I built the tables like the books said to (someone on this list pointed out the 'op' filed must not be empty like the book said it could). I run radtest and get all the information

Re: Problems with MySQL Auth-Type

2002-06-04 Thread Alan DeKok
Nick Davis <[EMAIL PROTECTED]> wrote: > Also, if PAP can do cleartext, crypt and md5 passwords, why would > anyone need to use Auth-Type := Local while using a sql database to > store user names and pwds? Historical reasons. That should probably be fixed, so that the server core does NO authen

Re: Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-31 Thread Chris Parker
At 08:52 AM 5/31/2002 +0200, Simon wrote: >On Thu, May 30, 2002 at 07:14:14PM -0500, Nick Davis wrote: > >[...] > > > root@localhost# radtest radman2 testing localhost 10 2 hostname> > > Sending Access-Request of id 128 to 127.0.0.1:1812 > > User-Name = "radman2" > > User-Passwor

Re: Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 07:14:14PM -0500, Nick Davis wrote: [...] > root@localhost# radtest radman2 testing localhost 10 2 > Sending Access-Request of id 128 to 127.0.0.1:1812 > User-Name = "radman2" > User-Password = "\2529M\234\353,\006w\2657K\346m\301\022@" > NAS-IP-

Problems with MySQL authentication was Re: Problems with MySQL Auth-Type

2002-05-30 Thread Nick Davis
ok I think I am really close to getting this working (having everything in mysql db). as a side note. i use a table called user instead of radcheck with different titles for the columns because this db is for other stuff too.. here are the tables: mysql> select * from user; +--+--

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Nick Davis
> > Yes, you should use "User-Password". However there's no real harm in > > using "Password", so if it means rebuilding a db it's not worth it. > > "update radcheck set attribute='User-Password' where attribute='Password';" > The charms of sql :) Excellent thanks! Nick -- Nick Davis Associat

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 12:32:24PM -0700, Frank Cusack wrote: > On Thu, May 30, 2002 at 02:14:54PM -0500, Nick Davis wrote: > [ unknown author ]: > > > On a side note, it seem that you should use Password, and not > > > Crypt-Password with all three PAP encryption schemes, unlike with the > > > lo

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 02:14:54PM -0500, Nick Davis wrote: [...] > One more question.. I thought it was recommended that we use "User-Password" > instead of "Password"? Should I just stick w/ "Password" if I want to use > PAP? I am starting out w/ clear passwords, but intend to switch to cryp

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Frank Cusack
On Thu, May 30, 2002 at 02:14:54PM -0500, Nick Davis wrote: [ unknown author ]: > > On a side note, it seem that you should use Password, and not > > Crypt-Password with all three PAP encryption schemes, unlike with the > > local auth-type. > > One more question.. I thought it was recommended tha

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 01:47:44PM -0400, Deramus, Chris wrote: > Simon, > > Wow, I feel stupid =). I didn't didn't realize all user id's go in radcheck > whether it's a group id or not, thank you so much for everything. Your time > is greatly appreciated. Welcome. > Everythings working now, t

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Nick Davis
Wow you have been most helpful!! Thanks! > > Also, if PAP can do cleartext, crypt and md5 passwords, why would anyone > > need to use Auth-Type := Local while using a sql database to store user > > names and pwds? > > Beats me :), less complexity perhaps? You can do both cleartext and > standard

RE: Problems with MySQL Auth-Type

2002-05-30 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Simon, Wow, I feel stupid =). I didn't didn't realize all user id's go in radcheck whether it's a group id or not, thank you so much for everything. Your time is greatly appreciated. Everythings working now, the only thing I n

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 09:27:32AM -0400, Deramus, Chris wrote: > Simon, > > I follow what you are saying, I changed a few tables per your suggestions, > no success. I'm going to copy paste what I have, I apologize in advanced for > the length of this post. > > mysql> select * from radcheck; > +

RE: Problems with MySQL Auth-Type

2002-05-30 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Simon, I follow what you are saying, I changed a few tables per your suggestions, no success. I'm going to copy paste what I have, I apologize in advanced for the length of this post. mysql> select * from

Re: Problems with MySQL Auth-Type

2002-05-30 Thread Simon
On Thu, May 30, 2002 at 08:38:04AM -0400, Deramus, Chris wrote: > Simon, > > I got Authentication to work with the method you described, but that's only > the first level. I realize that I can't make username, the group name. I > guess I am not wording it correctly, let me try better this time =)

RE: Problems with MySQL Auth-Type

2002-05-30 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Simon, I got Authentication to work with the method you described, but that's only the first level. I realize that I can't make username, the group name. I guess I am not wording it correctly, let me try better this time =). The Cisco

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 03:28:36PM -0400, Deramus, Chris wrote: > Simon, > > For the record you are the man :). I'm *almost* there and I do appreciate > you being in a good today...it must be my lucky day. > > I made the changes you suggested and I am now a step further, it does check > the pass

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 02:44:23PM -0500, Nick Davis wrote: > > > > > We're trying to set up a web front, where all of this stuff can be > > > changed without having to know any linux commands or mysql commands. I > > > have the web front basically done, but tying it into FreeRadius would be > > >

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 02:49:26PM -0400, Deramus, Chris wrote: > I reloaded the default sql.conf and made the necessary changes, in my > previous sql.conf I forgot I was commenting out a few queries therefore it > wasn't properly querying my database. With the default query's this is what > I get

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Nick Davis
> > > We're trying to set up a web front, where all of this stuff can be > > changed without having to know any linux commands or mysql commands. I > > have the web front basically done, but tying it into FreeRadius would be > > nearly impossible from what I'm understanding. That means the passwor

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Simon, For the record you are the man :). I'm *almost* there and I do appreciate you being in a good today...it must be my lucky day. I made the changes you suggested and I am now a step further, it does check the password file it seems, howev

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
While i'm in a posting mood :) On Wed, May 29, 2002 at 02:00:55PM -0400, Deramus, Chris wrote: > Alan, > > Thanks for your quick response, I will definitely give this a try. I like > this product and I think it'll work out great once I can finish the > configuration but let me ask you this. I re

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type I reloaded the default sql.conf and made the necessary changes, in my previous sql.conf I forgot I was commenting out a few queries therefore it wasn't properly querying my database. With the default query's this is what I get. Instead of

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 01:50:01PM -0400, Alan DeKok wrote: > "Deramus, Chris" <[EMAIL PROTECTED]> wrote: > > I have another group on which is using the VPN concentrators method of > > authentication, (only supports 500 users however, and we require 1500 or > > entries) and set that group up to pa

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Alan, Thanks for your quick response, I will definitely give this a try. I like this product and I think it'll work out great once I can finish the configuration but let me ask you this. I realize this isn't your problem but I just wanted t

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Alan DeKok
"Deramus, Chris" <[EMAIL PROTECTED]> wrote: > I have another group on which is using the VPN concentrators method of > authentication, (only supports 500 users however, and we require 1500 or > entries) and set that group up to pass all accounting information out to the > Radius server on port 181

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type MySQL is working on the accounting side when Radius requests are sent out. I have another group on which is using the VPN concentrators method of authentication, (only supports 500 users however, and we require 1500 or entries) and set that group up

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 12:26:50PM -0400, Deramus, Chris wrote: > I'm new to Free-Radius, I'll try to be as descriptive as possible. I have > taken the advice of this board and read all documentation possible before > asking this. I've searched on countless search engines for possible answers, > a

Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
I'm new to Free-Radius, I'll try to be as descriptive as possible. I have taken the advice of this board and read all documentation possible before asking this. I've searched on countless search engines for possible answers, and the only results I seem to come up with are pre Free Radius 0.