Repost problem using Oracle backend in thraded mode
Has someone an idea what happens with this? I paste my last post, Best regards, Rodrigo Gonzalez. The problem is still there, but I notice something, the user I tested has anempty password, I tested with a non empty password user and everything isok.I uncommented two DEBUG lines in rlm_sql and get this running radiusd -xxrlm_sql: check items Password == "[EMAIL PROTECTED]@\001"and running radiusd -xxsrlm_sql: check items Password == ""Maybe this can help someone with thisRegards,Rodrigo Gonzalez.
Re: FreeRadius with Oracle backend
The problem is still there, but I notice something, the user I tested has an empty password, I tested with a non empty password user and everything is ok. I uncommented two DEBUG lines in rlm_sql and get this running radiusd -xx rlm_sql: check items Password == "[EMAIL PROTECTED]@\001" and running radiusd -xxs rlm_sql: check items Password == "" Maybe this can help someone with this.... Regards, Rodrigo Gonzalez. - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 28, 2003 1:05 PM Subject: Re: FreeRadius with Oracle backend > "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote: > > Every auth request (made with radclient) is rejected with this error: No > > matching entry in the database for request from user [] > > The user exists. > > If I run freeradius with -s the problem does not existsis there any > > problem with threads and Oracle? > > Grab the latest CVS snapshot. It has at least one fix to the Oracle > code. > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius with Oracle backend
I am testing freeradius using Oracle and I have this problem. Every auth request (made with radclient) is rejected with this error: No matching entry in the database for request from user [] The user exists. If I run freeradius with -s the problem does not existsis there any problem with threads and Oracle? Best regards, Rodrigo.
Re: time format
Use AcctStartTime NOT h323-setup-time - Original Message - From: Raymond Chen To: [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 3:10 PM Subject: time format Dear list, Trying to setup the radius to write CDR straight to MySQL database. But the time from NAS as h323-setup-time=02:05:44.512 CN Thu Aug 15 2002 and in the MySQL database script, the time is define as -00-00 00:00:00. So when radius trys to insert to database, it returns an error say the format is incompatible. Any solution to this. Best Regards Raymond
Re: session timeout attribute
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 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, check your tcl before > > using it > > > > - Original Message - > > From: "Hooman Amini" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, May 29, 2002 9:14 AM > > Subject: session timeout attribute > > > > > > > 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 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 UNKNOWN-CLIENT:0 - ID 2 : IGNORED > > > > > > > > > > After that it was dead. No sig 11, no core file. > > > > > > > > Hi, > > > > > > > > SIG11 usually means hardware problems but since this time you say it > > died > > > > from no aparent reason and without core dumping I don't know. Are you > > seeing > > > > this behaviour with other apps on your system ? > > > > > > > > - Giovanni > > > > > > > > - > > > > List info/subscribe/unsubscribe? See > > > http://www.freeradius.org/list/users.html > > > > > > > > > __ > > > Do You Yahoo!? > > > Yahoo! - Official partner of 2002 FIFA World Cup > > > http://fifaworldcup.yahoo.com > > > > > > - > > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > - > 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: session timeout attribute
h323-credit-time it depends on tcl if it use the return value or not, check your tcl before using it - Original Message - From: "Hooman Amini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 9:14 AM Subject: session timeout attribute > 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 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 UNKNOWN-CLIENT:0 - ID 2 : IGNORED > > > > > > After that it was dead. No sig 11, no core file. > > > > Hi, > > > > SIG11 usually means hardware problems but since this time you say it died > > from no aparent reason and without core dumping I don't know. Are you seeing > > this behaviour with other apps on your system ? > > > > - Giovanni > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
SQL Module
I found a little problem with this module. Whenever it receives a user with an IP format, example: 10.1.2.3 it returns failed and it is wrong. I search the code and found that the problem is with this line: radius_xlat(querystr, MAX_QUERY_LEN, inst->config->authorize_check_query, request, sql_escape_string); After changing this line to: radius_xlat(querystr, MAX_QUERY_LEN, inst->config->authorize_check_query, request, NULL); everything goes fine... Regards.
SNMP
Could someone explain me if there is any way of fetch information about freeradius using SNMP? What is the configuration needed to do this? Regards.
Re: Fix for Exec-Program-Wait
Two daysif it runs all weekend without problems I think it is fixedon monday I tell you BTW: is there any radius library? I need to add auth request capabilities to a soft and I don't find any library to do this - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:28 PM Subject: Re: Fix for Exec-Program-Wait > "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote: > > It is running from yesterday and I do no see any problem, it never runs for > > more than 2 hours so I think the problem is fixed. > > That's what I like to hear, thanks! > > Alan DeKok. > > - > 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: Fix for Exec-Program-Wait
It is running from yesterday and I do no see any problem, it never runs for more than 2 hours so I think the problem is fixed. Regards, Rodrigo Gonzalez. - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:06 PM Subject: Re: Fix for Exec-Program-Wait > "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote: > > I am testing it right nowthe only thing I changed is: > > OK... so have you noticed any problems? > > Alan DeKok. > > - > 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: HELP!!!!!!! I'm so confused
raddb/sql.conf - Original Message - From: "Steve Camacho" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 3:09 PM Subject: RE: HELP!!! I'm so confused > Where can I find the queries to edit. The only thing I see is the > script that creates the default table. > > steve > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Alan DeKok > Sent: Thursday, May 23, 2002 12:33 PM > To: [EMAIL PROTECTED] > Subject: Re: HELP!!! I'm so confused > > "Steve Camacho" <[EMAIL PROTECTED]> wrote: > > I wanted to design my own database and point freeRADIUS to certain > > tables and fields within the DB. > > FreeRADIUS lets you do this. That's why the SQL queries are > customizable. > > For the default MySQL tables, ee: > > See 'src/modules/rlm_sql/drivers/rlm_sql_mysql/ > > > What I really need is more detailed instruction for installation on > > FreeBSD 4.2 using mySQL. > > There isn't much in the way of documentation. Set up the database, > create the tables, edit the queries, and it should work. > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > - > 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: Fix for Exec-Program-Wait
I am testing it right nowthe only thing I changed is: radlog(L_DBG, "Exec-Program: returned: %d", status); to radlog(L_INFO, "Exec-Program: returned: %d", status); To allow me to quickly watch any problem with the external auth program... Regards, Rodrigo Gonzalez. - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 4:05 PM Subject: Fix for Exec-Program-Wait > I've just committed a fix to the tree which should *hopefully* fix > the problem with the server locking up, when using Exec-Program-Wait. > > If you're using Exec-Program-Wait, and are willing to test the CVS > snapshot from tonight, please try it out, and report success/failure > to the list. > > If this change doesn't solve the problem, then there's more work to > do. If it DOES solve the problem, then it would help enormously to > know that. > > Alan DeKok. > > - > 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: cisco_vsa_hack doesn't run - success.. and a question..
All h323 attributes has the same problem with cisco gateways - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 11:28 AM Subject: Re: cisco_vsa_hack doesn't run - success.. and a question.. > Michael Shurtleff <[EMAIL PROTECTED]> wrote; > > OK, now it works. Now could someone on the development side tell me the > > purpose of the following statement in the code inside cisco_vsa_hack() in > > the rlm_preprocess.c file (which I commented out to make the vsa_hack > > work). I don't want to solve one problem in order to create another. > > > > if ((vp->attribute & 0x) != 1) continue; > > This code only does the hacking for the Cisco-AVPair attribute. If > the other Cisco attributes are screwed up, too, then we can remove > that line. > > I actually asked one of the RADIUS guys at Cisco about this, but > didn't get any response. I guess they think that this sort of > annoying thing is acceptable. > > Alan DeKok. > > - > 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: CPU
OS: Linux Kernel 2.2.17 Modules: SQL Top shows that is a radius daemon the one who has 99% of CPU usage It 'is not working in debug mode Regards. - Original Message - From: "Chris Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 11:39 AM Subject: Re: CPU > At 12:12 PM 5/2/2002 -0300, Rodrigo Gonzalez wrote: > >I tried latest CVS and the CPU issue is not solved, maybe I am doing > >something wrong.I test configuring delete_blocked_request yo yes and > >no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I > >need to restart the daemon > > What OS? Also, what modules are you using ( LDAP, SQL, ??? ). What does > 'top' show. Is FreeRADIUS the cpu hog? Does it happen in debug mode? If > so, what is FreeRADIUS doing when it spikes CPU ( based on debug message > output ). > > -Chris > -- > \\\|||/// \ StarNet Inc. \Chris Parker > \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering > | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 > oOo---(_)---oOo--\-- >\ Wholesale Internet Services - http://www.megapop.net > > > > - > 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: CPU
I really don't knnow how to do this, could someone explain it? Regards. - Original Message - From: "Alan DeKok" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 1:04 PM Subject: Re: CPU > "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote: > > I tried latest CVS and the CPU issue is not solved, maybe I am doing = > > something wrong.I test configuring delete_blocked_request yo yes and = > > no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I = > > need to restart the daemon > > That's bad. > > Can you trace it with gdb, to see what's happening? > > Alan DeKok. > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I tried latest CVS and the CPU issue is not solved, maybe I am doing something wrong.I test configuring delete_blocked_request yo yes and no, but it is the sameafter 2 or 3 hours the CPU goes to 99% and I need to restart the daemon Regards, Rodrigo Gonzalez.
CPU
I run freeradius 0.5 on a linux box with threads enabled. Whenever the server receives a Duplicate request the CPU goes up till the server hangs The log show this... Tue Apr 23 13:53:58 2002 : Error: Dropping duplicate authentication packet from client 2600.nas:1645 - ID: 219 And after thie I have to restart the dameon I searched in the mailing archive but I have not found a solution... Regards, Rodrigo Gonzalez. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
CPU
I run freeradius 0.5 on a linux box with threads enabled. Whenever the server receives a Duplicate request the CPU goes up till the server hangs The log show this... Tue Apr 23 13:53:58 2002 : Error: Dropping duplicate authentication packet from client 2600.rosario:1645 - ID: 219 And after thie I have to restart the dameon I searched in the mailing archive but I have not found a solution... Regards, Rodrigo Gonzalez. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html