Re: Administering with MySQL DB

2008-01-28 Thread Dashamir Hoxha
Hi, I have tested a bit daloradius and I have seen that there bugs/problems with it. Some other alternatives (which also do have problems) are these: http://cakeforge.org/projects/hotcakes/ http://sourceforge.net/projects/phpmyprepaid/ http://sourceforge.net/projects/phpradmin/

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
Glad to hear that Andy. I'll be happy to assist you with whatever daloradius questions you have, including feature requests and bug fixes :) Regards, Liran Tal. On Jan 20, 2008 8:15 PM, Andy Smith [EMAIL PROTECTED] wrote: Hi All, thanks for the assistance from everyone on this. My prob

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
Hey Dashmir, On Jan 28, 2008 1:28 PM, Dashamir Hoxha [EMAIL PROTECTED] wrote: Hi, I have tested a bit daloradius and I have seen that there bugs/problems with it. Some other alternatives (which also do have problems) are these: It's upsetting to hear that, I don't remember ever getting any

Re: Administering with MySQL DB

2008-01-28 Thread Dashamir Hoxha
liran tal wrote: Let's indeed move on, I'd appreciate it if you can give the svn version a try, it might be buggy just because it's SVN and by definition I try new stuff on it but I also commit fixes straight away so you really enjoy the latest. I hope to hear from you again, OK, Liran. Let me

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
Hey Dashmir, On Jan 28, 2008 2:49 PM, Dashamir Hoxha [EMAIL PROTECTED] wrote: Hi Liran, Please don't get upset. I just tested it out of curiosity and I didn't try to make it work at all costs. Maybe the problem was because I tested it with freeradius-2, I get upset because I'm dedicating

Re: Administering with MySQL DB

2008-01-28 Thread Dashamir Hoxha
Hi Liran, Please don't get upset. I just tested it out of curiosity and I didn't try to make it work at all costs. Maybe the problem was because I tested it with freeradius-2, and I renamed the table usergroup to radusergroup. Also I noticed that the interface (menus, left pane, etc.) is a bit

Re: Administering with MySQL DB

2008-01-20 Thread Andy Smith
Hi All, thanks for the assistance from everyone on this. My prob was not even knowing which nas table field you were meant to put the IP address of the device in due to the naming standard. I've installed daloradius, which was very quick and easy to install on a system already configured for

Re: Administering with MySQL DB

2008-01-19 Thread tnt
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 [EMAIL PROTECTED] piše: Erm, thanks. But Im trying to work out how I Administer the data in MySQL. Are there no utilities

Re: Administering with MySQL DB

2008-01-19 Thread liran tal
Hey Andy, There are other alternatives to dialup admin in terms of web management for freeradius. One of which is daloRADIUS (and yes it supports managing the nas entries for the database as well). Web: http://sourceforge.net/projects/daloradius/ Wiki: http://daloradius.wiki.sourceforge.net/

Administering with MySQL DB

2008-01-18 Thread Andy Smith
Hi list, 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

Re: Administering with MySQL DB

2008-01-18 Thread Andy Smith
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

Re: Administering with MySQL DB

2008-01-18 Thread Marinko Tarlac
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

Re: Administering with MySQL DB

2008-01-18 Thread Matt Pinkston
The nas table definition can be found at the bottom of this page http://wiki.freeradius.org/MySQL_DDL_script make sure to set: readclients = yes (probably at the bottom of sql.conf) the column names in the nas table are pretty self-explanatory after you have that set up. Just be sure to

Re: Administering with MySQL DB

2008-01-18 Thread Alan DeKok
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

Re: Administering with MySQL DB

2008-01-18 Thread Andy Smith
Hi, thanks, Ive looked at this and its a good guide to initial install but doesnt seem to provide any detailed info on how to administer the data in the tables. IE there is a sample of some data from a test system but this doesnt even mention the NAS table, how are other people administering

Re: Administering with MySQL DB

2008-01-18 Thread A . L . M . Buxey
Hi, thanks, Ive looked at this and its a good guide to initial install but doesnt seem to provide any detailed info on how to administer the data in the tables. IE there is a sample of some data from a test system but this doesnt even mention the NAS table, how are other people

Re: Administering with MySQL DB

2008-01-18 Thread Dashamir Hoxha
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