Here's what nmap gives on my system:
PORT STATE SERVICE 22/tcp open ssh . . . 3306/tcp open mysql
-- Mike
From: Qiubo Su (David Su) qiubosu@gmail.com To: support@drupal.org; erik.saline@gmail.com Sent: Thu, November 4, 2010 4:27:20 PM Subject: Re: [support] urgently need help for Site off-line error
hello erik,
below are the results a) to e) by running the commands:
a) root@quicksu-desktop:/home/quicksu# netstat -a | grep mysql
b) root@quicksu-desktop:/home/quicksu# netstat -a | grep 3006
c) root@quicksu-desktop:/home/quicksu# nmap localhost
Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:19 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE 21/tcp open ftp 80/tcp open http 443/tcp open https 631/tcp open ipp
Nmap done: 1 IP address (1 host up) scanned in 0.42 seconds
d) root@quicksu-desktop:/home/quicksu# nmap -A -T4 localhost
Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:21 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE VERSION 21/tcp open ftp vsftpd 2.2.2 80/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 443/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 631/tcp open ipp CUPS 1.4 No exact OS matches for host (If you know what OS is running on it, see http://nmap.org/submit/ ). TCP/IP fingerprint: OS:SCAN(V=5.00%D=11/5%OT=21%CT=1%CU=30003%PV=N%DS=0%G=Y%TM=4CD34015%P=i686- OS:pc-linux-gnu)SEQ(SP=CA%GCD=1%ISR=CC%TI=Z%CI=Z%II=I%TS=8)SEQ(SP=CA%GCD=2% OS:ISR=CC%TI=Z%CI=Z%II=I%TS=8)OPS(O1=M400CST11NW6%O2=M400CST11NW6%O3=M400CN OS:NT11NW6%O4=M400CST11NW6%O5=M400CST11NW6%O6=M400CST11)WIN(W1=8000%W2=8000 OS:%W3=8000%W4=8000%W5=8000%W6=8000)ECN(R=Y%DF=Y%T=40%W=8018%O=M400CNNSNW6% 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 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% 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 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 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 OS:E(R=Y%DFI=N%T=40%CD=S)
Network Distance: 0 hops Service Info: OS: Unix
OS and Service detection performed. Please report any incorrect results at http://nmap.org/submit/ . Nmap done: 1 IP address (1 host up) scanned in 30.47 seconds
e) root@quicksu-desktop:/home/quicksu# ps aux | grep mysql | grep -v grep
On Fri, Nov 5, 2010 at 11:52 AM, Erik Saline erik.saline@gmail.com wrote:
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-_.htm... http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000...
On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) qiubosu@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@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@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 firewallback on.
-- Mike
From: Qiubo Su (David Su) qiubosu@gmail.com To: support@drupal.org; cjones@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@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@ziobuddalabs.it > mailto:michel@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@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@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@ziobuddalabs.it > mailto:michel@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@ziobuddalabs.it mailto:michel@ziobuddalabs.it > > JABBER:michel@ziobuddalabs.it mailto:michel@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/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]