Hello Lin -
You will need to supply your own queries in the <SessionDatabase SQL> clause to use the rewritten username (%n). Have a look at section 6.7 in the Radiator 3.2 reference manual. regards Hugh On Thursday, August 22, 2002, at 12:13 AM, Huaikun Lin wrote: > Hi > > We use SQL server as the Session Database. > > But I don't want the user name shows up as [EMAIL PROTECTED] in > RADONLINE table. > > In SessionDatabase,how do I strip the realm xxx.xx.xx? > > Even I tried adding RewriteUsername s/^([^@]+).*/$1/ clause in > SessionDatabase like the following, the username still shows up as > [EMAIL PROTECTED] in RADONLINE table. > > <SessionDatabase SQL> > RewriteUsername s/^([^@]+).*/$1/ > DBSource dbi:Sybase:server=xxxx;database=xxxx > DBUsername xxxxxx > DBAuth xxxxxx > > </SessionDatabase SQL> > > How to solve the problem? > > Lin > > === > 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. > > NB: I am travelling this week, so there may be delays in our correspondence. -- 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.