From 8dfa2f14821acce6f5c89d447ba49b47339a3d36 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Sun, 2 Nov 2014 11:10:38 -0800
Subject: [PATCH] fix dates on aradial usage import, RT#29053

---
 bin/aradial-sftp_and_import | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/bin/aradial-sftp_and_import b/bin/aradial-sftp_and_import
index 0cb6bca3a..53357033c 100755
--- a/bin/aradial-sftp_and_import
+++ b/bin/aradial-sftp_and_import
@@ -169,6 +169,7 @@ foreach my $filename ( @$ls ) {
     my @extra_values = ();
     if ( $hash{'Status-Type'} eq 'Start' ) {
 
+      push @keys, 'AcctStartTime';
       $dbhash{'AcctStartTime'} = $hash{'Date'};
 
       $sql = 'INSERT INTO radacct ( '. join(',', @keys).
@@ -177,6 +178,8 @@ foreach my $filename ( @$ls ) {
     } elsif ( $hash{'Status-Type'} eq 'Stop' ) {
 
       my $AcctSessionId = delete($dbhash{AcctSessionId});
+
+      push @keys, 'AcctStopTime';
       $dbhash{'AcctStopTime'} = $hash{'Date'};
 
       push @extra_values, $AcctSessionId;
-- 
2.11.0