"Sharma Raj" <[EMAIL PROTECTED]> wrote:
> In our setup of Radius, we use an Oracle database. Ordinarily, when NAS
> sends Accounting Start messages to Radius, Radius sends Update messages
> to Oracle. Periodically, something odd happens - Radius sends a Rollback
> message to Oracle which undoes the Update.

  Maybe the UPDATE transaction fails, so that one update is being
rolled back.

> The Oracle DB listener trace for the first message shows the DML was
> received ok but the end of a trace shows a ROLLBACK (this undoes all the
> DMLs since the last COMMIT was sent). Details:

  In sql_oracle.c, the sql_query function executes the UPDATE and
commits it if it was OK, so any rollback should be confined to one
update only.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to