Hello Cassidy -
You can only specify one AddQuery in a SessionDatabase clause.
The way to do what you describe is to have a seperate AuthBy SQL clause with
no AuthSelect and no AccountingTable, just an AcctSQLStatement to do whatever
you need to have done.
<AuthBy SQL>
Identifier WriteToLastTimeOnline
AccountingStartsOnly
DBSource ....
DBUsername ....
DBAuth .....
AuthSelect
AcctSQLStatement ......
</AuthBy>
Then you will need to call this AuthBy clause wherever you need it.
hth
Hugh
On Saturday 22 September 2001 05:15, Cassidy B. Larson wrote:
> Howdy all,
>
> Here's my scenario.
>
> I have a session database that keeps track of everybody that's online,
> where, etc.
> I want to add another table that just keeps track of the username, ip, and
> last time online (timestamp). I want this table to be updated after (or
> before) the session database AddQuery gets called.. keeping a 'last time
> online' table somewhat up-to-date.
>
> Here's my problem, I'm not experiencing success by having multiple
> 'AddQuery' lines within the <SessionDatabase SQL> section of my radius
> config. It takes the second of the two.
>
> Is there a way to do this?
>
> I was thinking of doing it after the authentication succeedes, however, the
> authentication database is different than the session database (different
> user/pass, etc), so I'd have to redefine the connection to mysql and such..
> creating useless overhead.
>
> Thanks for any helpful hints/suggestions..
>
> Cassidy Larson
>
>
>
> ----
> Cassidy B. Larson -- Network Operations Manager
> InfoWest, Inc. * 596 E. Tabernacle * St. George, UT 84770
> Voice: 435-674-0165 * FAX: 435-674-9654
> [EMAIL PROTECTED]
> ----
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
