My SQL Error creating DB

rszkutak

Verified User
Joined
Dec 22, 2003
Messages
180
Location
Scottsdale, AZ & Clam Gulch, AK
Hey all,
I am new to the MySql area, so go light on me here ! :)

Anyway, I am creating a DB on RH 7.3 runnign the most curent version of DA. I am gettin an error on a customers site. This is what it reads EXACTLY. Does anyone have an idea of what this is and or how to address it ?

I treid to create a sample DB on other sites as well, to no avail. I get the same "cannot connect to SQL error" Although the MySQL 4.0.16 shows up as available, i somehow either question the connetion, or MySQL is lying to me !!!!



-Rob


Error creating the database


Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 
Hello,

You'll first need to check the mysql is running.. but generally we can assume it is or else you'll be getting emails. So what's probably happening is that the mysql.sock file is located somewhere else. The location will might be specified in the /etc/my.cnf file. The only 2 places I've ever seen the mysql.sock file is in /var/lib/mysql/mysql.sock or /tmp/mysql.sock.. so you can have a look in /tmp to see if that files exists. If it does then it's probably just a matter of either change the settings in /etc/my.cnf (if it exists), or else just creating a symbolic link to the correct socket file:
Code:
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
John
 
John,
Thanks for the reply... I logged into SSH with my root account and ran what you said. Honestly it sounded like exactly what is happeneing there.

That command ran correctly, but didn't solve the problem. I have to say that I am very much a UNIX novice, and command line..... OMG that is like going to a foreign country and not even knowing where you are. Sorry I am a massive Windows guy, but Windows, we'll we just won't go there for security reasons now will we??? or let alone e-mail ! If i could just manage to load a GUI, then I would be lots better.... sad, very sad i know.

How can I find out loggin in with SSH, where to locate that file if it even exists?

Sorry but my unix skills are very rough, I haven't admin'd a unix box in about 6 years now so I am very rusty.

This machine is a brand new install of RH 7.3, using the most current version of DA. Right now it has only been up about 4 days, it's that new.

Yours or anyones guidance is greatly apprecaited.

-Rob
 
I did a locate on the /var/lib/mysql and this is what i found.

I also did a look in the /tmp file and found nothing with a .sock after it. DA shows that MySql is running, so i suspect it is indeed up.

locate /var/lib/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/var/lib/mysql/mysql/db.frm
/var/lib/mysql/mysql/db.MYI
/var/lib/mysql/mysql/db.MYD
/var/lib/mysql/mysql/host.frm
/var/lib/mysql/mysql/host.MYI
/var/lib/mysql/mysql/host.MYD
/var/lib/mysql/mysql/user.frm
/var/lib/mysql/mysql/user.MYI
/var/lib/mysql/mysql/user.MYD
/var/lib/mysql/mysql/func.frm
/var/lib/mysql/mysql/func.MYI
/var/lib/mysql/mysql/func.MYD
/var/lib/mysql/mysql/tables_priv.frm
/var/lib/mysql/mysql/tables_priv.MYI
/var/lib/mysql/mysql/tables_priv.MYD
/var/lib/mysql/mysql/columns_priv.frm
/var/lib/mysql/mysql/columns_priv.MYI
/var/lib/mysql/mysql/columns_priv.MYD
/var/lib/mysql/test

Any thoughts on this ?
 
You could always try creating the /etc/my.cnf file with the following data:
Code:
[mysqld]
socket=/var/lib/mysql/mysql.sock
or even do a "locate mysql.sock" to find the socket. (You should actually run "updatedb" first to make sure the locate command is using the latest data.)

John
 
I know it's a old topic, but i have the same problem...

But all the replies didn't work....

Does someone have another idea?
 
Hello,

Is mysql running? are you getting a connect error, or a invalid username/password error. What OS are you using. Check /usr/local/directadmin/conf/mysql.conf and try out that user/pass in phpmyadmin. If MySQL isn't running, try starting it, or else check /var/lib/mysql/<hostname>.err to find out why it's not loading.

John
 
Hello,

Well, i solved it...

Just for anyone who has the same problem:

In my case mysqld wasn't responding to shutdown (it said there was a procces running on the same port)

So i checked out which pid's mysql was using at that moment:

Type in ssh:

# ps -A | grep mysql

Kill all the pid files

using:

#kill <pid number>

And then just restart mysqld.. (# service mysqld start)

I hope its a bit clear.

Thanks,

Kevin
 
hi, i have this problem ... aie .. and my serveur mysqld is down

Domain xxxxxxxx.com Created

Domain Created Successfully

Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
 
Last edited:
Hi
I am using wordpress and site is new and have 10 page view per day!also i have only one other site with 80 user pay day. several minute ago i tried to see my wordpress site but i saw this error:
Error establishing a database connection directadmin
I go to user level directadmin in my Db mysql database and saw this error:
Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I go in to my email and saw these reports:
New Message: Warning: The system load average is 13.84
A new message or response with subject:

Warning: The system load average is 13.84

has arrived for you to view.
Follow this link to view it:
and i folowed and saw:
This is an automated message notifying you that the 5 minute load average on your system is 13.84.
This has exceeded the 10 threshold.

One Minute - 24.8
Five Minutes - 13.84
Fifteen Minutes - 7.53

top - 11:02:18 up 6 days, 21:56, 0 users, load average: 23.30, 13.71, 7.52
Tasks: 234 total, 1 running, 233 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.2%us, 3.7%sy, 0.1%ni, 90.1%id, 0.7%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 4034096k total, 4010976k used, 23120k free, 1324k buffers
Swap: 0k total, 0k used, 0k free, 23504k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
237 root 10 -5 0 0 0 D 7.1 0.0 2:59.11 [kswapd0]
7079 mysql 16 0 225m 27m 2508 D 3.6 0.7 0:00.09 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/*****.com.err --pid-file=/var/lib/mysql/*****.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306
7091 hamdelor 18 0 75364 3268 2540 D 3.6 0.1 0:00.04 /php
7104 root 15 0 12756 1088 720 R 1.8 0.0 0:00.04 /usr/bin/top -c -b -n 1
1 root 18 0 10368 152 40 S 0.0 0.0 0:08.17 init [3]
2 root RT -5 0 0 0 S 0.0 0.0 0:01.23 [migration/0]
3 root 34 19 0 0 0 S 0.0 0.0 0:00.02 [ksoftirqd/0]
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/0]
5 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [migration/1]
6 root 34 19 0 0 0 S 0.0 0.0 0:00.01 [ksoftirqd/1]
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/1]
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.80 [events/0]
9 root 10 -5 0 0 0 S 0.0 0.0 0:00.08 [events/1]
10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [khelper]
51 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [kthread]
56 root 10 -5 0 0 0 S 0.0 0.0 0:00.12 [kblockd/0]
57 root 10 -5 0 0 0 S 0.0 0.0 0:09.90 [kblockd/1]
58 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [kacpid]
154 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/0]
155 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 [cqueue/1]
158 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [khubd]
160 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [kseriod]
234 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [khungtaskd]

Also receive me in my email:
lfd on *****.com: High 5 minute load average alert - 6.28

1 Min Load Avg: 12.44
5 Min Load Avg: 6.28
15 Min Load Avg: 3.08
Running/Total Processes: 2/256

atachments:
ps.txt:
Output from ps:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 10368 128 ? Ss Nov20 0:02 init [3]
root 2 0.0 0.0 0 0 ? S< Nov20 0:01 [migration/0]
root 3 0.0 0.0 0 0 ? SN Nov20 0:00 [ksoftirqd/0]
root 4 0.0 0.0 0 0 ? S< Nov20 0:00 [watchdog/0]
root 5 0.0 0.0 0 0 ? S< Nov20 0:00 [migration/1]
root 6 0.0 0.0 0 0 ? SN Nov20 0:00 [ksoftirqd/1]
root 7 0.0 0.0 0 0 ? S< Nov20 0:00 [watchdog/1]
root 8 0.0 0.0 0 0 ? S< Nov20 0:00 [events/0]
root 9 0.0 0.0 0 0 ? S< Nov20 0:00 [events/1]
root 10 0.0 0.0 0 0 ? S< Nov20 0:00 [khelper]
root 51 0.0 0.0 0 0 ? S< Nov20 0:00 [kthread]
root 56 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kblockd/0]
root 57 0.0 0.0 0 0 ? S< Nov20 0:09 \_ [kblockd/1]
root 58 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kacpid]
root 154 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [cqueue/0]
root 155 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [cqueue/1]
root 158 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [khubd]
root 160 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kseriod]
root 234 0.0 0.0 0 0 ? S Nov20 0:00 \_ [khungtaskd]
root 236 0.0 0.0 0 0 ? S Nov20 0:23 \_ [pdflush]
root 237 0.0 0.0 0 0 ? D< Nov20 0:55 \_ [kswapd0]
root 238 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [aio/0]
root 239 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [aio/1]
root 397 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kpsmoused]
root 425 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ata/0]
root 426 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ata/1]
root 427 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ata_aux]
root 437 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kstriped]
root 450 0.0 0.0 0 0 ? D< Nov20 1:18 \_ [kjournald]
root 475 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kauditd]
root 1306 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kmpathd/0]
root 1307 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kmpathd/1]
root 1308 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kmpath_handlerd]
root 1332 0.0 0.0 0 0 ? S< Nov20 0:10 \_ [kjournald]
root 1334 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [kjournald]
root 1336 0.0 0.0 0 0 ? S< Nov20 0:01 \_ [kjournald]
root 1475 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [iscsi_eh]
root 1517 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [cnic_wq]
root 1535 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ib_addr]
root 1549 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ib_mcast]
root 1550 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ib_inform]
root 1551 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [local_sa]
root 1555 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [iw_cm_wq]
root 1559 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ib_cm/0]
root 1560 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [ib_cm/1]
root 1564 0.0 0.0 0 0 ? S< Nov20 0:00 \_ [rdma_cm]
root 6041 0.0 0.0 0 0 ? D 10:00 0:00 \_ [pdflush]
root 1581 0.0 0.0 38880 120 ? Ssl Nov20 0:00 brcm_iscsiuio
root 1588 0.0 0.0 12156 616 ? Ss Nov20 0:00 iscsid
root 1589 0.0 0.1 12652 4464 ? S<Ls Nov20 0:00 iscsid
root 1910 0.0 0.0 5928 564 ? Ss Nov20 0:02 syslogd -m 0
root 1913 0.0 0.0 3824 412 ? Ss Nov20 0:03 klogd -x
root 1962 0.0 0.0 81552 1532 ? Sl Nov20 0:02 /usr/sbin/ss5 -t
root 1987 0.0 0.0 17888 592 ? Ss Nov20 0:00 /usr/sbin/dovecot
dovecot 2018 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2019 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2020 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2021 0.0 0.0 45756 1832 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2022 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2023 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2024 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2025 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2026 0.0 0.0 45756 1832 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2027 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2028 0.0 0.0 45756 1832 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2029 0.0 0.0 45756 1828 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2030 0.0 0.0 45756 1824 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2031 0.0 0.0 45756 1824 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2032 0.0 0.0 45756 1832 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2033 0.0 0.0 45756 1832 ? S Nov20 0:00 \_ dovecot/imap-login
dovecot 2034 0.0 0.0 15752 732 ? S Nov20 0:00 \_ dovecot/anvil [35 connections]
root 2035 0.0 0.0 15880 800 ? S Nov20 0:00 \_ dovecot/log
root 2038 0.0 0.0 19504 2132 ? S Nov20 0:00 \_ dovecot/config
root 2039 0.0 0.0 18880 1516 ? S Nov20 0:00 \_ dovecot/auth [0 wait, 0 passdb, 0 userdb]
root 28103 0.0 0.0 20308 944 ? S Nov21 0:00 \_ dovecot/auth [0 wait, 0 passdb, 0 userdb]
dovecot 17356 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17361 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17366 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17371 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17372 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17373 0.0 0.0 45752 1824 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17374 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17381 0.0 0.0 45752 1824 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17384 0.0 0.0 45752 1824 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 17385 0.0 0.0 45752 1824 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18258 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18259 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18263 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18271 0.0 0.0 45752 1824 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18276 0.0 0.0 45752 1832 ? S Nov26 0:00 \_ dovecot/pop3-login
dovecot 18528 0.0 0.0 45752 1828 ? S Nov26 0:00 \_ dovecot/pop3-login
root 2056 0.0 0.0 65980 820 ? S Nov20 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.red-ir.com.pid
mysql 2165 9.3 2.4 558852 97212 ? Sl Nov20 931:57 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.red-ir.com.err --pid-file=/var/lib/mysql/server.red-ir.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root 2631 0.0 0.0 14012 408 ? Ss Nov20 0:02 /usr/local/directadmin/da-popb4smtp
root 2708 0.0 0.0 91284 1480 ? Ss Nov20 0:00 pure-ftpd (SERVER)
root 2721 0.0 0.0 74860 1040 ? Ss Nov20 0:01 crond
root 3147 0.0 0.0 18436 492 ? S Nov20 0:00 /usr/sbin/smartd -q never
root 3150 0.0 0.0 3812 468 tty1 Ss+ Nov20 0:00 /sbin/mingetty tty1
root 3151 0.0 0.0 3812 472 tty2 Ss+ Nov20 0:00 /sbin/mingetty tty2
root 3153 0.0 0.0 3812 468 tty3 Ss+ Nov20 0:00 /sbin/mingetty tty3
root 3155 0.0 0.0 3812 472 tty4 Ss+ Nov20 0:00 /sbin/mingetty tty4
root 3157 0.0 0.0 3812 472 tty5 Ss+ Nov20 0:00 /sbin/mingetty tty5
root 3159 0.0 0.0 3812 472 tty6 Ss+ Nov20 0:00 /sbin/mingetty tty6
root 22644 0.0 0.0 62664 1028 ? Ss Nov21 0:00 /usr/sbin/sshd
root 4199 0.0 0.0 12636 660 ? S<s Nov23 0:00 /sbin/udevd -d
named 4246 0.0 0.0 165036 3400 ? Ssl Nov23 0:14 named -u named
nobody 1299 0.0 0.0 49292 1624 ? Ss Nov24 0:00 /usr/local/directadmin/directadmin d
nobody 10900 0.0 0.0 49292 764 ? S Nov26 0:00 \_ /usr/local/directadmin/directadmin d
nobody 10980 0.0 0.0 49292 764 ? S Nov26 0:00 \_ /usr/local/directadmin/directadmin d
nobody 10981 0.0 0.0 49292 764 ? S Nov26 0:00 \_ /usr/local/directadmin/directadmin d
nobody 11584 0.0 0.0 49292 764 ? S Nov26 0:00 \_ /usr/local/directadmin/directadmin d
nobody 11585 0.0 0.0 49292 764 ? S Nov26 0:00 \_ /usr/local/directadmin/directadmin d
mail 1330 0.0 0.0 56940 936 ? Ss Nov24 0:00 /usr/sbin/exim -bd -q15m -oP /var/run/exim.pid
root 18768 0.0 0.6 128476 24644 ? Ss 00:00 0:14 lfd - sleeping
root 6312 7.6 0.6 128476 24536 ? D 10:29 0:00 \_ lfd - (child) closing
root 6313 0.3 0.6 128476 24260 ? S 10:29 0:00 \_ lfd - (child) checking load...
root 6314 4.0 0.0 65748 1012 ? R 10:29 0:00 \_ /bin/ps axuf
root 19259 0.0 0.1 103196 7408 ? Ss 00:12 0:05 /usr/sbin/httpd -k start -DSSL
apache 23099 0.1 1.0 140608 44020 ? S 04:02 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 23100 0.0 1.1 143744 44928 ? S 04:02 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 23456 0.0 1.0 138644 42388 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 24159 0.0 1.1 141136 44484 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 24160 0.0 0.8 130416 34264 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 24714 0.1 1.1 143480 46620 ? S 04:03 0:25 \_ /usr/sbin/httpd -k start -DSSL
apache 24715 0.1 1.1 143464 46628 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 24716 0.1 1.1 143476 47220 ? S 04:03 0:26 \_ /usr/sbin/httpd -k start -DSSL
apache 24717 0.1 0.8 129860 33712 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
520 25307 0.1 1.1 140624 45128 ? D 04:03 0:27 \_ /usr/sbin/httpd -k start -DSSL
apache 25308 0.0 0.8 130572 34424 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 25310 0.0 0.9 134828 38680 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 25311 0.0 0.8 129636 33488 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 25314 0.0 0.8 129852 33704 ? S 04:03 0:19 \_ /usr/sbin/httpd -k start -DSSL
apache 25316 0.0 0.8 129872 33724 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 25317 0.1 1.1 145328 46468 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 25320 0.0 0.8 129636 33492 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 26178 0.0 1.0 141136 44228 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26179 0.0 0.8 129612 33464 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 26182 0.0 0.8 129620 33476 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 26184 0.1 0.9 134556 38408 ? S 04:03 0:25 \_ /usr/sbin/httpd -k start -DSSL
apache 26185 0.0 1.0 139632 43224 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26187 0.0 1.0 140368 43648 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
518 26190 0.1 1.1 143216 46368 ? S 04:03 0:28 \_ /usr/sbin/httpd -k start -DSSL
apache 26191 0.0 1.0 141144 44236 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 26193 0.0 1.0 136560 40392 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26195 0.1 1.1 144392 48124 ? S 04:03 0:29 \_ /usr/sbin/httpd -k start -DSSL
apache 26198 0.0 1.1 141128 44544 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 26200 0.0 1.1 143508 46748 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26202 0.0 0.8 131860 35672 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 26204 0.0 0.9 136052 37916 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26207 0.0 0.2 106732 10584 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 26208 0.0 0.8 129644 33496 ? S 04:03 0:19 \_ /usr/sbin/httpd -k start -DSSL
apache 26990 0.0 1.1 143224 46188 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 26991 0.1 1.0 140060 43784 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 26993 0.1 1.0 140368 44220 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 26994 0.1 1.0 142276 44216 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 26995 0.0 0.2 106284 10160 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 26997 0.1 1.1 141416 45012 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 26998 0.0 1.1 143876 47020 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27001 0.0 0.8 132552 34488 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 27003 0.0 0.9 134492 38324 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27005 0.1 0.9 134528 38400 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 27007 0.0 0.6 123308 27188 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
518 27010 0.1 0.9 136064 39924 ? S 04:03 0:25 \_ /usr/sbin/httpd -k start -DSSL
520 27012 0.1 1.1 140640 44916 ? D 04:03 0:29 \_ /usr/sbin/httpd -k start -DSSL
apache 27013 0.0 0.8 129668 33520 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 27015 0.0 0.8 132144 34056 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27018 0.0 1.0 139116 42528 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27020 0.0 0.9 134484 38252 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 27022 0.1 1.1 143472 47140 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 27024 0.0 1.1 143488 46900 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27026 0.0 1.1 141784 45076 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27029 0.0 0.9 133712 37564 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27031 0.0 0.9 133692 37544 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 27032 0.0 1.0 141136 44168 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 27033 0.1 1.1 143536 46904 ? S 04:03 0:25 \_ /usr/sbin/httpd -k start -DSSL
apache 27036 0.1 1.1 143312 46364 ? S 04:03 0:23 \_ /usr/sbin/httpd -k start -DSSL
apache 27038 0.0 0.2 106732 10584 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 27039 0.1 1.1 143740 46888 ? S 04:03 0:24 \_ /usr/sbin/httpd -k start -DSSL
apache 27043 0.0 1.0 139672 43384 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 27045 0.0 0.2 106728 10600 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 27047 0.0 1.1 141136 44552 ? S 04:03 0:20 \_ /usr/sbin/httpd -k start -DSSL
apache 27049 0.0 0.8 129868 33720 ? S 04:03 0:21 \_ /usr/sbin/httpd -k start -DSSL
apache 27050 0.0 1.1 143512 46552 ? S 04:03 0:22 \_ /usr/sbin/httpd -k start -DSSL
apache 3636 0.0 0.8 130660 34512 ? S 06:07 0:10 \_ /usr/sbin/httpd -k start -DSSL
apache 3637 0.0 1.1 141412 44756 ? S 06:07 0:12 \_ /usr/sbin/httpd -k start -DSSL
518 3638 0.0 0.8 130420 34280 ? S 06:07 0:14 \_ /usr/sbin/httpd -k start -DSSL
apache 3639 0.0 1.1 143496 46544 ? S 06:07 0:13 \_ /usr/sbin/httpd -k start -DSSL
apache 3640 0.0 1.0 140112 43648 ? S 06:07 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 3641 0.1 1.1 143236 46412 ? S 06:07 0:18 \_ /usr/sbin/httpd -k start -DSSL
520 3642 0.1 1.0 138612 43160 ? S 06:07 0:15 \_ /usr/sbin/httpd -k start -DSSL
apache 3643 0.0 1.0 141136 44164 ? S 06:07 0:11 \_ /usr/sbin/httpd -k start -DSSL
apache 3644 0.0 1.1 143524 46692 ? S 06:07 0:15 \_ /usr/sbin/httpd -k start -DSSL
apache 3645 0.0 0.8 131960 35804 ? S 06:07 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 3646 0.0 1.0 136808 40584 ? S 06:07 0:13 \_ /usr/sbin/httpd -k start -DSSL
apache 3647 0.0 1.0 139640 42884 ? S 06:07 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 3648 0.0 0.9 134516 38332 ? S 06:07 0:13 \_ /usr/sbin/httpd -k start -DSSL
apache 3649 0.0 0.9 135296 39136 ? S 06:07 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 3650 0.0 0.3 108720 12572 ? S 06:07 0:11 \_ /usr/sbin/httpd -k start -DSSL
apache 4344 0.0 0.3 108684 12536 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4345 0.0 1.0 139596 42600 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4346 0.0 0.8 129652 33504 ? S 07:17 0:10 \_ /usr/sbin/httpd -k start -DSSL
apache 4347 0.1 0.9 133888 37740 ? S 07:17 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 4348 0.0 0.8 131700 33648 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4349 0.1 1.1 143520 46576 ? S 07:17 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 4350 0.0 0.8 130140 33992 ? S 07:17 0:06 \_ /usr/sbin/httpd -k start -DSSL
apache 4351 0.0 0.2 106220 10072 ? S 07:17 0:05 \_ /usr/sbin/httpd -k start -DSSL
apache 4352 0.1 1.1 143732 47352 ? S 07:17 0:12 \_ /usr/sbin/httpd -k start -DSSL
apache 4353 0.0 1.1 141544 44380 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4354 0.0 1.0 141136 44200 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4355 0.0 0.8 129660 33496 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4356 0.0 1.1 141136 44732 ? S 07:17 0:09 \_ /usr/sbin/httpd -k start -DSSL
apache 4357 0.0 0.8 129636 33488 ? S 07:17 0:06 \_ /usr/sbin/httpd -k start -DSSL
apache 4358 0.0 0.2 106704 10556 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4359 0.0 0.8 132420 36212 ? S 07:17 0:09 \_ /usr/sbin/httpd -k start -DSSL
apache 4360 0.0 0.8 130636 34488 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4361 0.0 0.2 107236 11088 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4362 0.0 1.1 141144 44820 ? S 07:17 0:10 \_ /usr/sbin/httpd -k start -DSSL
apache 4363 0.0 0.3 108336 12188 ? S 07:17 0:06 \_ /usr/sbin/httpd -k start -DSSL
apache 4364 0.0 0.8 131964 35808 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4365 0.0 0.2 106464 10316 ? S 07:17 0:10 \_ /usr/sbin/httpd -k start -DSSL
apache 4366 0.0 1.1 143444 46620 ? S 07:17 0:09 \_ /usr/sbin/httpd -k start -DSSL
apache 4367 0.0 0.8 129864 33716 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4368 0.0 0.2 107344 11196 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4369 0.0 1.1 143488 46536 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4370 0.0 0.8 130644 34496 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4371 0.0 0.3 108636 12484 ? S 07:17 0:06 \_ /usr/sbin/httpd -k start -DSSL
apache 4372 0.0 1.0 140112 43640 ? S 07:17 0:08 \_ /usr/sbin/httpd -k start -DSSL
apache 4373 0.0 0.8 130644 34496 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
apache 4374 0.0 0.9 134460 38288 ? S 07:17 0:06 \_ /usr/sbin/httpd -k start -DSSL
apache 4379 0.0 0.2 107232 11084 ? S 07:17 0:07 \_ /usr/sbin/httpd -k start -DSSL
520 4380 0.1 1.0 139076 43316 ? D 07:17 0:11 \_ /usr/sbin/httpd -k start -DSSL

vmstat.txt
Output from vmstat:
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
0 7 0 22236 340 9776 0 0 19 89 23 8 5 4 90 1 0

apachestatus.html
Could not retrieve Apache Server Status

I restart httpd Apache then problem was solved and show me this message in putty:

Remaining processes: 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 4359 4360 4361 4362 4363 4364 4365 4366 4367 4368 4369 4370 4371 4372 4373 4374 4379 4380 24159 24160 24714 24715 24716 24717 25307 25308 25310 25311 25314 25316 25317 25320 26178 26179 26182 26184 26185 26187 26190 26191 26193 26195 26198 26200 26202 26204 26207 26208 26990 26991 26993 26994 26995 26997 26998 27001 27003 27005 27007 27010 27012 27013 27015 27018 27020 27022 27024 27026 27029 27031 27032 27033 27036 27038 27039 27043 27045 27047 27049 27050
Stopping httpd: [ OK ]

What was this problem? How i can prevent it again?
my server is Celeron Dual core + 4GB RAM +10bps
Thanks
 
Last edited:
Hi.
Now i see MYSQL in my server about 12 Hours has been downed.
I tried to restart mysql and it could not start and show in putty this error:
Starting MySQL......Manager of pid-file quit without updati[FAILED]

I search a lot this site and google but i can not find solution.
please help me.
thanks

error log:
111128 06:17:23 mysqld_safe mysqld from pid file /var/lib/mysql/server.****.com.pid ended
111128 06:18:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111128 6:18:01 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
111128 6:18:02 [Note] Plugin 'FEDERATED' is disabled.
111128 6:18:02 InnoDB: Initializing buffer pool, size = 8.0M
111128 6:18:02 InnoDB: Completed initialization of buffer pool
111128 6:18:02 InnoDB: Started; log sequence number 0 3187706289
/usr/sbin/mysqld: File './mysql-bin.000039' not found (Errcode: 2)
111128 6:18:02 [ERROR] Failed to open log (file './mysql-bin.000039', errno 2)
111128 6:18:02 [ERROR] Could not open log file
111128 6:18:02 [ERROR] Can't init tc log
111128 6:18:02 [ERROR] Aborting

111128 6:18:02 InnoDB: Starting shutdown...
111128 6:18:07 InnoDB: Shutdown completed; log sequence number 0 3187706289
111128 6:18:07 [Note] /usr/sbin/mysqld: Shutdown complete
 
Last edited:
Hi.
Now i see MYSQL in my server about 12 Hours has been downed.
I tried to restart mysql and it could not start and show in putty this error:


I search a lot this site and google but i can not find solution.
please help me.
thanks

error log:

i duplicated mysql-bin.000038 file and renamed it to mysql-bin.000039 then mysql restarted by command of "service mysqld start".

Why mysql-bin.000039 was not exist? or why it was deleted? or why mysql could not created it?
hacking attack?

Also i have installed CSF & FLD & ELS . can they cause such problem?
 
Last edited:
You probably should turn off saving of those mysql-bin files (Google it); while they do offer the ability to rebuild transactions if required, on shared servers hosting WordPress sites they're often going to create huge server loads, as WordPress makes a lot of MySQL calls (especially many WordPress plugins) and each call is saved in it's entirety for purposes of possible recreation. Saving those files can be a huge help, especially in recreating financial transactions in the event of a server crash, but generally you'll need a lot of horsepower.

Jeff
 
You probably should turn off saving of those mysql-bin files (Google it); while they do offer the ability to rebuild transactions if required, on shared servers hosting WordPress sites they're often going to create huge server loads, as WordPress makes a lot of MySQL calls (especially many WordPress plugins) and each call is saved in it's entirety for purposes of possible recreation. Saving those files can be a huge help, especially in recreating financial transactions in the event of a server crash, but generally you'll need a lot of horsepower.

Jeff

Thanks a lot.
 
Back
Top