From owner-freebsd-ports-bugs@freebsd.org Sun May 15 22:04:39 2016 Return-Path: Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4DCA5B3B2E8 for ; Sun, 15 May 2016 22:04:39 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 233B6117E for ; Sun, 15 May 2016 22:04:39 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id u4FM4ctA019361 for ; Sun, 15 May 2016 22:04:39 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 209512] mysql57-server-5.7.12: Server not usable after installation Date: Sun, 15 May 2016 22:04:38 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed 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 Many People X-Bugzilla-Who: rkean@bitmessage.ch X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: 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.22 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 15 May 2016 22:04:39 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D209512 --- Comment #5 from Regulus Kean --- Certainly. What I get now is this: 2016-05-15 21:54:19 [WARNING] mysql_install_db is deprecated. Please consid= er switching to mysqld --initialize 2016-05-15 21:54:19 [ERROR] Child process: /usr/local/libexec/mysqldterminated prematurely with errno=3D 32 2016-05-15 21:54:19 [ERROR] Failed to execute /usr/local/libexec/mysqld --defaults-extra-file=3D/usr/local/etc/mysql/my.cnf --bootstrap --datadir=3D/var/db/mysql --lc-messages-dir=3D/usr/local/share/mysql --lc-messages=3Den_US --basedir=3D/usr/local -- server log begin -- mysqld: [ERROR] Could not open required defaults file: /usr/local/etc/mysql/my.cnf mysqld: [ERROR] Fatal error in defaults handling. Program aborted! -- server log end -- /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql The file in question exists, but has the following permissions: -rw-r----- 1 root wheel 2319 May 12 06:03 /usr/local/etc/mysql/my.cnf Changing the file's group to "mysql" seems to fix this issue. Issuing "serv= ice mysql-server start" now gives: 2016-05-15 21:59:21 [WARNING] mysql_install_db is deprecated. Please consid= er switching to mysqld --initialize 2016-05-15 21:59:57 [WARNING] The bootstrap log isn't empty: 2016-05-15 21:59:57 [WARNING] 2016-05-15T19:59:21.636758Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead 2016-05-15T19:59:21.639688Z 0 [Warning] Could not increase number of max_open_files to more than 28701 (request: 32929) 2016-05-15T19:59:21.639724Z 0 [Warning] Changed limits: table_open_cache: 1= 4270 (requested 16384) Starting mysql. And indeed, the server is running now, and also after rebooting the machine. Thank you very much for your help! Of course, I'd be glad to test out patch= es to see whether installing an updated package results in a running mysql ser= ver right away. --=20 You are receiving this mail because: You are the assignee for the bug.=