Hi,
I was wondering how Radiator can capture a username without the suffix
when it's writing the AcctSQLStatement in accounting. I want the
AcctSQLStatement to update the SQL users table, but it's grabbing
username with the suffix ('mikesanlite+ppp' instead of just
'mikesanlite').
It's writing to the accounting table correctly, with suffixes and
realms. However, when it does the AcctSQLStatement, it cannot update
the SQL users table because of the suffix.
How can this be done? Any clues?
Trace 4 log:
-------------------------------
Thu Aug 17 16:47:37 2000: DEBUG: Query is: select Password, Expiration,
SimUse, IdleTime, SessionTime, StaticIP from USERS where IDENTIFIER =
'mikesanlite' AND STATUS != 'C' AND SESSIONTIME > 0
.
.
.
Thu Aug 17 16:47:38 2000: DEBUG: do query is: update USERS set
SESSIONTIME = (SESSIONTIME - 01000) where IDENTIFIER = 'mikesanlite+ppp'
-------------------------------
Config file:
-------------------------------
<AuthBy SQL>
.
.
.
AuthSelect select Password, Expiration, SimUse, \
IdleTime, SessionTime, StaticIP \
from USERS where IDENTIFIER = '%n' AND STATUS != 'C' \
AND SESSIONTIME > 0
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, Simultaneous-Use, check
AuthColumnDef 3, Idle-Timeout, reply
AuthColumnDef 4, Session-Timeout, reply
AuthColumnDef 5, Framed-IP-Address, reply
AccountingTable ACCOUNTING
AccountingStopsOnly
.
.
.
AcctSQLStatement update USERS set SESSIONTIME = (SESSIONTIME -
0%{Acct-Session-Time}) \
where IDENTIFIER = '%n'
</AuthBy>
-------------------------------
Thank you,
Janet
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
