SQL reading as user DEFAULT

2002-05-29 Thread Erich Zigler
modcall: entering group authorize modcall[authorize]: module preprocess returns ok modcall[authorize]: module attr_filter returns noop modcall[authorize]: module suffix returns ok radius_xlat: '[EMAIL PROTECTED]' sql_escape in: '[EMAIL PROTECTED]' sql_escape out: '[EMAIL PROTECTED]'

prepaid timeouts

2002-05-29 Thread Michael Bailey
Hello, I would like to use freeradius to offer a prepaid service where users can buy a certain number of days and will have unlimited use untill that period is up. I created a field in the database with the 'credit expires' date and have authorize_reply_query() returning a value for

Is there???

2002-05-29 Thread
Hello all, Is there any A/V pair like Login-Time in radius protocol -- Best regards, Dinar mailto:[EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: prepaid timeouts

2002-05-29 Thread
Hello Michael, Wednesday, May 29, 2002, 12:00:09 PM, you wrote: MB I would like to use freeradius to offer a prepaid service where users MB can buy a certain number of days and will have unlimited use untill that MB period is up. MB I created a field in the database with the 'credit expires'

2 SQL schemas at once

2002-05-29 Thread Thomas Jalsovsky
Hello, I would like to use different SQL schemas with the same RADIUS server. I would like to make SQL accounting for different NASes (and services). The attributes are different (Cisco VoIP and another devices). I thought about the system uses XTRadius but I didn't find anything about

RE: freeradius-0.5 crashing

2002-05-29 Thread Stefan Immel
Wed May 29 09:56:07 2002 : Error: Trying to look up name of unknown client 24.0.64.64. Wed May 29 09:56:07 2002 : Error: Accounting-Request packet sent to a non-accounting port from client UNKNOWN-CLIENT:0 - ID 57 : IGNORED Wed May 29 09:56:07 2002 : Error: CHILD: exit on signal (11) We had

Re: SQL group auth problem [patch]

2002-05-29 Thread Thomas Jalsovsky
Hello all, I went through the SQL module and I found that in the SQL authorization part, firstly the radcheck table is checked. If the given user is not found, it tries the DEFAULT setting but doesn't look for the radgroupcheck entries. This patch modifies the rlm_sql module to

radius+mysql=core dumped

2002-05-29 Thread rust
Hello freeradius-users, My config Linux Redhat 7 Linux 2.4.18 #3 SMP Fri Apr 5 14:07:36 MSD 2002 i686 unknown mysql Ver 3.22.32 for pc-linux-gnu on i686 freeradius-snapshot-20020522 If I set num_sql_socks 1, i have core dumped ;( With num_sql_socks = 1 it work fine What changes i must do and

Re: freeradius-0.5 crashing

2002-05-29 Thread Giovanni P. Tirloni
* Stefan Immel ([EMAIL PROTECTED]) wrote: Our radius just died again, this time without an sig 11: Wed May 29 11:49:53 2002 : Error: Trying to look up name of unknown client 8.193.44.64. Wed May 29 11:49:53 2002 : Error: Accounting-Request packet sent to a non-accounting port from cl ient

session timeout attribute

2002-05-29 Thread Hooman Amini
Hi, I have used freeradius for our prepaid calling card system.I am looking for an attribute to timeout our voip ivr sessions like session-timout. checking session-timeout i have got no result. any idea? Hooman --- Giovanni P. Tirloni [EMAIL PROTECTED] wrote: * Stefan Immel ([EMAIL

Re: Authorization via LDAP Authentication via PAM

2002-05-29 Thread Kostas Kalevras
On Wed, 29 May 2002, Michael Fuller wrote: Hi all, I am trying to get both authentication and authorisation through LDAP. While authentication works, authorisation still evades me. Ideas anybody ? Regards, Michael Fuller authorize{ files ldap } What is the problem you

run multiple query in sql.conf

2002-05-29 Thread Hooman Amini
Greeting, I have used freeradius in a cisco prepaid system.To update the users credit, i need to run multiple sql on stop radius query.How can I run multiple query in a single stop signal? Hooman __ Do You Yahoo!? Yahoo! - Official partner of

Re: Problem with Login-Time attribute.

2002-05-29 Thread Kostas Kalevras
On Tue, 28 May 2002, Aqeel Anwar wrote: Hi all I am using freeradius 0.5 on Solaris 7 and Cisco IOS 11.1. I want to restrict one of my user such a way that he can login only from 1500 to 1700. My users file is: foo Auth-Type := System, Login-Time == Any1500-1700, Framed-Protocol == PPP

Re: session timeout attribute

2002-05-29 Thread Hooman Amini
I have tried cisco debitcard.tcl but i has some error in using credit amount that's why i am looking for an automatic session timeout attribute to purge my session automatically. --- Rodrigo Gonzalez [EMAIL PROTECTED] wrote: h323-credit-time it depends on tcl if it use the return value or not,

Re: run multiple query in sql.conf

2002-05-29 Thread
Hello Hooman, Wednesday, May 29, 2002, 4:30:09 PM, you wrote: HA Greeting, HA I have used freeradius in a cisco prepaid system.To update the users credit, i HA need to run multiple sql on stop radius query.How can I run multiple query in a HA single stop signal? What doesn't let you use sql

Re: session timeout attribute

2002-05-29 Thread Rodrigo Gonzalez
If you explain which error you had maybe someone could help you - Original Message - From: Hooman Amini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:11 AM Subject: Re: session timeout attribute I have tried cisco debitcard.tcl but i has some error in

Re: Ascend-Data-Filter issue

2002-05-29 Thread Chris Parker
At 12:30 AM 5/29/2002 -0400, Eric Reischer wrote: Hi all. I'm using the 0.5 release on a Linux machine, and I can't seem to get the Ascend-Data-Filter attribute to function properly. If I put two lines such as: DEFAULT Auth-Type := ldap Framed-Protocol = PPP, more attributes

Re: Release Schedule

2002-05-29 Thread Chris Parker
At 10:49 PM 5/28/2002 -0300, Giovanni P. Tirloni wrote: Hi, Does FreeRADIUS has a release schedule ? When the next release is changed enough the core developers make a decision to tag it as a new release. There is not set schedule of releases, as most of us also have other primary jobs (

Re: run multiple query in sql.conf

2002-05-29 Thread Chris Parker
At 05:30 AM 5/29/2002 -0700, Hooman Amini wrote: Greeting, I have used freeradius in a cisco prepaid system.To update the users credit, i need to run multiple sql on stop radius query.How can I run multiple query in a single stop signal? You could run multiple sql instances, but that would take

Re: Problem with Login-Time attribute.

2002-05-29 Thread Aqeel Anwar
Thanks Kalevras. After Login-Time := Any1500-1700 it works as far as the Login is concerned. However if the user is connected between 1500 and 1700 then he is not disconnected automatically at 1700. I think there is a problem with session-timeout reply. do I need to change some configuration on

Re: SQL reading as user DEFAULT

2002-05-29 Thread Alan DeKok
Erich Zigler [EMAIL PROTECTED] wrote: sql_escape in: 'DEFAULT' sql_escape out: 'DEFAULT' sql_set_user: escaped user -- 'DEFAULT' I'm running Freeradius v0.5 on a FreeBSD machine.=20 Where is it getting DEFAULT from?=20 From the internal code of the SQL module. It looks for

Re: freeradius-0.5 crashing

2002-05-29 Thread Alan DeKok
Stefan Immel [EMAIL PROTECTED] wrote: Wed May 29 09:56:07 2002 : Error: Trying to look up name of unknown = client 24.0.64.64.=20 Wed May 29 09:56:07 2002 : Error: Accounting-Request packet sent to a = non-accounting port from client UNKNOWN-CLIENT:0 - ID 57 : IGNORED Wed May 29 09:56:07

Re: Service-Type

2002-05-29 Thread Alan DeKok
Mazen R. Kassem [EMAIL PROTECTED] wrote: Really nobody no from where to change the Service-Type to Administrative-User instead of Login-User for ldap user In your LDAP database. How you do this depends on your database, and isn't really an issue for the RADIUS server. Alan DeKok. -

Re: SQL reading as user DEFAULT

2002-05-29 Thread Erich Zigler
On Wednesday 29 May 2002 09:06 am, Chris Parker wrote: Where is it getting DEFAULT from? Do you have a DEFAULT entry in your database or an exact match for your user? What do you get when you run the query manually? I have an exact match, and when I run the command manually I get the proper

Re: SQL reading as user DEFAULT

2002-05-29 Thread Erich Zigler
On Wednesday 29 May 2002 09:53 am, Alan DeKok wrote: sql_escape in: 'DEFAULT' sql_escape out: 'DEFAULT' sql_set_user: escaped user -- 'DEFAULT' I'm running Freeradius v0.5 on a FreeBSD machine.=20 Where is it getting DEFAULT from?=20 From the internal code of the SQL module. It

Re: Problem with Login-Time attribute.

2002-05-29 Thread Kostas Kalevras
On Wed, 29 May 2002, Aqeel Anwar wrote: Thanks Kalevras. After Login-Time := Any1500-1700 it works as far as the Login is concerned. However if the user is connected between 1500 and 1700 then he is not disconnected automatically at 1700. I think there is a problem with session-timeout

Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
I'm new to Free-Radius, I'll try to be as descriptive as possible. I have taken the advice of this board and read all documentation possible before asking this. I've searched on countless search engines for possible answers, and the only results I seem to come up with are pre Free Radius

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type MySQL is working on the accounting side when Radius requests are sent out. I have another group on which is using the VPN concentrators method of authentication, (only supports 500 users however, and we require 1500 or entries) and set that group up

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Alan DeKok
Deramus, Chris [EMAIL PROTECTED] wrote: I have another group on which is using the VPN concentrators method of authentication, (only supports 500 users however, and we require 1500 or entries) and set that group up to pass all accounting information out to the Radius server on port 1813. It's

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Alan, Thanks for your quick response, I will definitely give this a try. I like this product and I think it'll work out great once I can finish the configuration but let me ask you this. I realize this isn't your problem but I just wanted to see what

Re: session timeout attribute

2002-05-29 Thread Hooman Amini
Hi, the problem is that when i use app_Debitcad.2.0.2.2.tcl , after authentication time which returns the values of h323-retun-code and h323-credit-amount and h323-credit-time my execution program goes to the state of not recieveing tel number without any delay.Also the section of reading credit

Re: run multiple query in sql.conf

2002-05-29 Thread Hooman Amini
Hi, That 's a good idea.How can I run a c module in the exec-program-wait section? should I config the user file considering my sql based config? Regards, Hooman --- Chris Parker [EMAIL PROTECTED] wrote: At 05:30 AM 5/29/2002 -0700, Hooman Amini wrote: Greeting, I have used freeradius in a

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 01:50:01PM -0400, Alan DeKok wrote: Deramus, Chris [EMAIL PROTECTED] wrote: I have another group on which is using the VPN concentrators method of authentication, (only supports 500 users however, and we require 1500 or entries) and set that group up to pass all

Re: Problem with ld

2002-05-29 Thread Alexandre Strube
On Wed, 29 May 2002 08:55:23 +0400, äÉÎÁÒ wrote: REALLY STUPID question: After setting the ld path did you run ldconfig? Hello all, I know that this problem was discussed many times. But again I want to ask a question. I'm trying to compile freeradius on OpenBSD machine, but the postgresql

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type I reloaded the default sql.conf and made the necessary changes, in my previous sql.conf I forgot I was commenting out a few queries therefore it wasn't properly querying my database. With the default query's this is what I get. Instead of taking in

Quick dumb question

2002-05-29 Thread Spike Ilacqua
How do a tell if radiusd built threaded? I'm trying to build the latest CVS on BSDI 4.2. I while back I built 0.3 using libsem.a trick, but I've forgot how I forced it to build with threads. The current snapshot builds with a few tweaks with I will post separately, but when I last visited the

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
While i'm in a posting mood :) On Wed, May 29, 2002 at 02:00:55PM -0400, Deramus, Chris wrote: Alan, Thanks for your quick response, I will definitely give this a try. I like this product and I think it'll work out great once I can finish the configuration but let me ask you this. I

Building on BSDI 4.2

2002-05-29 Thread Spike Ilacqua
I needed to do 3 things to build on BSDI 4.2: 1) Add typedef unsigned short uint16_tn; to eap.h. The EAP code uses uint16_t in a number of places but BSDI doesn't have it. 2) Remove the definitions of INADDR_NONE and INADDR_ANY src/include/missing.h. 3) Add -I/usr/local/ssl/include to

Re: problem with compiling freeradius - newbie LONG

2002-05-29 Thread Alexandre Strube
On Wed, 29 May 2002 19:14:09 +0200, Rennes Neps wrote: Hello configuring in libltdl running /bin/sh ./configure --enable-ltdl-install --cache-file=.././config.cache --srcdir=. configure: error: ltdl-install: invalid feature name configure: error: ./configure failed for libltdl [root@radius

Using CHAP with FreeRADIUS 0.5 *newbie*

2002-05-29 Thread Tom Hornby
I can get freeRADIUS 0.5 to authenticate properly with my linux shadow file. However, I need to be able to authenticate properly using CHAP (not by choice) but don't want to go through the hassle of installing an SQL database. I know there is a way to specify a 'custom' password file but

Re: Building on BSDI 4.2

2002-05-29 Thread Alan DeKok
Spike Ilacqua [EMAIL PROTECTED] wrote: I needed to do 3 things to build on BSDI 4.2: 1) Add typedef unsigned short uint16_tn; to eap.h. The EAP code uses uint16_t in a number of places but BSDI doesn't have it. OK... I'll add that to the configure script. 2) Remove the definitions of

RE: Problems with MySQL Auth-Type

2002-05-29 Thread Deramus, Chris
Title: RE: Problems with MySQL Auth-Type Simon, For the record you are the man :). I'm *almost* there and I do appreciate you being in a good today...it must be my lucky day. I made the changes you suggested and I am now a step further, it does check the password file it seems, however it

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Nick Davis
We're trying to set up a web front, where all of this stuff can be changed without having to know any linux commands or mysql commands. I have the web front basically done, but tying it into FreeRadius would be nearly impossible from what I'm understanding. That means the password

Re: Using CHAP with FreeRADIUS 0.5 *newbie*

2002-05-29 Thread Alan DeKok
Tom Hornby [EMAIL PROTECTED] wrote: However, I need to be able to authenticate properly using CHAP (not by choice) but don't want to go through the hassle of installing an SQL database. I know there is a way to specify a 'custom' password file but cannot find any information on how to do

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 02:49:26PM -0400, Deramus, Chris wrote: I reloaded the default sql.conf and made the necessary changes, in my previous sql.conf I forgot I was commenting out a few queries therefore it wasn't properly querying my database. With the default query's this is what I get.

Re: Problems with MySQL Auth-Type

2002-05-29 Thread Simon
On Wed, May 29, 2002 at 02:44:23PM -0500, Nick Davis wrote: We're trying to set up a web front, where all of this stuff can be changed without having to know any linux commands or mysql commands. I have the web front basically done, but tying it into FreeRadius would be nearly

¶Ç¯u¸¹½X¥X°â

2002-05-29 Thread q7_1mnqb2b2bgj
¶Ç¯u¸¹½X¥X°â §Ú¦³¥_°Ï02_¶}ÀY¶Ç¯u¸¹½X¡A¦@¬°77270µ§ ¬O§Ú±q¦U­Ó¦P·~¤½·|¡B¹q¸Üï¡B¶À­¶¡B¼x«H©Ò¡B ºô»Úºô¸ô¡A¥úºÐ¤ù...µ¥µ¥¡A ¸g¦~²Ö¤ë¤@µ§¤µ§¥´¤J¦¬¶°¤U¨Óªº¡A¶O¤F«Ü¤jªº¥\¤Ò¡C ¥úªá¿ú¶R¼x«H©Ò¥Xªºªº¥U¤l¡A´Nªá¤F¤£¤Ö¿ú¡A ¦A¸g¹L²Î­p¤èªk¾ã²z¡A©Ò¥H¨S¦³¥ô¦ó¤@µ§¬O­«½Æªº¡A

failover_sql_suffix

2002-05-29 Thread Eric
Hi All over again it is necessary to try to lead autorize and accountig on local mysql the server. If it for any reason did not manage to be made to lead authorization and accounting on the remote radius server. I have solved this task so: authorize { group { sql { ... } suffix { ...

Re: Building on BSDI 4.2

2002-05-29 Thread Echo FreeRadius
Just for reference 0.5 builds better on BSDi 4.3, however I haven't managed to get it to compile with multiprocessor support. I needed to use ./configure --with-threads=no --with-mysql-lib=/usr/local/mysql/lib to get it to compile. Kelvin - Original Message - From: Alan DeKok

configuration

2002-05-29 Thread ming
how can i configure the freeradius server after installed

Re: prepaid timeouts

2002-05-29 Thread Michael Bailey
On Wed, May 29, 2002 at 09:07:43AM -0500, Chris Parker wrote: At 08:00 AM 5/29/2002 +, Michael Bailey wrote: Hello, I would like to use freeradius to offer a prepaid service where users can buy a certain number of days and will have unlimited use untill that period is up. Use the

Indonesia

2002-05-29 Thread Faye Dube
I am Faye Dube a South African and attorney to the family of President Suharto former president of Indonesia. I seek the assistance of some one who is genuinely interested in entering into a business relationship with long term focus, understanding and willingness of a kind heart to help.

where can I get EAP-MD5 supported supplicant in user side on red-hat 7.2?

2002-05-29 Thread Yi-Wen Liu
I use freeRADIUS 0.5 as my radius server and enable EAP. I use winXP embedded 802.1x as my user side supplicant (choose EAP-MD5)and can run successfully. But, I want to findEAP-MD5 supported supplicant in user side on red-hat 7.2. If you know where to get, please reply to me. Thanks a lot!