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