[support] urgently need help for Site off-line error
Qiubo Su (David Su)
qiubosu at gmail.com
Thu Nov 4 22:41:35 UTC 2010
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 <MSN%3Amichel at ziobuddalabs.it> <mailto:
>>> michel at ziobuddalabs.it>
>>> >
>>> JABBER:michel at ziobuddalabs.it <JABBER%3Amichel 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101105/02587f6e/attachment.html
More information about the support
mailing list