Radius Sending Rollback Message?

Alan DeKok aland at ox.org
Thu Dec 8 20:30:06 CET 2005


"Sharma Raj" <Raj.Sharma at orange.ch> 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.




More information about the Freeradius-Users mailing list