Hello Janet -
Is your AuthBy SQL clause being called from two different places? One
for authentication with rewriteUsername and the other for accounting?
Somehow the processing for the two packets is different.
hth
Hugh
At 17:47 +1000 17/8/00, Janet N del Mundo wrote:
>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.
--
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
