From owner-freebsd-questions@freebsd.org Mon Mar 22 22:33:50 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 E7DCB5BC93D for ; Mon, 22 Mar 2021 22:33:50 +0000 (UTC) (envelope-from freebsd@dreamchaser.org) Received: from nightmare.dreamchaser.org (ns.dreamchaser.org [66.109.141.57]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "dreamchaser.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4F48Rd6SqBz4rYK for ; Mon, 22 Mar 2021 22:33:49 +0000 (UTC) (envelope-from freebsd@dreamchaser.org) Received: from breakaway.dreamchaser.org (breakaway [192.168.151.122]) by nightmare.dreamchaser.org (8.15.2/8.15.2) with ESMTP id 12MMXgM9054602; Mon, 22 Mar 2021 16:33:42 -0600 (MDT) (envelope-from freebsd@dreamchaser.org) Reply-To: freebsd@dreamchaser.org Subject: Re: problems upgrading mysql 5.6 => 5.7 To: John Levine , freebsd-questions@freebsd.org References: <20210321235845.E3B5870DD030@ary.qy> From: Gary Aitken Message-ID: <5ec345c3-01a6-f959-0971-5836ecc85e20@dreamchaser.org> Date: Mon, 22 Mar 2021 16:33:42 -0600 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:78.0) Gecko/20100101 Thunderbird/78.6.1 MIME-Version: 1.0 In-Reply-To: <20210321235845.E3B5870DD030@ary.qy> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.6.2 (nightmare.dreamchaser.org [192.168.151.101]); Mon, 22 Mar 2021 16:33:42 -0600 (MDT) X-Rspamd-Queue-Id: 4F48Rd6SqBz4rYK X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=pass (mx1.freebsd.org: domain of freebsd@dreamchaser.org designates 66.109.141.57 as permitted sender) smtp.mailfrom=freebsd@dreamchaser.org X-Spamd-Result: default: False [-3.30 / 15.00]; HAS_REPLYTO(0.00)[freebsd@dreamchaser.org]; ARC_NA(0.00)[]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; REPLYTO_ADDR_EQ_FROM(0.00)[]; DMARC_NA(0.00)[dreamchaser.org]; SPAMHAUS_ZRD(0.00)[66.109.141.57:from:127.0.2.255]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RBL_DBL_DONT_QUERY_IPS(0.00)[66.109.141.57:from]; NEURAL_HAM_SHORT(-1.00)[-0.996]; RCPT_COUNT_TWO(0.00)[2]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; RCVD_TLS_LAST(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:21947, ipnet:66.109.128.0/19, country:US]; 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: Mon, 22 Mar 2021 22:33:51 -0000 On 3/21/21 5:58 PM, John Levine wrote: > If you're using the mysql-server package, Mysql runs as the mysql > user, user ID 88, and all of its data files should belong > to mysql. > > Unless you really REALLY know what you are doing, nothing but mysql should be > writing the files in its database directory so nobody else should have write access to it. Well, I really *don't* know what I'm doing... I always started mysqld from a user account. I didn't pay attention to the owner/protections on the files, just set the data dir, and at one point I changed the permissions of everything in that account to 600; I may have forced the owner/group as well. I knew mysqld ran as mysql but I thought it only did that when started by root. Anyway... I chmod'd and chown'ed things to mysql:mysql and now get the following: [Warning] Can't create test file /hd2/home/me/mysql_data/breakaway.lower-test [Note] mysqld (mysqld 5.7.33-log) starting as process 14257 ... [Warning] Can't create test file /usr/home/me/mysql_data/breakaway.lower-test [Warning] Can't create test file /usr/home/me/mysql_data/breakaway.lower-test [Warning] One can only use the --user switch if running as root mysqld: File './mysql-bin.index' not found (Errcode: 13 - Permission denied) [ERROR] Aborting [Note] Binlog end There is an old mysql-bin.index file: ~/mysql_data$ ls -l mysql-bin.index -rwxrwx--- 1 mysql mysql 0 Feb 8 2020 mysql-bin.index and the directory: ~/mysql_data$ ls -dl . drwxrwxr-x 12 mysql mysql 1024 Mar 22 13:19 . so I don't understand what it is complaining about. aside: It was suggested to me that I go straight to version 8. However, when I deinstalled mysql57-client and mysql57-server it also wanted to deinstall libreoffice. I deleted using -f but when I tried to reinstall mysql80-server it wanted to reinstall mysql57-client and mysql80-client both, but then I got this: Proceed with this action? [y/N]: y [1/3] Fetching mysql80-server-8.0.23.txz: 100% 18 MiB 263.4kB/s 01:10 [2/3] Fetching mysql57-client-5.7.33.txz: 100% 2 MiB 397.0kB/s 00:05 [3/3] Fetching mysql80-client-8.0.23.txz: 100% 4 MiB 398.4kB/s 00:10 Checking integrity... done (2 conflicting) - mysql57-client-5.7.33 conflicts with mysql80-server-8.0.23 on /usr/local/bin/mysql_ssl_rsa_setup - mysql80-client-8.0.23 conflicts with mysql57-client-5.7.33 on /usr/local/bin/mysql Checking integrity... done (0 conflicting) Conflicts with the existing packages have been found. One more solver iteration is needed to resolve them. The following 3 package(s) will be affected (of 0 checked): Installed packages to be REMOVED: libreoffice: 7.0.4.2 New packages to be INSTALLED: mysql80-client: 8.0.23 mysql80-server: 8.0.23 So I tried deleting libreoffice, installing mysql80, then libreoffice, but libreoffice wants to replace mysql80-client with mysql57-client. That's using pkg to install, as opposed to building from ports. Gary