Re: multimedia/zoneminder: rc script runs mysql commands?

2012-04-02 Thread wwwdrich
where Id=1; | \ /usr/local/bin/mysqltest -h ${ZM_DB_HOST} -u ${ZM_DB_USER} -p${ZM_DB_PASS} ${ZM_DB_NAME} /dev/null 21 return -- View this message in context: http://freebsd.1045724.n5.nabble.com/multimedia-zoneminder-rc-script-runs-mysql-commands-tp5137566p5613799.html

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-04-02 Thread Mark Felder
On Mon, 02 Apr 2012 16:37:46 -0500, wwwdrich dr...@employees.org wrote: I have a K.I.S.S. solution I have been running for a while. Just source the zm.conf file into the init script and then use the variables there for the mysql test. I like this idea a lot. Is it breaking any guidelines? I

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-13 Thread Alex Dupre
Boris Samorodov ha scritto: Actually this should not happen. mysql rc script has a poststart directive to wait until the daemon is up and running. Last time I used the port (zoneminder) a year ago. It was the case. Has something changed in a year? MySQL rc script was patched 3 years ago. --

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-13 Thread Mark Felder
On Fri, 13 Jan 2012 03:20:13 -0600, Alex Dupre a...@freebsd.org wrote: Boris Samorodov ha scritto: Actually this should not happen. mysql rc script has a poststart directive to wait until the daemon is up and running. Last time I used the port (zoneminder) a year ago. It was the case. Has

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-12 Thread perryh
Chris Rees cr...@freebsd.org wrote: On 11 January 2012 18:44, Doug Barton do...@freebsd.org wrote: On 1/11/2012 10:41 AM, Mark Felder wrote: 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

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-12 Thread Alex Dupre
Boris Samorodov ha scritto: The problem is: while start-up zoneminder is launched after mysql was started but is not responding yet. Actually this should not happen. mysql rc script has a poststart directive to wait until the daemon is up and running. -- Alex Dupre

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-12 Thread Boris Samorodov
12.01.2012 14:23, Alex Dupre пишет: Boris Samorodov ha scritto: The problem is: while start-up zoneminder is launched after mysql was started but is not responding yet. Actually this should not happen. mysql rc script has a poststart directive to wait until the daemon is up and running.

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-12 Thread Ion-Mihai Tetcu
: Wednesday, January 11, 2012 2:47 PM To: Mark Felder Cc: freebsd-ports@freebsd.org Subject: Re: multimedia/zoneminder: rc script runs mysql commands? On Wed, 11 Jan 2012 12:41:27 -0600 Mark Felder f...@feld.me wrote: On Wed, 11 Jan 2012 12:16:45 -0600, Boris Samorodov b...@passap.ru wrote

multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Mark Felder
Hi all, The zoneminder port has this in its rc script which really should go away: zm_prestart() { local _count=0 while : ; do echo USE zm; SELECT Username from Users where Id=1; | \ /usr/local/bin/mysqltest -u root zm /dev/null 21 return

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Boris Samorodov
11.01.2012 21:58, Mark Felder пишет: The zoneminder port has this in its rc script which really should go away: zm_prestart() { local _count=0 while : ; do echo USE zm; SELECT Username from Users where Id=1; | \ /usr/local/bin/mysqltest

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Mark Felder
On Wed, 11 Jan 2012 12:16:45 -0600, Boris Samorodov b...@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

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Doug Barton
On 1/11/2012 10:41 AM, Mark Felder wrote: 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

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Mark Felder
On Wed, 11 Jan 2012 12:44:26 -0600, Doug Barton do...@freebsd.org wrote: That is attractive all on its own of course, however it still doesn't solve the OP's problem, since his mysqld is not local. Yeah, that was me -- the OP -- and I'm sitting here brainstorming but haven't been able to

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Chris Rees
On 11 January 2012 18:44, Doug Barton do...@freebsd.org wrote: On 1/11/2012 10:41 AM, Mark Felder wrote: 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

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Ion-Mihai Tetcu
On Wed, 11 Jan 2012 12:41:27 -0600 Mark Felder f...@feld.me wrote: On Wed, 11 Jan 2012 12:16:45 -0600, Boris Samorodov b...@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

Re: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Boris Samorodov
11.01.2012 22:41, Mark Felder пишет: I imagine what you've described is a situation where MySQL has a lot of databases/tables/et Unfortunately, it happens even if zoneminder is a lonely user of mysql. The pause (at my three-year-old server) was about 5 seconds... -- WBR, Boris Samorodov

RE: multimedia/zoneminder: rc script runs mysql commands?

2012-01-11 Thread Michael Scheidell
...@freebsd.org] on behalf of Ion-Mihai Tetcu [ite...@freebsd.org] Sent: Wednesday, January 11, 2012 2:47 PM To: Mark Felder Cc: freebsd-ports@freebsd.org Subject: Re: multimedia/zoneminder: rc script runs mysql commands? On Wed, 11 Jan 2012 12:41:27 -0600 Mark Felder f...@feld.me wrote: On Wed, 11