Message ID | 20200413074550.2735-8-stefan.schantl@ipfire.org |
---|---|
State | Accepted |
Commit | 1242cb0134ee9008b613a56957dbf7fe3f4b6b3d |
Headers |
Return-Path: <development-bounces@lists.ipfire.org> Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4910zr2dtkz3yC0 for <patchwork@web04.haj.ipfire.org>; Mon, 13 Apr 2020 07:46:16 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4910zd3qRmz2p8; Mon, 13 Apr 2020 07:46:05 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4910zc6xsqz30FK; Mon, 13 Apr 2020 07:46:04 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4910zY2Xkbz2xqq for <development@lists.ipfire.org>; Mon, 13 Apr 2020 07:46:01 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384) (Client did not present a certificate) by mail01.ipfire.org (Postfix) with ESMTPSA id 4910zX5rbXz2jN; Mon, 13 Apr 2020 07:46:00 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1586763961; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=qth+3TexGRx6N7H1vS2KtV/oFqpVEB1oTp3+0mYDnNk=; b=m7tWUZvKN9hPmdSVkukt98KrFRsMU3QPgeZLlFsGt6fqZJPhXpSlpUzr/Q45JJDZt+iFXt hE7+qId0TXOWLoCg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1586763961; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=qth+3TexGRx6N7H1vS2KtV/oFqpVEB1oTp3+0mYDnNk=; b=DsW53EWSf2uEfkYBRdqUmRj7BWKxCMh+pVWtvGiJVSWcK8dvZABF1K83suUgfUA0hAct0g UEsPbeC2OT6fv11plb78Qb3lTv81OfCUjGUkxIy+1pfyM/yATcP5P04zoDUgSU1C0AB9+H 8ARpaEYVFjZRRmtDGvef/r+lohP3bKn6wI2lZ4pruKnyR0E3x/lcozXOHhWASSa3+8X8Rb pyrYK0kTR4A4I7mcXAFBI7+Y3kR0xpwDqNxF1sgLw1SRu0H1fqM30BTovabJrIdWmlte4X bZXyqhgVdwYl3xe9Erp/u+7Lsat76hdTJe0DPipvdYkcQhD6rvdPZdP2ueJBEA== From: Stefan Schantl <stefan.schantl@ipfire.org> To: development@lists.ipfire.org Subject: [PATCH 08/19] ovpnclients.dat: Convert timestamps into localtime. Date: Mon, 13 Apr 2020 09:45:39 +0200 Message-Id: <20200413074550.2735-8-stefan.schantl@ipfire.org> In-Reply-To: <20200413074550.2735-1-stefan.schantl@ipfire.org> References: <20200413074550.2735-1-stefan.schantl@ipfire.org> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Authentication-Results: mail01.ipfire.org; auth=pass smtp.mailfrom=stefan.schantl@ipfire.org X-BeenThere: development@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: IPFire development talk <development.lists.ipfire.org> List-Unsubscribe: <https://lists.ipfire.org/mailman/options/development>, <mailto:development-request@lists.ipfire.org?subject=unsubscribe> List-Archive: <http://lists.ipfire.org/pipermail/development/> List-Post: <mailto:development@lists.ipfire.org> List-Help: <mailto:development-request@lists.ipfire.org?subject=help> List-Subscribe: <https://lists.ipfire.org/mailman/listinfo/development>, <mailto:development-request@lists.ipfire.org?subject=subscribe> Errors-To: development-bounces@lists.ipfire.org Sender: "Development" <development-bounces@lists.ipfire.org> |
Series |
[01/19] openvpn: Add WUI page for client usage statistics
|
|
Commit Message
Stefan Schantl
April 13, 2020, 7:45 a.m. UTC
Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
---
html/cgi-bin/logs.cgi/ovpnclients.dat | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat index 33d6d8717..cf3e0e7bc 100755 --- a/html/cgi-bin/logs.cgi/ovpnclients.dat +++ b/html/cgi-bin/logs.cgi/ovpnclients.dat @@ -123,7 +123,7 @@ my $database_query = qq( if ($cgiparams{'CONNECTION_NAME'}) { $database_query = qq( - SELECT * FROM sessions + SELECT common_name, DATETIME(connected_at, 'localtime'), DATETIME(disconnected_at, 'localtime'), bytes_received, bytes_sent FROM sessions WHERE common_name = '$cgiparams{"CONNECTION_NAME"}' AND (