From 623efaeb67eac29455ff973fdb935184cc1337c6 Mon Sep 17 00:00:00 2001
From: pnixon <pnixon>
Date: Thu, 24 Mar 2005 08:53:10 +0000
Subject: [PATCH] Add Oracle support

---
 bin/backup_radacct    | 2 ++
 bin/log_badlogins     | 1 +
 bin/monthly_tot_stats | 2 ++
 bin/tot_stats         | 2 ++
 bin/truncate_radacct  | 2 ++
 5 files changed, 9 insertions(+)

diff --git a/bin/backup_radacct b/bin/backup_radacct
index b4b20f9..1918a49 100755
--- a/bin/backup_radacct
+++ b/bin/backup_radacct
@@ -40,10 +40,12 @@ $query = "SELECT * FROM $sql_accounting_table WHERE AcctStopTime < '$date' AND A
 print "$query\n";
 open TMP, ">/tmp/backup_radacct.query"
 	or die "Could not open tmp file\n";
+print TMP "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM';\n" if ($sql_type eq 'oracle');
 print TMP $query;
 close TMP;
 $comm = "$sqlcmd -B -h $sql_server -u $sql_username $sql_password $sql_database </tmp/backup_radacct.query >$backup_directory/$date3" if ($sql_type eq 'mysql');
 $comm = "$sqlcmd  -U $sql_username -f /tmp/backup_radacct.query $sql_database >$backup_directory/$date3" if ($sql_type eq 'pg');
+$command = "$sqlcmd  $sql_username/$pass" . "@" . "$sql_database <$tmpfile.$server" if ($sql_type eq 'oracle');
 $command = "$sqlcmd '$sql_server' '$sql_port' '' '$sql_username' '$sql_password' </tmp/backup_radacct.query >$backup_directory/$date3" if ($sql_type eq 'sqlrelay');
 `$comm`;
 `/usr/local/bin/gzip -9 $backup_directory/$date3`;
diff --git a/bin/log_badlogins b/bin/log_badlogins
index 83cd18e..960a08e 100755
--- a/bin/log_badlogins
+++ b/bin/log_badlogins
@@ -193,6 +193,7 @@ for(;;){
 					$ctx->add($time);
 					$ctx->add('badlogin');
 					$uniqueid = $ctx->hexdigest;
+					print TMP "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM';\n" if ($sql_type eq 'oracle');
 #DEBUG#					print "INSERT INTO $sql_accounting_table (UserName,AcctUniqueId,NASIPAddress,NASPortId,AcctStartTime,AcctStopTime,AcctSessionTime,AcctInputOctets,AcctOutputOctets,CallingStationId,AcctTerminateCause) VALUES ('$user','$uniqueid','$addr','$port','$time','$time','0','0','0','$caller','$cause');\n";
 					print TMP "INSERT INTO $sql_accounting_table (UserName,AcctUniqueId,NASIPAddress,NASPortId,AcctStartTime,AcctStopTime,AcctSessionTime,AcctInputOctets,AcctOutputOctets,CallingStationId,AcctTerminateCause) VALUES ('$user','$uniqueid','$addr','$port','$time','$time','0','0','0','$caller','$cause');\n";
 					close TMP;
diff --git a/bin/monthly_tot_stats b/bin/monthly_tot_stats
index 20035f5..38ffcab 100755
--- a/bin/monthly_tot_stats
+++ b/bin/monthly_tot_stats
@@ -53,10 +53,12 @@ print "$query1\n";
 print "$query2\n";
 open TMP, ">/tmp/tot_stats.query"
 	or die "Could not open tmp file\n";
+print TMP "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM';\n" if ($sql_type eq 'oracle');
 print TMP $query1;
 print TMP $query2;
 close TMP;
 $command = "$sqlcmd -h $sql_server -u $sql_username $sql_password $sql_database </tmp/tot_stats.query" if ($sql_type eq 'mysql');
 $command = "$sqlcmd  -U $sql_username -f /tmp/tot_stats.query $sql_database" if ($sql_type eq 'pg');
+$command = "$sqlcmd  $sql_username/$pass" . "@" . "$sql_database <$tmpfile.$server" if ($sql_type eq 'oracle');
 $command = "$sqlcmd '$sql_server' '$sql_port' '' '$sql_username' '$sql_password' </tmp/tot_stats.query" if ($sql_type eq 'sqlrelay');
 `$command`;
diff --git a/bin/tot_stats b/bin/tot_stats
index ce72fd7..f5659e7 100755
--- a/bin/tot_stats
+++ b/bin/tot_stats
@@ -50,10 +50,12 @@ print "$query1\n";
 print "$query2\n";
 open TMP, ">/tmp/tot_stats.query"
 	or die "Could not open tmp file\n";
+print TMP "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM';\n" if ($sql_type eq 'oracle');
 print TMP $query1;
 print TMP $query2;
 close TMP;
 $command = "$sqlcmd -h $sql_server -u $sql_username $sql_password $sql_database </tmp/tot_stats.query" if ($sql_type eq 'mysql');
 $command = "$sqlcmd  -U $sql_username -f /tmp/tot_stats.query $sql_database" if ($sql_type eq 'pg');
+$command = "$sqlcmd  $sql_username/$pass" . "@" . "$sql_database <$tmpfile.$server" if ($sql_type eq 'oracle');
 $command = "$sqlcmd '$sql_server' '$sql_port' '' '$sql_username' '$sql_password' </tmp/tot_stats.query" if ($sql_type eq 'sqlrelay');
 `$command`;
diff --git a/bin/truncate_radacct b/bin/truncate_radacct
index a6e25b9..09f9193 100755
--- a/bin/truncate_radacct
+++ b/bin/truncate_radacct
@@ -46,9 +46,11 @@ $query .= "UNLOCK TABLES;" if ($sql_type eq 'mysql');
 print "$query\n";
 open TMP, ">/tmp/truncate_radacct.query"
         or die "Could not open tmp file\n";
+print TMP "ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF TZH:TZM';\n" if ($sql_type eq 'oracle');
 print TMP $query;
 close TMP;
 $command = "$sqlcmd -h$sql_server -u$sql_username $sql_password $sql_database </tmp/truncate_radacct.query" if ($sql_type eq 'mysql');
 $command = "$sqlcmd  -U $sql_username -f /tmp/truncate_radacct.query $sql_database" if ($sql_type eq 'pg');
+$command = "$sqlcmd  $sql_username/$pass" . "@" . "$sql_database <$tmpfile.$server" if ($sql_type eq 'oracle');
 $command = "$sqlcmd '$sql_server' '$sql_port' '' '$sql_username' '$sql_password' </tmp/truncate_radacct.query" if ($sql_type eq 'sqlrelay');
 `$command`;
-- 
2.39.5