Re: help need with mysql statement in freeradius

Hi all, After many trial and errors my perl modules is working great. Thanks IVan, Alan and all of who helped me a lot. Well I am not programmer but search in google and you guys helped me a lot. One thing is I am not able to log my custom message of perl modules in radius.log. Is it

Re: help need with mysql statement in freeradius

Put the log line before return. Ivan Kalik Kalik Informatika ISP Dana 17/5/2008, Bishal [EMAIL PROTECTED] piše: Hi all, After many trial and errors my perl modules is working great. Thanks IVan, Alan and all of who helped me a lot. Well I am not programmer but search in google and you

Re: help need with mysql statement in freeradius

Hi, $RAD_REPLY{'Reply-Message'} = Mac Address Successfully updated in database $RAD_REQUEST{'Calling-Station-Id'}; return RLM_MODULE_OK; # Do some logging. radiusd::radlog(1,rlm_perl:: NEW MAC updated in database.); note the order of

Re: help need with mysql statement in freeradius

Bishal wrote: I am getting core dumped while running that script. rlm_perl: perl_embed:: module = /usr/local/etc/raddb/mac_check.pl , func = authorize exit status= Undefined subroutine main::authorize called You're supposed to define that function if you use rlm_perl. The examples have it

Re: help need with mysql statement in freeradius

Hi, $username = $RAD_REQUEST{'User-Name'}; $callerid = $RAD_REQUEST{'Calling-Station-Id'}; Is this the right process of getting value from the request ? How can I bypass perl function Authorization, authentication, accounting so that only MAC assignment process will be done by this script?

Re: help need with mysql statement in freeradius

Ugh, even if your script was working user still can't make it. rad_recv: Access-Request packet from host 202.xx.xx.xx:52743, id=81, length=151 NAS-Identifier = pppoe-test.lumbininet.com.np NAS-Port = 12 NAS-Port-Type = Ethernet Service-Type = Framed-User

Re: help need with mysql statement in freeradius

But my script is not working. How can I assign variables username and callingStationid in my script during authentication process. rlm_perl doc show %RAD_REQUEST{'User-name'} but it's not helping? That's because you havent mastered even more basic things such as how to concatenate a string. You

Re: help need with mysql statement in freeradius

PS. You should run your script in authorize. Ivan Kalik Kalik Informatika ISP Dana 15/5/2008, Bishal [EMAIL PROTECTED] piše: Hello Ivan, I came up with this scripts but looks like it;s not working. In radiusd.conf perl{ modules = /usr/local/etc/raddb/mac_check.pl } Instantiate {

Re: help need with mysql statement in freeradius

I am getting core dumped while running that script. rlm_perl: perl_embed:: module = /usr/local/etc/raddb/mac_check.pl , func = authorize exit status= Undefined subroutine main::authorize called Segmentation fault (core dumped) ##Script part use vars qw(%RAD_REQUEST %RAD_REPLY %RAD_CHECK);

Re: help need with mysql statement in freeradius

debug output of the radius Module: Instantiated detail (reply_log) Listening on authentication *:1645 Listening on accounting *:1646 Ready to process requests. rad_recv: Access-Request packet from host 202.xx.xx.xx:52743, id=81, length=151 NAS-Identifier = pppoe-test.lumbininet.com.np

Re: help need with mysql statement in freeradius

http://wiki.freeradius.org/Rlm_perl Ivan Kalik kalik Informatika ISP Dana 14/5/2008, Bishal [EMAIL PROTECTED] piše: Hi all, I am trying to do MAC insertion during post authentication section with the help of freeradius. Like during authentication section it will check in mysql database

Re: help need with mysql statement in freeradius

Hi Ivan, I am using sql for AAA. Can u give me some exaples how can I do that withl Rlm_perl modules.? Thanks On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: http://wiki.freeradius.org/Rlm_perl Ivan Kalik kalik Informatika ISP Dana 14/5/2008, Bishal [EMAIL PROTECTED] pi¹e: Hi all,

Re: help need with mysql statement in freeradius

I am using sql for AAA. I have news for you - you are not. You are using it to store attributes. Can u give me some exaples how can I do that withl Rlm_perl modules.? Do Google: mysql perl tutorial. If it's not MySQL, replace that with the name of your sql server. Ivan Kalik Kalik

Re: help need with mysql statement in freeradius

Any sample scripts IVAN? On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: I am using sql for AAA. I have news for you - you are not. You are using it to store attributes. Can u give me some exaples how can I do that withl Rlm_perl modules.? Do Google: mysql perl tutorial. If it's not

Re: help need with mysql statement in freeradius

You have something against learning? It shouldn't take more than a day to master this. Ivan Kalik Kalik Informatika ISP Dana 14/5/2008, Bishal [EMAIL PROTECTED] piše: Any sample scripts IVAN? On 5/14/2008, Ivan Kalik [EMAIL PROTECTED] wrote: I am using sql for AAA. I have news for you

Re: help need with mysql statement in freeradius

Hello Ivan, I came up with this scripts but looks like it;s not working. In radiusd.conf perl{ modules = /usr/local/etc/raddb/mac_check.pl } Instantiate { exec expr dailycounter noresetcounter perl } radius debug shows perl modules loaded. But my script is not working. How can I

help need with mysql statement in freeradius

Hi all, I am trying to do MAC insertion during post authentication section with the help of freeradius. Like during authentication section it will check in mysql database for MAC use option. If MAC use= 1 then if the user is login for the first time then grab the mac address from the login