From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Oct 11 17:30:03 2013 Return-Path: Delivered-To: freebsd-ports-bugs@smarthost.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id 71B4D745 for ; Fri, 11 Oct 2013 17:30:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:1900:2254:206c::16:87]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 5E92F25C1 for ; Fri, 11 Oct 2013 17:30:03 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.7/8.14.7) with ESMTP id r9BHU1HR072897 for ; Fri, 11 Oct 2013 17:30:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.7/8.14.7/Submit) id r9BHU1Nh072896; Fri, 11 Oct 2013 17:30:01 GMT (envelope-from gnats) Date: Fri, 11 Oct 2013 17:30:01 GMT Message-Id: <201310111730.r9BHU1Nh072896@freefall.freebsd.org> To: freebsd-ports-bugs@FreeBSD.org Cc: From: Michael Gmelin Subject: Re: ports/182547: [PATCH] databases/mariadb55-server: Respect hier(7) (also affects databases/mariadb55-client) X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Michael Gmelin List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Oct 2013 17:30:03 -0000 The following reply was made to PR ports/182547; it has been noted by GNATS. From: Michael Gmelin To: Miroslav Lachman <000.fbsd@quip.cz> Cc: "bug-followup@FreeBSD.org" , Alexandr Kovalenko Subject: Re: ports/182547: [PATCH] databases/mariadb55-server: Respect hier(7) (also affects databases/mariadb55-client) Date: Fri, 11 Oct 2013 19:16:42 +0200 > On 11 Oct 2013, at 18:41, Miroslav Lachman <000.fbsd@quip.cz> wrote: >=20 > Michael Gmelin wrote: >>=20 >>=20 >>> On 11 Oct 2013, at 16:56, Miroslav Lachman<000.fbsd@quip.cz> wrote: >>>=20 >>> Michael Gmelin wrote: >>>> On Wed, 02 Oct 2013 21:55:29 +0200 >>>> Miroslav Lachman<000.fbsd@quip.cz> wrote: >>>>>=20 >>>>> I will test your patch in a few days. I am too busy with my $WORK now.= >>>>>=20 >>>>> Miroslav Lachman >>>>=20 >>>> Did you have a chance to test the patch yet? >>>>=20 >>>> Michael >>>=20 >>> I tried it right now, but I have a problem. mariadb55-server cannot be b= uilt on my test machine FreeBSD 9.2-RC4 amd64 GENERIC. >>>=20 >>> I always get this error even with original (not patched) version: >>>=20 >>> Creating bzip'd tar ball in '/usr/ports/databases/mariadb55-server/work/= mariadb55-server-5.5.33a.tbz' >>> tar: lib/mysql/plugin/auth_pam.so: Cannot stat: No such file or director= y >>> tar: Error exit delayed from previous errors. >>> pkg_create: make_dist: tar command failed with code 256 >>>=20 >>> I'll investigate it later. I have mariadb55-server-5.5.33a built on 8.4 p= roduction server, so I don't know why it failed on 9.2-RC4. >=20 > I am not able to find a proper fix of the problem with auth_pam.so, so I j= ust delete it from pkg-plist. MariaDB works without it. >=20 > Tests I did: >=20 > 1) start MariaDB with /usr/local/etc/my.cnf > works > 2) start MariaDB with /etc/my.cnf > failed to start [intended] > 3) check my_print_defaults --help > it still prints /etc/ and /etc/mysql/ as right locations for my.cnf > [wrong] >=20 > And I have a comment to (2). It prints the error message to a logfile, but= user is not informed about any error with 'service' command. > I think it should be printed to the users console. >=20 > I did: >=20 > root@sm-reserve ~/# service mysql-server onestart > Starting mysql. >=20 > As you can see, 'service' command said "Starting mysql." and no error was s= hown, which is really bad. I thought it started with /etc/my.cnf and later f= ound in a logfile, that MariaDB start failed: >=20 > root@sm-reserve ~/# tail -f /var/db/mysql/sm-reserve.codelab.cz.err >=20 > 131011 18:18:23 mysqld_safe Starting mysqld daemon with databases from /va= r/db/mysql > error: Config file /etc/my.cnf in invalid location, please move to or merg= e with /usr/local/etc/my.cnf > Fatal error in defaults handling. Program aborted > 131011 18:18:23 mysqld_safe mysqld from pid file /var/db/mysql/sm-reserve.= codelab.cz.pid ended >=20 > Maybe it is not related to your patch but why 'service' (rc script mysql-s= erver) is silent in the case of a failed start? >=20 > Miroslav Lachman Afaik service mysql always has been silent about errors (eg innodb log file s= izes don't match etc) due to the way the daemon is started, this should be t= he same with mysql55. I remember missing a warning about innodb not working m= any years ago since it was buried in MySQL error log So improving this - also for the MySQL port - would be great, but might be o= utside of the scope of this PR.