Possible to add a NAS in any MySQL table?

2009-12-08 Thread Peter Carlstedt 

Hello everyone,

 

I´ve been searching the net for answers but havent´been able to find any 
information about how to add a NAS in the MySQL tables instead of using the 
clients.conf file. It is possible to use one of the tables that comes with 
Freeradius?

If it is possible, is there any "HOW to" guide for it somewhere?

 

Best regards/ Peter Carlstedt
  
_
Keep your friends updated—even when you’re not signed in.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Possible to add a NAS in any MySQL table?

2009-12-08 Thread Patric 

Peter Carlstedt wrote:

Hello everyone,
 
I´ve been searching the net for answers but havent´been able to find 
any information about how to add a NAS in the MySQL tables instead of 
using the clients.conf file. It is possible to use one of the tables 
that comes with Freeradius?

If it is possible, is there any "HOW to" guide for it somewhere?


sql.conf:
-

   # Set to 'yes' to read radius clients from the database ('nas' 
table)

   # Clients will ONLY be read on server startup.  For performance
   # and security reasons, finding clients via SQL queries CANNOT
   # be done "live" while the server is running.
   #
   readclients = yes

   # Table to keep radius client info
   nas_table = "nas"



sql/${database}/dialup.conf:


   nas_query = "SELECT id, nasname, shortname, type, secret FROM 
${nas_table}"



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

Re: Possible to add a NAS in any MySQL table?

2009-12-09 Thread Maciej Łukasz Wojszkun 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

W dniu 2009-12-09 08:42, Patric pisze:
> Peter Carlstedt wrote:
>> Hello everyone,
>>  
>> I´ve been searching the net for answers but havent´been able to find
>> any information about how to add a NAS in the MySQL tables instead of
>> using the clients.conf file. It is possible to use one of the tables
>> that comes with Freeradius?
>> If it is possible, is there any "HOW to" guide for it somewhere?
> 
> sql.conf:
> -
> 
># Set to 'yes' to read radius clients from the database ('nas'
> table)
># Clients will ONLY be read on server startup.  For performance
># and security reasons, finding clients via SQL queries CANNOT
># be done "live" while the server is running.
>#
>readclients = yes
> 
># Table to keep radius client info
>nas_table = "nas"
> 
> 
> 
> sql/${database}/dialup.conf:
> 
> 
>nas_query = "SELECT id, nasname, shortname, type, secret FROM
> ${nas_table}"
> 
> 

Hi,

so, maybe You know, Patric, how I can insert into radacct table username
from inner session, not outer session?

- -- 
pozdrawiam
Maciej Łukasz Wojszkun
tel. +48698611234
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJLH6VdAAoJELZ0XRdrHMhc3oUH/23EWlCo/XJrHLdPMaM0CF1V
kTATI2qqdBM/+XILt6ppvRhwiGGsqNHkIK+YW3nZqKgk9tcSmWClu/ECWajXAcBT
rqGy1AhJLF2gpuyRHLMGJNRSd8EXjD0iHdyKpn3o6KVuQ2SvEBP0MaxAqvbXfca4
MoJ67sw3iZ9rYBEaKTWQsL4aePvPBfAIRqmyKfBn/PQpy2VRxhCX6ttDukoScRQz
Qc85men6lRfBBSRlt3H00wI0yP4uhJZf/A3dHL/xDtGGIlnoAEez6kJ6fVojKZtb
f2DB+lXthFV+rFw25+YvZaV46wYk4MWuJw3b9M6nWRhvImp0Fsh95jhoS9KI298=
=AhoQ
-END PGP SIGNATURE-
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Possible to add a NAS in any MySQL table?

2009-12-09 Thread tnt 
> so, maybe You know, Patric, how I can insert into radacct table username
> from inner session, not outer session?

Don't hijack other peoples threads. If you have something to ask - start
your own.

That is documented in post-auth section of inner-tunnel virtual server.

Ivan Kalik

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