Question on processing delayed proxy packets

2009-12-10 Thread Patric
SQL statement, but I would appreciate any comments on the idea and any experience others have had with this. Many thanks, Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Changing the format of a date attribute

2009-12-09 Thread Patric
Hi again all :) Patric wrote: Alan DeKok wrote: Patric wrote: Is there any way for me to get my FreeRADIUS-Acct-Session-Start-Time attribute value into that date format? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime So now I have the following

Re: Changing the format of a date attribute

2009-12-09 Thread Patric
Alan DeKok wrote: On 09-12-09 11:37 AM, Patric wrote: The problem with the above is that some of those formatting options ('%M %d %Y %H:%i:%s') are also defined as one-character variables, so instead of formatting the date with those options, its replacing each with the variable value

Changing the format of a date attribute

2009-12-08 Thread Patric
into that date format? Any advice would be very much appreciated. Many thanks, Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Changing the format of a date attribute

2009-12-08 Thread Patric
Alan DeKok wrote: Patric wrote: Is there any way for me to get my FreeRADIUS-Acct-Session-Start-Time attribute value into that date format? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_from-unixtime You sir are a genius :) It didnt even occur to me to do

Re: Possible to add a NAS in any MySQL table?

2009-12-08 Thread Patric
# be done live while the server is running. # readclients = yes # Table to keep radius client info nas_table = nas sql/${database}/dialup.conf: nas_query = SELECT id, nasname, shortname, type, secret FROM ${nas_table} HTH Patric

Handling proxied accounting updates that have been delayed

2009-12-07 Thread Patric
, so basically if the record already exists then leave that as the start time? But as I type it now I realise this will break the delay time calculation so there will be no way to calculate the real start time... Any advise or experiences would be much appreciated! Many thanks Patric

Re: Proxy to multiple servers in FR 2.1.7

2009-11-13 Thread Patric
to ip_address_of_server_A port 1813 You can see from the line above that it is sending this request to server A as well. This is where Im getting stuck :( Any pointers, suggestions, examples appreciated as always. Thanks again, Patric Craig Campbell wrote: Re: Do I need a second site

Re: Proxy to multiple servers in FR 2.1.7

2009-11-13 Thread Patric
understand how, clearly Im missing or not understanding something *bangs head on wall* Thanks for your patience and time! Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Proxy to multiple servers in FR 2.1.7

2009-11-13 Thread Patric
they both process that packet? Hope that clarifies a bit. Thanks Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Proxy to multiple servers in FR 2.1.7 [Solved]

2009-11-13 Thread Patric
as always, Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Proxy to multiple servers in FR 2.1.7

2009-11-12 Thread Patric
using the default realm so I dont know how to setup a second home_server_pool either... Any help is much appreciated, Im going in circles :) Many thanks Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Send accounting packets to multiple proxy servers

2009-11-11 Thread Patric
home_server = copy-acct-to-server-C } realm DEFAULT { acct_pool = my_acct_failover nostrip } Im not too sure where to go here, any help would be much appreciated as always! Many thanks, Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: No NAS-Port seen warning

2009-10-16 Thread Patric
Robert White wrote: Hey, Or can I make rlm_acct_unique look for Quintum-NAS-Port instead of just NAS-Port? Yup, just update modules/acct_unique HTH Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Question regarding retrying of requests in detail-combined file

2009-10-15 Thread Patric
it... Any pointers to sections/docs would be great as always, Thanks a mill! Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Question regarding retrying of requests in detail-combined file

2009-10-15 Thread Patric
-server check_interval = 10 num_answers_to_alive = 1 no_response_fail = yes } Thanks again! Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Small suggestion for FreeRadius debug output

2009-10-15 Thread Patric
Proxy-State = 0x323138 [2009-10-15 10:00:00] Finished request 701. [2009-10-15 10:00:01] Cleaning up request 701 ID 0 with timestamp +1286 [2009-10-15 10:00:01] Going to the next request [2009-10-15 10:00:02] Waking up in 0.3 seconds. Just a thought :) Thanks for everything! Patric - List info

Re: Small suggestion for FreeRadius debug output

2009-10-15 Thread Patric
Alan Buxey wrote: add a small 'x' ie radiusd -Xx (this was mentioned on this list a couple of days back) Arg, Im a dumbass... Sorry I must have missed it :) Thanks! Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Question regarding retrying of requests in detail-combined file

2009-10-15 Thread Patric
Alan DeKok wrote: Patric wrote: And 30 seconds later the request is retried and succeeds :) Is there any way for me to decrease the retry delay? See the retry_interval configuration in the detail listener. Hi Alan, Would I be correct in my understanding that I add that here

Adding vendor specific attributes to dictionary

2009-10-09 Thread Patric
/dictionary.myvendor[1]: dict_init: /etc/ Thats it - even in debug mode no other message is printed. Any pointers would as always be very much appreciated :) Many thanks and have a great Friday, Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Adding vendor specific attributes to dictionary

2009-10-09 Thread Patric
:) I have narrowed the problem down to the number field. The actual number I have been given to use is 32768, and the problem seems to be the fact that the number is 5 digits long. If I make the number 4 digits long my server starts up without complaint. Any suggestions? Many thanks, Patric

Re: Adding vendor specific attributes to dictionary

2009-10-09 Thread Patric
Alan DeKok wrote: Patric wrote: I have narrowed the problem down to the number field. The actual number I have been given to use is 32768, Install 2.1.7. See doc/ChangeLog Aaah, 2.1.7 Changelog: * Allowed vendor IDs to be be higher than 32767. Fantastic, upgrading now

Re: Setting up a virtual server to handle incoming proxied requests

2009-09-28 Thread Patric
Alan DeKok wrote: Patric wrote: I see I see, so I would only add a listen section if I were listening on a different interface or port? Yes. I think I get the proxying now :) proxy_requests = yes just makes the server process the detail-combined log right

Setting up a virtual server to handle incoming proxied requests

2009-09-25 Thread Patric
appreciate any pointers :) Many thanks Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Setting up a virtual server to handle incoming proxied requests

2009-09-25 Thread Patric
to load clients from SQL. To resolve this should I now remove the primary server from my nas table as I am defining it in the clients.conf ? Or is there a way to leave it in the nas table and assign a virtual_server directive to it? Thanks for the time and patience Patric - List info/subscribe

Re: Setting up a virtual server to handle incoming proxied requests

2009-09-25 Thread Patric
Alan DeKok wrote: Patric wrote: server requests_from_primary { listen { ipaddr = * port = 0 type = acct } Delete that listen section. It conflicts with the global one. The global one will accept packets on the accounting port, IP *, and will look

Re: Setting up a virtual server to handle incoming proxied requests

2009-09-25 Thread Patric
file, runs the sql update and returns a response - 100% what I was trying to achieve! Have a great weekend! Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Problem with proxying accounting packets on FR 2.1.3

2009-09-23 Thread Patric
relevant info but please advise if anything further is required. Many many thanks as always Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Problem with proxying accounting packets on FR 2.1.3

2009-09-23 Thread Patric
. Great thanks Alan, Ill give that a bash. Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Radclient PHP

2009-04-02 Thread Patric
.' disconnect '.$RadiusPassword.' 21'; $CommandResult = shell_exec($Command); $CommandResult will hold the entire result. HTH Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Relaying of accounting requests between Freeradius servers

2009-03-18 Thread Patric
a.l.m.bu...@lboro.ac.uk wrote: I have finally been able to upgrade my secondary freeradius server to 2.1.3 and I must commend everyone on their hard work, the changes are great :) any reason why not 2.1.4 ? :-) 2.1.3 was what was available when I downloaded... :) But now that Im

Re: Relaying of accounting requests between Freeradius servers

2009-03-18 Thread Patric
might be able to update it in the pre-proxy section, but then it occurred to me that I need to preserve the NAS-IP-Address as this is one of the values I need to send in a disconnect request :( Anything else you might be able to suggest? Many thanks Patric - List info/subscribe/unsubscribe? See

Re: Relaying of accounting requests between Freeradius servers

2009-03-18 Thread Patric
Alan DeKok wrote: Use Client-IP-Address, not NAS-IP-Address. The Client-IP-Address is the source address of the RADIUS packet. NAS-IP-Address is an attribute inside of the RADIUS packet. It can have nearly any value, including 127.0.0.1, or 0.0.0.0. Thanks Alan, I will see if I can figure

Re: Relaying of accounting requests between Freeradius servers

2009-03-18 Thread Patric
-Address != other_freeradius_server_ip) { update control { Proxy-To-Realm := PROXYME } } Many thanks Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Relaying of accounting requests between Freeradius servers

2009-03-17 Thread Patric
with a duplication error? Many thanks Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Relaying of accounting requests between Freeradius servers

2009-03-17 Thread Patric
Fantastic Ivan, thats exactly what I was heading towards :) Let me try this and see if my root problem is resolved! Thanks Configure server 2 *not* to proxy requests coming from server 1 back to it. And server 1 not to proxy requests coming from server 2 back to it. There is no reason to send

Re: How to return Reply-Message when user submitted wrong password

2007-11-08 Thread Patric
. Thanks in advance! -- Best Regards, SC Be careful with this, do you REALLY want to tell a possible attacker what they are doing wrong? Also many clients will completely ignore the reply message anyway... HTH Patric -- Q: I want to be a sysadmin. What should I do? A: Seek professional

Re: Access-Reject in a php script

2007-10-30 Thread Patric
Alan DeKok wrote: Yes, the debug output helped. It looks like it's an issue with src/main/exec.c. The code calling module_authorize() should treat FAIL the same as REJECT. Is that src/main/exec.c or src/main/auth.c? If I look at src/main/auth.c I see the following : int

Re: Access-Reject in a php script

2007-10-30 Thread Patric
Alan DeKok wrote: Is this even considered a bug? Can we expect this to be changed in the future? Yes. Not sure if you looked at the changes I originally made to rlm_exec.c but if you did, I was curious as to whether those changes contradicted the FreeRadius RFC's at all? I dont *think*

Re: Access-Reject in a php script

2007-10-26 Thread Patric
Alan DeKok wrote: There is no need to change the code. If your script exits with a non-zero exit code, then the authentication fails. If this isn't happening, then something else is going on, or you're not doing what you're saying you're doing. Rather than discuss what you think you're

Re: Access-Reject in a php script

2007-10-26 Thread Patric
manIP wrote: Hi everyone! Thank your for your answers... Alan, Patric has totally right. I've set the reject_delay to 0 and the result was the same. I really don't want to touch to the source code and I am sure we can find another way 1) if there is a server timeout, is it assumed

Re: Access-Reject in a php script

2007-10-26 Thread Patric
Alan DeKok wrote: Patric wrote: Something just occurred to me that I dont think I tried before. What happens if instead of doing an exit(2); you do a return(2); This way your script will still exit clean, so freeradius wont pick it up as a script failure, but hopefully will still get

Re: Access-Reject in a php script

2007-10-26 Thread Patric
manIP wrote: hereunder is the output debug: rad_recv: Access-Request packet from host x.x.x.x:2658, id=49, length=58 User-Name = xxx User-Password = xxx Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module

Re: Access-Reject in a php script

2007-10-25 Thread Patric
failed and does not respond to the access-request... HTH Patric -- Q: I want to be a sysadmin. What should I do? A: Seek professional help. -- Find out how you can get spam free email. http://www.bluebottle.com/tag/3 - List

Re: Access-Reject in a php script

2007-10-25 Thread Patric
Alan DeKok wrote: Patric wrote: But when you exit(2) in PHP, freeradius thinks that the script failed and does not respond to the access-request... It delays the Access-Reject. See the debug output. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list

Re: Access-Reject in a php script

2007-10-25 Thread Patric
manIP wrote: Hi, I have put exit(2) but as Patric said, freeradius thinks that the script failed and does not respond to the access-request. In the client side, there is a server time out...I don't know if that server time out is assumed as an Access-Reject? No it does not assume an access

Re: LOGs of free radius

2007-10-03 Thread Patric
missingok } /var/log/radius/radwtmp { monthly rotate 4 create compress missingok } /var/log/radius/sqltrace.sql { monthly rotate 4 create compress missingok } HTH Patric -- Q: I want to be a sysadmin. What should I do

Will connection attempts from NAS' not in nas table be logged?

2007-09-06 Thread Patric
mode? Many thanks! Patric -- Q: I want to be a sysadmin. What should I do? A: Seek professional help. -- Find out how you can get spam free email. http://www.bluebottle.com/tag/3 - List info/subscribe/unsubscribe? See http

Re: Will connection attempts from NAS' not in nas table be logged?

2007-09-06 Thread Patric
Patric wrote: Hi Guys, Just a quick question, as the per the subject line : If my freeradius server receives a connection attempt from a NAS not listed in the NAS table (as specified in sql.conf : nas_table = nas), will that attempt appear in the radius.log, or would such information only

Re: UNSUBSCRIBE

2007-06-19 Thread Patric
Florian Reinholz wrote: UNSUBSCRIBE No! ;] -- Q: I want to be a sysadmin. What should I do? A: Seek professional help. -- Free pop3 email with a spam filter. http://www.bluebottle.com - List info/subscribe/unsubscribe?

Re: Including Vendor specific dictionary file

2007-05-25 Thread Patric
[EMAIL PROTECTED] wrote: Hi, I have created a vendor specific dictionary file for freeradius. This file includes two attributes for our mini switches. Is it possible to include this file within the next freeradius release? AFAIK you can just include it via the {sysconfig

Freeradius pauses before responding when not running in debug mode

2007-05-25 Thread Patric
Hi all, As per the subject, I have found the following interesting behaviour with freeradius 1.1.6 When running the server in normal mode or in debug level 1 mode : radiusd -y or radiusd -y -x (lowercase x) When sending an access request, the server pauses for a few seconds somewhere in

FYI : My workaround for freeradius not sending back an Access-Reject on a failed external script

2007-05-25 Thread Patric
Hey guys, Thought it might interest some of you as to how I worked around the problem where freeradius does not return an Access-Reject if my php script does not exit successfully (in my case because a user should be rejected). The original code that checks the exit status of the script is

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Alan DeKok wrote: Patric wrote: I just want to clarify, if I set the reject_delay to 0, and in my external script the only thing I do is exit(1);, then freeradius will return a reject response to the NAS? It will send a reject to the NAS. Thanks Alan, you're an absolute gem! Patrick

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Alan DeKok wrote: Patric wrote: I just want to clarify, if I set the reject_delay to 0, and in my external script the only thing I do is exit(1);, then freeradius will return a reject response to the NAS? It will send a reject to the NAS. Sorry if Im flogging a dead horse here... I

Re: Question regarding external script authentication

2007-05-18 Thread Patric
[EMAIL PROTECTED] wrote: you have various other attributes in your real production system - perhaps you have matching DEFAULT values (eg in users file) which are aiding the access accept? If that were the case, then wouldnt this eliminate the problem: My radiusd.conf authorize section

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Patric wrote: [EMAIL PROTECTED] wrote: you have various other attributes in your real production system - perhaps you have matching DEFAULT values (eg in users file) which are aiding the access accept? If that were the case, then wouldnt this eliminate the problem: My radiusd.conf

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Alan DeKok wrote: It's a bug in 1.1.x. It's fixed in 2.0.0 Ah great, at least that explains it! I see the latest public release is 1.1.6, is 2.0.0 available perhaps in the cvs? Would you say it is stable enough to run in production yet? If not any ETA? Otherwise can you suggest any

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Alan DeKok wrote: See the main web page? It's all there... Read, and understood :] Out of curiosity I did compile the latest snapshot, and I see that it is fixed, and even returns the correct status based on what your external script returns (1 - rejected, 4 - handled, 5 - invalid,

Re: Question regarding external script authentication

2007-05-18 Thread Patric
Alan DeKok wrote: [EMAIL PROTECTED] wrote: It seems to be in the news section on all the pages *except* the main one. Your browser has cached the main page. Alan you're gonna give us all an inferiority complex if you continue to be right all the time! ;] Cheers

Question regarding external script authentication

2007-05-17 Thread Patric
Hi all, I am currently using exec to authenticate users through an external script. When all criteria match I return the correct access-accept pairs and the users authenticate successfully. When the criteria are NOT met, I exit(1) my php script to hand control back to the freeradius server.

Re: Question regarding external script authentication

2007-05-17 Thread Patric
Hi Alan, Thanks for ur response. Alan DeKok wrote: Set reject_delay = 0 in radiusd.conf. I just want to clarify, if I set the reject_delay to 0, and in my external script the only thing I do is exit(1);, then freeradius will return a reject response to the NAS? Or will it simply not

Re: Duplicate accounting log entries

2007-04-04 Thread Patric
Hi again, Thanks a stack for your responses, I have a much better understanding of how it works now! Yes I do have the acct_unique_id setup as below, and have managed to weed out a lot of the duplication now. Dennis Skinner wrote: No. Look in the radius.conf for a section that looks like

Re: Duplicate accounting log entries

2007-04-04 Thread Patric
Hi guys, The NAS maintainer was nice enough to get back to me, and problem has been sorted out. This is what was happening: Their proxy servers are behind a load sharing device, which is why the retransmission of one of the records had a different client_ip_address, but both entries came from

Duplicate accounting log entries

2007-04-03 Thread Patric
Hi guys, Hope someone can help, as this has me banging my head on the wall :] I am getting duplicate updates from my NAS, and Im trying to figure out how to prevent them from being written to my accounting logs table. I unfortunately have absolutely no control over the NAS, so thats not even

Re: Duplicate accounting log entries

2007-04-03 Thread Patric
My apologies, a piece of my explanation is not right... please see below. Sorry, bit of a complex explanation... :] Hi guys, Hope someone can help, as this has me banging my head on the wall :] I am getting duplicate updates from my NAS, and Im trying to figure out how to prevent them from

Re: Duplicate accounting log entries

2007-04-03 Thread Patric
Alan DeKok wrote: Your NAS is broken. Knowing that doesn't help much, but your NAS is definitely broken. I suspected as much. Unfortunately it is a huge company whose NAS it is, and it is doubtful that the would notice my little squeek from down here... :] 2 of these records have the

Auth Type when running exec script to authenticate

2007-01-24 Thread Patric
found for the request: Rejecting the user auth: Failed to validate the user. Can anyone point me in the right direction with this problem? radiusd: FreeRADIUS Version 1.1.3, for host i686-redhat-linux-gnu, built on Sep 20 2006 at 14:13:13 Thanks in advance Patric

Setting check pairs in script when using exec

2007-01-24 Thread Patric
not sure how to accomplish this. Can anyone point me in the right direction with this problem? radiusd: FreeRADIUS Version 1.1.3, for host i686-redhat-linux-gnu, built on Sep 20 2006 at 14:13:13 Thanks in advance Patric -- Looking

Re: proxy authentication

2006-12-28 Thread Patric
the script via exec during authentication. I do something similar to log failed/unsuccessful login attempts. HTH Patric -- Earn Your Teaching Degree Online Become a teacher with our elite online program. Get free info today! http

Re: DEFAULT access-reject Reply-Message

2006-11-30 Thread Patric
at what Windoze does with Reply-Messages - nothing! It dumps them. HTH Patric -- Online Criminal Justice Programs Criminal Justice careers are booming. Education-Advancement offers... http://tagline.bidsystem.com/fc

Re: build rpm packages on centOS

2006-11-14 Thread Patric
statement to make -i HTH Patric - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: build rpm packages on centOS

2006-11-14 Thread Patric
Michael Messner wrote: Patric sagte: Have you tried compiling the source? that works! if I add the -i in the spec file there is no change ... same error! thanks mIke So it compiles from source? Ok, what is your rpmbuild command? Patric - List info/subscribe/unsubscribe? See http

Re: Multiple input_pairs?

2006-11-02 Thread Patric
Alan DeKok wrote: Patric [EMAIL PROTECTED] wrote: Is it possible to specify multiple input pairs? No. If you want that functionality, use rlm_perl. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog

rlm_exec documentation

2006-11-01 Thread Patric
Hi guys, Im busy trying to figure out how to implement rlm_exec, and am really battling to find documentation to this end. Can anybody point me in the right direction, I dont mind doing the legwork myself, but Im getting nowhere fast... I am using freeradius 1.1.3 Thanks a stack! Patric

Re: rlm_exec documentation

2006-11-01 Thread Patric
Patric wrote: Hi guys, Im busy trying to figure out how to implement rlm_exec, and am really battling to find documentation to this end. Can anybody point me in the right direction, I dont mind doing the legwork myself, but Im getting nowhere fast... I am using freeradius 1.1.3 Thanks

Multiple input_pairs?

2006-11-01 Thread Patric
Hi, Is it possible to specify multiple input pairs? EG: exec { wait = yes input_pairs = request,config shell_escape = yes output = none } If it is possible would the above syntax be correct? TIA Patric - List info