Re: Q:ABOUT:EXECUTE QUERY

2006-09-11 Thread Alan Lumb
Hello. My scenario is the next. I need to detect the telephone number that dial to my NAS (Network Access Server) and validate if that number exist in my database to retrieve some information, if that telephone number dosenĀ“t exist i need to insert it's data. Then. 1. How can i get

RE: Mysql procedure and freeradius

2006-08-10 Thread Alan Lumb
I think maybe it could be a problem if the version of mysql.h that was during compilation used predates stored proceedures? Hi, That cant be the case, im using mysql 5 and a SP with freeradius 1.1.2 without any problems or recompiling. It must be an other issue. Maybe the sql user you let

Re: Unresponsive child

2006-08-09 Thread Alan Lumb
I do exactly the same thing as you - I get this problem from time to time (usually accompanied by a few discarding duplicate request messages as the nas re attempts). The documentation says that if you get these its probably back end, and its right. Usually its a slow query of some description,

Re: Mysql procedure and freeradius

2006-08-09 Thread Alan Lumb
ensure the user has Process_priv. Also there is the security_type flag in the mysql.proc table which defines who the proceedure runs as (invoker or definer) Its all quite well documented on the mysql website. Hi All. I have the trouble with mysql freeradius.I begin to write own

Re: DynaLoader loading problem

2006-07-31 Thread Alan Lumb
Looks to me like the version of Dynaloader.so that rlm_perl is using is newer than the version of Dynaloader.pm thats in the path. Dynaloader.pm comes as part of perl, so there must be a version on your hard disk somewhere either not in the path or coming in lower down your path list than the one

Re: How to execute TWO OR MORE Sql statement?

2006-07-26 Thread Alan Lumb
Create a stored procedure in the database that contains all of the SQL queries necessary. Then call that stored procedure via sql.conf. This works fine with Postgres. MySQL 5 supports stored proceedures and functions, however I know that mysql proceedures can cause problems as they can/will

Cisco-AVPair Route Map

2006-04-18 Thread Alan Lumb
Hi Everyone. I'm struggling to find concise documentation on Cisco-AVPairs (and what pairs cisco support) - can anyone help me with this? Mainly I am trying to setup a walled garden system based on radius reply, using a route map with set next hop e.g. route-map walled-garden permit 10 set ip

Re: perl scripts

2006-03-19 Thread Alan Lumb
This is the routine I use, uses the MD5 modules from CPAN. Very messy and stolen from about 5 different sources... The three inputs are the hashed reply, the actual password from your database and the challenge that was sent to the user. I think this works OK. my $cpass =$_[0];

Re: problems compiling, but works, or don't??

2006-01-26 Thread Alan Lumb
On non i386 32bit architecture (both sun and intel 64) i've had some problems compiling rlm_perl with the distributed libtool, yet had problems compiling the rest using --with-system-libtool! Unfortunately I didnt collect enough information to submit a bug report, but errors varied from what was

Re: RLM_perl and Cisco-AVPair

2006-01-25 Thread Alan Lumb
! On Wednesday 25 January 2006 00:17, Alan Lumb wrote: push(@avpairs,'ip:dns-servers=$dns1 $dns2'); push(@avpairs,ip:route=$$thisroute{network} $$thisroute{subnet}); $RAD_REPLY{'Cisco-AVPair'[EMAIL PROTECTED]; This code works for me on freeradius 1.1.0. Which version you are using ? -- Best Regards

Re: RLM_perl and Cisco-AVPair

2006-01-25 Thread Alan Lumb
Im trying to get RLM_perl to respond with two Cisco-AVPair lines (what would usually be done with += in users) So try that with rlm_perl the server functions that update the list need to see the += operator. I don't believe it works like that with rlm_perl, as += in perl means 'add as an

RLM_perl and Cisco-AVPair

2006-01-24 Thread Alan Lumb
Hi everyone. Im trying to get RLM_perl to respond with two Cisco-AVPair lines (what would usually be done with += in users) Unfortunately only the first seems to get sent back to the nas - debug output follows rlm_perl: Added pair Cisco-AVPair = ip:dns-servers=10.10.10.10 10.10.10.12 rlm_perl: