From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id OCclISaRO2KTFQEAgWs5BA (envelope-from ) for ; Wed, 23 Mar 2022 22:29:10 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id GLMBGiaRO2IrVgAAG6o9tA (envelope-from ) for ; Wed, 23 Mar 2022 22:29:10 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 2EF3327622 for ; Wed, 23 Mar 2022 22:29:10 +0100 (CET) Received: from localhost ([::1]:50134 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nX8XV-0003Ay-5u for larch@yhetil.org; Wed, 23 Mar 2022 17:29:09 -0400 Received: from eggs.gnu.org ([209.51.188.92]:52216) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nX8XO-0003Ap-Q3 for guix-patches@gnu.org; Wed, 23 Mar 2022 17:29:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:52338) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nX8XO-0007oo-I1 for guix-patches@gnu.org; Wed, 23 Mar 2022 17:29:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1nX8XO-0005rL-Aa for guix-patches@gnu.org; Wed, 23 Mar 2022 17:29:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#54457] [PATCH 9/9] gnu: Add ulogd Resent-From: fesoj000 Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Wed, 23 Mar 2022 21:29:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 54457 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: Maxime Devos , 54457@debbugs.gnu.org Received: via spool by 54457-submit@debbugs.gnu.org id=B54457.164807090822476 (code B ref 54457); Wed, 23 Mar 2022 21:29:02 +0000 Received: (at 54457) by debbugs.gnu.org; 23 Mar 2022 21:28:28 +0000 Received: from localhost ([127.0.0.1]:46235 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nX8Wq-0005qS-MZ for submit@debbugs.gnu.org; Wed, 23 Mar 2022 17:28:28 -0400 Received: from mail-ej1-f45.google.com ([209.85.218.45]:38625) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nX8Wp-0005qD-Oj for 54457@debbugs.gnu.org; Wed, 23 Mar 2022 17:28:28 -0400 Received: by mail-ej1-f45.google.com with SMTP id r13so5449155ejd.5 for <54457@debbugs.gnu.org>; Wed, 23 Mar 2022 14:28:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to:content-transfer-encoding; bh=+SVOjUkFHbH6J1nRvNZfldI5EMmEwLqs/wNf+9Bdb4w=; b=pRMyv+xQAgztY5M/SRq7TVf+QDk4s4HF2QgMk/br1p3ZAOEbDNyWzbMAB4VRefDVTn QKM6iJ3XucIlicKHsTrNqucGKoX1AOzXJhWRHQ0PaRzCGc3MlvE0YS7UZqTMuVD1EfcH m0flwmQ5Furfv1PH4FhYsvF/yrjTAsqO5vgdil3mgtcM83Ulrkb7Ex4HgRzoPpLCpmi/ rihCjIapnVqnLxerGUDS/Mp2h0LwS3nOU4KQkbcbzag4+VlKp4rkNoygeu1bEdEWnepl HP0/lcFfWbsngGLOF6U5N4UoTyyAqzu/vX7jkXS2ZAVyxQzv+4w65cPXeGk0XhMfrxQ9 0N/w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to :content-transfer-encoding; bh=+SVOjUkFHbH6J1nRvNZfldI5EMmEwLqs/wNf+9Bdb4w=; b=56QG0abE3fPa8ABJXiMrvLqjYkBnvbvu1TPDrDJu03NNhOvYgCXiSoZkXNrTddXpAS udWlGjw2rPw1PMDhuyCFsC/JPLKQFTXIRF01v/3R7Tq97Fe4XjV0Ciz8Esh42tCLTao5 5vaIgZkCfbnH5+RoG8COey4s2j0Z8QV2yGRvQATUbcDvXnBzqh+cl9VzdamvasxQE4YH kVJK6APMwUgipMuP/CdWMXjUOTyS84OhRJye6uhI5VxCiBOm+P3CAAyLRJA2qN8wIgrJ ycHyhTcV8f97VrHDJpVBvbq9uyNUTYkAm4dbHy2vLFkteIV9Xf/m+fW/rjVhnQBSRVKT xXFQ== X-Gm-Message-State: AOAM531wVsVS3f6xZMP4wQKzzcpzi+lm8JAdr9Ej0fcV8Z6DfmBD4Ys3 kuM5XFoavOkTSwFytARvzIE= X-Google-Smtp-Source: ABdhPJzEl63vMeaRTt+hCFzMsGv04R6kUKIbjfMhFnhicWvafroxhcw3mWyEW6jJkc21dYWsKIDKvw== X-Received: by 2002:a17:907:6e88:b0:6da:8f01:7a8f with SMTP id sh8-20020a1709076e8800b006da8f017a8fmr2258970ejc.619.1648070901140; Wed, 23 Mar 2022 14:28:21 -0700 (PDT) Received: from ?IPV6:2003:ee:af2f:e00:c2f9:c2bb:bf95:1fc5? (p200300eeaf2f0e00c2f9c2bbbf951fc5.dip0.t-ipconnect.de. [2003:ee:af2f:e00:c2f9:c2bb:bf95:1fc5]) by smtp.gmail.com with ESMTPSA id hg11-20020a1709072ccb00b006cee4fb36c7sm371395ejc.64.2022.03.23.14.28.20 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 23 Mar 2022 14:28:20 -0700 (PDT) Message-ID: Date: Wed, 23 Mar 2022 22:28:21 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.7.0 Content-Language: en-US References: <871b5ef4-87f1-bd27-0d24-0725064b2894@gmail.com> <51481207-31b7-58bc-00de-f0633a3a1059@gmail.com> <1b8078f4367dda851de6e32f1e5acba4eaf593a9.camel@telenet.be> From: fesoj000 In-Reply-To: <1b8078f4367dda851de6e32f1e5acba4eaf593a9.camel@telenet.be> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+larch=yhetil.org@gnu.org Sender: "Guix-patches" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1648070950; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding:resent-cc: resent-from:resent-sender:resent-message-id:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=+SVOjUkFHbH6J1nRvNZfldI5EMmEwLqs/wNf+9Bdb4w=; b=DamPONxmrJROgpXbEt4JQmRS+Gz1sS0Fb6U7z2HutFPtt20twM2ckk5QHrFaKSgG+1HRGq 5Ym5fE25fYz6BzR/W+yp/HD5zc/xh48dhsmNVNSSRvrE+HnH5uSbVIX4DrO6wRZWUQ2END 3WLc7MHzcCpXovem2D67g1+XfcpqQCoaQbtDfyJPuWOP/xDjVIBRdyBu7WGxy0tmH5Qi7d ICxqueEtAEpcveAKPUjFYIrcgsOJTqdhkWDHbyAYpr7MHoBHQm+apNj69Q7JRCRcxgNGiV VNZbFIv+zBP6b5OSFMvKvY+X7LkCoYQ4LSSPTRVh3fOjnYvbPnUsvTmUuLuMqA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1648070950; a=rsa-sha256; cv=none; b=cW863c1cAAkVhcoIbqdiTCPQHTSartGKL/LJ8Be9Us/vfUDFov9/uhyLVr/TSZd/t21jfX gomXTF9ZLRWyUwkt7fdU5KKOFGxIkt7zQinfYfF7L1gnpT7WX1h2S13KCxsNsAW73B+S1D DXyRM5KYTO/XcukRW7/e0VfuT1QkoFXHLMQ3+uP7Kji18Vc47js3CF4IRkpcl3R2RDLsNk 83LIEc0+FrRhRhXMDj4qwqcXH7TjrFT71DUzFW2dmv9I3CpR4K4ViMCoWLly/F0axcsQYs PjAMLKyrMknOdzNRV1igBk/KDkeGLkdE0Oousdo9z9x/GUa97lgyWqYfZIM7lQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=pRMyv+xQ; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "guix-patches-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-patches-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: 4.31 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=pRMyv+xQ; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of "guix-patches-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-patches-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: 2EF3327622 X-Spam-Score: 4.31 X-Migadu-Scanner: scn0.migadu.com X-TUID: 19JXNxYQbWE6 On 3/23/22 8:41 PM, Maxime Devos wrote: > fesoj000 schreef op ma 21-03-2022 om 22:20 [+0100]: >> +@item >> +SQL database back-end support: SQLite3, MySQL and PostgreSQL > Does this work out-of-the-box, or do extra inputs need to be added for > this? Good point, this is the upstream description of the daemon. I personally only use syslog output currently. And yes, to add support for those database back-ends, we need to add them as inputs. Although i would prefer to not "blow up" the package. Postgresql and especially mysql a rather "big boys". On a router this might be a little much. This could be fixed, by providing a separate "lib" output for those. For me personally, i plan to continue using syslog output. Further i plan to use pcap and josn output for certain things, but so far i did not have time to play with that. So, what i would do is, add sqlite, libpcap and jansson as inputs. This enables sqlite, pcap and json output support in ulogd. If postgresql and mysql is something somebody needs, i would propose to introduce a new package variant which adds those inputs. Is this something we could do?