ports/182547: [PATCH] databases/mariadb55-server: Respect hier(7) (also affects databases/mariadb55-client)

[Miroslav Lachman]

The following reply was made to PR ports/182547; it has been noted by GNATS.

From: Miroslav Lachman <000.fbsd at quip.cz>
To: Michael Gmelin <freebsd at grem.de>
Cc: "bug-followup at FreeBSD.org" <bug-followup at FreeBSD.org>, 
 Alexandr Kovalenko <never at nevermind.kiev.ua>
Subject: Re: ports/182547: [PATCH] databases/mariadb55-server: Respect hier(7)
 (also affects databases/mariadb55-client)
Date: Fri, 11 Oct 2013 18:41:01 +0200

 Michael Gmelin wrote:
 >
 >
 >> On 11 Oct 2013, at 16:56, Miroslav Lachman<000.fbsd at quip.cz>  wrote:
 >>
 >> Michael Gmelin wrote:
 >>> On Wed, 02 Oct 2013 21:55:29 +0200
 >>> Miroslav Lachman<000.fbsd at quip.cz>   wrote:
 >>>>
 >>>> I will test your patch in a few days. I am too busy with my $WORK now.
 >>>>
 >>>> Miroslav Lachman
 >>>
 >>> Did you have a chance to test the patch yet?
 >>>
 >>> Michael
 >>
 >> I tried it right now, but I have a problem. mariadb55-server cannot be built on my test machine FreeBSD 9.2-RC4 amd64 GENERIC.
 >>
 >> I always get this error even with original (not patched) version:
 >>
 >> 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 directory
 >> tar: Error exit delayed from previous errors.
 >> pkg_create: make_dist: tar command failed with code 256
 >>
 >> I'll investigate it later. I have mariadb55-server-5.5.33a built on 8.4 production server, so I don't know why it failed on 9.2-RC4.
 
 I am not able to find a proper fix of the problem with auth_pam.so, so I 
 just delete it from pkg-plist. MariaDB works without it.
 
 Tests I did:
 
 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]
 
 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.
 
 I did:
 
 root at sm-reserve ~/# service mysql-server onestart
 Starting mysql.
 
 As you can see, 'service' command said "Starting mysql." and no error 
 was shown, which is really bad. I thought it started with /etc/my.cnf 
 and later found in a logfile, that MariaDB start failed:
 
 root at sm-reserve ~/# tail -f /var/db/mysql/sm-reserve.codelab.cz.err
 
 131011 18:18:23 mysqld_safe Starting mysqld daemon with databases from 
 /var/db/mysql
 error: Config file /etc/my.cnf in invalid location, please move to or 
 merge 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
 
 Maybe it is not related to your patch but why 'service' (rc script 
 mysql-server) is silent in the case of a failed start?
 
 Miroslav Lachman