Hi, sorry for the late replay it is a stored procedure and we dont have a select privilege to the oracle. Alexandre Chapellon-3 wrote:

What is AuthBlock? An PL/SQL function? A stored procedure?

Whatever it is, it MUST return data presented as freeradius expect it (an array that mirror the users file syntax) Personally, I use a PL/SQL function. Called like this:

authorize_check_query = "SELECT * FROM tables (my_sql_func('param1, 'param2'...))"

Hope it helps.

Le 19.02.2009 11:18, kenshin a écrit :

...

Hi,

I am trying to connect freeradius with Oracle, the catch is that to get the information from oracle we need to use a command that is called AuthBlock. Is there a way to add this to the oraclesql.conf?

Thanks,

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22144926.html Sent from the FreeRadius - User mailing list archive at Nabble.com.

Well there is a command that I have that gets the all the info from the oracle database. Then I think I need to make a Perl module script. Is there a clear how to, for a Perl module script? Alan DeKok-2 wrote:

kenshin wrote:

...

Hi, sorry for the late replay it is a stored procedure and we dont have a select privilege to the oracle.

Then you can't access the stored procedure.

Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22145281.html Sent from the FreeRadius - User mailing list archive at Nabble.com.

Well I am new to this, I found a package in Ubuntu for it so the installation was ok but there is one thing I went to the site I want a normal configuration. I am trying to test that the radius is working after the installation. Then I want to add a perl script that will handle my Authblock I tried searching in the wiki but I guess I am not putting the right words. It wold be nice if I can get the link for the module Doc and the the text doc. Alan DeKok-2 wrote:

kenshin wrote:

...

Well there is a command that I have that gets the all the info from the oracle database.

Then I think I need to make a Perl module script. Is there a clear how to, for a Perl module script?

Yes. The documentation is included with the server.

Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22157719.html Sent from the FreeRadius - User mailing list archive at Nabble.com.

Well it gives me this at first Search results You searched for perl There is no page titled "perl". You can create this page. Then I see A Perl Article and then Page text matches. tnt-4 wrote:

...

Well I am new to this, I found a package in Ubuntu for it so the

installation

...

was ok but there is one thing I went to the site I want a normal configuration. I am trying to test that the radius is working after the installation. Then I want to add a perl script that will handle my Authblock I tried searching in the wiki but I guess I am not putting the right words. It wold be nice if I can get the link for the module Doc and the the text doc.

So what is the document that is matched when you type perl in wiki search box?

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22165016.html Sent from the FreeRadius - User mailing list archive at Nabble.com.

yes i did but didnt get it, but I will do it again. I will try to understand it as much as I can. tnt-4 wrote:

Did you bother reading that "perl article"?

Ivan Kalik Kalik Informatika ISP

Dana 23/2/2009, "kenshin" <eternalblade@gmail.com> piše:

...

Well it gives me this at first

Search results

You searched for perl

There is no page titled "perl". You can create this page.

Then I see A Perl Article and then Page text matches.

tnt-4 wrote:

...

...

Well I am new to this, I found a package in Ubuntu for it so the

installation

...

...

was ok but there is one thing I went to the site I want a normal configuration. I am trying to test that the radius is working after the installation. Then I want to add a perl script that will handle my Authblock I tried searching in the wiki but I guess I am not putting the right words. It wold be nice if I can get the link for the module Doc and the the

text

...

...

...

doc.

So what is the document that is matched when you type perl in wiki search box?

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22165016.html Sent from the FreeRadius - User mailing list archive at Nabble.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

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22166249.html Sent from the FreeRadius - User mailing list archive at Nabble.com.

Well I am trying for sure I will have troubles because I am totally new to this. Well, thanks for the guide ^^ tnt-4 wrote:

...

yes i did but didnt get it, but I will do it again. I will try to understand it as much as I can.

Hm, so you have trouble following simple instructions with ready-made examples. Yet you are planning a perl application accessing data via stored procedures in Oracle. Well, good luck with that.

Ivan Kalik Kalik Infomatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- View this message in context: http://www.nabble.com/Freeradius-with-Oracle-tp22072944p22173537.html Sent from the FreeRadius - User mailing list archive at Nabble.com.