Re: Oracle is not supported by radsqlrelay?

17 Aug 2006

Alexander Serkin wrote:
...
Nicolas Baradakis wrote:
...
Please create a patch with "diff -u radsqlrelay.orig radsqlrelay"
and post it to the list. I'll add it in version 1.1.3.
Here it is:

--- radsqlrelay.orig    2006-08-16 15:40:58.220277000 +0400
+++ radsqlrelay 2006-08-16 17:53:20.151452000 +0400
@@ -156,6 +156,8 @@
     $data_source = "DBI:mysql:database=$args{b};host=$args{h}";
 } elsif (lc($args{d}) eq 'pg') {
     $data_source = "DBI:Pg:dbname=$args{b};host=$args{h}";
+} elsif (lc($args{d}) eq 'oracle') {
+    $data_source = "DBI:Oracle:$args{b}";
 } else {
     print STDERR "error: SQL driver not supported yet: $args{d}\n";
     exit 1;
Added, thanks.
...
whith "-b db.domain.tld" i give the database description stored in 
$TNS_ADMIN/tnsnames.ora:
db.domain.tld =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = <DB SID>)
    )
  )
I've added this to the radsqlrelay(8) manpage, too.

-- 
Nicolas Baradakis

    