Re: Oracle is not supported by radsqlrelay?

2006-08-17 Thread Nicolas Baradakis 
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.orig2006-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

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

Oracle is not supported by radsqlrelay?

2006-08-16 Thread Alexander Serkin 

Alexander Serkin wrote:

Nicolas Baradakis wrote:


Maybe you could use radsqlrelay for accounting data, so FreeRADIUS
doesn't interact with the database anymore. See the manpages for
rlm_sql_log(5) and radsqlrelay(8) for more details.



didn't think about this yet. Is it possible to run radsqlrelay similar 
to radrelay - when it feeds the sql log to db while the log is being 
written by radiusd?


Oracle is not supported by radsqlrelay?

# radsqlrelay -b CDMA -d oracle -h host -P 1521 -p pass -u user -x ./tst-sql
error: SQL driver not supported yet: oracle

This is very strange because i remeber that i used it once after some 
maintenance operations with our oracle DB. May be with freeradius-1.1.1.

Something changed?

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

Re: Oracle is not supported by radsqlrelay?

2006-08-16 Thread Nicolas Baradakis 
Alexander Serkin wrote:

  Nicolas Baradakis wrote:
 
   Maybe you could use radsqlrelay for accounting data, so FreeRADIUS
   doesn't interact with the database anymore. See the manpages for
   rlm_sql_log(5) and radsqlrelay(8) for more details.
 
  didn't think about this yet. Is it possible to run radsqlrelay similar 
  to radrelay - when it feeds the sql log to db while the log is being 
  written by radiusd?

You'll find an answer in the manpages mentioned earlier.

 Oracle is not supported by radsqlrelay?
 
 # radsqlrelay -b CDMA -d oracle -h host -P 1521 -p pass -u user -x ./tst-sql
 error: SQL driver not supported yet: oracle

There is no Oracle support yet, because I couldn't test it when I wrote
radsqlrelay. As Perl DBI includes an Oracle driver, it should be trivial
to add. It's just a 2 lines patch in script/radsqlrelay.

 This is very strange because i remeber that i used it once after some 
 maintenance operations with our oracle DB. May be with freeradius-1.1.1.
 Something changed?

radsqlrelay was added in version 1.1.0 and since then it was never
changed. (you can check the CVS log if you want)

-- 
Nicolas Baradakis

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

Re: Oracle is not supported by radsqlrelay?

2006-08-16 Thread Alexander Serkin 

Nicolas Baradakis wrote:

radsqlrelay was added in version 1.1.0 and since then it was never
changed. (you can check the CVS log if you want)



Yes. i was wrong. In my case i've just fed sqllog to sqlplus utility.
Finally radsqlrelay works for me with oracle too after patching 2 
strings as you said.
At least this gives us a chance to free up the production db temporary 
for optimization.


Thanks for the hint, Nicolas.

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

Re: Oracle is not supported by radsqlrelay?

2006-08-16 Thread Nicolas Baradakis 
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.

-- 
Nicolas Baradakis

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

Re: Oracle is not supported by radsqlrelay?

2006-08-16 Thread Alexander Serkin 

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.orig2006-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
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html