[support] urgently need help for Site off-line error
Qiubo Su (David Su)
qiubosu at gmail.com
Thu Nov 4 23:27:20 UTC 2010
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 <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/ ]
> >
> >
> > --
> > [ 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/2b1e89bf/attachment-0001.html
More information about the support
mailing list