hello drupal support team,<br><br>thanks for your reply.<br>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.<br>
<br>root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start<br><br>Rather than invoking init scripts through /etc/init.d, use the service(8)<br>utility, e.g. service mysql start<br><br>Since the script you are attempting to invoke has been converted to an<br>
<br>Upstart job, you may also use the start(8) utility, e.g. start mysql<br>start: Job is already running: mysql<br><br>root@quicksu-desktop:/var/www/sites/all/modules# mysql<br>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<br>
<br><div class="gmail_quote">On Thu, Nov 4, 2010 at 1:34 AM, Jamie Holly <span dir="ltr"><<a href="mailto:hovercrafter@earthlink.net">hovercrafter@earthlink.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Sounds like MySQL didn't start when you rebooted. Type:<br>
<br>
sudo /etc/init.d/mysql start<br>
<br>
In a terminal and see what happens. <br><font color="#888888">
<pre cols="72">Jamie Holly
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre></font><div><div></div><div class="h5">
<br>
On 11/3/2010 6:09 AM, Qiubo Su (David Su) wrote:
<blockquote type="cite">
<h2 style="font-weight: normal;"><font size="2">dear drupal
support,</font></h2>
i installed and configure my drupal site in local ubuntu pc. it
has been working fine, but after i reboot the pc, it shows the
below error message and can never login to the site to browse the
pages.<br>
<h2>Site off-line</h2>
<div>
<p>The site is currently not available due to technical
problems. Please try again later. Thank you for your
understanding.</p>
<hr>
<p><small>If you are the maintainer of this site, please check
your database settings in the <code>settings.php</code>
file and ensure that your hosting provider's database server
is running. For more help, see the <a href="http://drupal.org/node/258" target="_blank">handbook</a>,
or contact your hosting provider.</small></p>
<p> i login to OS and run mysql, but got the "ERROR 2002
(HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)" error message.</p>
i try to login though phpmyadmin, but couldn't login there as
well.<br>
<br>
in the /var/log/apache2/error.log file, there is below output:<br>
<br>
[Wed Nov 03 21:23:25 2010] [notice] Apache/2.2.14 (Ubuntu) DAV/2
mod_fcgid/2.3.4 PHP/5.3.2-1ubuntu4.5 with Suhosin-Patch
mod_ruby/1.2.6 Ruby/1.8.7(2010-01-10) mod_ssl/2.2.14
OpenSSL/0.9.8k configured -- resuming normal operations<br>
[Wed Nov 03 21:24:17 2010] [error] [client 192.168.35.103] PHP
Fatal error: Call to undefined function _system_theme_data() in
/var/www/includes/theme.inc on line 481<br>
[Wed Nov 03 21:24:20 2010] [error] [client 192.168.35.103] File
does not exist: /var/www/favicon.ico<br>
<br>
in the /var/log/mysql/error.log file, there is below output:<br>
<br>
101103 22:35:28 [Note] Plugin 'FEDERATED' is disabled.<br>
101103 22:35:28 InnoDB: Started; log sequence number 0 44233<br>
101103 22:35:28 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.user' doesn't exist<br>
<br>
it is much appreciated if you can help with this.<br>
<br>
thanks,<br>
qiubo su<br>
<br>
<br>
</div>
</blockquote>
</div></div></div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>