On Fri, 9 Aug 2002, Alexander M. Pravking wrote:
> On Thu, Aug 08, 2002 at 08:38:13AM -0500, Rick Eicher II wrote:
> > Hello all,
> >
> > We use freeside to manage out system and ICRadius for our dailup users. We
> > are wanting to move to freeradius but seem to have a problem when
> > inserting users.
> >
> > failed: ERROR: Cannot insert a duplicate key into unique index
> > radcheck_pkey at ...
> >
> > failed: can't insert into groupname table: ERROR: Cannot insert a duplicate
> > key into unique index usergroup_pkey at ...
>
> Sounds like PosgreSQL error messages...
>
> > The fields that are indexed are of type serial so they should increment
> > themselves with out our help.
>
> Yes and no. If you specify its value, then _this value_ is inserted,
> e.g. INSERT INTO radcheck
> VALUES (0, 'Some-User', 'Some-Attribute', 'Some-Value', '==')
>
> If you specify no value, then the default value is inserted,
> which is nextval('radcheck_id_seq') for SERIAL type.
> e.g. INSERT INTO radcheck (username, attribute, value, op)
> VALUES ('Some-User', 'Some-Attribute', 'Some-Value', '==')
>
I already wrote about that, example postgresql.conf in your freeradius
contains some explanations in accounting section. What is good for mysql
may not be good for postgres :-)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
