DMARC-Filter: OpenDMARC Filter v1.4.2 delorie.com 56LIoNwd3152277
Authentication-Results: delorie.com; dmarc=pass (p=none dis=none) header.from=cygwin.com
Authentication-Results: delorie.com; spf=pass smtp.mailfrom=cygwin.com
DKIM-Filter: OpenDKIM Filter v2.11.0 delorie.com 56LIoNwd3152277
Authentication-Results: delorie.com;
	dkim=pass (1024-bit key, unprotected) header.d=cygwin.com header.i=@cygwin.com header.a=rsa-sha256 header.s=default header.b=oSiJwbZ9
X-Recipient: archive-cygwin AT delorie DOT com
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 447443858C2C
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1753123821;
	bh=okp5z1Zshcaw6uNmwapWTmI6ohM1Ln7X4EcJOc0dG4Y=;
	h=Date:Subject:To:References:In-Reply-To:List-Id:List-Unsubscribe:
	 List-Archive:List-Post:List-Help:List-Subscribe:From:Reply-To:Cc:
	 From;
	b=oSiJwbZ9I3jsYL/mOdDt7xOyw6ZwhPFn1ZNDWq+YGHVHTz0sli2kXKRzW8kkE3j35
	 /pBOVPanoixSri8zDda4da3Dm6CdJ/qa3vqyTaDfGsDTDW8Ua5gmfEqy3uQy7AjhMN
	 +JughpNnLmzIu5VBsJOvgHnuO+l0JEMKXJ/SF/1s=
X-Original-To: cygwin AT cygwin DOT com
Delivered-To: cygwin AT cygwin DOT com
DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 064A93858D1E
ARC-Filter: OpenARC Filter v1.0.0 sourceware.org 064A93858D1E
ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1753123762; cv=none;
 b=cQ9zwJIWSraPkFf9eJ4+iHHN2oAIbH+9T0jMJdlDL3iQLAvCy5Lz3buav+7+Ib/b87T+Ntsubf1HlX0r9LO96ZPsTKJhHsvbJemjRpvYv2j/6PMlSt72gqhJmLBcGG28Y8UEK4+I8fHblbWlELl+5mSr8u557F5wbc+dP0KIn2M=
ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key;
 t=1753123762; c=relaxed/simple;
 bh=vwB8cNUnhrpJwF3Qv4m4ys0Z4pa4JR8rH9v+0kPgTKc=;
 h=Message-ID:Date:MIME-Version:From:Subject:To:DKIM-Signature;
 b=wc6Pr7DMNnE/lYEhPpeATwXSazDayL0bCMBKWyUZExb2EZV1egcrkPbamc8Rlmv9SGHmRqkNeFav5mh+XVfFc4hx/VQDjbE6/4r77/3vuKTftMuIkNy7jlcgwm6ODOyINloUO9W4RM8MLe28wMH9SNKWACXaTALzMMtSVh10CLE=
ARC-Authentication-Results: i=1; server2.sourceware.org
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 064A93858D1E
Message-ID: <446c2872-dde4-47c7-84e8-8ef91a7906ba@SystematicSW.ab.ca>
Date: Mon, 21 Jul 2025 12:49:18 -0600
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: User "MariaDB" not seen by Cygwin, but it is there
Content-Language: en-CA
To: cygwin AT cygwin DOT com
References: <CA+1jF5pUJGwLzChwTrN+rnFtMcpDahqAF4_xBh4ikREDS7z47g AT mail DOT gmail DOT com>
 <2ea0e5b3-76ae-4e23-bb6e-0c1e0814e94c AT gmx DOT de>
 <0a8832b5-3ac5-4e0a-b142-0b638f6052fd AT SystematicSW DOT ab DOT ca>
 <CA+1jF5oPY8fADOLEPYSCFGkj49LHVNFZU5ewK23B2yDJ5jGXQA AT mail DOT gmail DOT com>
Organization: Systematic Software
In-Reply-To: <CA+1jF5oPY8fADOLEPYSCFGkj49LHVNFZU5ewK23B2yDJ5jGXQA@mail.gmail.com>
X-Rspamd-Queue-Id: 3B76A20027
X-Stat-Signature: pyewdpom5hp8xkmpk1xw6drhphkm1pr4
X-Rspamd-Server: rspamout02
X-Session-Marker: 427269616E2E496E676C69734053797374656D6174696353572E61622E6361
X-Session-ID: U2FsdGVkX1+kqcbGKPyjFBRVxvYQbGARm3HpUKX2u/s=
X-HE-Tag: 1753123760-610929
X-HE-Meta: U2FsdGVkX1+o7+jlyduXX3l+s9A8/2biR1oXVgvD7FFf+bMlF6NGCXz37wWrMoQlAmwn8BoA4hh2AxD1iuTL1yr5V1APgVnohRDwOn3NAL2Nrz6IdGc+Cl6YUAhigGuriMKw0lmbweebbw6dxC3R1NdSuwM4VMn/Lmu7OZbi7So2psJchhfH3wJbbkGGyiZCWAsZ8vjbXgUps4lJbAtM9qKvQRe65ndSzVuRnKltL7iX8nh6QDMhY8b4YkehmcBUjH1t8Pjgyzo/LA03IcnxhfoesxSdEJN1iCcUgoW6HWyVFn5QmnAnjaa23YWBm7f1uepGZU8jafewWF4yua2RkR+wMnPmQH75oqHKiqRRXAv5lGnpU2nmfowhwGkIplXbECGres+pLVNqVZdoxZ95q2np3NbPbS67G4vFslLsPjgZw1hTm84v3o8kRQ++sH+v0VhD6xGbDRc=
X-BeenThere: cygwin AT cygwin DOT com
X-Mailman-Version: 2.1.30
Precedence: list
List-Id: General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Unsubscribe: <https://cygwin.com/mailman/options/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=unsubscribe>
List-Archive: <https://cygwin.com/pipermail/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-request AT cygwin DOT com?subject=help>
List-Subscribe: <https://cygwin.com/mailman/listinfo/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=subscribe>
From: Brian Inglis via Cygwin <cygwin AT cygwin DOT com>
Reply-To: cygwin AT cygwin DOT com
Cc: Brian Inglis <Brian DOT Inglis AT SystematicSW DOT ab DOT ca>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
Errors-To: cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT com
Sender: "Cygwin" <cygwin-bounces~archive-cygwin=delorie DOT com AT cygwin DOT com>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from base64 to 8bit by delorie.com id 56LIoNwd3152277

On 2025-07-21 10:32, Aurélien Couderc via Cygwin wrote:
> On Mon, Jul 21, 2025 at 5:45 PM Brian Inglis via Cygwin
> <cygwin AT cygwin DOT com> wrote:
>>
>> On 2025-07-21 08:19, Matthias Andree via Cygwin wrote:
>>> Am 21.07.25 um 14:53 schrieb Aurélien Couderc via Cygwin:
>>>> I installed MariaDB (mysql fork) on my system, which per task manager
>>>> runs as it's own user "MariaDB".
>>>>
>>>> But Cygwin 3.7 from today cannot see the user "MariaDB", both getent
>>>> passwd MariaDB and getent passwd return no lines.
>>>>
>>>> Any clues what I am doing wrong?
>>>
>>> Did you create a local /etc/passwd file, say, through mkpasswd? If you did,
>>> maybe long ago -- maybe you need to re-run it and update your passwd file.
>>>
>>> https://cygwin.com/cygwin-ug-net/mkpasswd.html
>>
>> Preferably delete it and possibly modify /etc/nsswitch.conf:
>>
>>          https://cygwin.com/cygwin-ug-net/ntsec.html#ntsec-mapping-nsswitch
> 
> That file does not exist.

The may mean that the base-cygwin package script:

	/etc/postinstall/000-cygwin-post-install.sh

was not run successfully; if it was, it would be suffixed by .done; run either 
file from a shell and it will create a default base /etc/nsswitch.conf.

The relevant stanza may be displayed using the command:

$ awk '/NSSWITCH.*EOF$/,/^EOF/' /etc/postinstall/000-cygwin-post-install.sh*

> I think the problem is that Cygwin does not want to list accounts from
> "NT SERVICE" and "NT AUTHORITY", except you prefix that with "+". And
> that makes me mad, because it sucked up the time of around 25 students
> here for 90 mins in the class to find THAT solution. The professor
> KNEW the solution, but made it a group exercise for us to figure this
> bug out.
You can then modify that conf file per the docs linked above until you can see 
all the entries you expect: check using `getent passwd`, etc.

The above accounts are accessible using setting "db_enum: builtin"; you my want 
to start with: "db_enum: cache builtin local primary" to support the local 
cache, SAM, and AD; you could add source "files" to honour /etc/{passwd,group}, 
but you don't need that with the other entries; "alltrusted" to enumerate all 
trusted domain accounts, etc.

Running cygserver is advised to share a common cache across all running Cygwin 
processes, especially if running daemons and cron jobs or tasks, rather than 
having one cache per Cygwin process tree, and duplicating the enumeration, which 
can take a few seconds even over a LAN to a local DC.

-- 
Take care. Thanks, Brian Inglis              Calgary, Alberta, Canada

La perfection est atteinte                   Perfection is achieved
non pas lorsqu'il n'y a plus rien à ajouter  not when there is no more to add
mais lorsqu'il n'y a plus rien à retrancher  but when there is no more to cut
                                 -- Antoine de Saint-Exupéry

-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple