You could simulate a crash by deleting the mysql.sock file. If your ISP
allows you to access the logs, he may have inadvertently allowed others
access to them as well. Are you able to check if the system, especially
mysql, is all locked down properly. Correct permission, ownerships, etc.?
Only someone with the correct mysql root password could shut it down like
that. Are you able to check what cron jobs are running?
----- Original Message -----
From: "Chuck Lucas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 14:13
Subject: Re: MySql keeps crashing
> Yes, "host server" means ISP.
>
> I am able to view the logs because he lets me.
>
> I agree with you, I think someone else is shutting down the database, but
he
> insists that my perl scripts are causing it to crash. The only proof I
have
> right now is the MySql error log, which lists the "normal shutdown"
> messages. These messages occur everytime the database goes down. I need
to
> be able to show him the logs and prove that *I'm* not crashing the
database,
> someone/something is shutting it down.
>
> I was just hoping that the MySql developers would see my post and tell me
> that "normal shutdown" messages will NOT occur if the database
crashes...so
> I can go back to him and prove he's lying to me.
>
> Thanx,
> Chuck
>
> ----- Original Message -----
> From: Rolf Hopkins <[EMAIL PROTECTED]>
> To: Chuck Lucas <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, June 11, 2001 01:55
> Subject: Re: MySql keeps crashing
>
>
> >
> > This doesn't make much sense to me. By "host server" you mean your
ISP?
> > If so how are you able to view the logs? Are you DB admin or something?
> By
> > the looks, someone is able to get in and shut it down. This can only
> happen
> > with admin rights or mysql server wasn't set up correctly in the first
> > place.
> >
> > I can't possibly see how SQL scripts could shutdown the server
especially
> if
> > the server has been properly setup and secured.
> >
> >
> > ----- Original Message -----
> > From: "Chuck Lucas" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, June 11, 2001 12:03
> > Subject: help: MySql keeps crashing
> >
> >
> > > Need a little assistance. I've looked through the current MySql
manual,
> > but
> > > I can't find any information concerning my questions.
> > >
> > > My MySql server keeps crashing, or that's what my host server tells
me.
> > He
> > > claims that my scripts are crashing MySql. However, when I look at
the
> > > MySql error log, I see messages like this:
> > >
> > > mysqld started on Fri Jun 8 07:36:34 PDT 2001
> > > /usr/sbin/mysqld: ready for connections
> > > 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown
> > >
> > > 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete
> > >
> > > mysqld ended on Fri Jun 8 14:39:45 PDT 2001
> > >
> > > My questions are thus: If the server crashes, would it write a
"normal"
> > > shutdown message, or is that message indicative of someone/something
> > sending
> > > MySql a "shutdown" signal? Am I even looking in the correct
> log...should
> > I
> > > be looking in the update log, or somewhere else?
> > >
> > > Here is some other information that may affect your answer:
> > >
> > > MySql Server version 3.22.21
> > >
> > > Running on Cobalt RaQ with the following OS info:
> > > Linux 2.0.34 #1 mips
> > > glibc-2.0.7-10
> > >
> > > Any help you could offer would be greatly appreciated!
> > >
> > > Chuck
> > > [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
