Logging question

2005-10-13 Thread Curt LeCaptain
Currently I'm using the mysql logging functions of FreeRADIUS and I'm
logging two different things:

Dial-up customers that log in with just their username (username)
DSL Customers that log in with user at domain ([EMAIL PROTECTED])

I'm wondering, how would I get it so that both log the same way, that
is, just username, not the suffix @itol.com.  Any advice would be great!

Thanks,
Curt LeCaptain
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Logging question

2005-10-13 Thread Joe Maimon



Curt LeCaptain wrote:


Currently I'm using the mysql logging functions of FreeRADIUS and I'm
logging two different things:

Dial-up customers that log in with just their username (username)
DSL Customers that log in with user at domain ([EMAIL PROTECTED])

I'm wondering, how would I get it so that both log the same way, that
is, just username, not the suffix @itol.com.  Any advice would be great!

Thanks,
Curt LeCaptain
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html




sql.conf lets you log the stripped username


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Logging question

2005-10-13 Thread Dusty Doris



Currently I'm using the mysql logging functions of FreeRADIUS and I'm
logging two different things:

Dial-up customers that log in with just their username (username)
DSL Customers that log in with user at domain ([EMAIL PROTECTED])

I'm wondering, how would I get it so that both log the same way, that
is, just username, not the suffix @itol.com.  Any advice would be great!



Are these the same users?  For example bob is the same as [EMAIL PROTECTED] 
Is that the only domain you serve?  If so, use the hints file to 
automatically change the username for you.  This was recommended by Alan a 
few days ago for a similar question on the list.


in hints

DEFAULT User-Name !~ .*@
User-Name := [EMAIL PROTECTED]

That will rewrite bob to [EMAIL PROTECTED], if its doesn't contain an @.  Then 
they could do either.


However, if you plan on supporting more domains in the future, then I'd 
start getting them used to @domain now because it will be even more of a 
struggle if you need to make them start using it later.  Plus with an 
@domain on the username you leave yourself open to more options with 
realms, proxying, etc..


I am close to finally converting everyone to use realms as our services 
and domains using radius have grown quite a bit.  Having realms makes it a 
lot easier for us, especially that we now have a dozen ISPs running over 
our lines.  Its been a struggle, especially getting marketing/customer 
service to let me do it.


However, if you don't need realms and probably never will, that config 
entry will do exactly you need.


-Dusty Doris
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Logging question

2005-07-15 Thread Michel BĂ©langer




I have recently install Freeradius 1.0.4 on
Freebsd 5.4 and I have a question about the logging method. I need to
log ALL output log in MySQL but freeradius seems logger only some
items. It's possible to logging all the details ?

PS: sorry for my bad english.

-Michel

Example of the details which I have need for logger:

User-Name = "x"
Acct-Status-Type = Alive
NAS-IP-Address = xxx.xxx.xxx.xxx
NAS-Port-Id = "1469"
NAS-Port-Type = Async
Called-Station-Id = "0.18135:18.135#184550775#CCT
05MGAJ100301-647BLCA-000#speed:nrt-VBR:8000,8000,1#pppoe 00:0/"
Calling-Station-Id = "atm 9"
Acct-Status-Type = 0
Acct-Authentic = RADIUS
Acct-Session-Id = "0001B09E"
Framed-Protocol = PPP
Tunnel-Server-Endpoint:0 = "xx.xx.xx.xx"
Tunnel-Type:0 = L2TP
Framed-IP-Address = xx.xx.xx.xx
Acct-Input-Octets = 11654536
Acct-Output-Octets = 8767555
Acct-Input-Packets = 30
Acct-Output-Packets = 99184
Acct-Session-Time = 367068
Acct-Delay-Time = 0
Service-Type = Framed-User
Client-IP-Address = xx.xx.xx.xx
Acct-Unique-Session-Id = "6ee4bbf067e6b27a"




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html