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

Thu Nov 4 22:52:39 UTC 2010

netstat -a shows open or waiting connections.  Run this to see if
mysql or port 3306 is in the list.
nmap will show open ports on a server

Could be permissions issues.

Sounds like mysql might be running already.  What does the following
command show show?

ps aux |grep mysql|grep -v grep

If it returns anything mysql already started up

Google is usually the place I look to solve crazy mysql issues.

http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.html
http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000-cant-connect-local-mysql-server.html

On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) <qiubosu at gmail.com> wrote:
> hello victor,
>
> i did notice this and update the base memory RAM to 1G.
>
> it is ubuntu 10.0.4.
>
> On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <victorkane at gmail.com> wrote:
>>
>> Check the memory assigned to the VM and make sure it is enough to start
>> all the processes.
>> If it turns out that this is the case, you should be able to allocate
>> additional memory for that VM process in its configuration.
>> What is the base system?
>> Victor
>>
>> On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon at yahoo.com>
>> wrote:
>>>
>>> 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
>>>
>>> hello Christopher,
>>>
>>> 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/ ]
>>>
>>>
>>>
>>> --
>>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>>
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>