Re: MySQL

2008-01-21 Thread Alan DeKok
Arlinelson Fernandes dos Santos wrote: I saw this version and check the tables.sql, it has a few tables to create. You can get more tables by tables.sql from version 1.x.x, I don´t know why this new version comes with less table. Maybe only to update. I don´t know. 2.0.0 includes all of the

Re: Unknown syslog chosen but no facility spedified

2008-01-21 Thread Alan DeKok
Stuart Kendrick wrote: Starting RADIUS server: radiusd: Error: Unknown syslog chosen but no facility spedified Grab a CVS checkout, it should be fixed. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL accounting issue

2008-01-21 Thread Alan DeKok
Andy Smith wrote: I have attempted to configure freeradius to write accounting data to MySQL, however currently its not working. No data is being written to MySQL and the Radius client is complaining its not recieving a reply for accounting requests. I subsituted the detail setting in the

regarding RFC 2253 UTF-8 String Representation of Distinguished Names support

2008-01-21 Thread Gopinath Reddy N
Hi, Could anyone let me know whether RFC2253 is implemented in free radius. Iam trying to use special characters in Users name and active directory is expecting UTF-8 string form of the user. However free radius is not encoding it in UTF-8 format. Thanks for the help. -gnr - List

What is up with the SQL Groups

2008-01-21 Thread Etienne Pretorius
Hello List, I am on FreeRadius 1.1.6-1 on debian etch. I have a user that belongs to both DSL and DIAL groups. mysql select * from usergroup; +--+---+--+ | UserName | GroupName | priority |

freeradius + ldap + cisco sslvpn

2008-01-21 Thread satish patel
Dear all I have requirement of sslvpn authentication with freeradius + ldap server is there anyone have worked on freeradius + ldap or authenticate with goruping and other features... $ cat ~/satish/url.txt

Re: What is up with the SQL Groups

2008-01-21 Thread Phil Mayers
Etienne Pretorius wrote: Hello List, I am on FreeRadius 1.1.6-1 on debian etch. I have a user that belongs to both DSL and DIAL groups. The groups are merged http://marc.info/?l=freeradius-usersm=119010719300080w=2 This works properly in FreeRadius 2.0 I believe - List

Re: regarding RFC 2253 UTF-8 String Representation of Distinguished Names support

2008-01-21 Thread Alan DeKok
Gopinath Reddy N wrote: Could anyone let me know whether RFC2253 is implemented in free radius. it should be. Iam trying to use special characters in Users name and active directory is expecting UTF-8 string form of the user. However free radius is not encoding it in UTF-8 format.

Re: Traffic volume accounting

2008-01-21 Thread Spam Eater
Thanks! It turns out that my problem was in fact, another one. I was using radreply with custom parameters that I check against in bash scripts. The problem was freeRadius not sending to the NAS the correct parameters in radreply. Somehow, freeRadius ignores all parameters in radreply as sson as

upgrade error in 2.0 version

2008-01-21 Thread Gopinath Reddy N
Hi, I would like to know if anything related to configuration has been changed in 2.0 version when compared with 1.1.6 Iam running radiusd -C command it throws the below error. Is it a valid error or I can ignore it. /etc/raddb/users[21]: Parser error (check) for entry DEFAULT: Invalid Octet

Building FreeRadius 2.0 on Mac OS X fails

2008-01-21 Thread Walter Krivanek, VividVisions
Hi, I'm trying to build the current version of freeradius on my Mac OS X 10.5 Intel 64bit computer. First, I have troubles with the configure script. Even if I show the script my exact location of the MySQL include files using --with-mysql- include-dir and similar, I'm getting warnings

Re: regarding RFC 2253 UTF-8 String Representation of Distinguished Names support

2008-01-21 Thread Gopinath Reddy N
Hi Alan, Thanks for the information. Iam trying to send ldap search request to Active Directory using free radius 2.0 Iam using user login filter: (sAMAccountName=%{User-Name}) When I analyzed using ethereal I have observed the below information. António is sent as 0x41, 0x6e,0x74, 0xf3,

Re: MySQL accounting issue

2008-01-21 Thread A.smith
for request 85 radius_xlat: '/usr/local/var/log/radius/radacct/89.107.16.10/detail-20080121' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/89.107.16.10/detail-20080121 modcall[accounting]: module detail returns ok

adding accounting attribute

2008-01-21 Thread Alexander Serkin
Hi, FreeRadius Users. Could somebody tell me if it's possible to add some accounting attribute depending on user's SQL group membership? For example - for all members of SQL group 'somegroupname' add: User-Category = '1' to every accounting packet. Which module should i read about more carefully?

Re: MySQL accounting issue

2008-01-21 Thread A.smith
Ah, ok, now I see the other post regarding this. The problem is OpenSER and this status type: rlm_sql (sql): Unsupported Acct-Status-Type = 15 Whats the latest on this? Has the incompatibility been addressed in freeradius 2.0? thanks Andy.

Re: What is up with the SQL Groups

2008-01-21 Thread Etienne Pretorius
Phil Mayers wrote: Etienne Pretorius wrote: Hello List, I am on FreeRadius 1.1.6-1 on debian etch. I have a user that belongs to both DSL and DIAL groups. The groups are merged http://marc.info/?l=freeradius-usersm=119010719300080w=2 This works properly in FreeRadius 2.0 I believe -

Re: Building FreeRadius 2.0 on Mac OS X fails

2008-01-21 Thread Alan DeKok
Arran Cudbard-Bell wrote: CVS head fails at ... ld: file not found: /usr/local/freeradius-cvs100108/lib/libfreeradius-radius-2.0.0-beta.dylib $ make distclean $ ./configure $ make You've done a cvs update in a tree that started off as 2.0.0-beta. Can confirm the other two issues on stable

Re: MySQL accounting issue

2008-01-21 Thread tnt
Again, send a debug with the Start and Stop packets. Ivan Kalik Kalik Informatika ISP Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše: Also, regarding radius 1.x I now have a patch which allows this type of record. However next issue is that with accounting set to sql in radiusd.conf the SQL

MySQL

2008-01-21 Thread Anthony McGarry
Thanks David, that worked. Message: 6 Date: Sun, 20 Jan 2008 17:46:16 + From: Anthony McGarry [EMAIL PROTECTED] Subject: MySQL To: freeradius-users@lists.freeradius.org Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=iso-8859-1 Hi, I downloaded the latest version

Re: Support for RFC4372 (Chargeable User Identity)

2008-01-21 Thread Maja Wolniewicz
Alan DeKok pisze: Maja Wolniewicz wrote: According to RFC4372 CUI attribute in request can include a single NUL character, then your test if (%{Chargeable-User-Identifier}) { update reply { Chargeable-User-Identifier = } } evaluates to false. I've fixed this in CVS

Re: Building FreeRadius 2.0 on Mac OS X fails

2008-01-21 Thread Walter Krivanek, VividVisions
Alan DeKok wrote: Walter Krivanek, VividVisions wrote: First, I have troubles with the configure script. Even if I show the script my exact location of the MySQL include files using --with-mysql-include-dir and similar, I'm getting warnings that mysql.h has not been found and that the MySQL

RE: Freeradius +LDAP + Active Directory + Authenticate Only questions

2008-01-21 Thread William Segura
Thanks, I got it working. Is there a reason that the ldap search that rlm_ldap performs functions differently from ldapsearch? With ldapsearch I can do a search without specifying an OU but with rlm_ldap, it fails? I do not have control of the Active Directory server here so I cannot apply the

Re: Support for RFC4372 (Chargeable User Identity)

2008-01-21 Thread Alan DeKok
Maja Wolniewicz wrote: I'm now running freeradius from CVS FreeRADIUS Version 2.0.1-pre in post-auth I have: if (%{FreeRADIUS-Proxied-To} == 127.0.0.1) { if (%{Chargeable-User-Identity}) { Please fix this. Putting double quotes around *everything* was never necessary, and is much less

Re: Building FreeRadius 2.0 on Mac OS X fails

2008-01-21 Thread Alan DeKok
Walter Krivanek, VividVisions wrote: configure: running /bin/sh ./configure '--prefix=/usr/local/freeradius2' '--with-mysql-dir=/usr/local/mysql' That should be --with-mysql-include-dir=... What you have above is completely unsupported. checking for mysql/mysql.h... no Hmm... the

Re: Support for RFC4372 (Chargeable User Identity)

2008-01-21 Thread Maja Wolniewicz
Alan DeKok pisze: Maja Wolniewicz wrote: I'm now running freeradius from CVS FreeRADIUS Version 2.0.1-pre in post-auth I have: if (%{FreeRADIUS-Proxied-To} == 127.0.0.1) { if (%{Chargeable-User-Identity}) { Please fix this. Putting double quotes around *everything* was never necessary,

Re: Building FreeRadius 2.0 on Mac OS X fails

2008-01-21 Thread Info
Walter, I've overcome these problems on Tiger and offer these points in hopes it works on Leopard as well: 1] in my experience, rlm_perl doesn't like apple's perl install - haven't had the time to really figure out why, but installing my own build (tested with threaded/shared and w/o

Re: Support for RFC4372 (Chargeable User Identity)

2008-01-21 Thread Alan DeKok
Maja Wolniewicz wrote: Thanks. Now it works. That's good to hear. Yes, I want to add current realm to reply attribute Chargeable-User-Identity which comes form LDAP. When Chargeable-User-Identity attribute isn't present in request I want to remove Chargeable-User-Identity from reply.

Re: Support for RFC4372 (Chargeable User Identity)

2008-01-21 Thread Maja Wolniewicz
Alan DeKok pisze: Maja Wolniewicz wrote: Thanks. Now it works. That's good to hear. Yes, I want to add current realm to reply attribute Chargeable-User-Identity which comes form LDAP. When Chargeable-User-Identity attribute isn't present in request I want to remove

Re: MySQL

2008-01-21 Thread A . L . M . Buxey
Hi, I have installed MySQL and Freeradius2.0.0. I have updated the schema for MySQL and set the location, username and password in sql.conf. When I start radiusd -X I get the following output. I cannot see any mention of connecting to mysql. you arent using sql for authentication,

Re: SNMP error

2008-01-21 Thread A . L . M . Buxey
Hi, i followed the bugs file. i recompiled the freeradius with --enable-developer actually i made RPM file with ( rpmbuild -ta freeradius-1.1.7.tar.gz ) are you SURE That this worked fine - as if you used the standard SPEC then you wouldnt enable the developer stuff. (no debugging

Re: MySQL accounting issue

2008-01-21 Thread Andy Smith
Anyone any ideas? I repost this as the posts are in a messed up order on the forum page... As per my previous mail, my current issue is that with accounting set to sql in radiusd.conf the SQL statements are being written just to /usr/local/var/log/radius/sqltrace.sql and nothing is actually

FreeRadius V2.0.0 Simultaneous-Use Problems

2008-01-21 Thread Dryw Paulic
Hello Everyone, On Freeradius Version 2.0.0, I have an issue with Simultaneous-Use. Multiple logins are being caught, but the issue seems to be that the checks seem to be catching much more than they should be. In particular, I was looking at this user: mysql select * from radgroupcheck;

Blank spaces after username - problem with accounting - MySql database.

2008-01-21 Thread Marinko Tarlac
Hi there... It is me again... Few days ago, I wrote about my problem with accounting. Problem is that accounting doesn't work for some users. In this case it is test.user... After some investigation with log files (holly radiusd -X), I can see that problem is in username. As you can see (line

Re: FreeRadius V2.0.0 Simultaneous-Use Problems

2008-01-21 Thread Kevin Bonner
On Monday 21 January 2008 14:19:06 Dryw Paulic wrote: mysql select * from radgroupcheck; ++---+--++---+ | id | GroupName | Attribute| op | Value | ++---+--++---+ | 1 | dynamic | Auth-Type| == | Local |

filling in missing attributes

2008-01-21 Thread Duane Cox
Hello List I'm looking for a suggested solution to this problem. I'm running freeradius 2.0.0 and have a NAS that doesn't supply the NAS-Identifier or Called-Station-Id. I'm using rlm_sql to log acct information and would like to have this missing info filled in. Would it be best to use:

Re: FreeRadius V2.0.0 Simultaneous-Use Problems

2008-01-21 Thread tnt
I took a look at the SQL Queries used by freeradius to check the logins and decided to run them manually on my sql database: mysql SELECT COUNT(*) FROM radacct WHERE username = 'Kat' AND acctstoptime = 0; +--+ | COUNT(*) | +--+ | 16 | +--+ 1 row in set (0.00 sec)

Re: MySQL accounting issue

2008-01-21 Thread tnt
Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše: Also, regarding radius 1.x I now have a patch which allows this type of record. However next issue is that with accounting set to sql in radiusd.conf the SQL statements are being written just to /usr/local/var/log/radius/sqltrace.sql and nothing is

Re: rlm_dbm segfault debug

2008-01-21 Thread Alan DeKok
Patrick Medina wrote: Newbie and non-programmer here, though I've been a user of this very useful program for a year now (currently on v.2.0.0, CentOS 4.6, x86_64). I'm trying to get a MAC and SSID -based system to work with rlm_dbm. The system already works with the users file as follows:

MySQL

2008-01-21 Thread Anthony McGarry
Hi, I have installed MySQL and Freeradius2.0.0. I have updated the schema for MySQL and set the location, username and password in sql.conf. When I start radiusd -X I get the following output. I cannot see any mention of connecting to mysql. [EMAIL PROTECTED] sbin]# radiusd -X FreeRADIUS