mysql中如果我们开启bin-log日志全在mysql目录发现大量的mysql-bin.000001,mysql-bin.000002等，如果多了会发现占很大的空间，下面我来介绍mysql-bin日志关闭与删除方法。
日记删除
首先使用root权限账户登入mysql
#mysql -u root -pxxxxx
执行：mysql> reset master;
完成后退出：exit;
关闭日记或定时删除
编辑 my.cnf 注释 log-bin=mysql-bin 重启mysql即可
如果需要定时删除则 expire_logs_days = 3
意思为3天删除
为了减少一些误报，我们需要把 Directadmin 的一些值得信赖的服务添加CSF/LFD例外。编辑/etc/csf/csf.pignore 输入以下内容：
cmd:spamd child exe:/bin/dbus-daemon exe:/sbin/ntpd exe:/usr/bin/dbus-daemon exe:/usr/bin/dbus-daemon-1 exe:/usr/bin/fetchmail exe:/usr/bin/freshclam exe:/usr/libexec/dovecot/anvil exe:/usr/libexec/dovecot/imap exe:/usr/libexec/dovecot/imap-login exe:/usr/libexec/dovecot/managesieve exe:/usr/libexec/dovecot/managesieve-login exe:/usr/libexec/dovecot/pop3 exe:/usr/libexec/dovecot/pop3-login exe:/usr/libexec/gam_server exe:/usr/libexec/hald-addon-acpi exe:/usr/libexec/hald-addon-keyboard exe:/usr/local/bin/clamd exe:/usr/local/bin/freshclam exe:/usr/local/bin/pureftpd_uploadscan.sh exe:/usr/local/directadmin/dataskq exe:/usr/local/directadmin/directadmin exe:/usr/local/libexec/dovecot/imap exe:/usr/local/libexec/dovecot/imap-login exe:/usr/local/libexec/dovecot/pop3 exe:/usr/local/libexec/dovecot/pop3-login exe:/usr/local/mysql-5.1.54-linux-x86_64/bin/mysqld exe:/usr/local/php53/bin/php53 exe:/usr/local/php53/bin/php-cgi53 exe:/usr/local/php53/bin/php_uploadscan.sh exe:/usr/local/php53/sbin/php-fpm53 exe:/usr/local/php54/bin/php54 exe:/usr/local/php54/bin/php-cgi54 exe:/usr/local/php54/bin/php_uploadscan.sh exe:/usr/local/php54/sbin/php-fpm54 exe:/usr/local/php55/bin/php55 exe:/usr/local/php55/bin/php-cgi55 exe:/usr/local/php55/bin/php_uploadscan.sh exe:/usr/local/php55/sbin/php-fpm55 exe:/usr/local/php56/bin/php56 exe:/usr/local/php56/bin/php-cgi56 exe:/usr/local/php56/bin/php_uploadscan.sh exe:/usr/local/php56/sbin/php-fpm56 exe:/usr/local/sbin/nginx exe:/usr/sbin/exim exe:/usr/sbin/hald exe:/usr/sbin/httpd exe:/usr/sbin/mysqld exe:/usr/sbin/mysqld_safe exe:/usr/sbin/named exe:/usr/sbin/nginx exe:/usr/sbin/ntpd exe:/usr/sbin/proftpd exe:/usr/sbin/pure-ftpd exe:/usr/sbin/sshd
然后重启LFD：
/etc/init.d/lfd restart
来自：https://www.plugins-da.net/info/csf-lfd-exceptions-for-directadmin-csf.pignore
p.s. Based on this thread: http://forum.directadmin.com/showthread.php?t=49424
如果你发现在DA打开CSF提示如下错误：
Permission denied [User:admin UID:501]
可以执行如下命令修复：
chown root /usr/local/directadmin/plugins/csf/exec/csf chmod 4755 /usr/local/directadmin/plugins/csf/exec/csf
你總是對我說為什麼不送禮物給你，回想起來，我確實沒送過可以留作紀念的東西，甚至合影都沒有張。我不想給你留下太多痛，因為我們遲早是要分離的，有太多的分歧。
我不好，沒有那麼多的時間陪伴你，沒有那麼多的時間做家務，總是工作，工作，工作。但沒有錢我相信你是無法忍受的，你無法過寒酸的日子，儘管你曾嘴上說不論如何都願意陪我走。
你有那麼多的男性朋友，我總是要擔心帶綠帽子，我無法忍受你若無其事的和其他男人暖昧。我不得不考慮以後如果我更忙了，或者分隔兩地了，你是否會背著我與其他男人做些不為人知的事情。我為了你改變了自己的原則和底線，我接受了你沉重的過往，但唯獨我無法接受背叛！
生活上我對你也有很多的不滿，作為一個女孩兒，房間總是雜亂無章，一定要我親自清理或者一催再催。吃飯也是，做完總是要抱怨我不幫忙或乾脆不做，明明無所事事。我要工作，如何幫忙？停下工作，對不住客戶，哪裡來的未來？
我喜歡賢慧的女人，而不是一個等待我照顧的女孩兒。
對不起，我寫下這篇文章，我希望我們仍然有磨合的機會，我現在仍然願意接受你，但我在忍耐，希望知道火山積累滿了就會爆發。如果有一天你不再是我的唯一，我也不再是你的唯一，那，我們就是真的不適合。
curl -I -m 10 -o /dev/null -s -w %{http_code} www.cnweed.com 如果你想禁用DirectAdmin的da-popb4smtp服务
编辑 /etc/exim.conf
找到： hostlist relay_hosts = net-lsearch;/etc/virtual/pophosts
修改为： hostlist relay_hosts =
重启 exim
/etc/init.d/exim restart # Redhat/Debian
/usr/local/etc/rc.d/exim restart # FreeBSD
来自：http://help.directadmin.com/item.php?id=467
有时候不知道前路在何方，有时候不知道是否坚持错了方向，到现在我认为不论别人觉得是对还是错，只要自己觉得没有问题，那就勇敢的去做去拼，要无畏、无惧！不论成败，它都是你的一个经验，你失去的成本还可以从其他地方赚回来，但你失去的机会也许永远无法再得到。风险越大，回报越大！
DirectAdmin组件ZendGuardLoader，明明安装了探针却显示红叉叉，是因为一般是根据zend_loader.enable判断的，DA没加这些在php.ini，我们手动加上就好了
编辑php.ini，搜索：zend_extension，在底下加上
zend_loader.enable=1 zend_loader.disable_licensing=0 zend_loader.obfuscation_level_support=3 zend_loader.license_path=
然后 service httpd restart 重启下apache使修改生效
至于DirectAdmin PHP.INI的位置可以参考：http://www.cnweed.com/2743.html
[Sun Sep 21 17:37:10 2014] [emerg] (28)No space left on device: Couldn't create accept lock (/var/log/httpd/accept.lock.8411) (5)
下午收到监控邮件有台DirectAdmin服务器Apache服务无法启动，检查错误日记后，发现如上错误。首先df -h检查硬盘是否饱和，然后ipcs -s检查ipc，发现是ipc不足。如下所示
# ipcs -s ------ Semaphore Arrays -------- key semid owner perms nsems 0x00000000 19234816 apache 600 1 0x00000000 19267585 apache 600 1 0x00000000 19300354 apache 600 1 0x00000000 19398659 apache 600 1 0x00000000 19431428 apache 600 1 0x00000000 19464197 apache 600 1 0x00000000 19562502 apache 600 1 ………………
执行如下命令清除然后重启Apache即可
ipcs -s | grep apache | perl -lane 'print `ipcrm sem $F[1]`' service httpd restart
引起这个问题的原因可能是apache没有被正确的关闭。写了个简单的shell可以加入crontab定期执行
#!/bin/bash rm -rf /var/log/weed/ipcs.log ipcs -s >> /var/log/weed/ipcs.log ipcslist=`grep -c "" /var/log/weed/ipcs.log` if [ "$ipcslist" -ge "20" ]; then ipcs -s | perl -ane '/^0x00000000/ && `ipcrm -s $F[1]`' echo $(date) "Ipc crowded, clean up" >> /var/log/weed/ipcs_clean.log fi
#! /bin/bash
#====================================================================
# sys-mon.sh
#
# Copyright (c) 2011, WangYan <webmaster@wangyan.org>
# All rights reserved.
# Distributed under the GNU General Public License, version 3.0.
#
# Monitor system mem and load, if too high, restart some service.
#
# See: https://wangyan.org/blog/sys-mon-shell-script.html
#
# V 0.5, Date: 2011-12-08
#====================================================================
# Need to monitor the service name
# Must be in /etc/init.d folder exists
NAME_LIST="httpd nginx mysql"
# Single process to allow the maximum CPU (%)
PID_CPU_MAX="25"
# The maximum allowed memory (%)
PID_MEM_SUM_MAX="95"
# The maximum allowed system load
SYS_LOAD_MAX="6"
# Log path settings
LOG_PATH="/var/log/sys-mon.log"
# Date time format setting
DATA_TIME=$(date +"%y-%m-%d %H:%M:%S")
# Your email address
EMAIL="webmaster@example.com"
# Your website url
MY_URL="http://106.187.38.210/p.php"
#====================================================================
for NAME in $NAME_LIST
do
PID_CPU_SUM="0";PID_MEM_SUM="0"
PID_LIST=`ps aux | grep $NAME | grep -v root`
IFS_TMP="$IFS";IFS=$'\n'
for PID in $PID_LIST
do
PID_NUM=`echo $PID | awk '{print $2}'`
PID_CPU=`echo $PID | awk '{print $3}'`
PID_MEM=`echo $PID | awk '{print $4}'`
# echo "$NAME: PID_NUM($PID_NUM) PID_CPU($PID_CPU) PID_MEM($PID_MEM)"
PID_CPU_SUM=`echo "$PID_CPU_SUM + $PID_CPU" | bc`
PID_MEM_SUM=`echo "$PID_MEM_SUM + $PID_MEM" | bc`
if [ `echo "$PID_CPU >= $PID_CPU_MAX" | bc` -eq 1 ];then
if [[ "$NAME" = "php-fpm" || "$NAME" = "httpd" ]];then
sleep 5
if [ `echo "$PID_CPU >= $PID_CPU_MAX" | bc` -eq 1 ];then
echo "${DATA_TIME}: kill ${NAME}($PID_NUM) successful (CPU:$PID_CPU)" | tee -a $LOG_PATH
kill $PID_NUM
fi
else
echo "${DATA_TIME}: [WARNING!] ${NAME}($PID_NUM) cpu usage is too high! (CPU:$PID_CPU)" | tee -a $LOG_PATH
fi
fi
done
IFS="$IFS_TMP"
SYS_LOAD=`uptime | awk '{print $(NF-2)}' | sed 's/,//'`
SYS_MON="CPU:$PID_CPU_SUM MEM:$PID_MEM_SUM LOAD:$SYS_LOAD"
# echo -e "$NAME: $SYS_MON\n"
SYS_LOAD_TOO_HIGH=`awk 'BEGIN{print('$SYS_LOAD'>'$SYS_LOAD_MAX')}'`
PID_MEM_SUM_TOO_HIGH=`awk 'BEGIN{print('$PID_MEM_SUM'>'$PID_MEM_SUM_MAX')}'`
if [[ "$SYS_LOAD_TOO_HIGH" = "1" || "$PID_MEM_SUM_TOO_HIGH" = "1" ]];then
/etc/init.d/$NAME stop
sleep 5
for ((i=1;i<4;i++))
do
if [ `pgrep $NAME | wc -l` = "0" ];then
echo "$DATA_TIME: Stop $NAME successful! ($SYS_MON)" | tee -a $LOG_PATH
break
else
echo "${DATA_TIME}: [WARNING!] Stop $NAME failed[$i]! ($SYS_MON)" | tee -a $LOG_PATH
pkill $NAME && killall $NAME
fi
done
/etc/init.d/$NAME start
sleep 5
for ((ii=1;ii<4;ii++))
do
if [ `pgrep $NAME | wc -l` != "0" ];then
echo "$DATA_TIME: Start $NAME successful!" | tee -a $LOG_PATH
break
else
echo "${DATA_TIME}: [WARNING!] Start $NAME failed[$ii]! ($SYS_MON)" | tee -a $LOG_PATH
/etc/init.d/$NAME start
sleep 5
fi
done
if [ `pgrep $NAME | wc -l` != "0" ];then
echo "${DATA_TIME}: [ERROR!] Start $NAME failed! ($SYS_MON)" | mail -s "Start $NAME failed" $EMAIL
fi
fi
done
STATUS_CODE=`curl -o /dev/null -s -w %{http_code} $MY_URL`
#echo -e "STATUS CODE: $STATUS_CODE\n"
if [ "$STATUS_CODE" != "200" ];then
sleep 3
STATUS_CODE=`curl -o /dev/null -s -w %{http_code} $MY_URL`
if [ "$STATUS_CODE" != "200" ];then
echo "${DATA_TIME}: [WARNING!] Website Downtime! ($SYS_MON)" | tee -a $LOG_PATH
echo "${DATA_TIME}: [WARNING!] Website Downtime! ($SYS_MON)" | mail -s "Start $NAME failed" $EMAIL
fi
fi Named is not reloading correctly when I add a domain
On some systems, the named boot script provided with the bind rpms don't seem to reliably reload the named program. You can obtain a new named boot script by running the following:
RedHat:
cd /etc/init.d mv named named.backup wget -O named http://www.directadmin.com/named chmod 755 named /sbin/chkconfig named reset
This boot script uses a more direct method of reloading named.
其他操作系统请访问来源：http://help.directadmin.com/item.php?id=40
一、登入 DirectAdmin 管理员，查找域知否已经存在
二、查看/etc/named.conf文件是否已经存在该域名
来源：http://help.directadmin.com/item.php?id=28