hello erik,<br><br>below are the results a) to e) by running the commands:<br><br>a) root@quicksu-desktop:/home/quicksu# netstat -a | grep mysql<br><br>b) root@quicksu-desktop:/home/quicksu# netstat -a | grep 3006<br><br>c) root@quicksu-desktop:/home/quicksu# nmap localhost<br>
<br>Starting Nmap 5.00 ( <a href="http://nmap.org">http://nmap.org</a> ) at 2010-11-05 12:19 NZDT<br>Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1.<br>Interesting ports on localhost (127.0.0.1):<br>Not shown: 996 closed ports<br>
PORT STATE SERVICE<br>21/tcp open ftp<br>80/tcp open http<br>443/tcp open https<br>631/tcp open ipp<br><br>Nmap done: 1 IP address (1 host up) scanned in 0.42 seconds<br><br>d) root@quicksu-desktop:/home/quicksu# nmap -A -T4 localhost<br>
<br>Starting Nmap 5.00 ( <a href="http://nmap.org">http://nmap.org</a> ) at 2010-11-05 12:21 NZDT<br>Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1.<br>Interesting ports on localhost (127.0.0.1):<br>Not shown: 996 closed ports<br>
PORT STATE SERVICE VERSION<br>21/tcp open ftp vsftpd 2.2.2<br>80/tcp open http Apache httpd 2.2.14 ((Ubuntu))<br>| robots.txt: has 36 disallowed entries (15 shown)<br>| /includes/ /misc/ /modules/ /profiles/ /scripts/ <br>
| /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt <br>| /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt <br>|_ /MAINTAINERS.txt<br>|_ html-title: Site off-line | Drupal<br>443/tcp open http Apache httpd 2.2.14 ((Ubuntu))<br>
| robots.txt: has 36 disallowed entries (15 shown)<br>| /includes/ /misc/ /modules/ /profiles/ /scripts/ <br>| /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt <br>| /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt <br>
|_ /MAINTAINERS.txt<br>|_ html-title: Site off-line | Drupal<br>631/tcp open ipp CUPS 1.4<br>No exact OS matches for host (If you know what OS is running on it, see <a href="http://nmap.org/submit/">http://nmap.org/submit/</a> ).<br>
TCP/IP fingerprint:<br>OS:SCAN(V=5.00%D=11/5%OT=21%CT=1%CU=30003%PV=N%DS=0%G=Y%TM=4CD34015%P=i686-<br>OS:pc-linux-gnu)SEQ(SP=CA%GCD=1%ISR=CC%TI=Z%CI=Z%II=I%TS=8)SEQ(SP=CA%GCD=2%<br>OS:ISR=CC%TI=Z%CI=Z%II=I%TS=8)OPS(O1=M400CST11NW6%O2=M400CST11NW6%O3=M400CN<br>
OS:NT11NW6%O4=M400CST11NW6%O5=M400CST11NW6%O6=M400CST11)WIN(W1=8000%W2=8000<br>OS:%W3=8000%W4=8000%W5=8000%W6=8000)ECN(R=Y%DF=Y%T=40%W=8018%O=M400CNNSNW6%<br>OS:CC=Y%Q=)T1(R=Y%DF=Y%T=40%S=O%A=S+%F=AS%RD=0%Q=)T2(R=N)T3(R=Y%DF=Y%T=40%W<br>
OS:=8000%S=O%A=S+%F=AS%O=M400CST11NW6%RD=0%Q=)T4(R=Y%DF=Y%T=40%W=0%S=A%A=Z%<br>OS:F=R%O=%RD=0%Q=)T5(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%RD=0%Q=)T6(R=Y%DF=Y<br>OS:%T=40%W=0%S=A%A=Z%F=R%O=%RD=0%Q=)T7(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%R<br>
OS:D=0%Q=)U1(R=Y%DF=N%T=40%IPL=164%UN=0%RIPL=G%RID=G%RIPCK=G%RUCK=G%RUD=G)I<br>OS:E(R=Y%DFI=N%T=40%CD=S)<br><br>Network Distance: 0 hops<br>Service Info: OS: Unix<br><br>OS and Service detection performed. Please report any incorrect results at <a href="http://nmap.org/submit/">http://nmap.org/submit/</a> .<br>
Nmap done: 1 IP address (1 host up) scanned in 30.47 seconds<br><br>e) root@quicksu-desktop:/home/quicksu# ps aux | grep mysql | grep -v grep<br><br><div class="gmail_quote">On Fri, Nov 5, 2010 at 11:52 AM, Erik Saline <span dir="ltr"><<a href="mailto:erik.saline@gmail.com">erik.saline@gmail.com</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;">netstat -a shows open or waiting connections. Run this to see if<br>
mysql or port 3306 is in the list.<br>
nmap will show open ports on a server<br>
<br>
Could be permissions issues.<br>
<br>
Sounds like mysql might be running already. What does the following<br>
command show show?<br>
<br>
ps aux |grep mysql|grep -v grep<br>
<br>
If it returns anything mysql already started up<br>
<br>
<br>
Google is usually the place I look to solve crazy mysql issues.<br>
<br>
<br>
<a href="http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.html" target="_blank">http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.html</a><br>
<a href="http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000-cant-connect-local-mysql-server.html" target="_blank">http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000-cant-connect-local-mysql-server.html</a><br>
<div><div></div><div class="h5"><br>
<br>
On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) <<a href="mailto:qiubosu@gmail.com">qiubosu@gmail.com</a>> wrote:<br>
> hello victor,<br>
><br>
> i did notice this and update the base memory RAM to 1G.<br>
><br>
> it is ubuntu 10.0.4.<br>
><br>
> On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <<a href="mailto:victorkane@gmail.com">victorkane@gmail.com</a>> wrote:<br>
>><br>
>> Check the memory assigned to the VM and make sure it is enough to start<br>
>> all the processes.<br>
>> If it turns out that this is the case, you should be able to allocate<br>
>> additional memory for that VM process in its configuration.<br>
>> What is the base system?<br>
>> Victor<br>
>><br>
>> On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <<a href="mailto:jm_hannon@yahoo.com">jm_hannon@yahoo.com</a>><br>
>> wrote:<br>
>>><br>
>>> Are you sure this isn't some kind of a firewall issue? A simple, but<br>
>>> slightly dangerous, test would be to:<br>
>>><br>
>>> (1) Turn off the firewall<br>
>>> (2) Try to make your connection<br>
>>> (3) Regardless of the outcome of (2), immediately turn the firewall<br>
>>> back on.<br>
>>><br>
>>> -- Mike<br>
>>><br>
>>> From: Qiubo Su (David Su) <<a href="mailto:qiubosu@gmail.com">qiubosu@gmail.com</a>><br>
>>> To: <a href="mailto:support@drupal.org">support@drupal.org</a>; <a href="mailto:cjones@partialflow.com">cjones@partialflow.com</a><br>
>>> Sent: Thu, November 4, 2010 1:59:15 PM<br>
>>> Subject: Re: [support] urgently need help for Site off-line error<br>
>>><br>
>>> hello Christopher,<br>
>>><br>
>>> i run apt-get install --reinstall mysql-server and start<br>
>>> /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000):<br>
>>> Can't connect to local MySQL server through socket<br>
>>> '/var/run/mysqld/mysqld.sock' (2)".<br>
>>><br>
>>> i even create /var/run/mysqld/mysqld.sock file and then restart mysql,<br>
>>> but the mysqld.sock file disappear and get the same error.<br>
>>><br>
>>> i got this problem when i finished install/configure drupal site and make<br>
>>> it up and running, can browse the drupal site, loging from phpmyadmin, run<br>
>>> /etc/init.d/mysql start without any issue, log to mysql from command line<br>
>>> without any issue, then i restart the VM (use VM for this), then got the<br>
>>> above problem.<br>
>>><br>
>>><br>
>>><br>
>>> On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones<br>
>>> <<a href="mailto:cjones@partialflow.com">cjones@partialflow.com</a>> wrote:<br>
>>>><br>
>>>> The log is telling you that the users table doesn't exist. I don't know<br>
>>>> how you installed mysql, or what distro you are using. If you installed<br>
>>>> using a package management tool then an administrative user should have<br>
>>>> been created. Review your installation process and make sure that all<br>
>>>> the necessary databases and tables are there, including the one<br>
>>>> mentioned in your logs. If you're using apt / dpkg and friends on a<br>
>>>> debian system, then you might try something like<br>
>>>><br>
>>>> apt-get install --reinstall mysql-server<br>
>>>><br>
>>>> On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:<br>
>>>> > dear drupal support,<br>
>>>> ><br>
>>>> > "/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have<br>
>>>> > "bind-address" set to localhost and "socket" is set to<br>
>>>> > /var/run/mysqld/mysqld.sock already.<br>
>>>> ><br>
>>>> > but after run /etc/init.d/mysql start, still got below output<br>
>>>> ><br>
>>>> > Rather than invoking init scripts through /etc/init.d, use the<br>
>>>> > service(8)<br>
>>>> > utility, e.g. service mysql restart<br>
>>>> ><br>
>>>> > Since the script you are attempting to invoke has been converted to an<br>
>>>> > Upstart job, you may also use the restart(8) utility, e.g. restart<br>
>>>> > mysql<br>
>>>> ><br>
>>>> > mysql start/running<br>
>>>> ><br>
>>>> > run mysql, still got below output as well<br>
>>>> ><br>
>>>> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket<br>
>>>> > '/var/run/mysqld/mysqld.sock' (2)<br>
>>>> ><br>
>>>> > tail -10f /var/log/mysql/error.log, still got the same error<br>
>>>> ><br>
>>>> > 101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled.<br>
>>>> > 101104 12:41:09 InnoDB: Started; log sequence number 0 44233<br>
>>>> > 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege<br>
>>>> > tables: Table 'mysql.user' doesn't exist<br>
>>>> ><br>
>>>> > by the way, the server use dynamic IP address and the<br>
>>>> > /etc/network/interfaces is as below<br>
>>>> ><br>
>>>> > auto lo<br>
>>>> > iface lo inet loopback<br>
>>>> ><br>
>>>> ><br>
>>>> > On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli<br>
>>>> > <<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a><br>
>>>> > <mailto:<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>>> wrote:<br>
>>>> ><br>
>>>> > Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:<br>
>>>> >> 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,<br>
>>>> >> however, after i reboot the pc and run /etc/init.d/mysql start as<br>
>>>> >> below, it doesn't work again. thanks for your help with this<br>
>>>> >> again.<br>
>>>> >><br>
>>>> >> root@quicksu-desktop:/var/www/sites/all/modules#<br>
>>>> >> /etc/init.d/mysql<br>
>>>> >> start<br>
>>>> >><br>
>>>> >> Rather than invoking init scripts through /etc/init.d, use the<br>
>>>> >> service(8)<br>
>>>> >> utility, e.g. service mysql start<br>
>>>> >><br>
>>>> >> Since the script you are attempting to invoke has been converted<br>
>>>> >> to an<br>
>>>> >><br>
>>>> >> Upstart job, you may also use the start(8) utility, e.g. start<br>
>>>> >> 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<br>
>>>> >> socket '/var/run/mysqld/mysqld.sock' (2)<br>
>>>> > Hi, try to see if "/var/run/mysqld/" exist.<br>
>>>> > Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is<br>
>>>> > set to localhost and if "socket" is set to<br>
>>>> > /var/run/mysqld/mysqld.sock.<br>
>>>> ><br>
>>>> > M.<br>
>>>> ><br>
>>>> > --<br>
>>>> > Michel'ZioBudda' <a href="mailto:Morellimichel@ziobuddalabs.it">Morellimichel@ziobuddalabs.it</a><br>
>>>> > <mailto:<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><br>
>>>> > Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)<br>
>>>> > Telefono: 0200619074<br>
>>>> > Telefono Cell: +39-3939890025 -- Fax: +39-0291390660<br>
>>>> ><br>
>>>> > <a href="http://www.ziobudda.net" target="_blank">http://www.ziobudda.net</a> ICQ: 58351764<br>
>>>> > <a href="http://www.ziobuddalabs.it" target="_blank">http://www.ziobuddalabs.it</a> Skype: zio_budda<br>
>>>> > <a href="http://www.ziodrupal.net" target="_blank">http://www.ziodrupal.net</a><br>
>>>> > <a href="mailto:MSN%3Amichel@ziobuddalabs.it">MSN:michel@ziobuddalabs.it</a> <mailto:<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><br>
>>>> ><br>
>>>> > <a href="mailto:JABBER%3Amichel@ziobuddalabs.it">JABBER:michel@ziobuddalabs.it</a> <mailto:<a href="mailto:michel@ziobuddalabs.it">michel@ziobuddalabs.it</a>><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>
>> --<br>
>> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
><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>
</div></div></blockquote></div><br>