> NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > > but I need to be able to authenticate with user/passwords from MySQL. > > No, you don't. You do NOT want to give your users accounts to log > in to your MySQL server. > > You want to pull the user's authorization items from MySQL > (e.g. Password). You then want to use another method to authenticate > them. >
That is what I meant. I would not have assumed to actually add every user as a MySQL user, but to enter their user/password data into the 'radius' database. > I would recommend reading the debugging output of the server. If > the sql module returns 'notfound' for a user, then it means that the > users configuration was not found in the MySQL database. Fix that, > and it should work. > I have in fact read the debugging info and I'm not quite sure what to think of it. I have manually executed the sql statements that are output with the debug info and all of the information appears to be coming back appropriately. I'm not sure if I do not have enough entries in the tables in the database or if I have the incorrect entries or if I have not used the correct operators. I'm completely at a loss as to what to do or where to even start debugging more, if that's possible. I'm under orders to implement a radius solution with user/passwords stored in MySQL to replace the current Merit/LDAP setup and I only have a certain amount of time in which to do this. I have tried ICRadius, which I was able to get to authenticate, however, the I was unable to get the limitation of Simultaneous-Use working, so that's not feasible, I've been working with Freeradius all day, every day this week and I'm still unable to unauthenticate from user information stored in MySQL. I've spent every day reading through the archives, posting to the list, trying configuration changes, trying database data changes to no avail. My last option is to try Radiator, which I have installed the demo for, but I'm not comfortable with anything regarding its configuration or database structure. It seems that I must just be missing something very simple, but I just can't put my finger on it. Sorry, I got caught in the ramble. This has been quite frustrating. I appreciate all of the help everybody has provided. If anybody comes up with any ideas, or has any configuration and database layout information that they would like to share, please feel free to email me. Thanks, --Josh Snyder NetNITCO Systems Administration - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
