Skip site navigation (1)Skip section navigation (2) 
Date:      Wed, 11 Jan 2012 11:58:12 -0600
From:      Mark Felder <feld@feld.me>
To:        freebsd-ports@freebsd.org
Cc:        bsam@freebsd.org
Subject:   multimedia/zoneminder: rc script runs mysql commands?
Message-ID:  <op.v7xljag634t2sn@tech304>
next in thread | raw e-mail | index | archive | help 
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  
2>&1 && return
                 _count=$(( $_count + 1 ))
                 if [ $_count -gt 10 ]; then
                         err 1 "${name}: mysqltest command failed"
                 fi

                 sleep 1
         done
}


If you have your mysql install on a different server (which you should if  
you have tons of cameras and events) the startup fails to work. I can't  
see a reason why this should be kept, but perhaps someone else has an  
idea? This isn't a common practice in any other program that requires a  
database....



Thanks,


Mark

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?op.v7xljag634t2sn>