radusergroup without primary key

2012-12-26 Thread Efi merdler
Hello, I'm using radius 2.1.12 with postgresql as a backend. I've noticed that radusergroup does not contain any key column. There is a complaint on the subject posted back in 2007 (http://lists.freeradius.org/pipermail/freeradius-devel/2007-August/003239.html) however nobody addressed it. We

Re: radusergroup without primary key

2012-12-26 Thread Marinko Tarlać
You can add what ever you want to the read-only tables. On 26.12.2012 10:59, Efi merdler wrote: Hello, I'm using radius 2.1.12 with postgresql as a backend. I've noticed that radusergroup does not contain any key column. There is a complaint on the subject posted back in 2007

Re: radusergroup without primary key

2012-12-26 Thread Efi merdler
What do you mean by read-only tables ? As I understand I'm suppose to add items to it. On Wed, Dec 26, 2012 at 1:20 PM, Marinko Tarlać mangi...@gmail.com wrote: You can add what ever you want to the read-only tables. On 26.12.2012 10:59, Efi merdler wrote: Hello, I'm using radius 2.1.12

Re: radusergroup without primary key

2012-12-26 Thread Marinko Tarlać
As I know, FreeRadius will only read from radusergroup table. All you need to do is to take care about the SQL queries inside dialup.conf file which are executed on this table (which means do not change the column names unless you change them inside dialup.conf too). For example, I several

Re: radusergroup without primary key

2012-12-26 Thread Alan DeKok
Efi merdler wrote: We are accessing the table from an external process and it requires a primary key to be successful, how would you recommend handling it ? Add a key. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html