If you read the docs (i.e. manual.html) you'll find:
setenv MSQL_DEBUG api:query
________________________________________
Michael D. Black Principal Engineer
mblack@csi.cc 407-676-2923,x203
http://www.csi.cc Computer Science Innovations
http://www.csi.cc/~mike My home page
FAX 407-676-2355
----- Original Message -----
From: Steve C <stephen.catto@REMOVESPAMcableinet.co.uk>
To: Bill Loye <bloye@protocom.com>; <msql-list@lists.hughes.com.au>
Sent: Friday, October 15, 1999 11:31 AM
Subject: Re: Log files
Hi Bill,
Bill Loye wrote:
>
> Is there any way to start log files (similar to
> apache access_errorlog, xtacas, and sendmail
> system logging) for the msql db server?
>
> Something is periodically killing my msql server
> and I can't determine what it is (there are several
> people developing on it). I am running 2.0.11
> on a sparc 20 with 128 mb, Solaris 2.5. No other
> processes are affected.
>
> Thank you.
This might be the job of the guardian script
it can be found in the file msql-2.0.10.1.tar
after unpacking in the scripts directory called
run_daemon.
It needs a bit of editing, mail address and inst_dir and
see paste below.
HTH
Steve C
remove the horrible REMOVESPAM from email address to reply
==== paste of script ====
#!/bin/sh
#
# Because this stuff is still pretty young, you may wish to run the
# server using this script. It'll notify if the server crashes and
# restart it after a couple of minutes. It also puts the core in a
# known
# place and mails you any output generated by the terminal process.
#
# run it as 'run_daemon msqld' to run the mSQL engine.
#
# bambi@Bond.edu.au
INST_DIR=/usr/local/Minerva
ADMIN="you@some.machine"
PROG=$1
if test ! -d "${INST_DIR}/debug"
then
mkdir ${INST_DIR}/debug
fi
if test ! -d "${INST_DIR}/debug/${PROG}"
then
mkdir ${INST_DIR}/debug/${PROG}
fi
while :
do
cd ${INST_DIR}/debug/${PROG}
${INST_DIR}/bin/${PROG} > output 2>&1
echo "Program : ${PROG}
Time : `date`
Program Output
--------------
" > mail.tmp
cat output >> mail.tmp
/usr/ucb/mail -s "Minerva Daemon Crash Report" ${ADMIN} <
mail.tmp
sleep 15
done
============ end of paste =============
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST