Re: Freeradius-Users Digest, Vol 46, Issue 102 Why is groupname field blank in radacct

2009-02-26 Thread ngwarai zed
Hallo all, First of all thanks Kalik for your responses. I checked the link you you sent but I couldn't get the info I am looking for. Let me expand further on the problem:- I have MySQL 5.0.67 and PostgreSQL 8.3.6 and freeRADIUS 2.17 installed on GNU/Linux Fedora 10 distribution. I have

rlm_sql: Failed to create the pair: Failed to find IP address

2009-02-26 Thread Ilya
Hello! Please help! I’ve got the following situation: In radcheck I’ve got: ___ |Username|ATTRIBUTE |OP|VALUE| |test|Cleartext-Password |:=|test | --- in radreply: __

Re: rlm_sql: Failed to create the pair: Failed to find IP address

2009-02-26 Thread Alan DeKok
Ilya wrote: I’ve got the following situation: .. __ |Username|ATTRIBUTE|OP|VALUE | |test|Framed-IP-Address|:=|081.018.118.238| --- That isn't a good IP address. But if I, just for

Re: Question about authenticating CHAP clientsusinganexternalprogram-A different case

2009-02-26 Thread Ali Majdzadeh
Ivan, Hello Thanks for your reply. I have got some questions to ask. We have different types of clients (Or, connections) in our system; Dial-Up, ADSL, VoIP, CHAP, MS-CHAP, MS-CHAPv2 and ... . Each of these clients need different authorization method. Now, where should our authorization code

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread magicboiz
HI again Ivan Do you know how can I modify the source code, in order to print in the error message the exact time when the child was created/forked? If I want to find errors in my sql backend server, I need to know the exact time when the requests are lost.. checking the code, It looks

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread Marinko Tarlac
First, optimize your database, add indexes and use storage engines which will give you the best performance... Increase interim-update interval After that, try to add more handlers and see what will happen. If you're using mysql, check tuning-primer.sh and mysqltuner.pl scripts. On Thu, Feb 26,

Re: SQLCounter configuration

2009-02-26 Thread alt_
tnt-4 wrote: 3) Currently I receive something like Reply-Message = Your maximum never usage time has been reached when the counter reaches its limit - even when what was counted as not time but data volume. Can Reply-Message for sqlcounter be configured as in the expiration module?

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread Alan DeKok
magicboiz wrote: Do you know how can I modify the source code, in order to print in the error message the exact time when the child was created/forked? If I want to find errors in my sql backend server, I need to know the exact time when the requests are lost.. checking the code, It

Re: SQLCounter configuration

2009-02-26 Thread Alan DeKok
alt_ wrote: Can you show some examples please? I try to do like this: noresetBytecounter if (reject) { update reply { Reply-Message := Traffic limit exceeded. } } but if noresetBytecounter return reject freeradius immediatly return reject to

Re: SQLCounter configuration

2009-02-26 Thread Alexander Solodukhin
On Thu, 26 Feb 2009 12:03:22 +0200, Alan DeKok al...@deployingradius.com wrote: alt_ wrote: Can you show some examples please? I try to do like this: noresetBytecounter if (reject) { update reply { Reply-Message := Traffic limit exceeded. } } but if

Re: EAP-PEAP GTC auth_type

2009-02-26 Thread tnt
Great! It works perfectly. Other than enabling ldap in authorize and authenticate in inner-tunnel, I also had to change eap.conf's gtc section to auth_type = LDAP. This works, but it brings up another problem. Setting auth_type to PAP, Local, or commented out on gtc section does not work for

Re: Freeradius-Users Digest, Vol 46, Issue 102 Why is groupname fieldblank in radacct

2009-02-26 Thread tnt
I have MySQL 5.0.67 and PostgreSQL 8.3.6 and freeRADIUS 2.17 installed on GNU/Linux Fedora 10 distribution. I have identical radius databases on both MySQL and PostgreSQL. When I use the PostgreSQL, the groupname field in the radacct table gets filled in but when I change the database to MySQL,

Re: SQLCounter configuration

2009-02-26 Thread Alan DeKok
Alexander Solodukhin wrote: /etc/freeradius/sites-enabled/default[412]: SQL Counter modules aren't allowed in 'post-auth' sections -- they have no such method. The REJECT handler needs to be put into the post-auth section. Not the sqlcounter module. Please READ the default configuration

Re: SQLCounter configuration

2009-02-26 Thread tnt
Can you show some examples please? I try to do like this: noresetBytecounter if (reject) { update reply { Reply-Message := Traffic limit exceeded. } } but if noresetBytecounter return reject freeradius immediatly return reject to user and do not

Re: Question about authenticating CHAPclientsusinganexternalprogram-A different case

2009-02-26 Thread tnt
Thanks for your reply. I have got some questions to ask. We have different types of clients (Or, connections) in our system; Dial-Up, ADSL, VoIP, CHAP, MS-CHAP, MS-CHAPv2 and ... . Each of these clients need different authorization method. Now, where should our authorization code reside? Shall we

Re: Question about authenticating CHAPclientsusinganexternalprogram-A different case

2009-02-26 Thread Ali Majdzadeh
Ivan, Hello Thanks for your reply. Sorry if my question is elementary, but this is the last one. What is the difference between creating a customized module to do Authorization/Post-Authentication and using external programs as instances of rlm_exec module to the so-called functionalities? Kind

Re: Question about authenticating CHAPclientsusinganexternalprogram-Adifferent case

2009-02-26 Thread tnt
Thanks for your reply. Sorry if my question is elementary, but this is the last one. What is the difference between creating a customized module to do Authorization/Post-Authentication and using external programs as instances of rlm_exec module to the so-called functionalities? Module is much

Re: Question about authenticating CHAPclientsusinganexternalprogram-Adifferent case

2009-02-26 Thread Ali Majdzadeh
Ivan, Thanks for your reply. I think I should start writing my own module, because the AAA system itself is in C. In other words, all of our external programs are C programs. Thanks again for your patience and guidance. Kind Regards Ali Majdzadeh Kohbanani - List info/subscribe/unsubscribe? See

Re: SQLCounter configuration

2009-02-26 Thread Alexander Solodukhin
On Thu, 26 Feb 2009 13:19:06 +0200, t...@kalik.net wrote: Can you show some examples please? I try to do like this: noresetBytecounter if (reject) { update reply { Reply-Message := Traffic limit exceeded. } } but if noresetBytecounter return reject

Re: SQLCounter configuration

2009-02-26 Thread tnt
Sorry, i read mans and comments in config and try to do like you say but it's not work as i need. I have sqlcounter: sqlcounter noresetBytecounter { counter-name = Total-Max-Octets check-name = Max-Octets reply-name = ChilliSpot-Max-Total-Octets sqlmod-inst =

FR 2.1.3 compile problem

2009-02-26 Thread Chris Howley
Alan, I encountered the following problem (see below) when attempting to compile the latest version of 2.1.3 (stable code) from the git tree. Your help in fixing this problem would be appreciated. Thanks, Chris Environment: SunOS XX 5.10 Generic_120012-14 i86pc i386 i86p gcc

Re: SQLCounter configuration

2009-02-26 Thread Alexander Solodukhin
On Thu, 26 Feb 2009 16:55:00 +0200, t...@kalik.net wrote: Sorry, i read mans and comments in config and try to do like you say but it's not work as i need. I have sqlcounter: sqlcounter noresetBytecounter { counter-name = Total-Max-Octets check-name = Max-Octets

Re: FR 2.1.3 compile problem

2009-02-26 Thread Nicolas Goutte
Looking for lt__PROGRAM__LTX_preloaded_symbols in my email archive, this was already reported on 2009-02-02 for Linux ( thread Installation Problem), but as far as I know no definite answer was given. Have a nice day! Am 26.02.2009 um 16:16 schrieb Chris Howley: Alan, I encountered the

SQL-Accounting

2009-02-26 Thread Tim Stone
Hello, is it possible to call only a simple Stored Procedure (SP) on the MySQL-Server to do the Accounting Job, like the sql-log module (rlm_sql_log(5)), but do not log in file, instead of this, call the SP: I can't find more Information for such configuration. Thanx for help, Tim - List

Re: SQL-Accounting

2009-02-26 Thread tnt
is it possible to call only a simple Stored Procedure (SP) on the MySQL-Server to do the Accounting Job, like the sql-log module (rlm_sql_log(5)), but do not log in file, instead of this, call the SP: I can't find more Information for such configuration. unlang supports only SELECT statements.

Re: SQLCounter configuration

2009-02-26 Thread tnt
I can do like this: if (!reply:ChilliSpot-Max-Total-Octets) { update reply { Reply-Message := Traffic limit exceeded. } } but if user enter wrong password Traffic limit exceeded. error message will be displayed. I had a look at the

Re: SQLCounter configuration

2009-02-26 Thread Alexander Solodukhin
On Thu, 26 Feb 2009 20:56:03 +0200, t...@kalik.net wrote: I can do like this: if (!reply:ChilliSpot-Max-Total-Octets) { update reply { Reply-Message := Traffic limit exceeded. } } but if user enter wrong password Traffic limit exceeded.

Re: SQLCounter configuration

2009-02-26 Thread tnt
Thank you. I see this solution in the internet, but i need configurable Reply-Message, becouse i want to limit not only traffic, but session time too. Actually, I can recall that sqlcounter had configurable Reply-Message in early days (I had 1.0.5 where it was configurable). Download 1.0.5 and

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
unlang supports only SELECT statements. Call your procedure from a perl script. 1) can I access to all accounting releated information from the perl module like in the sql-module? Are any examples out there? # Start = INSERT INTO ${acct_table} (AcctSessionId, UserName, \ #

Re: SQL-Accounting

2009-02-26 Thread tnt
1) can I access to all accounting releated information from the perl module like in the sql-module? You said that you want to call a stored procedure. Yes, your database does have access to all the information stored in it. Are any examples out there? $query = CALL your_procedure; If you need

Re: Two factor authentication to both LDAP directory and SecurID

2009-02-26 Thread Greg Vickers
Hi Ivan, t...@kalik.net wrote: Yes. There is no problem in composing Cleartext-Password on the fly from users password and the token.It shouldn't be too difficult to create a perl script that does that. Excellent! So the username and tokencode/password is passed from the NAS (ASA5500) to the

Re: Conversion to Version 2

2009-02-26 Thread Doug Hardie
On Oct 6, 2008, at 02:22, Alan DeKok wrote: Doug Hardie wrote: Thats not that big a deal as for the basic stuff, the code is quite straight forward. However, the bigger issue is for modules. The wiki page is still completely oriented towards version 1 as I have never tried version 2.

Re: Conversion to Version 2

2009-02-26 Thread Alan DeKok
Doug Hardie wrote: Is there still a way to compile the module away from the freeradius source structure like there was for version 1? That was difficult to do in version 1. It should be a lot easier now, as all of the include files have been cleaned up and regularized. Alan DeKok. - List

Re: Conversion to Version 2

2009-02-26 Thread Doug Hardie
On Feb 26, 2009, at 21:52, Alan DeKok wrote: Doug Hardie wrote: Is there still a way to compile the module away from the freeradius source structure like there was for version 1? That was difficult to do in version 1. It should be a lot easier now, as all of the include files have been

Re: Conversion to Version 2

2009-02-26 Thread Alan DeKok
Doug Hardie wrote: Are there any worked examples. I have not figured out how to get it done yet. There are no worked examples. However, you should just have to set CFLAGS=-I/path/to/include, where that directory contains /freeradius/libradius.h, etc. Alan DeKok. - List

Re: EAP-PEAP GTC auth_type

2009-02-26 Thread Fajar A. Nugraha
On Thu, Feb 26, 2009 at 5:14 PM, t...@kalik.net wrote: Is there a way I can authenticate with BOTH system user and LDAP using PEAP-GTC? the main radiusd.conf can have multiple authorize methods available, right? Why does gct have to explicitly set auth_type? Leave gtc as pap. Change

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
2009/2/27 t...@kalik.net: 1) can I access to all accounting releated information from the perl module like in the sql-module? You said that you want to call a stored procedure. Yes, your database does have access to all the information stored in it. Are any examples out there? $query = CALL

Re: SQL-Accounting

2009-02-26 Thread Tim Stone
Thanks for help !!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html