Re: RADIUS stops responding after a while

2006-04-06 Thread Stefan Winter
Hi,

> I've got strange behavior on y FR, need to find the way to prevent it, and
> find out what caused it.

That is something several people are experiencing and it is being looked into. 
Any help in debugging would be appreciated, I guess, since the problem is 
indeed hard to spot.
Check the mailing list archives of topic: "Version 1.1.1 stops responding".

> I've just went to my radius server and found out that it doesn't want to
> handle requests.. I restarted it in debug and it told me that SQL module is
> unknown. (was working fine for 1 month) I restarted again in debug and now
> it went OK and works fine, but this thing is not acceptable in the field .

Interesting.

> So does any one knows what could cause such a behavior (not accepting
> requests, due to module malfunction) and more importantly is there any way
> to monitor the server functionality? Let's say something like send testing
> request each 30min or something and if server doesn't reply send email
> notification?

You could use Nagios and its RADIUS module. That's what we do and it works 
like a charm. You can even say sth like: if the probe failed twice, do a 
stop/start of service and see if it helps; if not, send a notification.

Greetings,

Stefan Winter

-- 
Stefan WINTER

RESTENA Foundation - Réseau Téléinformatique de l'Education Nationale et de 
la Recherche
R&D Engineer

6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg
email: [EMAIL PROTECTED]     Tel.:     +352 424409-1
http://www.restena.lu               Fax:      +352 422473

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


Re: Redundant ldap's bug?

2006-04-06 Thread Alan DeKok
Paulo Cabrita <[EMAIL PROTECTED]> wrote:
> I saw the code a little closer and I think it's not worthy to try to 
> have one CA and two certificate for each server. The LDAP client only 
> support the data for one connection...
> 
> static char *tls_opt_certfile = NULL;

  Yes, that's exactly what I said.

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


Re: RADIUS stops responding after a while

2006-04-06 Thread Alan DeKok
"Alex M" <[EMAIL PROTECTED]> wrote:
> I've just went to my radius server and found out that it doesn't want to
> handle requests.. I restarted it in debug and it told me that SQL module is
> unknown.

  Who edited the config file since the last time the server started?

> So does any one knows what could cause such a behavior (not accepting
> requests, due to module malfunction) and more importantly is there any way
> to monitor the server functionality? Let's say something like send testing
> request each 30min or something and if server doesn't reply send email
> notification?

  It should be trivial to write a shell script to do that.

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


Re: mysql replication vs. radrelay

2006-04-06 Thread Alan DeKok
Olaf =?ISO-8859-1?Q?Sch=E4fer?= <[EMAIL PROTECTED]> wrote:
> I have a redundant radius server setup with two radius servers. On each
> of the servers freeradius 1.1.1 and mysql is running. If the primary
> server goes down the AC falls back to the secondary server. To keep the
> databases (except the radacct table) synchronised I use MySQL
> replication. But I'm not sure which is the best way to replicate the
> accounting information: using radrelay or mysql-replication, too?

  I would suggest radrelay.  The reason is that (in DB terms) it uses
a journal of what has to be replicated: RADIUS packets.

> Besides the man page for radrelay says "The  functions  of  radrelay
> have been added to radiusd". I couldn't find any documentation about
> this feature. Any hints? 

  It shouldn't say that in the 1.1.1 release.  radrelay should still
be there.

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


Re: pre-proxy programme

2006-04-06 Thread Alan DeKok
"Mark Supersonik" <[EMAIL PROTECTED]> wrote:
> Please, look at the fact that we speak about DOMAINS quota, but not users 
> quota.

  That doesn't really matter.

  You made it clear you're trying to cancel the proxy decision AFTER
you made it.  That's what's causing the problem.  My comments were
trying to get you to NOT make the proxy decision in the first place.

> The roaming users are authenticated by the authserv oh his domain (WISP). 
> So, apart from the users quota (which doesn't affect us because the remote 
> authserv does this work for us), there is a WISP quota, WISPs prepay to 
> proxy a volume of resources, and we, the setlement part (proxy), must 
> detemrine if before all want to permite this authorization

  That changes nothing of what I said.  My solution still applies.

  My solution was based on general design principles, not on knowing
the detail of who has what quota.  As a result, my solution works in
many situations, whereas other solutions may not.

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


Re: mysql replication vs. radrelay

2006-04-06 Thread Peter Nixon
On Fri 07 Apr 2006 00:01, Olaf Schäfer wrote:
> hello,
>
> I have a redundant radius server setup with two radius servers. On each
> of the servers freeradius 1.1.1 and mysql is running. If the primary
> server goes down the AC falls back to the secondary server. To keep the
> databases (except the radacct table) synchronised I use MySQL
> replication. But I'm not sure which is the best way to replicate the
> accounting information: using radrelay or mysql-replication, too?

My last experience with MySQL master-master replication and FreeRADIUS was 
that mysql corrupted my radacct table within 24 hours. This was 4-5 years 
ago, however you have to understand the constraints of databases and the fact 
that sql replication is a "hard" problem.

radrelay on the other hand is easy and works perfectly!

> Besides the man page for radrelay says "The  functions  of  radrelay
> have been added to radiusd". I couldn't find any documentation about
> this feature. Any hints?
>
> regards,
> olaf

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpte1Fc2jOaB.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RADIUS stops responding after a while

2006-04-06 Thread Alex M








I’ve got strange behavior on y FR, need to find the way to
prevent it, and find out what caused it.

I’ve just went to my radius server and found out that it doesn’t
want to handle requests…. I restarted it in debug and it told me that SQL
module is unknown… (was working fine for 1 month) I restarted again in
debug and now it went OK and works fine, but this thing is not acceptable in
the field … So does any one knows what could cause such a behavior (not
accepting requests, due to module malfunction) and more importantly is there
any way to monitor the server functionality? Let’s say something like
send testing request each 30min or something and if server doesn’t reply
send email notification?

 

 

Thanks!

 






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

Re: User in Multiple Groups

2006-04-06 Thread Scott Reed
Someone posted that many readers of this list don't have HTML mail readers, so
I cleaned up the spacing on the tables and am reposting this in text so all
can read it.

Scott Reed 
 Owner 
 NewWays 
 Wireless Networking 
 Network Design, Installation and Administration 
 www.nwwnet.net

-- Original Message --- 
 From: "Scott Reed" <[EMAIL PROTECTED]> 
 To: FreeRadius users mailing list  
 Sent: Thu, 6 Apr 2006 07:54:08 -0500 
 Subject: Re: User in Multiple Groups

> I did not usurp a thread, I reposted my own. 
> 
> I changed radcheck to have := instead of ==. No change. 
> 
> First query returns: 
> ++--+--+-++ 
> | id | GroupName| Attribute| Value   | op | 
> ++--+--+-++ 
> | 28 | MS1-AP1  | Service-Type | Framed-User | == | 
> | 31 | Router-Admin | Service-Type | Login-User  | == | 
> ++--+--+-++ 
> Second query returns 
> ++--+---+---++ 
> | id | GroupName| Attribute | Value | op | 
> ++--+---+---++ 
> | 34 | Router-Admin | Mikrotik-Group| full  | =  | 
> | 39 | Router-Admin | Fall-Through  | Yes   | =  | 
> | 37 | MS1-AP1  | Fall-Through  | Yes   | =  | 
> | 33 | MS1-AP1  | Port-Limit| 128k  | =  | 
> ++--+---+---++ 
> 
> I have a document from the FreeRadius WIKI (rlm_sql) that says, "Processing
continues to the next group IF: 
> There was not a match for the last group's check items OR 
> Fall-Through was set in the last group's reply items. 
> If the user logs into a router, the request is for Login-User and they
should get the Router-Admin replies. If they log in to an AP, the request is
Framed-User and they should get the AP replies. 
> 
> Scott Reed 
> Owner 
> NewWays 
> Wireless Networking 
> Network Design, Installation and Administration 
> www.nwwnet.net 
> 
> -- Original Message --- 
> From: Phil Mayers <[EMAIL PROTECTED]> 
> To: FreeRadius users mailing list  
> Sent: Thu, 06 Apr 2006 13:22:39 +0100 
> Subject: Re: User in Multiple Groups 
> 
> > Scott Reed wrote: 
> > > I have searched the archive and came close to figuring this out, but I
have not 
> > 
> > Don't start your query as part of another thread please. 
> > 
> > > 
> > > Configuration tables: 
> > > 1 USERGROUP 
> > > 2 80 sreed MS1-AP1 
> > > 3 76 treed MS1-AP1 
> > > 4 78 sreed Router-Admin 
> > > 5 79 treed Router-Admin 
> > > 6 81 dreed Router-Admin 
> > > 7 
> > > 8 RADCHECK 
> > > 9 331 dreed User-Password == password 
> > > 10 269 treed User-Password == password 
> > > 11 267 sreed User-Password == password 
> > 
> > This should be ":=" for User-Password. If the match is failing, that may 
> > be the issue. 
> > 
> > > 12 
> > > 13 RADGROUPCHECK 
> > > 14 31 Router-Admin Service-Type == Login-User 
> > > 15 28 MS1-AP1 Service-Type == Framed-User 
> > > 16 
> > > 17 RADREPLY 
> > > 18 33 sreed Fall-Through = yes 
> > > 19 43 treed Fall-Through = yes 
> > > 20 
> > > 21 RADGROUPREPLY 
> > > 22 33 MS1-AP1 Port-Limit = 128k 15 
> > > 23 34 Router-Admin Mikrotik-Group = full 10 
> > > 24 39 Router-Admin Fall-Through = Yes 10 
> > > 25 37 MS1-AP1 Fall-Through = Yes 15 
> > 
> > I don't think Fall-Through does anything in rlm_sql. What are you 
> > expecting it to do? 
> > 
> > > rad_recv: Access-Request packet from host 192.168.100.13:1201, id=166,
length=83 
> > > Service-Type = Login-User 
> > > User-Name = "treed" 
> > > User-Password = "password" 
> > > Calling-Station-Id = "192.168.100.240" 
> > > NAS-Identifier = "HotSpot" 
> > > NAS-IP-Address = 192.168.100.13 
> > > Processing the authorize section of radiusd.conf 
> > > modcall: entering group authorize for request 1 
> > > modcall[authorize]: module "preprocess" returns ok for request 1 
> > > modcall[authorize]: module "chap" returns noop for request 1 
> > > modcall[authorize]: module "mschap" returns noop for request 1 
> > > rlm_realm: No '@' in User-Name = "treed", looking up realm NULL 
> > > rlm_realm: No such realm "NULL" 
> > > modcall[authorize]: module "suffix" returns noop for request 1 
> > > radius_xlat: 'treed' 
> > > rlm_sql (sql): sql_set_user escaped user --> 'treed' 
> > > rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM
radcheck WHERE 
> > > Username = 'treed' ORDER BY id 
> > > rlm_sql_mysql: query: SELECT 
> > >
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op

> > > FROM radgroupcheck,usergroup WHERE usergroup.Username = 'treed' AND 
> > > usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id 
> > 
> > What is the result of this query if you execute it directly against the 
> > database? 
> > 
> > > rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM
radreply WHERE 
> > > Username = 'treed' ORDER BY id 
> > 
> 

Re: How to make FR reset the logs

2006-04-06 Thread Mordor Networks
Hello Thank you all for your replies , i fixed my issue using some scripts that comes with dialup_admin, /bin/ dir , it is working for know , thank you Guy Fraser.My question know , is it possible to send any attribute using  dialup_admin to disconnect a user, i have a some handmade bash scripts to do that but it would be great if it can be done with dialup_adim -> radius -> pppd/pppoe-servers
Thanks again
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: mysql replication vs. radrelay

2006-04-06 Thread Guy Fraser
On Thu, 2006-06-04 at 23:01 +0200, Olaf Schäfer wrote:
> hello,
> 
> I have a redundant radius server setup with two radius servers. On each
> of the servers freeradius 1.1.1 and mysql is running. If the primary
> server goes down the AC falls back to the secondary server. To keep the
> databases (except the radacct table) synchronised I use MySQL
> replication. But I'm not sure which is the best way to replicate the
> accounting information: using radrelay or mysql-replication, too?
> 
> Besides the man page for radrelay says "The  functions  of  radrelay
> have been added to radiusd". I couldn't find any documentation about
> this feature. Any hints? 
> 
> regards,
> olaf
There are many schools of thought on that.

Some prefer SQL replication, others suggest it is better to build it
into the management system. If you have lots of people managing 
the accounts and you may need a different method, than someone 
with only a few people maintaining accounts, since table locking 
and connection load balancing could become an issue. In some cases 
batch processing is acceptable, in other cases it can be detrimental.

Can you give us an idea, about how many people will be changing 
user info and at what rate you would be expecting additions, 
modifications and removals?

It would be helpful for those of us designing management systems, 
so we can test for possible conflicts and performance issues. I 
am not yet working on the SQL maintenance portion of my project 
but it would be helpful for me to have that information in order 
to do some preliminary planning. Some replication methods scale 
better than others, but have their own drawbacks and difficulties.

PS Have you had a chance to try my PHP radiusd.conf configuration 
parser ?


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


Re: How to make FR reset the logs

2006-04-06 Thread Guy Fraser
On Thu, 2006-06-04 at 14:12 -0400, Dennis Skinner wrote:
> Guy Fraser wrote:
> > vacuum;
> 
> This is not a MySQL command.
> 
> You probably want to look at CHECK TABLE, REPAIR TABLE, and OPTIMIZE
> TABLE.  But we are getting off topic here
> 
> I will note that FreeRADIUS performance had significant improvements
> once the tables were changed to InnoDB from MyISAM, especially the
> radacct table as that fills up quick if you don't archive regularly.

I said :

"
I don't use MySQL very often so do not know for sure if this would 
work, but here goes a simple example :

select * into radacct_old from radacct where AcctStopTime < '2006-04-01
00:00:00' ;

delete from radacct where AcctStopTime < '2006-04-01 00:00:00' ;

vacuum;

If you intend on using MySQL you will need to learn how to use
it. There are many functions and some may help you do what 
you want.
"

I prefer PostgreSQL, which is SQL92 compliant and does support 
the SQL VACUUM command. MySQL database maintenance is of little 
interest to me, because I do not think it is good for anything 
but text and blob storage, and I don't need that very often.
Since nobody else had attempted to answer the posters question 
I suggested a possible method he could try, and suggested he 
learn how to maintain MySQL if he intends on using it. I REALLY
do NOT want to get into a flame war over the differences between 
MySQL and PostgreSQL. I based my sample on SQL standard commands 
hoping that MySQL would support them, but having suggested that 
they may not work without specifying why, may have left it open 
for interpretation. I am sure that for those who know MySQL well 
it works very well for them, but I don't care to spend the time 
learning how to do things the MySQL way.

I have provided some assistance ensuring that the MySQL and 
PostgreSQL drivers had the same functionality, and have a 
MySQL db on the R&D machine for that purpose, but do not 
have any intention on using it for production. The 
PostgreSQL db I use for my custom Cistron server has operated 
flawlessly and at high efficiency since it was installed 
over 5 years ago. Since the Software and Hardware are long in 
the tooth, I will be upgrading them in the near future. I have 
been helping with the development of FreeRadius for a couple 
years, in preparation for this long anticipated upgrade. Once 
I have a good Management interface I will upgrade. I have 
spent a few days building some functions and others have been 
spending considerable time on similar projects, and some of 
us have agreed to share, our work in order to move this along, 
so I am hoping to have a new server in place by years end.

Good luck, and have a great day.


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


Re: Problem with Cisco-AVPair

2006-04-06 Thread Kevin Bonner
On Thursday 06 April 2006 08:24, Antonio Matera wrote:
> 

Please stop using HTML when posting your messages.  You just might get a few 
more useful responses from people who don't bother to read html-only 
messages.

Kevin Bonner


pgpIqhmYWA5QQ.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

mysql replication vs. radrelay

2006-04-06 Thread Olaf Schäfer
hello,

I have a redundant radius server setup with two radius servers. On each
of the servers freeradius 1.1.1 and mysql is running. If the primary
server goes down the AC falls back to the secondary server. To keep the
databases (except the radacct table) synchronised I use MySQL
replication. But I'm not sure which is the best way to replicate the
accounting information: using radrelay or mysql-replication, too?

Besides the man page for radrelay says "The  functions  of  radrelay
have been added to radiusd". I couldn't find any documentation about
this feature. Any hints? 

regards,
olaf

-- 
Olaf Schäfer <[EMAIL PROTECTED]>



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


Re: pre-proxy programme

2006-04-06 Thread Mark Supersonik
Please, look at the fact that we speak about DOMAINS quota, but not users 
quota.
The roaming users are authenticated by the authserv oh his domain (WISP). 
So, apart from the users quota (which doesn't affect us because the remote 
authserv does this work for us), there is a WISP quota, WISPs prepay to 
proxy a volume of resources, and we, the setlement part (proxy), must 
detemrine if before all want to permite this authorization


[access 
WISP]--[PROXY]--[Home 
WISP]

  |
(user from Home WISP)



From: "Alan DeKok" <[EMAIL PROTECTED]>
Reply-To: FreeRadius users mailing list 


To: FreeRadius users mailing list 
Subject: Re: pre-proxy programme Date: Thu, 06 Apr 2006 12:02:36 -0400

"Mark Supersonik" <[EMAIL PROTECTED]> wrote:
> How can we programme the pre-proxy stage of a freeRADIUS proxy PC in 
order

> to reject the request if the domain of the user doesn't have quota (in a
> proxy's MySQL database table) ?

  Why are you doing this in the preproxy stage?  Why not make the
server avoid proxying completely if the user is over quota?

  Look at he place in your configuration where it tells the server to
proxy the request, and then add "AND the quota is OK".

  Alan DeKok.

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


_
¿Estás pensando en cambiar de coche? Todas los modelos de serie y extras en 
MSN Motor. http://motor.msn.es/researchcentre/


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


Re: mysql-devel??

2006-04-06 Thread Pelusa Vali
>In Debian etch the MySQL client headers are in package libmysqlclient15-dev.
>
>However as Peter said you should just install a binary version from
>Debian with apt-get.
># apt-get install freeradius-mysql freeradius-dialupadmin
>
>If you really want to recompile FreeRADIUS yourself, search in the FAQ
>how to build a Debian package from sources.
>
>> and, by the way, how may i uninstall freeradius??
>
>Like any other Debian package:
># apt-get remove freeradius
>
>-- 
>Nicolas Baradakis

thanks so much Nicolas, but now i have a problem i installed freeradius from 
sources compiling it and now i need use mysql, i tested it in another pc 
installing first mysql and then compiling freeradius and works great.  but now, 
are there any way to uninstall freeradius (compiled from sources) to rebuild it 
to use mysql??
thanks for your help


___ 
Halloween Humour: What did the dragon say when he saw the knight in his shining 
armour?

postmaster.co.uk
http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=155
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: rlm_ldap: object not found

2006-04-06 Thread Marc Delisle

Thanks Sayantan it works!

Marc Delisle

Sayantan Bhowmick a écrit :

HI,
Change the filter configuration in ldap section of radiusd.conf to
the following:
filter = "(cn=%{Stripped-User-Name:-%{User-Name}})"

-Sayantan




On Wed, Apr 5, 2006 at  1:53 am, in message

<[EMAIL PROTECTED]>, Marc Delisle
<[EMAIL PROTECTED]> wrote: 

Hi,
thanks to those who answered me for my previous post. It turned out
to 

be a certificate problem.

Now, freeradius binds to LDAP on Netware, but does not find any

object:

rlm_ldap: waiting for bind result ...
rlm_ldap: Bind was successful
rlm_ldap: performing search in o=college, with filter (uid=delislma)
rlm_ldap: object not found or got ambiguous search result
rlm_ldap: search failed

Thanks,

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






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


Re: mysql-devel??

2006-04-06 Thread Pelusa Vali
>If you plan to use freeradius+mysql on debian I suggest you just install the 
>packages that come with it. It's not really necessary to compile it 
>yourself..
Thanks Peter, now my question is, i wan to use it to add security to a wlan and 
use hostapd and driver madwifi, so, it is not necessary to compile 
freeradius??, i use openssl to create certificates (use eap-peap).  
Second, do you know any way to uninstall freeradius in debian??
thanks again.




___ 
What major city is located on the mouth of the Pasig river and the head of a 
bay with the same name as the city?

postmaster.co.uk
http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=169

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


Re: How to make FR reset the logs

2006-04-06 Thread Dennis Skinner
Guy Fraser wrote:
> vacuum;

This is not a MySQL command.

You probably want to look at CHECK TABLE, REPAIR TABLE, and OPTIMIZE
TABLE.  But we are getting off topic here

I will note that FreeRADIUS performance had significant improvements
once the tables were changed to InnoDB from MyISAM, especially the
radacct table as that fills up quick if you don't archive regularly.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: How to make FR reset the logs

2006-04-06 Thread Guy Fraser
On Wed, 2006-05-04 at 22:06 +0300, Mordor Networks wrote:
> Date: Wed, 05 Apr 2006 11:09:58 -0600
> From: Guy Fraser <[EMAIL PROTECTED]>
> Subject: Re: How to make FR reset the logs
> To: freeradius-users@lists.freeradius.org
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain
> 
> On Wed, 2006-05-04 at 06:15 +0300, Mordor Networks wrote:
> > hi
> > Is it possible to make FR remove all monthly accounting logs from
> the 
> > database "mysql"?
> 
> Yikes, why would you want to do that?
> 
> Thanks for your reply . i have pppoe-server with FR and mysql and
> dialup_admin , and 600 user , so i have a lot of traffic and logs
> daily/monthly 

I don't use MySQL very often so do not know for sure if this would 
work, but here goes a simple example :

select * into radacct_old from radacct where AcctStopTime < '2006-04-01
00:00:00' ;

delete from radacct where AcctStopTime < '2006-04-01 00:00:00' ;

vacuum;

If you intend on using MySQL you will need to learn how to use
it. There are many functions and some may help you do what 
you want.

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


Re: pre-proxy programme

2006-04-06 Thread Alan DeKok
"Mark Supersonik" <[EMAIL PROTECTED]> wrote:
> How can we programme the pre-proxy stage of a freeRADIUS proxy PC in order 
> to reject the request if the domain of the user doesn't have quota (in a 
> proxy's MySQL database table) ?

  Why are you doing this in the preproxy stage?  Why not make the
server avoid proxying completely if the user is over quota?

  Look at he place in your configuration where it tells the server to
proxy the request, and then add "AND the quota is OK".

  Alan DeKok.

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


Re: Termination when there is no traffic

2006-04-06 Thread Alan DeKok
Johnny <[EMAIL PROTECTED]> wrote:
> I've got a little proiblem with my radius server. I use it for
> dial-in accounts via ISDN. I've the problem that connections are
> terminated automatically when no traffic is on the line. The
> authentification works without problems, but I do not know which
> parameter I have to change so that connections wont be terminated
> automatically anymore. Could anyone help me with this? Thank you!

  http://www.freeradius.org/rfc/attributes.html

  See Idle-Timeout

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


Re: mysql-devel??

2006-04-06 Thread Nicolas Baradakis
Pelusa Vali wrote:

> i use debian etch and cann't find such package, may be it's not
> necessary for debian or new mysql versions don't use it any more??

In Debian etch the MySQL client headers are in package libmysqlclient15-dev.

However as Peter said you should just install a binary version from
Debian with apt-get.
# apt-get install freeradius-mysql freeradius-dialupadmin

If you really want to recompile FreeRADIUS yourself, search in the FAQ
how to build a Debian package from sources.

> and, by the way, how may i uninstall freeradius??

Like any other Debian package:
# apt-get remove freeradius

-- 
Nicolas Baradakis

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


Re: Freeradius cannot find rlm_sql_postgresql driver!

2006-04-06 Thread Nicolas Baradakis
Peter Nixon wrote:

> > The licenses of PostgreSQL and FreeRADIUS are incompatible, therefore
> > Debian doesn't distribute a binary version of the PostgreSQL module.
>
> Since when is the BSD license incompatible with the GPL??

The old / original BSD license is not compatible.
http://www.gnu.org/licenses/license-list.html#GPLIncompatibleLicenses

-- 
Nicolas Baradakis

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


Re: Can Juniper router or firewall configured on Free radius

2006-04-06 Thread Zoltan Ori
On Thursday 06 April 2006 09:37, Venu Gopal wrote:
> Thanks a lot for the reply,
> i got this link for configuring radius, but wonder is
> there any modification to be done apart from cisco
> devices.

I'm not sure what you mean. You have Cisco authenticating and want to have the 
same for Juniper? You probably need to define exactly what you are trying to 
accomplish and what you are working with.

On the assumption that you have Cisco working and want Juniper, too: 
Decide what reply attributes you need and how you will differentiate the 
sources of the access request.  Read about huntgroups. Or, you might include 
both Juniper and Cisco replies in the same users entry since the devices 
should ignore attributes they don't understand. I won't guarantee that will 
work as I've not done it myself.

Zoltan Ori

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


Re: Compiling freeradius 1.1.1 in FreeBSD 6.0 with mysql support

2006-04-06 Thread Guy Fraser
On Wed, 2006-05-04 at 13:08 -0400, Alan DeKok wrote:
> "Mark Hennessy" <[EMAIL PROTECTED]> wrote:
> > I'm trying to build freeradius 1.1.1 on a FreeBSD 6.0 system with MySQL
> > 4.1.15
> 
>   Doesn't the ports system work?

That exactly what I was thinking.

The port was updated on Mar. 28

> 
> > checking for mysql_init in -lmysqlclient_r (using mysql_config)... no
> 
>   See the config.log for details.  Maybe libmysqlclient_r needs
> additional libraries for it to work.
> 


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


Re: Freeradius cannot find rlm_sql_postgresql driver!

2006-04-06 Thread lmyho


--- Nicolas Baradakis <[EMAIL PROTECTED]> wrote:

> lmyho wrote:
> 
> > I am trying to test the freeradius to work with postgresql database.
> > Just installed freeradius 1.1.0 on debian system via 'aptitude
> > install' command of debian.
> >
> > [...]
> >
> >  Error: rlm_sql (sql): Could not link driver rlm_sql_postgresql:
> > rlm_sql_postgresql.so: cannot open shared object file: No such file or 
> > directory
> 
> The licenses of PostgreSQL and FreeRADIUS are incompatible, therefore
> Debian doesn't distribute a binary version of the PostgreSQL module.
> 
> You could build a Debian package from source with the tarball of
> FreeRADIUS 1.1.1 from www.freeradius.org. The FAQ explains how
> to do this:
> 
> http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ

Hi Nicolas, 
Thanks very much for telling me this!  I built the pkgs from tarball-1.1.1...  
But I
got tons of warnings in the building process, tons of them!  Just list a few 
below. 
Just want to know: with so many warnings, do the pkgs I built still usable?  
Thanks
a lot for advising!!   Please see the list (only picked a few) below:

radius.c: In function 'make_secret':
radius.c:167: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness
radius.c: In function 'make_passwd':
radius.c:205: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness
radius.c: In function 'make_tunnel_passwd':
radius.c:294: warning: pointer targets in passing argument 2 of 
'librad_MD5Update'
differ in signedness

rlm_passwd.c: In function 'build_hash_table':
rlm_passwd.c:218: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c:232: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c: In function 'get_pw_nam':
rlm_passwd.c:299: warning: pointer targets in passing argument 1 of 'hash' 
differ in
signedness
rlm_passwd.c: In function 'passwd_authorize':
rlm_passwd.c:536: warning: pointer targets in assignment differ in signedness
rlm_preprocess.c: In function 'cisco_vsa_hack':
rlm_preprocess.c:126: warning: pointer targets in passing argument 1 of
'__builtin_strchr' differ in signedness
rlm_preprocess.c:144: warning: pointer targets in assignment differ in 
signedness
rlm_preprocess.c: In function 'rad_mangle':
rlm_preprocess.c:203: warning: pointer targets in passing argument 1 of
'__builtin_strchr' differ in signedness
rlm_preprocess.c:206: warning: pointer targets in passing argument 1 of 'strcpy'
differ in signedness
rlm_preprocess.c: In function 'huntgroup_access':
rlm_preprocess.c:375: warning: pointer targets in passing argument 1 of 
'strNcpy'
differ in signedness
rlm_preprocess.c:376: warning: pointer targets in passing argument 1 of 'strlen'
differ in signedness
rlm_preprocess.c: In function 'add_nas_attr':
rlm_preprocess.c:404: warning: pointer targets in passing argument 1 of
'ip_hostname' differ in signedness
rlm_preprocess.c:425: warning: pointer targets in passing argument 1 of
'ip_hostname' differ in signedness
rlm_radutmp.c: In function 'radutmp_checksimul':
rlm_radutmp.c:658: warning: pointer targets in assignment differ in signedness
rlm_realm.c: In function 'check_for_realm':
rlm_realm.c:209: warning: pointer targets in passing argument 1 of 'strcpy' 
differ
in signedness
rlm_sql.c: In function 'sql_groupcmp':
rlm_sql.c:564: warning: pointer targets in passing argument 1 of 'strlen' 
differ in
signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 1 of 'strlen' 
differ in
signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c:564: warning: pointer targets in passing argument 2 of 
'__builtin_strcmp'
differ in signedness
rlm_sql.c: In function 'rlm_sql_authorize':
rlm_sql.c:824: warning: pointer targets in assignment differ in signedness
rlm_sql.c: In function 'rlm_sql_checksimul':
rlm_sql.c:1227: warning: pointer targets in assignment differ in signedness

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: mysql-devel??

2006-04-06 Thread Peter Nixon
On Thu 06 Apr 2006 06:43, Pelusa Vali wrote:
> hi list, now i'd like to compile freeradius and later use dialup-admin, it
> needs mysql and in book RADIUS Jonathan Hassell says it's necessary have at
> least mysql-devel, but i use debian etch and cann't find such package, may
> be it's not necessary for debian or new mysql versions don't use it any
> more?? and, by the way, how may i uninstall freeradius??
> thanks for your help.

If you plan to use freeradius+mysql on debian I suggest you just install the 
packages that come with it. It's not really necessary to compile it 
yourself..

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpPIycTQtQn4.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius cannot find rlm_sql_postgresql driver!

2006-04-06 Thread Peter Nixon
On Thu 06 Apr 2006 11:58, Nicolas Baradakis wrote:
> lmyho wrote:
> > I am trying to test the freeradius to work with postgresql database.
> > Just installed freeradius 1.1.0 on debian system via 'aptitude
> > install' command of debian.
> >
> > [...]
> >
> >  Error: rlm_sql (sql): Could not link driver rlm_sql_postgresql:
> > rlm_sql_postgresql.so: cannot open shared object file: No such file or
> > directory
>
> The licenses of PostgreSQL and FreeRADIUS are incompatible, therefore
> Debian doesn't distribute a binary version of the PostgreSQL module.

Since when is the BSD license incompatible with the GPL??

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpWWdtdzfP4Y.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Redundant ldap's bug?

2006-04-06 Thread Paulo Cabrita

Hi Alan,

I saw the code a little closer and I think it's not worthy to try to 
have one CA and two certificate for each server. The LDAP client only 
support the data for one connection...


static char *tls_opt_certfile = NULL;
static char *tls_opt_keyfile = NULL;
static char *tls_opt_dhfile = NULL;
static char *tls_opt_cacertfile = NULL;
static char *tls_opt_cacertdir = NULL;

What do you think?



Alan DeKok wrote:


Paulo Cabrita <[EMAIL PROTECTED]> wrote:
...

 See:

http://www.openldap.org/devel/cvsweb.cgi/~checkout~/libraries/libldap/tls.c?rev=1.133&hideattic=1&sortbydate=0

...
static char *tls_opt_cacertfile = NULL;
...

 Yup.  It's a bug in the OpenLDAP client library.  They don't support
multiple users of LDAP connections in the same program.

 I'll file a bug with the OpenLDAP project.

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


 



--

Atentamente,


|Paulo Cabrita, Msc|
|Director do Centro de Informática |
|da Universidade Autónoma de Lisboa|
|Tel: +351-213177635   |
|Fax: +351-213533702   |
|E-mail: [EMAIL PROTECTED]|



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


Re: dialup admin & ippool administraton

2006-04-06 Thread Peter Nixon
We have developed a new sqlippool module which exclusively uses SQL (Tested 
with Postgresql) and doesn't require configuration in radiusd.conf (at least 
no more than the existing sql module)

We are currently load testing this for stability and will be rolling it into 
production tomorrow if all goes well. At that point we will also commit it to 
FR cvs.

I suggest you wait a few days before you do too much more coding :-)

Cheers

Peter

On Wed 29 Mar 2006 12:28, Olaf Schäfer wrote:
> > the sqlippool module in cvs does this..
>
> This module sounds interesting - something I haven't take into my
> considerations keeping the dynamic ippool data in the sql-db, too. And
> it's obvious to do it this way using a primary and a backup server.
>
> But the configuration information like "range-start" etc. is still
> stored in the radiusd.conf. My idea was to put these configuration
> information for each ippool into the mysql-db.
>
> Some background information for better understanding :) My task is to
> migrate from MS-IAS to freeradius. Thus people are used to do
> administration tasks with a GUI. :) At least normal production
> administration tasks should be integrated within a GUI. Putting
> configuration information into a db would save the parsing and editing
> the radius.conf by dialup-admin scripts.
>
> best regards,
> Olaf
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc


pgpZU1V4Zaem7.pgp
Description: PGP signature
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Problem with Cisco-AVPair

2006-04-06 Thread Antonio Matera




Hallo,
I tried with EAP-TLS and PEAP/MS-CHAPv2.

With the last, I have this user:

vlan3  Cisco-AVPair == "ssid=VLAN3",
User-Password == "test"
  Tunnel-Medium-Type = IEEE-802,

  Tunnel-Private-Group-Id = 3,

  Tunnel-Type = VLAN



If I insert the check ==  in the Cisco-AVPair  attribute, I have this
log:

rad_recv: Access-Request packet from host 192.168.9.104:1645, id=21,
length=240
    User-Name = "vlan3"
    Framed-MTU = 1400
    Called-Station-Id = "0012.dacb.8420"
    Calling-Station-Id = "000c.f135.f1ba"
    Cisco-AVPair = "ssid=VLAN3"
    Service-Type = Login-User
    Message-Authenticator = 0x57cbe83313e35c36a3878a5151361c44
    EAP-Message =
0x020900501900170301002029a86e41268c925e584b0924c058e045487523e0b2181541f520fe517e5fa67c1703010020ebe4e512af90e916f41fc666e138157bd279a6ed7f1ab44243f67e72d18ce012
    NAS-Port-Type = Wireless-802.11
    Cisco-NAS-Port = "260"
    NAS-Port = 260
    State = 0xbb09e1038e24af4dc9f4002adb7d6b0a
    NAS-IP-Address = 192.168.9.104
    NAS-Identifier = "ap"
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 8
  modcall[authorize]: module "preprocess" returns ok for request 8
  modcall[authorize]: module "mschap" returns noop for request 8
    rlm_realm: No '@' in User-Name = "vlan3", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 8
  rlm_eap: EAP packet type response id 9 length 80
  rlm_eap: No EAP Start, assuming it's an on-going EAP conversation
  modcall[authorize]: module "eap" returns updated for request 8
    users: Matched entry vlan3 at line 24
  modcall[authorize]: module "files" returns ok for request 8
modcall: leaving group authorize (returns updated) for request 8
  rad_check_password:  Found Auth-Type EAP
auth: type "EAP"
  Processing the authenticate section of radiusd.conf
modcall: entering group authenticate for request 8
  rlm_eap: Request found, released from the list
  rlm_eap: EAP/peap
  rlm_eap: processing type peap
  rlm_eap_peap: Authenticate
  rlm_eap_tls: processing TLS
  eaptls_verify returned 7
  rlm_eap_tls: Done initial handshake
  eaptls_process returned 7
  rlm_eap_peap: EAPTLS_OK
  rlm_eap_peap: Session established.  Decoding tunneled attributes.
  rlm_eap_peap: Received EAP-TLV response.
  rlm_eap_peap: Tunneled data is valid.
  rlm_eap_peap:  Had sent TLV failure.  User was rejcted rejected
earlier in this session.
 rlm_eap: Handler failed in EAP/peap
  rlm_eap: Failed in EAP select
  modcall[authenticate]: module "eap" returns invalid for request 8
modcall: leaving group authenticate (returns invalid) for request 8
auth: Failed to validate the user.
Login incorrect: [vlan3/] (from
client ap-test port 260 cli 000c.f135.f1ba)
Delaying request 8 for 1 seconds
Finished request 8


The radius don't authenticate my user, but the SSID is correct!

I don't understand what is wrong.


Thanks a lot for your support...
Antonio

on 06/04/2006 14.59 Guy Davies said the following:

  I don't think you should be setting the Auth-Type.  Just let
FreeRADIUS work that out.  What are you doing with your Cisco AP?  Are
you doing PEAP/MS-CHAPv2?  If so, then you must have a User-Password
== "foo" in your user database and you *must not* set Auth-Type :=
EAP.

You should do as Sergio says and use == in your Cisco-AVPair check
item.  This is a comparison.

Rgds,

Guy

On 06/04/06, Antonio Matera <[EMAIL PROTECTED]> wrote:
  
  
 Hallo,
 If I set Cisco-AVPair == "ssid=SSID1" in my user authentication, the
authentication Fail with any ssid and user.
 If I set Cisco-AVPair := "ssid=SSID1" my users are always authenticated.

 Is there any other configuration to set in the radius or in the access
point?

 In my access request there is the AVPair attribute:


 rad_recv: Access-Request packet from host 192.168.9.104:1645, id=19,
length=166
   User-Name = "TEST4"
   Framed-MTU = 1400
   Called-Station-Id = "0012.dacb.8420"
   Calling-Station-Id = "000c.f135.f1ba"
   Cisco-AVPair = "ssid=VLAN3"
   Service-Type = Login-User
   Message-Authenticator =
0xb2a3f1fd52d9d6ff9702cc8f1f480f46
   EAP-Message = 0x020600060d00
   NAS-Port-Type = Wireless-802.11
   Cisco-NAS-Port = "260"
   NAS-Port = 260
   State = 0x0491685cf8ece3184d685dedfedbb3d4
   NAS-IP-Address = 192.168.9.104
   NAS-Identifier = "ap"


 but I don't understand if it works...


 Any idea?


 Thanks


 on 06/04/2006 11.39 Sergio Sagliocco said the following:
 Hi
I think you have to try in this way (for example):
TEST4 Cisco-AVPair == "ssid=SSID1" , Auth-Type := EAP
 Tunnel-Medium-Type = IEEE-802,
 Tunnel-Private-Group-Id = 2,
 Tunnel-Type = VLAN
DEFAULT Auth-Type := Reject

if uou want a password:
TEST4 Cisco-AVPair == "ssid=SSID1" ,User-Password="", Auth-Type := EAP
 Tunnel-Medium-Type = IEEE-802,
 Tunnel-Private-Group-Id = 2,
 Tunn

Re: Can Juniper router or firewall configured on Free radius

2006-04-06 Thread Venu Gopal
Thanks a lot for the reply, 
i got this link for configuring radius, but wonder is
there any modification to be done apart from cisco
devices.

Regards
Venu

--- "Zoltan A. Ori" <[EMAIL PROTECTED]> wrote:

> On Thursday 06 April 2006 06:56, Venu Gopal wrote:
> > Hi All,
> >
> > Any one can help me juniper equiqments are
> configured
> > on free radius? If so please help me out the
> server
> > side configuration of users on Redhat. If there
> are
> > any referral web links please do let me know.
> > A quick response in this regard would be highly
> > appreciated.
> 
> Google 'Juniper radius configuration' or read the
> 'help topic system 
> radius-server' from the router cli. Juniper specific
> attributes are listed 
> there.
> 
> On Juniper router:
> 
> [edit system]
> radius-server server-address {
> port number; 
> secret password; 
> retry number; 
> timeout seconds; 
> }
> 
> On freeRADIUS make entries for the router as you
> would for any NAS in 
> clients.conf and user using any of the applicable
> attributes.
> 
> Zoltan Ori
> 
> 
> - 
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Problem with Cisco-AVPair

2006-04-06 Thread Guy Davies
I don't think you should be setting the Auth-Type.  Just let
FreeRADIUS work that out.  What are you doing with your Cisco AP?  Are
you doing PEAP/MS-CHAPv2?  If so, then you must have a User-Password
== "foo" in your user database and you *must not* set Auth-Type :=
EAP.

You should do as Sergio says and use == in your Cisco-AVPair check
item.  This is a comparison.

Rgds,

Guy

On 06/04/06, Antonio Matera <[EMAIL PROTECTED]> wrote:
>  Hallo,
>  If I set Cisco-AVPair == "ssid=SSID1" in my user authentication, the
> authentication Fail with any ssid and user.
>  If I set Cisco-AVPair := "ssid=SSID1" my users are always authenticated.
>
>  Is there any other configuration to set in the radius or in the access
> point?
>
>  In my access request there is the AVPair attribute:
>
>
>  rad_recv: Access-Request packet from host 192.168.9.104:1645, id=19,
> length=166
>User-Name = "TEST4"
>Framed-MTU = 1400
>Called-Station-Id = "0012.dacb.8420"
>Calling-Station-Id = "000c.f135.f1ba"
>Cisco-AVPair = "ssid=VLAN3"
>Service-Type = Login-User
>Message-Authenticator =
> 0xb2a3f1fd52d9d6ff9702cc8f1f480f46
>EAP-Message = 0x020600060d00
>NAS-Port-Type = Wireless-802.11
>Cisco-NAS-Port = "260"
>NAS-Port = 260
>State = 0x0491685cf8ece3184d685dedfedbb3d4
>NAS-IP-Address = 192.168.9.104
>NAS-Identifier = "ap"
>
>
>  but I don't understand if it works...
>
>
>  Any idea?
>
>
>  Thanks
>
>
>  on 06/04/2006 11.39 Sergio Sagliocco said the following:
>  Hi
> I think you have to try in this way (for example):
> TEST4 Cisco-AVPair == "ssid=SSID1" , Auth-Type := EAP
>  Tunnel-Medium-Type = IEEE-802,
>  Tunnel-Private-Group-Id = 2,
>  Tunnel-Type = VLAN
> DEFAULT Auth-Type := Reject
>
> if uou want a password:
> TEST4 Cisco-AVPair == "ssid=SSID1" ,User-Password="", Auth-Type := EAP
>  Tunnel-Medium-Type = IEEE-802,
>  Tunnel-Private-Group-Id = 2,
>  Tunnel-Type = VLAN
> DEFAULT Auth-Type := Reject
>
> Regards
> sergio
>
> Antonio Matera wrote:
>
>
>  My goal is to have authenticate user only if the SSID is right!
> You know how can I do it?
>
> Thanks
> Antonio
>
> on 05/04/2006 17.33 Sergio Sagliocco said the following:
>
>
>  Hello
> your goal is authenticate users only if the SSID is rght or to have
> different EAP Authentication method based on SSID?
>
> regards
> sergio
>
>
> Antonio Matera wrote:
>
>
>
>  Hallo,
> thanks for the answer.
>
> With your solution my radius don't authenticate my users
> Is my configuration correct or I need other change in my radius files?
>
> Thanks bye
>
> on 05/04/2006 15.27 Sergio Sagliocco said the following:
>
>
>
>  Hi
> I think you have to use == instead of :=
> For example:
>
> DEFAULT Cisco-AVPair == "ssid=testLEAP" , EAP-Type := Cisco-LEAP
>
> Regards
>
>
>
>
>  - List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
>
>
>
>
> 
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
>
>
> --
>
> --
> Antonio Matera
> CREATE-NET
> Via Solteri, 38 - 38100 Trento
> e-mail: [EMAIL PROTECTED]
> phone: +39 0461 408400 ext. 305
> fax: +39 0461 421157
> www.create-net.org
> --
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>

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


Re: User in Multiple Groups

2006-04-06 Thread Scott Reed




I did not usurp a thread, I reposted my own.

I changed radcheck to have := instead of ==.  No change.

First query returns:
++--+--+-++
| id | GroupName    | Attribute    | Value   | op |
++--+--+-++
| 28 | MS1-AP1  | Service-Type | Framed-User | == |
| 31 | Router-Admin | Service-Type | Login-User  | == |
++--+--+-++
Second query returns ++--++---++
| id | GroupName    | Attribute  | Value | op |
++--++---++
| 34 | Router-Admin | Mikrotik-Group | full  | =  |
| 39 | Router-Admin | Fall-Through   | Yes   | =  |
| 37 | MS1-AP1  | Fall-Through   | Yes   | =  |
| 33 | MS1-AP1  | Port-Limit | 128k  | =  |
++--++---++

I have a document from the FreeRadius WIKI (rlm_sql) that says, "Processing continues to the next group IF:
    There was not a match for the last group's check items OR
    Fall-Through was set in the last group's reply items.
If the user logs into a router, the request is for Login-User and they should get the Router-Admin replies.  If they log in to an AP, the request is Framed-User and they should get the AP replies.


Scott Reed 


Owner 


NewWays 


Wireless Networking 


Network Design, Installation and Administration 


www.nwwnet.net 




-- Original Message 
---

From: Phil Mayers <[EMAIL PROTECTED]> 


To: FreeRadius users mailing list  


Sent: Thu, 06 Apr 2006 13:22:39 +0100 


Subject: Re: User in Multiple Groups 



> Scott Reed wrote: 
> 

> I have searched the archive and came close to figuring this out, but I have 
not  
> 
> 

Don't start your query as part of another thread please. 
> 
> 

>  
> 

> Configuration tables: 
> 

>       1 USERGROUP 
> 

>       2 80      sreed   MS1-AP1 
> 

>       3 76      treed   MS1-AP1 
> 

>       4 78      sreed   Router-Admin 

> 

>       5 79      treed   Router-Admin 

> 

>       6 81      dreed   Router-Admin 

> 

>       7 
> 

>       8 RADCHECK 
> 

>       9 331     dreed   User-Password   
==      password 
> 

>      10 269     treed   User-Password   
==      password 
> 

>      11 267     sreed   User-Password   
==      password 
> 
> 

This should be ":=" for User-Password. If the match is failing, that 
may  
> 

be the issue. 
> 
> 

>      12 
> 

>      13 RADGROUPCHECK 
> 

>      14 31      Router-Admin    
Service-Type    ==      Login-User 
> 

>      15 28      MS1-AP1        
  Service-Type    ==      Framed-User 
> 

>      16 
> 

>      17 RADREPLY 
> 

>      18 33      sreed   Fall-Through  
  =       yes 
> 

>      19 43      treed   Fall-Through  
  =       yes 
> 

>      20 
> 

>      21 RADGROUPREPLY 
> 

>      22 33      MS1-AP1        
  Port-Limit        =       128k    
15 
> 

>      23 34      Router-Admin    
Mikrotik-Group  =       full    10 
> 

>      24 39      Router-Admin    
Fall-Through     =      Yes     10 
> 

>      25 37      MS1-AP1        
  Fall-Through     =      Yes     15 

> 
> 

I don't think Fall-Through does anything in rlm_sql. What are you  
> 

expecting it to do? 
> 
> 

> rad_recv: Access-Request packet from host 192.168.100.13:1201, id=166, 
length=83 
> 

>         Service-Type = Login-User 
> 

>         User-Name = "treed" 
> 

>         User-Password = "password" 
> 

>         Calling-Station-Id = 
"192.168.100.240" 
> 

>         NAS-Identifier = "HotSpot" 
> 

>         NAS-IP-Address = 192.168.100.13 
> 

>   Processing the authorize section of radiusd.conf 
> 

> modcall: entering group authorize for request 1 
> 

>   modcall[authorize]: module "preprocess" returns ok for 
request 1 
> 

>   modcall[authorize]: module "chap" returns noop for request 
1 
> 

>   modcall[authorize]: module "mschap" returns noop for 
request 1 
> 

>     rlm_realm: No '@' in User-Name = "treed", looking 
up realm NULL 
> 

>     rlm_realm: No such realm "NULL" 
> 

>   modcall[authorize]: module "suffix" returns noop for 
request 1 
> 

> radius_xlat:  'treed' 
> 

> rlm_sql (sql): sql_set_user escaped user --> 'treed' 
> 

> rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM 
radcheck WHERE  
> 

> Username = 'treed' ORDER BY id 
> 

> rlm_sql_mysql: query:  SELECT  
> 

> 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
  
> 

> FROM radgroupcheck,usergroup WHERE usergroup.Username = 'treed' AND  

> 

> usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id 

> 
> 

What is the result of this query if you execute it directly against the  

> 

database? 
> 
> 

> rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM 
radreply WHERE  
> 

> Username = 'treed' ORDER BY id 
> 
> 

> rlm_sql_mysql: query:  SELECT  
> 

> 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribu

Re: Can Juniper router or firewall configured on Free radius

2006-04-06 Thread Zoltan A. Ori
On Thursday 06 April 2006 06:56, Venu Gopal wrote:
> Hi All,
>
> Any one can help me juniper equiqments are configured
> on free radius? If so please help me out the server
> side configuration of users on Redhat. If there are
> any referral web links please do let me know.
> A quick response in this regard would be highly
> appreciated.

Google 'Juniper radius configuration' or read the 'help topic system 
radius-server' from the router cli. Juniper specific attributes are listed 
there.

On Juniper router:

[edit system]
radius-server server-address {
port number; 
secret password; 
retry number; 
timeout seconds; 
}

On freeRADIUS make entries for the router as you would for any NAS in 
clients.conf and user using any of the applicable attributes.

Zoltan Ori


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


Re: Problem with Cisco-AVPair

2006-04-06 Thread Antonio Matera




Hallo,
If I set Cisco-AVPair == "ssid=SSID1" in my user authentication, the
authentication Fail with any ssid and user.
If I set Cisco-AVPair := "ssid=SSID1" my users are always authenticated.

Is there any other configuration to set in the radius or in the access
point? 

In my access request there is the AVPair attribute:

rad_recv: Access-Request packet from host 192.168.9.104:1645, id=19,
length=166

  User-Name = "TEST4"

  Framed-MTU = 1400

  Called-Station-Id = "0012.dacb.8420"

  Calling-Station-Id = "000c.f135.f1ba"

  Cisco-AVPair = "ssid=VLAN3"

  Service-Type = Login-User

  Message-Authenticator = 0xb2a3f1fd52d9d6ff9702cc8f1f480f46

  EAP-Message = 0x020600060d00

  NAS-Port-Type = Wireless-802.11

  Cisco-NAS-Port = "260"

  NAS-Port = 260

  State = 0x0491685cf8ece3184d685dedfedbb3d4

  NAS-IP-Address = 192.168.9.104

  NAS-Identifier = "ap"



but I don't understand if it works...


Any idea?


Thanks 


on 06/04/2006 11.39 Sergio Sagliocco said the following:

  Hi
I think you have to try in this way (for example):
TEST4 Cisco-AVPair == "ssid=SSID1" , Auth-Type := EAP
  Tunnel-Medium-Type = IEEE-802,
  Tunnel-Private-Group-Id = 2,
  Tunnel-Type = VLAN
DEFAULT Auth-Type := Reject

if uou want a password:
TEST4 Cisco-AVPair == "ssid=SSID1" ,User-Password="", Auth-Type := EAP
  Tunnel-Medium-Type = IEEE-802,
  Tunnel-Private-Group-Id = 2,
  Tunnel-Type = VLAN
DEFAULT Auth-Type := Reject

Regards
sergio

Antonio Matera wrote:
  
  
My goal is to have authenticate user only if the SSID is right!
You know how can I do it?

Thanks
Antonio

on 05/04/2006 17.33 Sergio Sagliocco said the following:


  Hello
your goal is authenticate users only if the SSID is rght or to have
different EAP Authentication method based on SSID?

regards
sergio


Antonio Matera wrote:
  
  
  
Hallo,
thanks for the answer.

With your solution my radius don't authenticate my users
Is my configuration correct or I need other change in my radius files?

Thanks bye

on 05/04/2006 15.27 Sergio Sagliocco said the following:



  Hi
I think you have to use == instead of :=
For example:

DEFAULT Cisco-AVPair == "ssid=testLEAP"  ,  EAP-Type := Cisco-LEAP

Regards

  
  
  

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




  

  



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

  
  
  


-- 

--
Antonio Matera
CREATE-NET
Via Solteri, 38 - 38100 Trento
e-mail: [EMAIL PROTECTED]
phone: +39 0461 408400   ext. 305
fax: +39 0461 421157
www.create-net.org
--


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

Re: User in Multiple Groups

2006-04-06 Thread Phil Mayers

Scott Reed wrote:
I have searched the archive and came close to figuring this out, but I have not 


Don't start your query as part of another thread please.



Configuration tables:
  1 USERGROUP
  2 80  sreed   MS1-AP1
  3 76  treed   MS1-AP1
  4 78  sreed   Router-Admin
  5 79  treed   Router-Admin
  6 81  dreed   Router-Admin
  7
  8 RADCHECK
  9 331 dreed   User-Password   ==  password
 10 269 treed   User-Password   ==  password
 11 267 sreed   User-Password   ==  password


This should be ":=" for User-Password. If the match is failing, that may 
be the issue.



 12
 13 RADGROUPCHECK
 14 31  Router-AdminService-Type==  Login-User
 15 28  MS1-AP1  Service-Type==  Framed-User
 16
 17 RADREPLY
 18 33  sreed   Fall-Through=   yes
 19 43  treed   Fall-Through=   yes
 20
 21 RADGROUPREPLY
 22 33  MS1-AP1  Port-Limit=   128k15
 23 34  Router-AdminMikrotik-Group  =   full10
 24 39  Router-AdminFall-Through =  Yes 10
 25 37  MS1-AP1  Fall-Through =  Yes 15


I don't think Fall-Through does anything in rlm_sql. What are you 
expecting it to do?




rad_recv: Access-Request packet from host 192.168.100.13:1201, id=166, length=83
Service-Type = Login-User
User-Name = "treed"
User-Password = "password"
Calling-Station-Id = "192.168.100.240"
NAS-Identifier = "HotSpot"
NAS-IP-Address = 192.168.100.13
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 1
  modcall[authorize]: module "preprocess" returns ok for request 1
  modcall[authorize]: module "chap" returns noop for request 1
  modcall[authorize]: module "mschap" returns noop for request 1
rlm_realm: No '@' in User-Name = "treed", looking up realm NULL
rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 1
radius_xlat:  'treed'
rlm_sql (sql): sql_set_user escaped user --> 'treed'
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'treed' ORDER BY id
rlm_sql_mysql: query:  SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'treed' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id


What is the result of this query if you execute it directly against the 
database?



rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE 
Username = 'treed' ORDER BY id


rlm_sql_mysql: query:  SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  
FROM radgroupreply,usergroup WHERE usergroup.Username = 'treed' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.prio


Again, what does this query give against the database?


rlm_sql (sql): No matching entry in the database for request from user [treed]


This error code is returned if the check items don't match the request.

Possibly take a look in:

src/modules/rlm_sql/rlm_sql.c

...around line 860 (depending on the version you're running) and 
uncomment these lines:


/*
 * Uncomment these lines for debugging
 * Recompile, and run 'radiusd -X'
 */

/*
DEBUG2("rlm_sql:  check items");
vp_listdebug(check_tmp);
DEBUG2("rlm_sql:  reply items");
vp_listdebug(reply_tmp);
*/

...then recompile and run again.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Termination when there is no traffic

2006-04-06 Thread Zoltan A. Ori
On Thursday 06 April 2006 04:29, Johnny wrote:
>
>  I do not know which parameter I have to change so
> that connections wont be terminated automatically anymore. 

That's a function of the NAS and/or the user's PC. Read NAS docs on session 
timeout value.

Zoltan Ori

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


Can Juniper router or firewall configured on Free radius

2006-04-06 Thread Venu Gopal
Hi All,

Any one can help me juniper equiqments are configured
on free radius? If so please help me out the server
side configuration of users on Redhat. If there are
any referral web links please do let me know.
A quick response in this regard would be highly
appreciated.

Regards
Venugopal

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: User in Multiple Groups

2006-04-06 Thread Scott Reed




Surely someone has users in mulitple groups and can tell me how to make that work.

Scott Reed 


Owner 


NewWays 


Wireless Networking 


Network Design, Installation and Administration 


www.nwwnet.net 




-- Original Message 
---

From: "Scott Reed" <[EMAIL PROTECTED]> 


To: FreeRadius users mailing list  


Sent: Wed, 5 Apr 2006 07:25:29 -0500 


Subject: User in Multiple Groups 



> 

I have searched the archive and came close to figuring this out, 
but I have not been able to get a user to exist in 2 groups and have each 
authenticate.  I have one set of systems that need Login-User and then reply 
with one set of responses and another set that need Framed-User and reply with a 
different set of 
responses.

> I have both groups working if I have the user in just one group.  If 
the user is in 2 groups, one group works and the other Rejects.  What is wrong 
with my 
configuration?

> 
> There is an accounting request packet in the trace below that 
show that sreed is logged into one of the Framed-User devices.  Then there is 
the packet from treed trying to log into a Login-User 
device.

> 
> Configuration 
tables:

>   1 
USERGROUP

>   2 80  sreed   
MS1-AP1

>   3 76  treed   
MS1-AP1

>   4 78  sreed   
Router-Admin

>   5 79  treed   
Router-Admin

>   6 81  dreed   
Router-Admin

>   
7

>   8 
RADCHECK

>   9 331 dreed   User-Password   ==  
password

>  10 269 treed   User-Password   ==  
password

>  11 267 sreed   User-Password   ==  
password

>  
12

>  13 
RADGROUPCHECK

>  14 31  Router-AdminService-Type==  
Login-User

>  15 28  MS1-AP1  Service-Type==  
Framed-User

>  
16

>  17 
RADREPLY

>  18 33  sreed   Fall-Through=   
yes

>  19 43  treed   Fall-Through=   
yes

>  
20

>  21 
RADGROUPREPLY

>  22 33  MS1-AP1  Port-Limit=   128k
15

>  23 34  Router-AdminMikrotik-Group  =   full
10

>  24 39  Router-AdminFall-Through =  Yes 
10

>  25 37  MS1-AP1  Fall-Through =  Yes 
15

>  

> Debug 
trace:

> rlm_sql_mysql: Starting connect to MySQL server for 
#1

> rlm_sql (sql): Connected new DB handle, 
#1

> rlm_sql (sql): starting 
2

> rlm_sql (sql): Attempting to connect rlm_sql_mysql 
#2

> rlm_sql_mysql: Starting connect to MySQL server for 
#2

> rlm_sql (sql): Connected new DB handle, 
#2

> rlm_sql (sql): starting 
3

> rlm_sql (sql): Attempting to connect rlm_sql_mysql 
#3

> rlm_sql_mysql: Starting connect to MySQL server for 
#3

> rlm_sql (sql): Connected new DB handle, 
#3

> rlm_sql (sql): starting 
4

> rlm_sql (sql): Attempting to connect rlm_sql_mysql 
#4

> rlm_sql_mysql: Starting connect to MySQL server for 
#4

> rlm_sql (sql): Connected new DB handle, 
#4

> rlm_sql (sql): - 
generate_sql_clients

> rlm_sql (sql): Query: SELECT * FROM 
nas

> rlm_sql (sql): Reserving sql socket id: 
4

> rlm_sql_mysql: query:  SELECT * FROM 
nas

> rlm_sql (sql): Read entry 
nasname=nwnr0004.nwadmin.net,shortname=nwnr0004,secret=sbr28tsr

> rlm_sql (sql): Adding client 10.2.49.5 (nwnr0004) to clients 
list

> rlm_sql (sql): Read entry 
nasname=nwnr0003.nwadmin.net,shortname=nwnr0003,secret=sbr28tsr

> rlm_sql (sql): Adding client 10.2.49.4 (nwnr0003) to clients 
list

> rlm_sql (sql): Read entry 
nasname=nwnr0002.nwadmin.net,shortname=nwnr0002,secret=sbr28tsr

> rlm_sql (sql): Adding client 10.0.1.4 (nwnr0002) to clients 
list

> rlm_sql (sql): Read entry 
nasname=hotspot.nwwhome.net,shortname=hotspot,secret=testing123

> rlm_sql (sql): Adding client 192.168.100.13 (hotspot) to clients 
list

> rlm_sql (sql): Read entry 
nasname=nwnr0001.nwadmin.net,shortname=nwnr0001,secret=sbr28tsr

> rlm_sql (sql): Adding client 10.0.0.1 (nwnr0001) to clients 
list

> rlm_sql (sql): Released sql socket id: 
4

> Module: Instantiated sql 
(sql)

> Module: Loaded 
Acct-Unique-Session-Id

>  acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, 
Client-IP-Address, 
NAS-Port"

> Module: Instantiated acct_unique 
(acct_unique)

> Module: Loaded 
detail

>  detail: detailfile = 
"/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"

>  detail: detailperm = 
384

>  detail: dirperm = 
493

>  detail: locking = 
no

> Module: Instantiated detail 
(detail)

> Module: Loaded 
System

>  unix: cache = 
no

>  unix: passwd = 
"(null)"

>  unix: shadow = 
"/etc/shadow"

>  unix: group = 
"(null)"

>  unix: radwtmp = 
"/var/log/radius/radwtmp"

>  unix: usegroup = 
no

>  unix: cache_reload = 
600

> Module: Instantiated unix 
(unix)

> Module: Loaded 
radutmp

>  radutmp: filename = 
"/var/log/radius/radutmp"

>  radutmp: username = 
"%{User-Name}"

>  radutmp: case_sensitive = 
yes

>  radutmp: check_with_nas = 
yes

>  radutmp: perm = 
384

>  radutmp: callerid = 
yes

> Mo

pre-proxy programme

2006-04-06 Thread Mark Supersonik

I know, I know, I'm very tedious

How can we programme the pre-proxy stage of a freeRADIUS proxy PC in order 
to reject the request if the domain of the user doesn't have quota (in a 
proxy's MySQL database table) ?

I've been looking for two days the answer:

a) rlm_exec module in a pre-proxy stage returning "exit 1" if a local MySQL 
query doen't return positive quota. --> PROBLEM: No way of return a 
REPLY-Message with the termination cause


b) our own module rlm_X from rlm_example -->> PROBLEM: return to my C 
acknowledgements  and back to compiling, buff ...


c) Trying to do in some way a mapping between a realm and 2 authservs (1 is 
local mysql) and get the authentication from a AND function of both answers.


Isn't there a better solution Please help us, we can't find much clear 
information about freeradius, neither in the Wiki!


_
Un amor, una aventura, compañía para un viaje. Regístrate gratis en MSN Amor 
& Amistad. http://match.msn.es/match/mt.cfm?pg=channel&tcid=162349


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


Re: Problem with Cisco-AVPair

2006-04-06 Thread Sergio Sagliocco
Hi
I think you have to try in this way (for example):
TEST4 Cisco-AVPair == "ssid=SSID1" , Auth-Type := EAP
  Tunnel-Medium-Type = IEEE-802,
  Tunnel-Private-Group-Id = 2,
  Tunnel-Type = VLAN
DEFAULT Auth-Type := Reject

if uou want a password:
TEST4 Cisco-AVPair == "ssid=SSID1" ,User-Password="", Auth-Type := EAP
  Tunnel-Medium-Type = IEEE-802,
  Tunnel-Private-Group-Id = 2,
  Tunnel-Type = VLAN
DEFAULT Auth-Type := Reject

Regards
sergio

Antonio Matera wrote:
> My goal is to have authenticate user only if the SSID is right!
> You know how can I do it?
>
> Thanks
> Antonio
>
> on 05/04/2006 17.33 Sergio Sagliocco said the following:
>> Hello
>> your goal is authenticate users only if the SSID is rght or to have
>> different EAP Authentication method based on SSID?
>>
>> regards
>> sergio
>>
>>
>> Antonio Matera wrote:
>>   
>>> Hallo,
>>> thanks for the answer.
>>>
>>> With your solution my radius don't authenticate my users
>>> Is my configuration correct or I need other change in my radius files?
>>>
>>> Thanks bye
>>>
>>> on 05/04/2006 15.27 Sergio Sagliocco said the following:
>>> 
 Hi
 I think you have to use == instead of :=
 For example:

 DEFAULT Cisco-AVPair == "ssid=testLEAP"  ,  EAP-Type := Cisco-LEAP

 Regards

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

-- 
Sergio SAGLIOCCO
SecureLAB - http://www.securelab.it
CSP s.c. a r.l. - http://www.csp.it
__
Villa Gualino
Viale Settimo Severo, 63 - 10133 Torino [IT]
tel. +39 011 481 5140 - Mobile +39 348 6024078 
fax  +39 011 481 5001 
__


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


Re: Compiling freeradius 1.1.1 in FreeBSD 6.0 with mysql support

2006-04-06 Thread Nicolas Baradakis
Mark Hennessy wrote:

> checking for mysql_init in -lmysqlclient_r (using mysql_config)... no
> checking for mysql_init in -lmysqlclient_r... no

FreeRADIUS requires the thread-safe version of the MySQL client library,
unless you configure it with the option --without-threads.

> It's not seeing mysql libraries, but they do indeed exist:
> # ls -al /usr/local/mysql/lib/mysql
> total 1974
> drwxr-xr-x  2 root  wheel 512 Apr  5 10:39 .
> drwxr-xr-x  3 root  wheel 512 Apr  5 10:39 ..
> -rw-r--r--  1 root  wheel   14446 Apr  5 10:39 libdbug.a
> -rw-r--r--  1 root  wheel   41928 Apr  5 10:39 libheap.a
> -rw-r--r--  1 root  wheel   13640 Apr  5 10:39 libmerge.a
> -rw-r--r--  1 root  wheel  331488 Apr  5 10:39 libmyisam.a
> -rw-r--r--  1 root  wheel   24934 Apr  5 10:39 libmyisammrg.a
> -rw-r--r--  1 root  wheel  472466 Apr  5 10:39 libmysqlclient.a
> -rwxr-xr-x  1 root  wheel 871 Apr  5 10:39 libmysqlclient.la
> lrwxr-xr-x  1 root  wheel  20 Apr  5 10:39 libmysqlclient.so ->
> libmysqlclient.so.14
> -rwxr-xr-x  1 root  wheel  387482 Apr  5 10:39 libmysqlclient.so.14
> -rw-r--r--  1 root  wheel  237570 Apr  5 10:39 libmystrings.a
> -rw-r--r--  1 root  wheel  253852 Apr  5 10:39 libmysys.a
> -rw-r--r--  1 root  wheel  105640 Apr  5 10:39 libnisam.a
> -rw-r--r--  1 root  wheel5472 Apr  5 10:39 libvio.a

I don't see the file "libmysqlclient_r.so" in your setup.
Re-install MySQL with thread support, or configure FreeRADIUS without
thread support.

-- 
Nicolas Baradakis

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


Re: Freeradius cannot find rlm_sql_postgresql driver!

2006-04-06 Thread Nicolas Baradakis
lmyho wrote:

> I am trying to test the freeradius to work with postgresql database.
> Just installed freeradius 1.1.0 on debian system via 'aptitude
> install' command of debian.
>
> [...]
>
>  Error: rlm_sql (sql): Could not link driver rlm_sql_postgresql:
> rlm_sql_postgresql.so: cannot open shared object file: No such file or 
> directory

The licenses of PostgreSQL and FreeRADIUS are incompatible, therefore
Debian doesn't distribute a binary version of the PostgreSQL module.

You could build a Debian package from source with the tarball of
FreeRADIUS 1.1.1 from www.freeradius.org. The FAQ explains how
to do this:

http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ

-- 
Nicolas Baradakis

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


Re: Redundant ldap's bug?

2006-04-06 Thread Paulo Cabrita

Thanks Alan.

Nevertheless I will try the solution of one CA for the two servers, if 
it's the same, it will probably work


I will post the result later.

Cheers.

Alan DeKok wrote:


Paulo Cabrita <[EMAIL PROTECTED]> wrote:
...

 See:

http://www.openldap.org/devel/cvsweb.cgi/~checkout~/libraries/libldap/tls.c?rev=1.133&hideattic=1&sortbydate=0

...
static char *tls_opt_cacertfile = NULL;
...

 Yup.  It's a bug in the OpenLDAP client library.  They don't support
multiple users of LDAP connections in the same program.

 I'll file a bug with the OpenLDAP project.

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


 



--

Atentamente,


|Paulo Cabrita, Msc|
|Director do Centro de Informática |
|da Universidade Autónoma de Lisboa|
|Tel: +351-213177635   |
|Fax: +351-213533702   |
|E-mail: [EMAIL PROTECTED]|



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


Termination when there is no traffic

2006-04-06 Thread Johnny
Hi there,

I've got a little proiblem with my radius server. I use it for dial-in accounts 
via ISDN. I've the problem that connections are terminated automatically when 
no traffic is on the line. The authentification works without problems, but I 
do not know which parameter I have to change so that connections wont be 
terminated automatically anymore. Could anyone help me with this? Thank you!

Regards, John

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