Re: Administering with MySQL DB
Erm, thanks. But Im trying to work out how I Administer the data in MySQL. Are there no utilities for entering data? If I have to enter data manually with SQL insert etc can anyone point me at some docs explaining the format the information should be in?? Andy Smith wrote:
Im completely new to freeradius, I have installed the server with MySQL and also got the dialup web GUI up and running. However its still not clear to me how I add new NAS devices, you dont appear to be able to do that in the GUI. I just want to add a system by IP address with a secret. Do I need to manually do an insert into mysql? If so can someone give me a pointer to how the data should be entered? Or any other help!!
Edit the configuration files with a text editor. Alan DeKok.
FreeRadius Wiki is a good starting point. SQL Howto Andy Smith wrote:
Erm, thanks. But Im trying to work out how I Administer the data in MySQL. Are there no utilities for entering data? If I have to enter data manually with SQL insert etc can anyone point me at some docs explaining the format the information should be in??
Andy Smith wrote:
/ Im completely new to freeradius, I have installed the server with />/ MySQL and also got the dialup web GUI up and running. />/ However its still not clear to me how I add new NAS devices, you dont />/ appear to be able to do that in the GUI. I just want />/ to add a system by IP address with a secret. Do I need to manually do an />/ insert into mysql? If so can someone give me />/ a pointer to how the data should be entered? Or any other help!! / Edit the configuration files with a text editor.
Alan DeKok. ------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Andy Smith wrote:
Erm, thanks. But Im trying to work out how I Administer the data in MySQL. Are there no utilities for entering data? If I have to enter data manually with SQL insert etc can anyone point me at some docs explaining the format the information should be in?? There are many applications, depending on what you want to use radius for. For example I use Radius Manager. It is not free (open source), but it is also not expensive. If you have your own application for managing users, it is not so difficult to connect it to the database of radius. However you have to understand first how radius works.
These pages can be useful: http://wiki.freeradius.org/SQL_HOWTO http://wiki.freeradius.org/Rlm_sql http://wiki.freeradius.org/Operators However I would advice you to use the latest release, freeradius-2. Good luck, Dashamir
http://dev.mysql.com/doc/refman/5.0/en/data-manipulation.html Read at least insert, select, update and delete. Ivan Kalik Kalik Informatika ISP Dana 18/1/2008, "Andy Smith" <a.smith@ukgrid.net> piše:
Erm, thanks. But Im trying to work out how I Administer the data in MySQL. Are there no utilities for entering data? If I have to enter data manually with SQL insert etc can anyone point me at some docs explaining the format the information should be in??
Andy Smith wrote:
Im completely new to freeradius, I have installed the server with MySQL and also got the dialup web GUI up and running. However its still not clear to me how I add new NAS devices, you dont appear to be able to do that in the GUI. I just want to add a system by IP address with a secret. Do I need to manually do an insert into mysql? If so can someone give me a pointer to how the data should be entered? Or any other help!!
Edit the configuration files with a text editor.
Alan DeKok.
participants (4)
-
Andy Smith -
Dashamir Hoxha -
Marinko Tarlac -
tnt＠kalik.co.yu