Hi Hugh,
The syntax is as follow:
AddQuery BEGIN radius.sessiondb ('%n', '%N', %{NAS-Port}, %{Timestamp},
'%{NAS-Port-Type}'); END;
It works.
You can also refer to the DBI faq at
http://www.ibc.wustl.edu/perl5/other/site/DBI/FAQ.html
Thank you for your suggestion
Hugh Irvine wrote:
> Hello Anthony -
>
> On Fri, 27 Aug 1999, Anthony Chan wrote:
>
> >
> > For the second problem, I try to use store procedure for the Oracle session
> > database. I create a procedure using the following sql:
> >
> > CREATE OR REPLACE PROCEDURE radius.sessiondb (NAME IN VARCHAR2 , NASID IN VARCHAR2,
> > PORT IN NUMBER, TIME IN NUMBER, PORTTYPE IN VARCHAR2)
> > AS BEGIN
> > insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, TIME_STAMP,
> > FRAMEDIPADDRESS, NASPORTTYPE) values (NAME, NASID, PORT, TIME, PORTTYPE);
> > END;
> >
> > I use sqlplus to create the above procedure. Then, I exeute the procedure, at the
> > sql prompt:
> >
> > EXEC radius.sessiondb ('c200030', '203.63.154.1', 1234, 935668514, 'Async');
> >
> > The execute is success. Then, I put the following config into the Radiator config
> > file:
> >
> > AddQuery exec radius.sessiondb ('%n', '%N', %{NAS-Port}, %{Timestamp},
> > '%{NAS-Port-Type}')
> >
> > However, I get the following error message:
> > Thu Aug 26 19:55:15 1999: ERR: do failed for 'EXECUTE radius.sessiondb ('c200030',
> > '203.63.154.1', 1234, 935668514, 'Async')': ORA-00900: invalid SQL statement (DBD
> > ERROR: OCIStmtExecute)
> >
>
> The error shown above is an Oracle error (ORA-00900), but you might try
> experimenting with the exec syntax - perhaps remove the parentheses "()"?
>
> AddQuery exec radius.sessiondb '%n', '%N', %{NAS-Port}, %{Timestamp},
> '%{NAS-Port-Type}'
>
> > I don't find any further descriptions inside the Radiator reference manual
> about
> > it. Can you give me more details about using the store procedures?
>
> Radiator employs the DBD/DBI libraries to avoid database dependencies, so there
> is nothing database specific in the code.
>
> BTW - when you get the stored procedures working, please let us know what you
> did and we will put an entry in the FAQ describing what is necessary.
>
> thanks
>
> Hugh
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Cheers,
Anthony Chan
Sun Professional Services Hong Kong
22/F Shui On Centre,
8 Harbour Road, Wanchai,
Hong Kong
Phone: (852) 2820-0674
Fax : (852) 2802-8655
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
