Re: Diferent Session-Timeout depending on NAS

2006-07-03 Thread Santiago Balaguer García
Yeah!! Your solution is the easiest one. I did not explain enough well my problem. the session-timeout has to asign depending on the NAS and the remaining time. My goal is sends the value of Session-Timeout attribute once this value had benn multiplied by a factor depending on the NAS. For

RE: FreeRADIUS and Postgres annoyance

2006-08-29 Thread Santiago Balaguer García
Anyway, in some aspect freeradius can improve. I use nas table and it works fine. Obviously, I must reboot my RADIAS servers when I insert a new NAS client and it is a problem. I afirm that 'realm' table is userless. I trid to configure lot of times without success. From: Gregory J. Marsh

Multiple registers in my DB with the same information

2006-08-29 Thread Santiago Balaguer García
Hi people, I use freeradius 1.1.0 in a debian servers for several years. Now I use my radius server more than before. So in my DB it appears some strange duplicate registers which have the same inforrmation. I show a snapshoot with an account where the problem happens:

Duplicate requests in a session

2006-08-30 Thread Santiago Balaguer García
Hi people, 1) In my activity I realize that when the conexion to Internet of a NAS is NOT good (there are some reday in the DSL), the NAS send several Start requests. My problen is my RADIUS server ask for all these requests and they are inserted in my DB. So, when the user or the NAS

Re: Duplicate requests in a session

2006-08-31 Thread Santiago Balaguer García
: James Wakefield [EMAIL PROTECTED] Reply-To: FreeRadius users mailing list freeradius-users@lists.freeradius.org To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Subject: Re: Duplicate requests in a session Date: Wed, 30 Aug 2006 22:07:09 +1000 Santiago Balaguer García wrote

why radacctid is the primary key of radacct table instead of acctuniqueid ?

2006-08-31 Thread Santiago Balaguer García
After solving the problem of duplicate registers in radacct, see https://list.xs4all.nl/pipermail/freeradius-users/2006-August/056246.html I have this doubt: why radacctid is the primary key of radacct table instead of acctuniqueid ? This is a way to avoid this problem and the DBMS

Re: Duplicate requests in a session

2006-08-31 Thread Santiago Balaguer García
They primary key should be a synthetic field, and not something derived directly from the packet. Calling it 'acctuniqueid' is awkward, maybe renaming it to 'radiuskey'? It can then be used in the SQL queries as %{Acct-Unique-ID:-%{Acct-Session-id}}, which should be safe for all

acctsessionid is void

2006-08-31 Thread Santiago Balaguer García
Following with my questions, I propose the next question: Is it acceptable that a NAS always sends as a acctsession attribute a null or void value ? Santiago _ Moda para esta temporada. Ponte al día de todas las tendencias.

Re: Duplicate requests in a session

2006-09-01 Thread Santiago Balaguer García
If you aplly this change and add this rule, you do the same that freeradius does to build acctuniqueid attribute and put this attribute as primery key. Good question. Does anyone have anything against changing this? -Peter On Thu 31 Aug 2006 10:11, Santiago Balaguer García wrote:

RE: RADIUS proxy-----trace user site surfed------

2006-09-14 Thread Santiago Balaguer García
You can use the radacct table to log your users. Obviously, you have to enable the use of a DB for working with freeradius. From: ego seek [EMAIL PROTECTED] Reply-To: FreeRadius users mailing list freeradius-users@lists.freeradius.org To: Freeradius MailingList

RE: Decreasing connection time (Session-Timeout)

2006-10-24 Thread Santiago Balaguer García
The best way to update your DB with the new session-timeout value is to CREATE A TRIGGER in your database when a STOP request is sent by your NAS. In this STOP request you have all information you need. I supposed your hotspot has activated accounting option. The option of executing an

realm table

2006-11-15 Thread Santiago Balaguer García
Hi people, I am using freeradius 1.0.4 in my debian machine. I get almost all data from a postgres database. However, all my realms are in the proxy.conf file. I realized a realm table exists in my DB schema, however there is no SQL query which call to this table in the postgresql.conf file. Is

client log

2006-12-05 Thread Santiago Balaguer García
Hi people, I have installed freeradius 1.0.4 in my AAA servers. I work several years with this service and funcion very well. I am develeping a PHP platform for my people who install hotspots. Well, I want to log if a nas can not authenticate with my RADIUS server because of any reason. I

RE: Which Variable name for sql result

2006-12-13 Thread Santiago Balaguer García
The query which appears in sql.conf returns a set of registers. This query behieves as radreply attributes, it means this querys corresponds to the attributes of a username. Find in a manual about the attributes of a username. From: [EMAIL PROTECTED] To:

Multiple entries for a realm

2006-12-13 Thread Santiago Balaguer García
Hi people, I do roaming with other companies successfully. My roaming partner has two RADIUS servers, so in the proxy.conf I have two entries for the realm weroam/. However, only the first entry works because if I change the IP for a incorrect one (case of fallback), freeradius does not

RE: Multiple entries for a realm

2006-12-14 Thread Santiago Balaguer García
I try both but without success. I know if freeradius choose one server or another because for each radius we stablish a VPN, so I can see in my Cisco VPN concentrator which radius server my freeradius choosed. For each realm entry my roaming partner and we get up a VPN. Date: Wed, 13 Dec

attrs behind a realm

2006-12-20 Thread Santiago Balaguer García
Hi people, I am using freeradius 1.0.4 for sereral years and I do proxy radius successfully with my roaming patners. However, now I have a roaming patner with the BABEL realm. So, when a BABEL user authenticates in my RADIUS I do proxy radius and BABEL radius server gives me the user

RE: interesting (somewhat old) article

2007-01-04 Thread Santiago Balaguer García
At once glace, iIt is a good link and talking about the beginnings of popularity of wireless technology. I must go on reading it. From:"Long" [EMAIL PROTECTED]Reply-To:[EMAIL PROTECTED], FreeRadius users mailing

RE: postgresql or mysql

2007-01-04 Thread Santiago Balaguer García
Yes, freeradius works the same. Although, the line readclient=yes does not appear in postgresql.conf file, you can add in order to read NAS clients from the posrgres DB. But, MySQL is simpler to use and understand. Anyway, I advance the selecction of a DB for freeradius do not depend on the

RE: FreeRADIUS 1.1.4 has been released

2007-01-05 Thread Santiago Balaguer García
But, this version does not still support that the existed realms in 'proxy.conf' file was in a DB. It is useful for me, because I have a lot of roaming partners. From:Alan DeKok [EMAIL PROTECTED]Reply-To:FreeRadius users mailing list freeradius-users@lists.freeradius.orgTo:FreeRadius users

Re: Proxying based on SSID

2007-01-24 Thread Santiago Balaguer García
I think both are wrong because you must distinguish amog the different SSIDs that an AP broadcast. It sometimes happens the wireless MAC are the same for all SSIDs. Only some devices (such as Mikrotik) let change the MAC for each ESSID. Another thing is you have to differenciate the ESSID in

specific username, specific conexion

2007-02-08 Thread Santiago Balaguer García
Hi, I am using freeradius for ages, but a boss ask me if it is possible to create an account which is only navigate for a specific website. Yes, it is true. I need an account to navigate for only one site (or set of websites). How can I configure this account? Thanks.Acepta el reto MSN Premium:

Attributes of a realm

2007-03-14 Thread Santiago Balaguer García
After I read the attached post, I have a doubt: if I use a MySQL DB to manage freeradius service, how can Ifix specific atributes to all users of a determined realm? From:"Jóhann B. Guðmundsson" [EMAIL PROTECTED]Reply-To:FreeRadius users mailing list

<    1   2