[support] urgently need help for Site off-line error

[Victor Kane]

It is customary for four engineers travelling in a Fiat 147 that refuses to
start, to pull over to the side of the road as best they can, and stop the
car.

Then, they all get out. And get in again, and, turning the ignition key
surely but slowly, the car starts.

Make a new VM, install a LAMP stack using any well documented method,
install phpmyadmin using apt-get, and after making sure phpmyadmin works,
restore your Drupal site and report back.

On Fri, Nov 5, 2010 at 12:28 PM, Christopher M. Jones <
cjones at partialflow.com> wrote:

> Quiubu Su, "LAMP" stands for Linux+Apache+MySQL+PHP. So yes, you have a
> LAMP stack.
>
> Since you say you have created the socket file by hand, it may be that
> permissions got screwed up. This would not explain why the problem
> happened in the first place, unless you had done something else before
> you rebooted that might have changed permissions on one of that file's
> parent directories. If the socket file is not getting created by the
> mysql init script then this is a likely cause.
>
> If this doesn't help, Quiubu Su, then your problem is officially out of
> my league, and I commend your soul to more capable hands. However, I can
> still suggest that you google the error you're getting, and see if you
> can find clues from more general sources. At the end of the day this
> doesn't really appear to be a Drupal issue but a Linux / MySQL one.
> Sorry I couldn't help you more.
>
>
>
> On 11/05/2010 08:38 AM, Shai Gluskin wrote:
> > I'm late to this issue. What I'm reporting likely has nothing to do with
> > the issue... /but just in case/... and others should know about this
> anyway:
> >
> > *backup_migrate module v. 2.3 with table-locking turned on will crash
> > mysql on your server.*
> > *
> > *
> > There is a patch, but 2.3 is still the recommended release:
> > http://drupal.org/node/952584
> >
> > Shai
> >
> > On Fri, Nov 5, 2010 at 6:13 AM, Qiubo Su (David Su) <qiubosu at gmail.com
> > <mailto:qiubosu at gmail.com>> wrote:
> >
> >     On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane at gmail.com
> >     <mailto:victorkane at gmail.com>> wrote:
> >
> >         But what mystifies me is that quiuboso says it was running fine
> >         before he rebooted.
> >
> >         1. How much memory in the Ubuntu base machine? 2.5G
> >         2. Is the VM Ubuntu too? Yes It has 1 GB? Yes
> >         3. The VM effectively has a LAMP stack installed together with
> >         Drupal? No LAMP, I installed PHP, Apache, MySql manually
> >
> >
> >
> >         On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden
> >         <nick at thewebtailor.co.uk <mailto:nick at thewebtailor.co.uk>>
> wrote:
> >
> >             Some versions of MySQL default to only allowing local
> >             connections to the server. It's not clear from what you've
> >             written if, when you 'use a VM for this', the drupal install
> >             and the MySQL server are both on the VM. If not, you might
> >             need to alter the MySQL config to allow connections over the
> >             network from another machine. Not only that but you might
> >             need to change the GRANT command issued during the drupal
> >             set up, because if you grant permissions to a user @ a
> >             certain machine or IP those permissions do not apply if the
> >             user (in this case the drupal system) connects from a
> >             different machine or IP.
> >
> >             Hope that helps. I'm away from my desk so can't give exact
> >             advice, but that's what struck me when you mentioned using a
> VM.
> >
> >             Nick
> >             Sent from my BlackBerry® wireless device
> >
> >             -----Original Message-----
> >             From: "Qiubo Su \(David Su\)" <qiubosu at gmail.com
> >             <mailto:qiubosu at gmail.com>>
> >             Sender: support-bounces at drupal.org
> >             <mailto:support-bounces at drupal.org>
> >             Date: Fri, 5 Nov 2010 09:59:15
> >             To: <support at drupal.org <mailto:support at drupal.org>>;
> >             <cjones at partialflow.com <mailto:cjones at partialflow.com>>
> >             Reply-To: support at drupal.org <mailto:support at drupal.org>
> >             Subject: Re: [support] urgently need help for Site off-line
> >             error
> >
> >             --
> >             [ Drupal support list | http://lists.drupal.org/ ]
> >             --
> >
> >             [ Drupal support list | http://lists.drupal.org/ ]
> >
> >
> >
> >         --
> >         [ Drupal support list | http://lists.drupal.org/ ]
> >
> >
> >
> >     --
> >     [ Drupal support list | http://lists.drupal.org/ ]
> >
> >
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101105/c693d6cd/attachment-0001.html