From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from mail-wm1-f45.google.com (mail-wm1-f45.google.com [209.85.128.45]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by smtp.subspace.kernel.org (Postfix) with ESMTPS id 5D4863D0903 for ; Fri, 13 Mar 2026 17:48:29 +0000 (UTC) Authentication-Results: smtp.subspace.kernel.org; arc=none smtp.client-ip=209.85.128.45 ARC-Seal:i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1773424110; cv=none; b=stn7IHHS66poVm4avl+8ij/7l+WZ2yP8vEvdAXW63KcVcf7g6va3zl5bgtzbLSt1d6nvaE96a0yPB6jsQo7NmkYfO+K07ZX+pepwCV9xShQ3UBqOQT8tXDY/4FrPGyVuekezucATCcyCTcddpVQ1pbLBy3geGy9SOrOrvaWBeOQ= ARC-Message-Signature:i=1; a=rsa-sha256; d=subspace.kernel.org; s=arc-20240116; t=1773424110; c=relaxed/simple; bh=TWDo8QSGG9FgM5eDtpe6obe0bpwVrY9XvgV6/9CBZdM=; h=Message-ID:Date:MIME-Version:Subject:To:Cc:References:From: In-Reply-To:Content-Type; b=IlikdT+s/OboF+VsOA1ANF2gtjn25qCSx4ZTxA93L1wKPnrVENyF8JCcc1uaeUa1YcvwwoXPWvzWmSuv8IAU+5BeK7saY+4hAVd3KDhiKjV/gOcOXedry3VJd+BnarYz/W206SUo+aW2C2Igcn66IV6b5FUhY+yKWIolSHfQhQY= ARC-Authentication-Results:i=1; smtp.subspace.kernel.org; dmarc=pass (p=none dis=none) header.from=gmail.com; spf=pass smtp.mailfrom=gmail.com; dkim=pass (2048-bit key) header.d=gmail.com header.i=@gmail.com header.b=YQk98tOQ; arc=none smtp.client-ip=209.85.128.45 Authentication-Results: smtp.subspace.kernel.org; dmarc=pass (p=none dis=none) header.from=gmail.com Authentication-Results: smtp.subspace.kernel.org; spf=pass smtp.mailfrom=gmail.com Authentication-Results: smtp.subspace.kernel.org; dkim=pass (2048-bit key) header.d=gmail.com header.i=@gmail.com header.b="YQk98tOQ" Received: by mail-wm1-f45.google.com with SMTP id 5b1f17b1804b1-48541edecf9so25835915e9.1 for ; Fri, 13 Mar 2026 10:48:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773424108; x=1774028908; darn=vger.kernel.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=4wc59JHWlxlV49Xu4pkv5qxkwv3LnMLE9wiNeBvnGno=; b=YQk98tOQqO/SbCBjm2l2d0IYEjkkmtoO+3qmHdQPhMd2hy4c7T5jzhYgXwrpsiAVF/ UwgJJhm/OvURZMRrvVs2ymk0fMO33jd0YjFI+pQ8XUoIQthJemiSA1kKLgnervl5iKlJ pn5roA+T+W/O0GPJ1qcKOmpDbe+KdmgSZ00HOCIuH7nUZjqZjPu4SdbAOIi4+0YC4Z6T sUr1Zf9u0DM0yUZR2sgRsTEmeZM4eTzHsuWhOaWiT6XogCOswQjRyDprHYPjtvDZ4jbP R0GgCinx7ZmrjRPNm8Y6ADXnf9x0UILkk6Nad7vuA052tBLZMhEyssn87nfAvb7uYkri yJHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773424108; x=1774028908; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=4wc59JHWlxlV49Xu4pkv5qxkwv3LnMLE9wiNeBvnGno=; b=hMDEOwLrsbx6IJgSgk4L1SVK1nxz++DzqJLgQdho2/ylVQz8LEg39Po94PtC7gjk4W LVxT1JjJzKNs/P3uxFkrSjqIgN28SYxwbT0tVallcKTWLxLhR26nXPTHZ98bF+lrkmen uJauUOzwztovoHxQla34ZCbxtlOJZ2h6UdHZ32tq+0N9gYm6TAEoiYAyQRpRXNyQTusd ZH0TUuPFqZLNuw9K1/vOjedVqCE7f++u0eAV+EkFYvUd6TnvcU4RbWv2QLGce59S59ak 8ZXRfPdCtRipQYkGnhL9oawIZ39Bybla5GFF/YpIqnfYIinU8ebq/tE9RNt3Yt9H4MyX MG6A== X-Gm-Message-State: AOJu0YwiPdg/skRBfuyT+MiAyQET6qYybIHtVocMTMT2o2UHyx+9goRJ wUafMov1WSMj4wsK9SNH+w/Imh1Z2ZXTAE1NozGm24yDc9QMUGFViaXJ X-Gm-Gg: ATEYQzz9WZjHPCoC1yvOWW4RKy5cwEnW6hgUp0uBr5w5m6siAJv2k1Xf/U8+ZAal+rr ctGrD4J/GvNvqKEHUm30nqVsnap34SZ/l8dD9qg/eDxGg3YtGyL2ALiB87Ucmb4RhOPvjJnn7s2 uddSnnlVSmDbvJDwxdrULicJmnr/liTI2eaAtmmXiPUknlPaIMDqKEPzcq/QUKk61r77QlVU8QH L9N6zPOzY2spac14shtmuLFB9svKzwUHWAM58ascqhO3IVScH+VcIrSX7PwjdkJ8S/2ksWELCHR gg/7NSeiV/ci+0m5z1l9GmRDNCwbCK1F3IIizi3YBBq4SgjNM4i+2YF27VGrGrlyD0wWeW6nY0Y IjQOpWm25QPTxNNJgrm0uoOJm603ual1BzJBS9qo74In/V73bToiDIYWv0X6niKw+yqbod2w9CX GAtZUHR2tGVkQYmbv5/xZXGDteB1X7LeousIffszAh3oahUq008MCY7qkZkIjXFgFtW9tT9lc/N Hf/IQzZtAebuc0Lze4= X-Received: by 2002:a05:600c:37cc:b0:485:5812:27bc with SMTP id 5b1f17b1804b1-48558122839mr56882655e9.5.1773424107565; Fri, 13 Mar 2026 10:48:27 -0700 (PDT) Received: from [192.168.1.14] (mm-214-205-122-178.mgts.dynamic.pppoe.byfly.by. [178.122.205.214]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4854b66e3f8sm217631535e9.14.2026.03.13.10.48.26 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 13 Mar 2026 10:48:27 -0700 (PDT) Message-ID: <948e83d4-4a34-41d5-a394-6c4ec17bc534@gmail.com> Date: Fri, 13 Mar 2026 20:48:25 +0300 Precedence: bulk X-Mailing-List: linux-kernel@vger.kernel.org List-Id: List-Subscribe: List-Unsubscribe: MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [RFC] Modernizing Linux authentication logs (lastlog, btmp, utmp, wtmp) with SQLite To: Adhemerval Zanella Netto , linux-api@vger.kernel.org, Thorsten Kukuk Cc: linux-kernel@vger.kernel.org, audit@vger.kernel.org, libc-alpha@sourceware.org References: <660c10e6-f8b5-46e2-a424-e3e052992b3a@gmail.com> <2d5de14a-17d2-4d08-992e-cbc5d430e231@linaro.org> Content-Language: en-US From: Roman Bakshansky In-Reply-To: <2d5de14a-17d2-4d08-992e-cbc5d430e231@linaro.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 3/13/26 4:59 PM, Adhemerval Zanella Netto wrote: > From the glibc standpoint my plan is just to make the accounting database > function no-op [1] (I hopefully to get this in the next 2.44 release). > > And I think Thorsten Kukuk already adapted most of the usages in current > distros [2][3] using similar strategy, along with a better systemd > integration. I am not sure if/when distros are incorporating his work. > > [1] https://patchwork.sourceware.org/project/glibc/list/?series=37271 > [2] https://www.thkukuk.de/blog/Y2038_glibc_lastlog_64bit/ > [3] https://www.thkukuk.de/blog/Y2038_glibc_utmp_64bit/ Thank you for the links and information. I have been following Thorsten Kukuk's work. I know that liblastlog2 is already integrated into util-linux and successfully solves the Y2038 problem for lastlog. I am also aware of his wtmpdb project. These are important steps in the right direction. My RFC proposes to go further and provide a unified solution for all four files: lastlog, btmp, utmp, wtmp. The idea is to create a set of public libraries (liblastlog2, libbtmp2, libutmp2, libwtmp2) with a consistent C interface, built on SQLite. This would provide 64-bit timestamps, indexes for fast queries, ACID transactions, and schema extensibility without breaking backward compatibility.