From owner-freebsd-questions@FreeBSD.ORG Sat Dec 17 19:13:09 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 27BAE16A41F for ; Sat, 17 Dec 2005 19:13:09 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: from smtp4.suscom.net (smtp4.suscom.net [64.78.119.247]) by mx1.FreeBSD.org (Postfix) with ESMTP id E7DD643D45 for ; Sat, 17 Dec 2005 19:13:07 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: from localhost (unknown [127.0.0.1]) by smtp4.suscom.net (Postfix) with ESMTP id 8292B15005E for ; Sat, 17 Dec 2005 14:13:06 -0500 (EST) Received: from smtp4.suscom.net ([127.0.0.1]) by localhost (smtp4.suscom.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 07267-02-19 for ; Sat, 17 Dec 2005 14:13:02 -0500 (EST) Received: from seibercom.net (ip148.217.susc.suscom.net [216.45.217.148]) by smtp4.suscom.net (Postfix) with SMTP id 0145E150060 for ; Sat, 17 Dec 2005 14:13:01 -0500 (EST) Received: from [192.168.0.2] (//gerard [192.168.0.2]) by seibercom.net (8.13.4/8.13.4) with ESMTP id jBHJD2ZF048044 for ; Sat, 17 Dec 2005 14:13:02 -0500 (EST) (envelope-from gerard@seibercom.net) Date: Sat, 17 Dec 2005 14:13:04 -0500 From: Gerard Seibert To: freebsd-questions@freebsd.org Sender: gerard@seibercom.net Organization: Seibercom X-Face: "\j?x](l|]4p?-1Bf@!wN<&p=$.}^k-HgL}cJKbQZ3r#Ar]\%U(#6}'?<3s7%(%(gxJxxcR nSNPNr*/^~StawWU9KDJ-CT0k$f#@t2^K&BS_f|?ZV/.7Q Message-Id: <20051217141021.1B66.GERARD@seibercom.net> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Mailer: Becky! ver. 2.24.01 [en] X-Virus-Scanned: amavisd-new at suscom.net Subject: Script Problem X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-questions@freebsd.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 17 Dec 2005 19:13:09 -0000 Using FreeBSD 5.4 Please do not laugh. I absolutely suck at writing scripts. Someday I might learn, but in the mean time, I need some assistance. I want to run a script from CRON that will check to see if MySQL is running, and if not, restart it. I have had a problem with MySQL shutting down unexpectedly. This is my first attempt at writing the script. #!/bin/sh if (`ps -wxuU mysql | grep -o mysqld_safe`) then echo "MySQL is Running" else /usr/local/etc/rc.d/mysql-server.sh restart echo "MySql Server is Restarted" fi That produces this output even though MySQL is running. A mysqld process already exists Stopping mysql. Waiting for PIDS: 47567, 47567. Starting mysql. MySql Server is Restarted If I stop MySQL and then run the script, I get this output. mysql not running? (check /var/db/mysql/seibercom.net.pid). Starting mysql. MySql Server is Restarted Obviously, I do not know what I am doing. Perhaps someone could help me with this. Ciao -- Gerard Seibert gerard@seibercom.net