Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 15 May 2016 22:04:38 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 209512] mysql57-server-5.7.12: Server not usable after installation
Message-ID:  <bug-209512-13-k2jmjlsnMr@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-209512-13@https.bugs.freebsd.org/bugzilla/>
References:  <bug-209512-13@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D209512

--- Comment #5 from Regulus Kean <rkean@bitmessage.ch> ---
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.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-209512-13-k2jmjlsnMr>