(RADIATOR) user rewrite diff. from auth and acct

[Hugh Irvine]

Hello Anton -

You would change this:

                 AcctColumnDef   USERNAME,User-Name

to this:

                 AcctColumnDef   USERNAME,%u,formatted

regards

Hugh

On Friday 25 May 2001 09:18, Anton Krall wrote:
> Here is what I use right now:
>
> <Realm xxxx>
>         RewriteUsername         s/^(.*)\@xxxx$/$1\@zzzz/
>         RewriteUsername s/^([^@]+).*/$1/
>         AuthByPolicy ContinueUntilAccept
>         <AuthBy SQL>
>                 DBSource dbi:mysql:menu_mx:sql
>                 DBUsername radius
>                 DBAuth RaDiUs
>                 AuthSelect
>                 AuthColumnDef 0, Encrypted-Password, check
>
>                AccountingTable ACCOUNTING
>                 AcctColumnDef   USERNAME,User-Name
>                 AcctColumnDef   TIME_STAMP,Timestamp,integer
>                 AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
>                 AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
>                 AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
>                 AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
>                 AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
>                 AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
>                 AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
>                 AcctColumnDef   NASIDENTIFIER,NAS-Identifier
>                 AcctColumnDef   NASIPADDRESS,NAS-IP-Address
>                 AcctColumnDef   NASPORT,NAS-Port,integer
>                 AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
>                 AcctColumnDef   hora,Timestamp,formatted-date,'%Y%m%d %T'
>                 AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
>                 AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
>                 #AcctSQLStatement ....
>         </AuthBy>
> Saludos
>
>
> What part should I modify?
> Anton Krall
> Director de Tecnologia
> Inter.net Mexico
> (www.mx.inter.net)
> Email: akrall at team.inter.net
> Directo: 5-241-7609
> Conmutador: 5-241-7600
> Mobile: 044-5105-5160
>
> Outside Mexico:
> Office: (525)241-7609
> PBX: (525)241-7600
> Mobile: (525)105-5160
>
> ______________________
>
> Thursday, May 24, 2001, 5:58:49 PM, you wrote:
>
>
> HI> Hello Anton -
>
> HI> You should proably use %u (or %{User-Name}) for your accounting
> (instead of HI> %n).
>
> HI> hth
>
> HI> Hugh
>
> HI> On Friday 25 May 2001 05:09, Anton Krall wrote:
> >> Guys..
> >>
> >> I use user rewrites for the authby clauses... like this:
> >>
> >>         RewriteUsername        
> >> s/^(.*)\@mcm.inter.net$/$1\@mx.inter.net/ RewriteUsername
> >> s/^([^@]+).*/$1/
> >>
> >> and the user gets auth without a problem..
> >>
> >> the problem is that a user user at domain.com auth by only asking the
> >> authyby DB for the user
> >>
> >> but... in my acct mysql files... I want the username entry to be
> >> user at domain and right now its only recording user (like after the
> >> reqrites).
> >>
> >> How can I change or limit this?
> >>
> >> Thx
> >>
> >>
> >> Saludos
> >>
> >> Anton Krall
> >> Director de Tecnologia
> >> Inter.net Mexico
> >> (www.mx.inter.net)
> >> Email: akrall at team.inter.net
> >> Directo: 5-241-7609
> >> Conmutador: 5-241-7600
> >> Mobile: 044-5105-5160
> >>
> >> Outside Mexico:
> >> Office: (525)241-7609
> >> PBX: (525)241-7600
> >> Mobile: (525)105-5160
> >>
> >>
> >> ===
> >> Archive at http://www.open.com.au/archives/radiator/
> >> Announcements on radiator-announce at open.com.au
> >> To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.