Re: CLASS value in SQL xlat

2013-09-04 Thread Okis Chuang
Dear Arran, Much thanks! It works! Okis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

CLASS value in SQL xlat

2013-09-03 Thread Okis Chuang
Hi all, I'm using FR 2.2.0 with Oracle 11g. Now I'm collecting Accounting records into Oracle DB with sql xlat which call a function in PL/SQL. For example in debug mode it expands like below: %{sql:select wifi_acct.onlineStart(..., '%{Class[*]}',..) from dual} TestCL:

RE: coa

2013-07-23 Thread Okis Chuang
I think you should read documentation about CoA offered by your NAS. Then see what can likely be about *Missing Attribute* at least. You better know about all of Error-Cause it may occur. In my experience, it might be lack of key on identifying unique host. In other words, could it be your

Re: Delete one value of multiple attribute(Class)

2013-07-17 Thread Okis Chuang
Okis Chuang wrote: Actually I can write a short perl script to do this, but I try to do with pure unlang. Unlang is not really intended to do that. In fact, the reason why I need this function is that sometimes we treat some attributes as temporary variable for generating another

RE: Freeradius-Users Digest, Vol 99, Issue 55

2013-07-17 Thread Okis Chuang
Hi all, Really appreciate all your kind supports and helps very much. Alan..I didn't meant to be inaccurate about describing my situation...I just don't want to blur my question with too many details. Well, I think I didn't keep the balance well. If let you feel bad, I'm very sorry about that.

Re: Delete one value of multiple attribute(Class)

2013-07-17 Thread Okis Chuang
Hi all, Really appreciate all your kind supports and helps very much. Alan..I didn't meant to be inaccurate about describing my situation...I just don't want to blur my question with too many details. Well, I think I didn't keep the balance well. If let you feel bad, I'm very sorry about

Delete one value of multiple attribute(Class)

2013-07-16 Thread Okis Chuang
Dear all, I want to delete a specific AVP which could be one of multiple value attribute, such as *Class*. Suppose I have three Class value: Class 1, Class 2, Class 3. Then I want to remove Class 2 if its value matches the regex in the pre-proxy section. I've tried some unlang below but

Re: Delete one value of multiple attribute(Class)

2013-07-16 Thread Okis Chuang
Is there anyone can help? Actually I can write a short perl script to do this, but I try to do with pure unlang. So.if someone can told me whether this purpose can be done with only unlang, I can save lots of time on this endless trial. Lol In fact, the reason why I need this function is

RE: rlm_sql_oracle:libclntsh.so.11.1: cannot open shared object file

2013-05-28 Thread Okis Chuang
FreeRADIUS] [mailto:ml-node+s1045715n5720446...@n5.nabble.com] Sent: Tuesday, May 28, 2013 1:53 PM To: Okis Chuang Subject: Re: rlm_sql_oracle:libclntsh.so.11.1: cannot open shared object file On 28.05.2013 7:00, Okis Chuang wrote: Could not link driver rlm_sql_oracle: libclntsh.so.11.1: cannot open

rlm_sql_oracle:libclntsh.so.11.1: cannot open shared object file

2013-05-27 Thread Okis Chuang
Hi guys, I'm now trying to build another FreeRADIUS 2.2.0 with rlm_sql_oracle which using Oracle instantclient 11.2.0.3.0 and backend Oracle 11g. And the OS version is Linux x86_64 (including CentOS 6.2 RHEL Server 5 Tikanga). I've tried many times following step by step on google.

Re: How to fix the proxy source port

2013-04-29 Thread Okis Chuang
Chuang Okis wrote: I think you misunderstanding my point a bit. Maybe I don't express it clear enough. I only need fixing my *source port* instead of random port, I don't care IP address at all. Ah, OK. Actually, due to some maintenance issue, we want to know that could we fix our

Re: How to fix the proxy source port

2013-04-28 Thread Okis Chuang
quote author='Alan DeKok-2' Okis Chuang wrote: Can I FIX the source port rather than random src port when proxy request to other RADIUS server? I know it is able to fix src IP address in proxy.conf, but seems no config about fixed src port. What if I set src_ipaddr = 127.0.0.1

Originate CoA Request After Receiving Access-Accept

2013-04-26 Thread Okis Chuang
Dear all, From the originate-coa documentation, it seems I can't originate coa-request at the section of pre-proxy or post-proxy. It's documented, pretty clear. I'm not sure whether it is the cause of my following questions. But what if I need two steps below finished continually both in

RE: Freeradius-Users Digest, Vol 96, Issue 88

2013-04-26 Thread Okis Chuang
Okis Chuang wrote: From the originate-coa documentation, it seems I can?t originate coa-request at the section of pre-proxy or post-proxy. It?s documented, pretty clear. It's nice to hear that the documentation helps. :) I thought docs are very helpful at most

FW: Freeradius-UsRe: Originate CoA Request After Receiving Access-Accepters Digest, Vol 96, Issue 88

2013-04-26 Thread Okis Chuang
Okis Chuang wrote: From the originate-coa documentation, it seems I can?t originate coa-request at the section of pre-proxy or post-proxy. It?s documented, pretty clear. It's nice to hear that the documentation helps. :) I thought docs are very helpful at most

Re: Originate CoA Request After Receiving Access-Accept

2013-04-26 Thread Okis Chuang
Okis Chuang wrote: From the originate-coa documentation, it seems I can?t originate coa-request at the section of pre-proxy or post-proxy. It?s documented, pretty clear. It's nice to hear that the documentation helps. :) I thought docs are very helpful

How to fix the proxy source port

2013-04-24 Thread Okis Chuang
Hi all, Can I FIX the source port rather than random src port when proxy request to other RADIUS server? I know it is able to fix src IP address in proxy.conf, but seems no config about fixed src port. What if I set src_ipaddr = 127.0.0.1:3100 in proxy.conf, could this work? Thanks in

RE: Have anyone test the performance about FreeRADIUS+jRadius on authentication?

2013-04-23 Thread Okis Chuang
satisfy it by itself? Can it send CoA request to WiFi gateway after receiving some predefined attribute value with web portal while it sending access request to FreeRADIUS? I plan to make it become a policy manager. Cheers, Okis --- Chuang Okis wrote

Have anyone test the performance about FreeRADIUS+jRadius on authentication?

2013-04-23 Thread Okis Chuang
Thanks Fajar your speedy response and really helpful for me. Yeah..I'm pretty grateful about all contributions here for sure! And I'm definitely not insist on desiring the best solution here. I just want to listen some opinions or advice from all those experienced. Anyway, I'll keep learning