mysql troubleshooting

mysql> SHOW FULL PROCESSLIST\G
>>>> (ERROR 2006 (HY000): MySQL server has gone away)

http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
http://dbaspot.com/forums/mysql/147301-error-2006-hy000-mysql-server-has-gone-away.html

Max concurrent user

http://forums.cpanel.net/f189/how-raise-maxclient-apache-2-2-16-a-170946.html

Place the limits in /usr/local/apache/conf/includes/pre_main_global.conf file for ServerLimit and MaxClients instead, then run the following commands:

Code:

cp /usr/local/apache/conf/httpd.conf /usr/local/apache/conf/httpd.conf.bak101029 /usr/local/cpanel/bin/apache_conf_distiller --update /scripts/rebuildhttpdconf /etc/init.d/httpd restart

This will backup your current httpd.conf, run the distiller to distill the changes in the include file, rebuild Apache configuration file, then restart Apache.

finally - NAT server works!

i'm using this template

#---------------------------------------------------------------  # Load the NAT module #  # Note: It is best to use the /etc/rc.local example in this  #       chapter. This value will not be retained in the  #       /etc/sysconfig/iptables file. Included only as a reminder.  #---------------------------------------------------------------    modprobe iptable_nat   #---------------------------------------------------------------  # Enable routing by modifying the ip_forward /proc filesystem file #  # Note: It is best to use the /etc/sysctl.conf example in this  #       chapter. This value will not be retained in the #         /etc/sysconfig/iptables file. Included only as a reminder.  #---------------------------------------------------------------    echo 1 > /proc/sys/net/ipv4/ip_forward    #---------------------------------------------------------------  # Allow masquerading # - Interface eth0 is the internet interface  # - Interface eth1 is the private network interface  #---------------------------------------------------------------    iptables -A POSTROUTING -t nat -o eth0 -s 192.168.1.0/24 -d 0/0 \           -j MASQUERADE     #---------------------------------------------------------------  # Prior to masquerading, the packets are routed via the filter  # table's FORWARD chain.  # Allowed outbound: New, established and related connections  # Allowed inbound : Established and related connections  #---------------------------------------------------------------    iptables -A FORWARD -t filter -o eth0 -m state \           --state NEW,ESTABLISHED,RELATED -j ACCEPT     iptables -A FORWARD -t filter -i eth0 -m state \           --state ESTABLISHED,RELATED -j ACCEPT 

thank you for faj-kumar for let me find this

http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch14_:_Linux_Firewalls_Using_iptables

another linux journal

i'm now reading this post by raj-kumar.

http://raj-kumar-linux.blogspot.com/2010_03_07_archive.html

:)

tcptrack

how to install tcptrack

wget http://packages.sw.be/tcptrack/tcptrack-1.1.5-1.2.el5.rf.i386.rpm

yum install libpcap.i386

rpm -Uvh tcptrack-1.1.5-1.2.el5.rf.i386.rpm

run the program

tcptrack -i eth0

Done..