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


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