From owner-freebsd-questions@freebsd.org Sun Feb 14 11:07:06 2021 Return-Path: Delivered-To: freebsd-questions@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 29ABD52AF66 for ; Sun, 14 Feb 2021 11:07:06 +0000 (UTC) (envelope-from darcy@druid.net) Received: from mail.vex.net (mail.vex.net [IPv6:2605:2600:1001::44]) by mx1.freebsd.org (Postfix) with ESMTP id 4Ddkvs1kcJz4tGR for ; Sun, 14 Feb 2021 11:07:04 +0000 (UTC) (envelope-from darcy@druid.net) Received: from imp.druid.net (unknown [IPv6:2607:9880:1150:40:ea2a:eaff:fe28:7058]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: darcy) by mail.vex.net (Postfix) with ESMTPSA id 0BF43471C6 for ; Sun, 14 Feb 2021 06:06:57 -0500 (EST) To: freebsd-questions@freebsd.org From: D'Arcy Cain Subject: Upgrade to 12.2 and permission weirdness Message-ID: <69dcd9f7-b5f8-1111-8bea-9be93a493eba@druid.net> Date: Sun, 14 Feb 2021 06:06:56 -0500 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: 4Ddkvs1kcJz4tGR X-Spamd-Bar: / Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=none (mx1.freebsd.org: domain of darcy@druid.net has no SPF policy when checking 2605:2600:1001::44) smtp.mailfrom=darcy@druid.net X-Spamd-Result: default: False [-0.57 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; ARC_NA(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; RBL_DBL_DONT_QUERY_IPS(0.00)[2605:2600:1001::44:from]; TO_MATCH_ENVRCPT_ALL(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; TO_DN_NONE(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; AUTH_NA(1.00)[]; RCPT_COUNT_ONE(0.00)[1]; SPAMHAUS_ZRD(0.00)[2605:2600:1001::44:from:127.0.2.255]; DMARC_NA(0.00)[druid.net]; NEURAL_SPAM_SHORT(0.43)[0.434]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_SPF_NA(0.00)[no SPF record]; RCVD_NO_TLS_LAST(0.10)[]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:19842, ipnet:2605:2600::/32, country:CA]; RCVD_COUNT_TWO(0.00)[2]; MAILMAN_DEST(0.00)[freebsd-questions] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 14 Feb 2021 11:07:06 -0000 I recently upgraded FreeBSD to 12.2. Everything seems fine except for some odd permission thing when running from cron. For example I have a script that dumps my clients' MySQL databases which gives me this email every morning: ERROR 1045 (28000): Access denied for user 'darcy'@'localhost' (using password: NO) Yet when I run the same command from the command line it works fine. I get a similar problem on another server with my PostgreSQL database under another user but when I switch that cron job to my user it does work. I suspect something related to effective vs. real UIDs and identd but nothing changed in the setup after the upgrade. Any ideas for what to look for? Cheers. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 788 2246 (DoD#0082) (eNTP) | what's for dinner. IM: darcy@VybeNetworks.com, VoIP: sip:darcy@druid.net Disclaimer: By sending an email to ANY of my addresses you are agreeing that: 1. I am by definition, "the intended recipient". 2. All information in the email is mine to do with as I see fit and make such financial profit, political mileage, or good joke as it lends itself to. In particular, I may quote it where I please. 3. I may take the contents as representing the views of your company if I so wish. 4. This overrides any disclaimer or statement of confidentiality that may be included or implied in your message.