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

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 sekret 2 NAS hostname Sending Access-Request of id 128 to 127.0.0.1:1812 User-Name = radman2 User-Password =

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 VPN Dialer

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 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 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, 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 need to figure out

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 unix

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, the

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 that we

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 Associate Systems

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;

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

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 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 1813. It's

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 to see what

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 pass all

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 taking

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: 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, however

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 password

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 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 nearly