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

Thu Nov 4 22:05:27 UTC 2010

Are you sure this isn't some kind of a firewall issue?  A simple, but slightly 
dangerous, test would be to:

    (1) Turn off the firewall
    (2) Try to make your connection
    (3) Regardless of the outcome of (2), immediately turn the firewall back on.

-- Mike

>
>From: Qiubo Su (David Su) <qiubosu at gmail.com>
>To: support at drupal.org; cjones at partialflow.com
>Sent: Thu, November 4, 2010 1:59:15 PM
>Subject: Re: [support] urgently need help for Site off-line error
>
>helloChristopher,
>
>i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql 
>start, but still got the same error "ERROR 2002 (HY000): Can't connect to local 
>MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
>
>i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the 
>mysqld.sock file disappear and get the same error.
>
>i got this problem when i finished install/configure drupal site and make it up 
>and running, can browse the drupal site, loging from phpmyadmin, run 
>/etc/init.d/mysql start without any issue, log to mysql from command line 
>without any issue, then i restart the VM (use VM for this), then got the above 
>problem.
>
>
>
>
>On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones at partialflow.com> 
>wrote:
>
>The log is telling you that the users table doesn't exist. I don't know
>>how you installed mysql, or what distro you are using. If you installed
>>using a package management tool then an administrative user should have
>>been created. Review your installation process and make sure that all
>>the necessary databases and tables are there, including the one
>>mentioned in your logs. If you're using apt / dpkg and friends on a
>>debian system, then you might try something like
>>
>>apt-get install --reinstall mysql-server
>>
>>
>>On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
>>> dear drupal support,
>>>
>>> "/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have
>>> "bind-address" set to localhost and "socket" is set to
>>> /var/run/mysqld/mysqld.sock already.
>>>
>>> but after run /etc/init.d/mysql start, still got below output
>>>
>>> Rather than invoking init scripts through /etc/init.d, use the service(8)
>>> utility, e.g. service mysql restart
>>>
>>> Since the script you are attempting to invoke has been converted to an
>>> Upstart job, you may also use the restart(8) utility, e.g. restart mysql
>>>
>>> mysql start/running
>>>
>>> run mysql, still got below output as well
>>>
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>>> '/var/run/mysqld/mysqld.sock' (2)
>>>
>>> tail -10f /var/log/mysql/error.log, still got the same error
>>>
>>> 101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled.
>>> 101104 12:41:09  InnoDB: Started; log sequence number 0 44233
>>> 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege
>>> tables: Table 'mysql.user' doesn't exist
>>>
>>> by the way, the server use dynamic IP address and the
>>> /etc/network/interfaces is as below
>>>
>>> auto lo
>>> iface lo inet loopback
>>>
>>>
>>> On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel at ziobuddalabs.it
>>
>>> <mailto:michel at ziobuddalabs.it>> wrote:
>>>
>>>     Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
>>>>     hello drupal support team,
>>>>
>>>>     thanks for your reply.
>>>>     i tried /etc/init.d/mysql start and it is ok for the database,
>>>>     however, after i reboot the pc and run /etc/init.d/mysql start as
>>>>     below, it doesn't work again. thanks for your help with this again.
>>>>
>>>>     root at quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql
>>>>     start
>>>>
>>>>     Rather than invoking init scripts through /etc/init.d, use the
>>>>     service(8)
>>>>     utility, e.g. service mysql start
>>>>
>>>>     Since the script you are attempting to invoke has been converted to an
>>>>
>>>>     Upstart job, you may also use the start(8) utility, e.g. start mysql
>>>>     start: Job is already running: mysql
>>>>
>>>>     root at quicksu-desktop:/var/www/sites/all/modules# mysql
>>>>     ERROR 2002 (HY000): Can't connect to local MySQL server through
>>>>     socket '/var/run/mysqld/mysqld.sock' (2)
>>>     Hi, try to see if "/var/run/mysqld/" exist.
>>>     Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is
>>>     set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
>>>
>>>     M.
>>>
>>>     --
>>>     Michel'ZioBudda'  Morellimichel at ziobuddalabs.it 
>>> <mailto:michel at ziobuddalabs.it>
>>
>>>     Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)
>>>     Telefono: 0200619074
>>>     Telefono Cell: +39-3939890025 --  Fax: +39-0291390660
>>>
>>>     http://www.ziobudda.net                          ICQ: 58351764
>>>     http://www.ziobuddalabs.it                       Skype: zio_budda
>>>     http://www.ziodrupal.net                         
>>> MSN:michel at ziobuddalabs.it  <mailto:michel at ziobuddalabs.it>
>>>                                               JABBER:michel at ziobuddalabs.it 
>>> <mailto:michel at ziobuddalabs.it>
>>>
>>>
>>--
>>
>>[ Drupal support list | http://lists.drupal.org/ ]
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101104/65a43797/attachment.html 