nas table and virtual servers?

2010-12-16 Thread Jiann-Ming Su
Does the nas table work with virtual servers? That is, what is the nas configuration equivalent of the following config? client my_switch { ipaddr = 192.168.201.154 secret = abc.123 virtual_server = my_virtual_server } On startup

Re: nas table and virtual servers?

2010-12-16 Thread Alan DeKok
Jiann-Ming Su wrote: Does the nas table work with virtual servers? Yes. On startup, freeradius reads from the nas table and loads the clients listed there. But, those clients don't know which virtual server to connect to. Read the schema the queries. There's a server entry which

Re: nas table and virtual servers?

2010-12-16 Thread Jiann-Ming Su
- Original Message From: Alan DeKok al...@deployingradius.com To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Fri, December 17, 2010 12:42:45 AM Subject: Re: nas table and virtual servers? Jiann-Ming Su wrote: Does the nas table work with virtual

RE: Freeradius is unable to read NAS table in mysql db

2010-06-10 Thread superataru -
Hi. Sorry 'cause i'm late. Some troubles. Well i worked as following explained to perform a test (problem we talk about) but also to check if password would have been passed encrypted in the internet. || *|NAS-USG100|*( *USGWAN* -79.xxx.xxx.xxx

RE: Freeradius is unable to read NAS table in mysql db

2010-06-10 Thread Tim Sylvester
of the PDC. FreeRADIUS uses the source IP address of the RADIUS packet to determine the IP address of the NAS, not the NAS-IP-Address attribute. The IP addresses in the clients.conf file and the nas table in MySQL are checked using the source IP address of the RADIUS packet. So, you can either ignore

RE: Freeradius is unable to read NAS table in mysql db

2010-06-10 Thread superataru -
Ok. Thank you so much! It's coming time to turn all winradius server in freeradius units :-) Now let's working on PEAP . . . so i argue, we'll have to talk again! :-) Gtrz Superataru, -- ___ Sono solo un passeggero del volo e mi credevo pilota . . . -

RE: Freeradius is unable to read NAS table in mysql db

2010-06-07 Thread superataru -
Hi. Sorry for some errors in former mails. Yes parameter is the right one. Once i set this i obtain what i want: it works! I had misunderstood what parameter yes/no would have changed on setting. I already attach log file with *yes* setting. *So problem has been solved! :-)* Anyway . . . I see

Re: Freeradius is unable to read NAS table in mysql db

2010-06-07 Thread Alan Buxey
Hi, User-Name = cactus User-Password = barilotto NAS-IP-Address = 172.16.68.10 this is the address that the NAS is coming from - you say the devices are all accessed via VPN? what is the end point of the VPN? looks like its the windows box thats also running MQSL and WinRADIUS? alan

Re: Freeradius is unable to read NAS table in mysql db

2010-06-07 Thread superataru -
Hi. Thank you for reply. I thought same thing could be possible, so i created an other user on mysql server. I connected directly to USG on the Public IP of its (no VPNs now) I performed radiusd -X . . . User-Name = vito User-Password = catozzo NAS-IP-Address =

Re: Freeradius is unable to read NAS table in mysql db

2010-06-07 Thread Alan Buxey
Hi, I thought same thing could be possible, so i created an other user on mysql server. I connected directly to USG on the Public IP of its (no VPNs now) I performed radiusd -X . . . and what does eg wireshark or tcpdump show - run it, listening on udp port 1812, when you perform the

Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread superataru -
/clients.conf file, setting readclients = yes in /raddb/sql.conf. Once i set it to no, autentication fails. I checked nas table structure and it's ok, the same as in /usr/local/etc/raddb/sql/mysql/nas.sql User are instead loaded fine from mysql users table. How could i solve it? Thanks in advance Here my

RE: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread Tim Sylvester
it to no, autentication fails. I checked nas table structure and it's ok, the same as in /usr/local/etc/raddb/sql/mysql/nas.sql User are instead loaded fine from mysql users table. Your message doesn't have enough information to troubleshoot your problem. Run FreeRADIUS in debug mode (radiusd -X

RE: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread superataru -
Thank you for reply. I found the problem. I missed a field during nas table analysis. The field was server, varchar(64). I added it. I had also to - clear clients.conf from NAS manually added to avoid duplicates; - set one NAS address, formerly added, as Host address instead of subnet. Now

Re: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread superataru -
/radiusd/radiusd.sock Ready to process requests. Ignoring request to authentication address * port 1812 from unknown client 89.aa.bb.cc port 19556 Ready to process requests*. *89.aa.bb.cc is NAS address i set on mysql NAS table.* So no problems with tables structure, but some misconfiguration with data

Re: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread superataru -
/run/radiusd/radiusd.sock Ready to process requests. Ignoring request to authentication address * port 1812 from unknown client 89.aa.bb.cc port 19556 Ready to process requests*. *89.aa.bb.cc is NAS address i set on mysql NAS table.* So no problems with tables structure, but some

Re: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread Alan Buxey
Hi, So no problems with tables structure, but some misconfiguration with data. as per previous email sent to you from another perosn helping you radiusd -X it will show you where the problem is - or send the output to the list because otherwise we can do little but make random guesses :-(

RE: Freeradius is unable to read NAS table in mysql db

2010-06-06 Thread Tim Sylvester
on command file /usr/local/var/run/radiusd/radiusd.sock Ready to process requests. Ignoring request to authentication address * port 1812 from unknown client 89.aa.bb.cc port 19556 Ready to process requests. 89.aa.bb.cc is NAS address i set on mysql NAS table. Send the following information

Re: Re: How long is the nas-table cached by freeradius?

2010-06-01 Thread Alan Buxey
Hi, Is this fix available now ? (freeradius server to read the change in nas-table without restart) Thanks. what is your issue/problem - are you dealing with updated details of existing NAS or NEW NAS devices being added? alan - List info/subscribe/unsubscribe? See http://www.freeradius.org

Re: How long is the nas-table cached by freeradius?

2010-06-01 Thread Bjørn Mork
Rameshbabu Ragothaman rameshbabu.ragotha...@ibec.net writes: Is this fix available now ? (freeradius server to read the change in nas-table without restart) Looks like I've expired the rest of this thread so this might have been brought up before, but did you check out the raddb/sites

Using the NAS table for Huntgroup-Name

2010-06-01 Thread Bjørn Mork
I thought I might share a configuration part that has proven useful for us... Based on the howto at http://wiki.freeradius.org/SQL_Huntgroup_HOWTO , we found that we might as well add the huntgroup name to the NAS table when adding new NASes. No need to maintain two separate tables with the NAS

Re:Re: How long is the nas-table cached by freeradius?

2010-05-31 Thread Rameshbabu Ragothaman
Is this fix available now ? (freeradius server to read the change in nas-table without restart) Thanks. Evert Meulie ev...@witelcom.com wrote: Just wondering about the following: If a change is made in the nas-table of the radius-db, how long does it take for the freeradius daemon to start using

RE: Re: How long is the nas-table cached by freeradius?

2010-05-31 Thread Tim Sylvester
=networkradius@lists.freeradius.or g [mailto:freeradius-users-bounces+tim.sylvester=networkradius@lists.freer adius.org] On Behalf Of Rameshbabu Ragothaman Sent: Monday, May 31, 2010 12:30 PM To: freeradius-users@lists.freeradius.org Cc: al...@nitros9.org Subject: Re:Re: How long is the nas-table

Re: Problem with server atribute in NAS table with mysql

2009-11-10 Thread Ana Gallardo
which means you havent updated the SQL qeuery to use that column. nas_query = SELECT id, nasname, shortname, type, secret, server FROM ${nas_table} That was the problem. Thank you very much Alan. -- Ana Gallardo Gómez - List

Problem with server atribute in NAS table with mysql

2009-11-09 Thread Ana Gallardo
Hello, I'm using Freeradius 2.0.4-3 an Debian. My clients are in a MySQL database (nas table). ++--+---+---+-++-+---+---+ | id | nasname | shortname | type | ports| secret

Re: Problem with server atribute in NAS table with mysql

2009-11-09 Thread Alan Buxey
Hi, My clients are in a MySQL database (nas table). ++--+---+---+-++-+---+---+ | id | nasname | shortname | type | ports| secret | server | community | description

Re: Add clients into nas table

2009-05-22 Thread Alan DeKok
Ming-Ching Tiew wrote: May I ask if I am using sql to store the client list in the sql table 'nas', is there a way for me to ask freeradius to refresh the list ? Or is it that I must kill and restart freeradius ? You have to re-start the server. Alan DeKok. - List

Re: Add clients into nas table

2009-05-22 Thread A . L . M . Buxey
and if its a new unknown client it can read your NAS table for info and allow the new client... alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Add clients into nas table

2009-05-21 Thread Ming-Ching Tiew
May I ask if I am using sql to store the client list in the sql table 'nas', is there a way for me to ask freeradius to refresh the list ? Or is it that I must kill and restart freeradius ? Regards. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: NAS table

2009-04-18 Thread tnt
so thak you ivan...really apreciate for your answeri just install it using apt-get install command ubuntu 7.10. so i'll upgrade to wich version??which version is better..?? Current one. 2.1.4. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See

RE: NAS table

2009-04-16 Thread Nizar Zulmi
wrong...still cannot read NAS from nas table on radius..was it? really apreciate your answer. Nizar --- On Thu, 4/16/09, Ivan Kalik t...@kalik.net wrote: From: Ivan Kalik t...@kalik.net Subject: RE: NAS table To: 'FreeRadius users mailing list' freeradius-users@lists.freeradius.org Date: Thursday

Re: NAS table

2009-04-15 Thread Nizar Zulmi
, April 14, 2009 7:25:02 PM Subject: RE: NAS table Message Post radiusd -X output of server startup. Is sql enabled anywhere in the configuration? It isn't by default. Ivan Kalik Kalik Informatika ISP -Original Message- From: freeradius-users-bounces+tnt=kalik

Re: NAS table

2009-04-15 Thread JDL
, 2009 7:25:02 PM *Subject:* RE: NAS table Post radiusd -X output of server startup. Is sql enabled anywhere in the configuration? It isn't by default. Ivan Kalik Kalik Informatika ISP -Original Message- *From:* freeradius-users-bounces+tnt=kalik@lists.freeradius.org

RE: NAS table

2009-04-15 Thread Ivan Kalik
this is result of freeradius -X reread_config: reading radiusd.conf Config: including file: /etc/freeradius/proxy.conf Config: including file: /etc/freeradius/clients.conf Config: including file: /etc/freeradius/snmp.conf Config: including file: /etc/freeradius/eap.conf Config:

Re: NAS table

2009-04-14 Thread Nizar Zulmi
i comment out this on clients.conf #client 127.0.0.1 { #   secret  = passwordradius #   shortname   = localhost #   nastype = other # localhost isn't usually a NAS... #} and i add this to NAS table on radius database. insert into nas (nasname, shortname, secret

RE: NAS table

2009-04-14 Thread Ivan Kalik
@lists.freeradius.org] On Behalf Of Nizar Zulmi Sent: 14 April 2009 08:00 To: FreeRadius users mailing list Subject: Re: NAS table i comment out this on clients.conf #client 127.0.0.1 { # secret = passwordradius # shortname = localhost # nastype = other # localhost isn't

NAS table

2009-04-13 Thread Nizar Zulmi
anyone can help.. i want to set my radius server reading the NAS from table NAS on radius database. my radius are still reading NAS from clients.conf. apreciate your help. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: NAS table

2009-04-13 Thread Ivan Kalik
+tnt=kalik@lists.freeradius.org] On Behalf Of Nizar Zulmi Sent: 13 April 2009 19:40 To: freeradius-users@lists.freeradius.org Subject: NAS table i want to set my radius server reading the NAS from table NAS on radius database. my radius are still reading NAS from clients.conf. - List

Re: NAS table

2009-04-13 Thread Nizar Zulmi
-users@lists.freeradius.org Sent: Tuesday, April 14, 2009 5:11:55 AM Subject: RE: NAS table Have you enabled read_clients in sql.conf? Doing that doesn't disable reading clients.conf. Just remove duplicate clients from the file. Ivan Kalik Kalik Informatika ISP -Original Message- From

Re: NAS table

2009-04-13 Thread JDL
Nizar Zulmi wrote: i enable this on sql.conf readclients = yes do i have to remove this : client 127.0.0.1 { Do you have a 127.0.0.1 client in your the nas table? If so, then yes, you will need to remove it or else you will end up with a duplicate. If this client is not in your nas table

Re: Get clients virtual_server info from SQL nas table

2008-07-07 Thread A . L . M . Buxey
Hi, /* * Table structure for table 'nas' */ CREATE TABLE nas ( id SERIAL PRIMARY KEY, nasname VARCHAR(128) NOT NULL, shortname VARCHAR(32) NOT NULL, typeVARCHAR(30) NOT NULL DEFAULT 'other', ports int4, secret VARCHAR(60) NOT NULL,

Get clients virtual_server info from SQL nas table

2008-07-05 Thread nf-vale
Hi all, In my deploy, freeradius is retrieving clients info from sql nas table, but this table does not have a virtual _server column, and need to use virtual servers. Is it possible to get virtual_server info from sql nas table, instead of clients.conf file. If yes, what do I need to do? Thx

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread Alan DeKok
nf-vale wrote: In my deploy, freeradius is retrieving clients info from sql nas table, but this table does not have a virtual _server column, and need to use virtual servers. Is it possible to get virtual_server info from sql nas table, instead of clients.conf file. If yes, what do I need

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread nf-vale
for postgres? 2.0.5 sources? Is it also possible for radiusd to retrieve realms and proxy information from SQL instead of files? Thx again, Nelson Vale Sáb, 2008-07-05 às 16:09 +0200, Alan DeKok escreveu: nf-vale wrote: In my deploy, freeradius is retrieving clients info from sql nas table

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread Alan DeKok
nf-vale wrote: Thanks for your quick answer. In the freeradius-server-2.0.3/raddb/sql/postgresql/nas.sql file the sql table structure did not show any server column: ... Where can I get the most updated SQL schema for postgres? 2.0.5 sources? That would be a good idea, yes. Is it also

Will connection attempts from NAS' not in nas table be logged?

2007-09-06 Thread Patric
Hi Guys, Just a quick question, as the per the subject line : If my freeradius server receives a connection attempt from a NAS not listed in the NAS table (as specified in sql.conf : nas_table = nas), will that attempt appear in the radius.log, or would such information only appear in debug

Re: Will connection attempts from NAS' not in nas table be logged?

2007-09-06 Thread Patric
Patric wrote: Hi Guys, Just a quick question, as the per the subject line : If my freeradius server receives a connection attempt from a NAS not listed in the NAS table (as specified in sql.conf : nas_table = nas), will that attempt appear in the radius.log, or would such information only

nas table and users.conf

2007-08-23 Thread Genis Pujol Hamelink
Hello, Apparently the radiusd is not loading the nas list from the nas table but from the users.conf...anyone knows how to tell freeradius to load the list from the mysql table and skip the users.conf file? cheers, Genís. - List info/subscribe/unsubscribe? See http://www.freeradius.org

Re: nas table and users.conf

2007-08-23 Thread A . L . M . Buxey
Hi, Hello, Apparently the radiusd is not loading the nas list from the nas table but from the users.conf...anyone knows how to tell freeradius to load the list from the mysql table and skip the users.conf file? 1) ensure you have populated the SQL database with the NAS table 2) ensure

RE: nas table and users.conf

2007-08-23 Thread Genis Pujol Hamelink
)... Should this be in the config file by default or is it only available on the latest version of freeradius? Genís De: [EMAIL PROTECTED] en nombre de [EMAIL PROTECTED] Enviado el: jue 23/08/2007 13:16 Para: FreeRadius users mailing list Asunto: Re: nas table

Re: nas table and users.conf

2007-08-23 Thread A . L . M . Buxey
Hi, thank you for your reply. I have everything set up as u mentioned, but for 2) ensure that you have enabled 'read clients' in the SQL config for the SQL dialect you have chosen This option is not available... and in radiusd.conf only the clients.conf file is mentioned ($INCLUDE)...

RE: nas table and users.conf

2007-08-23 Thread Genis Pujol Hamelink
Hi, I'm using RHEL 3, it ships with freeradius 0.9.0, could it be that this option is not available in this version?...I added the string u mentioned but it doesn't read the data from the nas table...clients.conf only has localhost and the nas and clients file are empty. cheers, Genís

Re: nas table and users.conf

2007-08-23 Thread Alan DeKok
Genis Pujol Hamelink wrote: I'm using RHEL 3, it ships with freeradius 0.9.0, could it be that this option is not available in this version?...I added the string u mentioned but it doesn't read the data from the nas table...clients.conf only has localhost and the nas and clients file

NAS Table in SQL

2007-03-07 Thread ChristosH
Does subnetting in the NAS table work when using SQL? If I wanted to allow any address from my internal network, 111.111.%.% for example, can I store the nasname as 111.111.0.0/16 like I do in the users table? Or does it have to be in the form 255.255.0.0? -- View this message in context: http

Re: clients.conf and nas table (was Re: installing FR on FBSD 6.2)

2007-03-01 Thread A . L . M . Buxey
has nas table Should both of them contain the same datas ? Why should we has both of them, not one only ? you shouldnt use both - that just creates confusion. if you want to use the NAS table, use that. if you want to use clients.conf use that. BUT if you use the NAS table you must have a dummy

clients.conf and nas table (was Re: installing FR on FBSD 6.2)

2007-02-28 Thread PD
... at /usr/local/etc/raddb we has clients.conf that contain nas ip address, secret, shortname and type. but at radius database we also has nas table Should both of them contain the same datas ? Why should we has both of them, not one only ? TIA Paul - List info/subscribe/unsubscribe? See http

Re: Re: Re: nas table in rlm_sql module - usage

2007-02-13 Thread ChristosH
/nas-table-in-rlm_sql-module---usage-tf3201294.html#a8894555 Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list

Re: Re: Re: nas table in rlm_sql module - usage

2007-02-13 Thread A . L . M . Buxey
to have a stub clients.conf - even with just a fake client in it. to USE the NAS SQL table, simply look at the bottom few lines of sql.conf - its self documented! # Set to 'yes' to read radius clients from the database ('nas' table) readclients = yes ensure that the other lines

nas table in rlm_sql module - usage

2007-02-09 Thread tzieleniewski
Hi!! I was trying to find out what is this table nas really used for. I read the whole documentation in the doc directory of radius and dialup_admin but I still have many doubts. Is it used just for mapping and getting information about online users or it is somehow equivalent to clients.conf

Re: nas table in rlm_sql module - usage

2007-02-09 Thread Gaddis, Jeremy L.
On Fri, 9 Feb 2007, tzieleniewski wrote: I was trying to find out what is this table nas really used for. I read the whole documentation in the doc directory of radius and dialup_admin but I still have many doubts. Is it used just for mapping and getting information about online users or it

Re: nas table in rlm_sql module - usage

2007-02-09 Thread TZieleniewski
and getting information about online users or it is somehow equivalent to clients.conf file?? It's the SQL equivalent of clients.conf, yes. so clients.conf can be empty and all settings can be contained in nas table? will sql work for ip6 client?? - List info/subscribe/unsubscribe? See

Re: nas table in rlm_sql module - usage

2007-02-09 Thread Gaddis, Jeremy L.
On Fri, 9 Feb 2007, TZieleniewski wrote: so clients.conf can be empty and all settings can be contained in nas table? Yes. will sql work for ip6 client?? No idea. -- Jeremy L. Gaddis, MCP, GCWN [EMAIL PROTECTED] LinuxWiz Consulting http://linuxwiz.net

Re: nas table in rlm_sql module - usage

2007-02-09 Thread ChristosH
Gaddis, Jeremy L.-2 wrote: On Fri, 9 Feb 2007, TZieleniewski wrote: so clients.conf can be empty and all settings can be contained in nas table? Is there some spot where we can get definitions for each column (like where each definition maps to in the clients.conf file)? Does it work out

Re: Re: nas table in rlm_sql module - usage

2007-02-09 Thread tzieleniewski
: On Fri, 9 Feb 2007, TZieleniewski wrote: so clients.conf can be empty and all settings can be contained in nas table? Is there some spot where we can get definitions for each column (like where each definition maps to in the clients.conf file)? Does it work out like (naming from

Re: Re: nas table in rlm_sql module - usage

2007-02-09 Thread ChristosH
probably the nasname has to be different (its ip resolution) from the one specified in the clients.conf file. Well those of course are only my suggestions:) Cheers -tomasz -- View this message in context: http://www.nabble.com/nas-table-in-rlm_sql-module---usage-tf3201294.html#a8894555 Sent from

Re: Re: Re: nas table in rlm_sql modul e - usage

2007-02-09 Thread tzieleniewski
://www.nabble.com/nas-table-in-rlm_sql-module---usage-tf3201294.html#a8894555 Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org

Re: Re: Re: Re: nas table in rlm_sql modul e - usage

2007-02-09 Thread tzieleniewski
) from the one specified in the clients.conf file. Well those of course are only my suggestions:) Cheers -tomasz -- View this message in context: http://www.nabble.com/nas-table-in-rlm_sql-module---usage-tf3201294.html#a8894555 Sent from the FreeRadius - User mailing list

RE: nas table

2006-06-13 Thread Cliff Hayes
Thanks. Found it on the last line. readclients = yes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan DeKok Sent: Monday, June 12, 2006 7:29 PM To: FreeRadius users mailing list Subject: Re: nas table Cliff Hayes [EMAIL PROTECTED] wrote

nas table

2006-06-12 Thread Cliff Hayes
Hello, I am a new user trying to set up FreeRadius on Fedora 5. I purchased a copy of Hassell's Radius book; didn't seem to help much. I was able to get it to work with clients.conf Then, I converted to MySQL. I think I'm supposed to copy the clients into the nas table, so I did

Re: nas table

2006-06-12 Thread Alan DeKok
Cliff Hayes [EMAIL PROTECTED] wrote: Then, I converted to MySQL. I think I'm supposed to copy the clients into the nas table, so I did that, but the table doesn't appear to be being used. What do I have to do to use the table? Am I supposed to be using the table? read sql.conf. Alan

NAS table fields

2006-06-09 Thread Cliff Hayes
Hello, I looked through all the documentation I could find and surfed google but could not find details on what needs to go in the NAS fields. For example, in the clients.conf file, the only required fields are SECRET and SHORTNAME. In the NAS table, SHORTNAME is optional (can be NULL

Re: NAS table fields

2006-06-09 Thread K. Hoercher
On 6/9/06, Cliff Hayes [EMAIL PROTECTED] wrote: For example, in the clients.conf file, the only required fields are SECRET and SHORTNAME. In the NAS table, SHORTNAME is optional (can be NULL), and NASNAME cannot be NULL. So, do I copy what I had in the clients.conf SHORTNAME into the NAS table

nas table

2006-05-25 Thread Santiago Balaguer García
Hi people, I use freeradius 1.0.5 and am getting my nas information from nas table since several months ago. How ever, I realize I have to put DNS in this table because I have DDNS entries. Where must I put the DDNS in this table?? In ipddr I can not because is inet type and a primary key

Re: nas table

2006-05-25 Thread Alan DeKok
=?iso-8859-1?B?U2FudGlhZ28gQmFsYWd1ZXIgR2FyY+1h?= [EMAIL PROTECTED] wrote: I use freeradius 1.0.5 and am getting my nas information from nas table since several months ago. How ever, I realize I have to put DNS in this table because I have DDNS entries. Where must I put the DDNS

nas table in SQL backend

2006-03-08 Thread trs
The SQL scripts have a comment for the nas table that says it isn't used by freeradius. Is this still the case? How is it populated otherwise? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: nas table in SQL backend

2006-03-08 Thread Alan DeKok
trs [EMAIL PROTECTED] wrote: The SQL scripts have a comment for the nas table that says it isn't used by freeradius. Is this still the case? How is it populated otherwise? It's used. It's not populated by the server. It's populated by the admin. Alan DeKok. - List info/subscribe

Re: nas table in SQL backend

2006-03-08 Thread Alan DeKok
trs [EMAIL PROTECTED] wrote: How is it used? Can I modify it (e.g., add columns, change the primary key, etc.) to better suit my environment? Sure, if you modify the SQL queries and server source, too. Alan DeKok. - List info/subscribe/unsubscribe? See

RE: NAS table

2006-01-24 Thread Gunther
a reload or so, or even an auto reload after the radius server did an insert or update. Gunther From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Santiago Balaguer GarcíaSent: Monday, January 23, 2006 4:47 AMTo: freeradius-users@lists.freeradius.orgSubject: NAS table Hi

NAS table

2006-01-23 Thread Santiago Balaguer García
Hi people, I am using freeradius as authentication service for two years. I use freeradius 1.0.4 in a Debian servers. My quiestion is I use clients.conf file for mu nas clients, however I read in the freeradius doc that this file can be supported in an database ( it is very useful for me because

RE: NAS table

2006-01-23 Thread alan
@lists.freeradius.org Subject: NAS table Hi people, I am using freeradius as authentication service for two years. I use freeradius 1.0.4 in a Debian servers. My quiestion is I use clients.conf file for mu nas clients, however I read in the freeradius doc that this file can

SQL NAS table

2005-10-25 Thread Alex M
Can some one point me to the documentation on use of SQL NAS table? So that I can add nas devices to the DB and not a text file? Thanks! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: SQL NAS table

2005-10-25 Thread Guy Fraser
On Tue, 2005-25-10 at 12:52 -0400, Alex M wrote: Can some one point me to the documentation on use of SQL NAS table? So that I can add nas devices to the DB and not a text file? ...snip... There has been discussion on this in the past, here is a message I sent as a response to this list

RE: SQL NAS table

2005-10-25 Thread Alex M
you tell me what other fields are normaly stend for? Thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guy Fraser Sent: Tuesday, October 25, 2005 1:06 PM To: freeradius-users@lists.freeradius.org Subject: Re: SQL NAS table On Tue, 2005-25-10

RE: SQL NAS table

2005-10-25 Thread Alex M
I have set the NAS table to to have values: Nasname: my ip addres Secret: testing123 When im trying to test the connection, on the server im getting unknown client... Why? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guy Fraser Sent: Tuesday

NAS TABLE

2005-07-07 Thread Velikanov
Good Day. I used freeradius-1.0.2 and Oracle with table NAS in Oracle. Everything was OK. But in freeradius-snapshot-20050624 I got such error: ... rlm_sql (sql): - generate_sql_clients rlm_sql (sql): Query: SELECT id,nasname,shortname,type,secret FROM nas rlm_sql (sql):

Re: NAS TABLE

2005-07-07 Thread Nicolas Baradakis
Velikanov wrote: I used freeradius-1.0.2 and Oracle with table NAS in Oracle. Everything was OK. But in freeradius-snapshot-20050624 I got such error: ... rlm_sql (sql): - generate_sql_clients rlm_sql (sql): Query: SELECT id,nasname,shortname,type,secret FROM nas

Re: How can I using postgres NAS table

2005-06-16 Thread Andrey V. Elsukov
. wrote: How can I using postgres NAS table? I not found info about this :( rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql: /* * Table structure for table 'nas' * This is not currently used by FreeRADIUS but is usefull for reporting * anyway. */ CREATE TABLE nas ( ... -- WBR

How can I using postgres NAS table

2005-06-08 Thread Алексей В. Лабута
Hi All! How can I using postgres NAS table? I not found info about this :( My ware is: ibm x335 suse 9.3 freeradius 1.0.2 postgres 8.0.3 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

How long is the nas-table cached by freeradius?

2005-06-03 Thread Evert Meulie
Hi all! Just wondering about the following: If a change is made in the nas-table of the radius-db, how long does it take for the freeradius daemon to start using this updated info? Or is the nas-table only read at freeradius (re)start? Regards, Evert begin:vcard fn:Evert Meulie

Re: How long is the nas-table cached by freeradius?

2005-06-03 Thread Alan DeKok
Evert Meulie [EMAIL PROTECTED] wrote: Just wondering about the following: If a change is made in the nas-table of the radius-db, how long does it take for the freeradius daemon to start using this updated info? Or is the nas-table only read at freeradius (re)start? It's only read at re

log_badlogins and nas table

2005-04-01 Thread Stefan Winter
Hello, are there any plans to enable log_badlogins to extract clients information from a nas table instead of from the clients.conf file? It currently doesn't work properly if the clients.conf doesn't contain the information it wants. I have patched it myself so that it uses neither nas table

NAS authentication without checking nasname field on nas table

2005-03-23 Thread Luca Lafranchi
Hi, to resolve the problem of the nas with dynamic ip (adsl), it's possible to authenticate the nas without checking nasname field (NAS-IP-Address) on nas table of radius ? Thank you Luca Lafranchi - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Reload NAS table on freeradius after record update

2005-03-04 Thread Alan DeKok
Chan Min Wai [EMAIL PROTECTED] wrote: If the NAS list is check from time to time. The restart might not be required... Sure. When does the server decide to re-check the NAS list? How does it reload the list without causing problems for the existing list? Alan DeKok. - List

Re: Reload NAS table on freeradius after record update

2005-03-03 Thread Chan Min Wai
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan DeKok wrote: Luca Lafranchi [EMAIL PROTECTED] wrote: Mmmhh... with a HUP signal the radius server reload the config data, but the server may drop a few authentication requests at that time... No, it won't. Alan DeKok. Thinking of

Re: Reload NAS table on freeradius after record update

2005-03-03 Thread Michael Mitchell
Thinking of something.. If the NAS list is check from time to time. The restart might not be required... Am I dreaming somehow? No, you're not dreaming, but currently the NAS list is only read at startup (or HUP)... - List info/subscribe/unsubscribe? See

RE: Reload NAS table on freeradius after record update

2005-03-02 Thread Luca Lafranchi
08:55 To: freeradius-users@lists.freeradius.org Subject: RE: Reload NAS table on freeradius after record update Yes, you have to send the server a HUP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luca Lafranchi Sent: Wednesday, 2 March 2005 6:49

Re: Reload NAS table on freeradius after record update

2005-03-02 Thread Michael Mitchell
Nope, thats it. There is no other way. The server should only be down for a couple of seconds... Luca Lafranchi wrote: Mmmhh... with a HUP signal the radius server reload the config data, but the server may drop a few authentication requests at that time... Other solutions ? - List

Re: Reload NAS table on freeradius after record update

2005-03-02 Thread Alan DeKok
Luca Lafranchi [EMAIL PROTECTED] wrote: Mmmhh... with a HUP signal the radius server reload the config data, but the server may drop a few authentication requests at that time... No, it won't. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reload NAS table on freeradius after record update

2005-03-01 Thread Luca Lafranchi
Hi, The NAS table is read at freeradius startup. It's possible to reload this table when I change a record (update for example the nasname field with a new ip client) ? Thank you Luca - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: Reload NAS table on freeradius after record update

2005-03-01 Thread Mitchell, Michael J
Yes, you have to send the server a HUP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Luca Lafranchi Sent: Wednesday, 2 March 2005 6:49 PM To: freeradius-users@lists.freeradius.org Subject: Reload NAS table on freeradius after record update Hi

NAS table replaces clients.conf?

2005-02-23 Thread Patricio Marin
uses the data from the NAS table? Thanks Patrick - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

  1   2   >