Oracle is not supported by radsqlrelay?

Alexander Serkin als at cell.ru
Thu Aug 17 07:20:56 CEST 2006


Nicolas Baradakis wrote:
> Alexander Serkin wrote:
> 
>> Finally radsqlrelay works for me with oracle too after patching 2
>> strings as you said.
> 
> 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;

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>)
     )
   )

-- 
Sincerely Yours,
Alexander



More information about the Freeradius-Users mailing list