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

Michael Hannon jm_hannon at yahoo.com
Fri Nov 5 00:26:42 UTC 2010


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 at gmail.com>
>To: support at drupal.org; erik.saline at 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 at quicksu-desktop:/home/quicksu# netstat -a | grep mysql
>
>b) root at quicksu-desktop:/home/quicksu# netstat -a | grep 3006
>
>c) root at 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 at 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 at quicksu-desktop:/home/quicksu# ps aux | grep mysql | grep -v grep
>
>
>On Fri, Nov 5, 2010 at 11:52 AM, Erik Saline <erik.saline at 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-_.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/ ]
>>>
>>--
>>[ Drupal support list | http://lists.drupal.org/ ]
>>
>


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101104/1270c6ce/attachment-0001.html 


More information about the support mailing list