Merge branch 'next' of ssh://git.ipfire.org/pub/git/ipfire-2.x into next-switch-to...

[people/pmueller/ipfire-2.x.git] / html / cgi-bin / logs.cgi / ovpnclients.dat

diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat
index 2009990ec844f0535e858ae5fd5500c6f2251025..a064893a1a5cc7b75880a8c3b5c40fac7b63cf7b 100755 (executable)
--- a/html/cgi-bin/logs.cgi/ovpnclients.dat
+++ b/html/cgi-bin/logs.cgi/ovpnclients.dat
@@ -95,6 +95,21 @@ unless ($to_datestring ge $from_datestring) {
        $errormessage = "$Lang::tr{'error the to date has to be later than the from date'}";
 }
 
+# Initialise database
+my $cursor = $database_handle->prepare("
+       CREATE TABLE IF NOT EXISTS sessions(
+               common_name TEXT NOT NULL,
+               connected_at TEXT NOT NULL,
+               disconnected_at TEXT,
+               bytes_received INTEGER,
+               bytes_sent INTEGER
+       );
+
+       -- Create index for speeding up searches
+       CREATE INDEX IF NOT EXISTS sessions_common_name ON sessions(common_name);
+");
+$cursor->execute();
+
 my $database_query = qq(
        SELECT
         common_name, SUM(