(RADIATOR) Radiator 3.6 buildsql not working

[Hugh Irvine]

Hello Angus -

This looks like you have not set up the Oracle installation correctly.

There is a FAQ item here:

	http://www.open.com.au/radiator/faq.html#59

And also check the archive site:

	www.open.com.au/archives/radiator

You should also check your Oracle documentation and the DBD  
documentation.

regards

Hugh


On Tuesday, Jul 8, 2003, at 17:02 Australia/Melbourne, Angus Yiu wrote:

> Dear Hugh,
>  
>     Thank you for your support. I have changed to "Oracle", but got  
> the other error:
>  
> bash-2.03# buildsql -dbsource dbi:Oracle:rad -dbusername fred -dbauth  
> password -l angus
>
> DBI connect('rad','fred',...) failed: ORA-12641: Authentication  
> service failed to initialize (DBD ERROR: OCIServerAttach) at  
> /usr/local/bin/buildsql line 86
> Could not DBI->connect to dbi:Oracle:rad: ORA-12641: Authentication  
> service failed to initialize (DBD ERROR: OCIServerAttach) at  
> /usr/local/bin/buildsql line 89.
>  
> Best Regards,
> Angus Yiu
>  
> Automated Systems (HK) Ltd.
> 15/F., Topsail Plaza, 11 On Sum Street,
> Shatin, Hong Kong
> Tel   : 2608-6150
> Fax   : 2608-6566
> Email : anyiu at asl.com.hk
>  
> ----------------------------------------------------------------------- 
> -----------------------------------------------------------
>  
> ASL 30th Anniversary -- Solid Foundation, Fresh Perspective
>  
> ----------------------------------------------------------------------- 
> -----------------------------------------------------------------------
>  
> This is a PRIVATE message. If you are not the intended recipient,  
> please delete without copying and kindly advise us by e-mail of the  
> mistake in delivery. NOTE: Regardless of content, this e-mail shall  
> not operate to bind ASL to any order or other contract unless pursuant  
> to explicit written agreement or government initiative expressly  
> permitting the use of e-mail for such purpose.
>  
> ----------------------------------------------------------------------- 
> ----------
>
> ----- Original Message -----
> From: Hugh Irvine
> To: Angus Yiu
> Cc: radiator at open.com.au
> Sent: Tuesday, July 08, 2003 1:14 PM
> Subject: Re: (RADIATOR) Radiator 3.6 buildsql not working
>
>
> Hello Angus -
>
> The correct spelling is "dbi:Oracle:rad".
>
> See section 24.4 in the Radiator 3.6 reference manual ("doc/ref.html").
>
> regards
>
> Hugh
>
>
> On Tuesday, Jul 8, 2003, at 14:16 Australia/Melbourne, Angus Yiu wrote:
>
> Dear Sir,
>  
>     I am trying to config. a radiator (3.6-demo)  using <AuthBy SQL>  
> in order to contact to a Oracle 8.1.7(the oracle and the radiator are  
> on the same machine.)  I have created the table "SUBSCRIBERS" and user  
> on the table in Oracle.However, I did not succeed. I've got the  
> following errors when performing a command "buildsql" to find the user  
> "angus"
>  
> bash-2.03# buildsql -dbsource dbi:oracle:rad -dbusername fred -dbauth  
> password -l angus
> install_driver(oracle) failed: Can't locate DBD/oracle.pm in @INC  
> (@INC contains: . /usr/local/lib/perl5/5.8.0/sun4-solaris  
> /usr/local/lib/perl5/5.8.0  
> /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris  
> /usr/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl .)  
> at (eval 22) line 3.
> Perhaps the DBD::oracle perl module hasn't been fully installed,
> or perhaps the capitalisation of 'oracle' isn't right.
> Available drivers: ExampleP, Oracle, Proxy.
>  at /usr/local/bin/buildsql line 86
>  
> p.s. I've also complied, tested and installed DBI (DBD-Oracle-1.12)  
> and DBD ( DBI-1.20)  successfully using sunwork shop c compiler.
> Platform: Solaris 8
> Machine:  Sun Microsystems Ultra 10
> cpu:        360 MHz
> Ram:        328M
>
> Thanks a lot for paying attention and so much appreciate.
>
> Best Regards,
> Angus Yiu
>  
> Automated Systems (HK) Ltd.
> 15/F., Topsail Plaza, 11 On Sum Street,
> Shatin, Hong Kong
> Tel   : 2608-6150
> Fax   : 2608-6566
> Email : anyiu at asl.com.hk
>  
> ----------------------------------------------------------------------- 
> -----------------------------------------------------------
>  
> ASL 30th Anniversary -- Solid Foundation, Fresh Perspective
>  
> ----------------------------------------------------------------------- 
> -----------------------------------------------------------------------
>  
> This is a PRIVATE message. If you are not the intended recipient,  
> please delete without copying and kindly advise us by e-mail of the  
> mistake in delivery. NOTE: Regardless of content, this e-mail shall  
> not operate to bind ASL to any order or other contract unless pursuant  
> to explicit written agreement or government initiative expressly  
> permitting the use of e-mail for such purpose.
>  
> ----------------------------------------------------------------------- 
> ----------
>
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 6075 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030708/715faf86/attachment.bin>