hi, there is a simple patch . correct index problem. --- schema.sql.orig Mon May 18 19:13:56 2009 +++ schema.sql Thu Aug 27 18:27:37 2009 @@ -39,7 +39,7 @@ XAscendSessionSvrKey VARCHAR(10) ); CREATE UNIQUE INDEX radacct_idx1 - ON radacct(acctsessionid,username,acctstarttime, + ON radacct(username,acctsessionid,acctstarttime, acctstoptime,nasipaddress,framedipaddress); CREATE SEQUENCE radacct_seq START WITH 1 INCREMENT BY 1; @@ -65,6 +65,7 @@ op VARCHAR(2) NOT NULL, value VARCHAR(40) ); +CREATE INDEX radcheck_idx1 ON radcheck(UserName); CREATE SEQUENCE radcheck_seq START WITH 1 INCREMENT BY 1; /* Trigger to emulate a serial # on the primary key */