Hi all. Looking forward to picking your brains regarding FreeRADIUS as I'm kinda new to it. I took over administrative duties for the person who previously took care of our network and I'm trying to work with some of the FreeRADIUS settings and update to a newer version in the process. Current version is 1.0.4 (I know, it ancient), however also in the middle of a CentOS build while hoping to deploy that latest version of FreeRADIUS. I have a curious question though. Since the current version is substantially older than what we're moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one? Thanks in advance, -Tim
I have a curious question though. Since the current version is substantially older than what we’re moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one?
It will depend on your current schema. The queries used by FreeRADIUS could have be customized. Even if they haven't been customized, it is possible the default changed between version. If they are different, you will need to move the queries from the config of your old server, and incorporate them into the config of the the new FreeRADIUS install. If the queries are the same, then you can just copy the database.
Thanks in advance,
-Tim
Tom
Thanks again to everyone and their input. I was able to get the server to run after importing the database. The database itself has been in production for some time, I was very skeptical about changing the DB so I decided to edit the calls that FreeRADIUS runs on the DB itself which worked out very well indeed. One thing I noticed that it seems in the change in the DB was the name itself (truncated from "freeradius" to just "radius) and id in some tables was changed to priority? So far so good either way, it's working well and radius -X returns no errors :-) -Tim -----Original Message----- From: freeradius-users-bounces+tim=velociter.net@lists.freeradius.org [mailto:freeradius-users-bounces+tim=velociter.net@lists.freeradius.org] On Behalf Of Tom Samplonius Sent: Friday, January 21, 2011 7:27 PM To: FreeRadius users mailing list Subject: Re: New to the lists
I have a curious question though. Since the current version is substantially older than what we’re moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one?
It will depend on your current schema. The queries used by FreeRADIUS could have be customized. Even if they haven't been customized, it is possible the default changed between version. If they are different, you will need to move the queries from the config of your old server, and incorporate them into the config of the the new FreeRADIUS install. If the queries are the same, then you can just copy the database.
Thanks in advance,
-Tim
Tom - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Tim McNabb wrote:
I have a curious question though. Since the current version is substantially older than what we’re moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one?
Look at the schema. It should be pretty similar, IIRC. You might even be able to use the DB unchanged. The most you'll have to do is add an "operator" field. See the SQL docs && examples. Alan DeKok.
For example, usergroup table is renamed to radusergroup but inside sql.conf you can set what ever you want... On 1/22/2011 8:57 AM, Alan DeKok wrote:
Tim McNabb wrote:
I have a curious question though. Since the current version is substantially older than what we’re moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one? Look at the schema. It should be pretty similar, IIRC. You might even be able to use the DB unchanged.
The most you'll have to do is add an "operator" field. See the SQL docs&& examples.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thanks to everyone for your responses! I'm still trying to pick apart how it is configured though it is pretty standard IMO. radiusd.conf and clients.conf seem to be the only two modified files. I'll perform a mysqldump so I can test it out and see if the default config will run ok. Will let you know how everything turns out! Thanks in advance, -Tim -----Original Message----- From: freeradius-users-bounces+tim=velociter.net@lists.freeradius.org [mailto:freeradius-users-bounces+tim=velociter.net@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Friday, January 21, 2011 11:57 PM To: FreeRadius users mailing list Subject: Re: New to the lists Tim McNabb wrote:
I have a curious question though. Since the current version is substantially older than what we’re moving to, how will this affect the sql database? Will I be able to install the newest version of FreeRADIUS and just perform a mysql dump from the old server to the new one?
Look at the schema. It should be pretty similar, IIRC. You might even be able to use the DB unchanged. The most you'll have to do is add an "operator" field. See the SQL docs && examples. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (4)
-
Alan DeKok -
Marinko Tarlac -
Tim McNabb -
Tom Samplonius