From owner-freebsd-ports@FreeBSD.ORG  Wed Jan 11 18:41:38 2012
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 57F5E106567A
	for <freebsd-ports@freebsd.org>; Wed, 11 Jan 2012 18:41:38 +0000 (UTC)
	(envelope-from feld@feld.me)
Received: from mwi1.coffeenet.org (unknown [IPv6:2607:f4e0:100:300::2])
	by mx1.freebsd.org (Postfix) with ESMTP id EAC6A8FC12
	for <freebsd-ports@freebsd.org>; Wed, 11 Jan 2012 18:41:37 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=feld.me;
	s=blargle; 
	h=In-Reply-To:Message-Id:From:Mime-Version:Date:References:Subject:To:Content-Type;
	bh=DKX5kmDn/gxExd58zAJW4eIXNqD82vjsNhnOuyOFdNk=; 
	b=Lj0SvxKa7T+gqy269jFXxMkya8Ymnt2BCPgBmREnLleSQWdq3COC4GxEdycD7iW1+phnw7yKGpE8Id3t12a14pU9cPqbGAEZ61O0cax/zPB9OjxY3geM8K7ULs0meoDT;
Received: from localhost ([127.0.0.1] helo=mwi1.coffeenet.org)
	by mwi1.coffeenet.org with esmtp (Exim 4.77 (FreeBSD))
	(envelope-from <feld@feld.me>) id 1Rl377-000LVH-OV
	for freebsd-ports@freebsd.org; Wed, 11 Jan 2012 12:41:37 -0600
Received: from feld@feld.me by mwi1.coffeenet.org (Archiveopteryx 3.1.4)
	with esmtpsa id 1326307287-88972-88971/5/15; Wed, 11 Jan 2012 18:41:27
	+0000
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: freebsd-ports@freebsd.org
References: <op.v7xljag634t2sn@tech304> <4F0DD20D.7010002@passap.ru>
Date: Wed, 11 Jan 2012 12:41:27 -0600
Mime-Version: 1.0
From: Mark Felder <feld@feld.me>
Message-Id: <op.v7xnjdfz34t2sn@tech304>
In-Reply-To: <4F0DD20D.7010002@passap.ru>
User-Agent: Opera Mail/11.61 (FreeBSD)
X-SA-Score: -1.0
Subject: Re: multimedia/zoneminder: rc script runs mysql commands?
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 11 Jan 2012 18:41:38 -0000

On Wed, 11 Jan 2012 12:16:45 -0600, Boris Samorodov <bsam@passap.ru> wrote:

> The problem is: while start-up zoneminder is launched after mysql
> was started but is not responding yet. Then zoneminder can't register
> it's cameras, etc. This hack was introduced to catch the moment when
> mysql really is operational and then start zoneminder.
> If someone has a solution -- you are welcome.

Instead of hacking up zoneminder's rc script with further patches like  
pulling out the real mysql server, database, username and password perhaps  
we should see if we can get the mysql maintainer(s) to fix the mysql rc  
script so it doesn't exit until the service is fully fired up and  
functional? I imagine what you've described is a situation where MySQL has  
a lot of databases/tables/etc and churns for a bit before accepting  
connections, but if it finally hits a badly crashed table or something and  
doesn't complete starting up but the rc script already exited... that  
wouldn't be good.

Advantage: better behavior
Disadvantage: slows up the start process of all dependent services.


This is all speculation at this point, but it seems silly that the mysql  
rc script would finish before the database can really accept connections.