Re: FreeRadius overview
David Covert wrote: How do you tell freeRadius to reference an external MS-SQL db rather than the local users flat file? $ ls raddb/*sql.conf $ grep sql raddb/radiusd.conf $ cat doc/rlm_sql Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius overview
On 12/28/06, David Covert [EMAIL PROTECTED] wrote: I have gotten freeRadius working with a mikrotik NAS using the users flat file (hooray for me! g). Now I need to have the freeRadius server reference a MS-SQL db server rather than the users file on the freeRadius server. I am quite fuzzy about the process tho. I am hoping for some basic edukashun. [snip] First, you read the FAQ[1], then you search through the wiki[2], then you read through the well-documented configuration files that came with FreeRADIUS. Afterwards, you use what you've learned to try to get the whole setup working. If/when you run into issues you can't figure out, you search through the archives for this list. If your search doesn't turn up anything useful, you come back to the list and post specific, detailed questions including configurations that you're using and letting us know what you've already tried that didn't work (and what errors you were getting). Lather, rinse, repeat. One eventually ends up with a working configuration. -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius overview
On 12/28/06, David Covert [EMAIL PROTECTED] wrote: I have gotten freeRadius working with a mikrotik NAS using the users flat file (hooray for me! g). Now I need to have the freeRadius server reference a MS-SQL db server rather than the users file on the freeRadius server. I am quite fuzzy about the process tho. I am hoping for some basic edukashun. I failed to include the appropriate links in my previous e-mail: [1]: http://wiki.freeradius.org/index.php/FAQ [2]: http://wiki.freeradius.org/Main_Page -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius overview
David Covert wrote: I have gotten freeRadius working with a mikrotik NAS using the users flat file (hooray for me! g). Now I need to have the freeRadius server reference a MS-SQL db server rather than the users file on the freeRadius server. I am quite fuzzy about the process tho. I am hoping for some basic edukashun. How do you tell freeRadius to reference an external MS-SQL db rather than the local users flat file? How do you issue the query to the db? (what file contains the connection string and query) How do the returning fields get mapped into RADIUS attributes? (what do you do when the db calls the field uname and RADIUS calls it user-name) You haven't looked at sql.conf, have you? -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius overview
David, start with rlm_sql at source_directory/doc, check also your sql.conf in your installation etc/raddb directoryit help me also this one to start http://www.frontios.com/freeradius.html (for mysql). I hope it helpsif you're about using ms-sql check also mssql at source_directory/doc. Regards [EMAIL PROTECTED] wrote on 12/28/2006 01:37:51 PM: I have gotten freeRadius working with a mikrotik NAS using the users flat file (hooray for me! g). Now I need to have the freeRadius server reference a MS-SQL db server rather than the users file on the freeRadius server. I am quite fuzzy about the process tho. I am hoping for some basic edukashun. How do you tell freeRadius to reference an external MS-SQL db rather than the local users flat file? How do you issue the query to the db? (what file contains the connection string and query) How do the returning fields get mapped into RADIUS attributes? (what do you do when the db calls the field uname and RADIUS calls it user-name) Thank you for your time, Dave Covert - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius overview
David Covert wrote: Ok, I almost get it... question: The mssql.conf file has an entry like this: #Database table configutation radius_db = radius I assume that radius refers to a pre-determined schema that freeRadius That is not a schema, that is the database name. As in: SELECT * FROM radius.radcheck WHERE UserName='[EMAIL PROTECTED]' in the MySQL world. As for Platy, no. You really should use the radius schema. It will save you a lot of grief down the road. Create a new set of tables and have platy make mods to both its main tables and the radius ones at the same time. We have that exact setup. If you have a *very* simple radcheck setup (no usergroups, time limits, etcbasically just the password), then you may be able to get away with modding the query to only pull the username and password from the Platy table. Something like: SELECT id,username,Password,password,== from customers where username=blah So you are hardcoding the attribute and operator into the query. But as I said, you really should use a separate set of tables. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html