From owner-freebsd-ports-bugs@freebsd.org Wed Oct 7 17:43:12 2020 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 13982434A2A for ; Wed, 7 Oct 2020 17:43:12 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.nyi.freebsd.org (mailman.nyi.freebsd.org [IPv6:2610:1c1:1:606c::50:13]) by mx1.freebsd.org (Postfix) with ESMTP id 4C61rv6sSfz3Zqj for ; Wed, 7 Oct 2020 17:43:11 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.nyi.freebsd.org (Postfix) id EB89E4344D0; Wed, 7 Oct 2020 17:43:11 +0000 (UTC) Delivered-To: ports-bugs@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id EB512434323 for ; Wed, 7 Oct 2020 17:43:11 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4C61rv61Twz3ZZ6 for ; Wed, 7 Oct 2020 17:43:11 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id B36461B50D for ; Wed, 7 Oct 2020 17:43:11 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 097HhBvH057557 for ; Wed, 7 Oct 2020 17:43:11 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 097HhBM3057556 for ports-bugs@FreeBSD.org; Wed, 7 Oct 2020 17:43:11 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 250186] sysutils/py-salt Postgres using hardcoded unknown user Date: Wed, 07 Oct 2020 17:43:11 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: danmcgrath.ca@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter cc flagtypes.name Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Oct 2020 17:43:12 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D250186 Bug ID: 250186 Summary: sysutils/py-salt Postgres using hardcoded unknown user Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Some People Priority: --- Component: Individual Port(s) Assignee: ports-bugs@FreeBSD.org Reporter: danmcgrath.ca@gmail.com CC: christer.edwards@gmail.com CC: christer.edwards@gmail.com Flags: maintainer-feedback?(christer.edwards@gmail.com) Hi, It would seem that when I tried to put some credentials for postgres into my /usr/local/etc/salt/minion.d/postgres.conf as follows: postgres.host: '/tmp' # to use a socket postgres.port: '5432' postgres.user: 'postgres' postgres.pass: '' postgres.maintenance_db: 'postgres' Trying to run a `salt-call postgres.db_list` (or anything) would fail, complaining that the user "pgsql" doesn't exist. A quick check in the file /usr/local/lib/python3.7/site-packages/salt/modules/postgres.py around line= 163 shows that there is a check for FreeBSD that sets the `runas =3D "pgsql"`, = which a few lines below ultimately sets the `user =3D runas`. If I change this to `runas =3D "postgres"` to match the system user id, the= state modules run fine. Seeing as how runas is a param for seemingly everything (see https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.postgres.= html), I suppose it is less critical, but I am thinking this is indeed a bug as it totally ignores the config file values that I specified when called via salt-call on the minion, but I defer to the experts! Thanks o/ --=20 You are receiving this mail because: You are the assignee for the bug.=