Home

每月存档十一月, 2009

CentOS_4.6_Cacti短信报警设置

2009年11月11日写评论作者 夜行人

首先
参考安装Cacti的插件
http://www.php-oa.com/2009/06/04/plugin-architecture.html
参考设置邮件报警，并确认邮件报警是生效的，否则短信报警不会生效
http://www.hiadmin.com/cacti%E9%85%8D%E7%BD%AEe-mail%E6%8A%A5%E8%AD%A6/

然后，安装飞信
mkdir /root/downloadsss/fetion
cd /root/downloadsss/fetion
下载飞信主程序
wget http://www.it-adv.net/fetion/downng/fetion20090406003-linux.tar.gz
下载飞信用到的库
wget http://www.it-adv.net/fetion/downng/library_linux.tar.gz

mkdir -p /usr/local/tools/fetion/
cd /usr/local/tools/fetion/
tar xzf /root/downloadsss/fetion/fetion20090406003-linux.tar.gz
mv install/ fetion_src
mkdir /usr/local/tools/fetion/lib

释放fetion会用到的库
tar -xzvf /root/downloadsss/fetion/library_linux.tar.gz -C /usr/local/tools/fetion/lib
cd /usr/local/tools/fetion/lib
ln -s libcrypto.so.0.9.8 libcrypto.so.4
ln -s libssl.so.0.9.8 libssl.so.4

###################如果你是CentOS5以上版本（例如CactiEZ9.0），则无需做以下操作#################
由于是在CentOS4.6上安装fetion，所以需要拷贝CentOS5上的一些库文件，幸好网上有人找出来打包好了，下载来用就可以了
下载CentOS4会用到的库
cd /root/downloadsss/fetion
wget http://xok.la/file/2009/04/fetion_lib_rhel4_xok.zip
cd /usr/local/tools/fetion/
unzip /root/downloadsss/fetion/fetion_lib_rhel4_xok.zip
这个fetion_lib_rhel4_xok.zip包里的库文件也不是很全，启动飞信时，提示少一个libgcc_s.so.1，我们去我们自己的CentOS 5.2上scp一个过来
scp 192.168.0.110:/lib/libgcc_s.so.1 /usr/local/tools/fetion/lib
########################如果你是CentOS5以上版本，则无需做以上操作#################

编写飞信的启动脚本
vi /usr/local/tools/fetion/fetion
添加以下内容
#!/bin/bash
prefix=/usr/local/tools/fetion/
LD_LIBRARY_PATH=”$prefix/lib${LD_LIBRARY_PATH+:${LD_LIBRARY_PATH}}”
export LD_LIBRARY_PATH
$prefix/lib/ld-linux.so.2 /usr/local/tools/fetion/fetion_src/fetion “$@”

保存退出
chmod 755 /usr/local/tools/fetion/fetion

至此，飞信就安装好了。

最后，编辑cacti/plugins/thold/thold-functions.php
在thold–functions.php查找function thold_mail($to, $from, $subject, $message, $filename, $headers = ”)行在此行下面加入：
file_put_contents(’/var/www/cacti/plugins/thold/alert.log’, $subject); # 用file_put_contents函数将$subject写入alert.log文件
exec(’echo $subject >> /var/www/cacti/plugins/thold/alert.log’); # 换行
exec(’date +%D/%T >> /var/www/cacti/plugins/thold/alert.log’); #加入时间标签
exec(’sh /var/www/cacti/plugins/thold/sendsms.sh’); #执行飞信机器人脚步

编写脚本sendsms.sh自动调用飞信机器人发送报警

#!/bin/sh
#send sms by fetion
#Write by Ethan.Pan
if [ ! -e “/var/www/cacti/plugins/thold/alert.log” ]; then
echo “Usage:alert.log does not exist”
elif [ -n “`cat /var/www/cacti/plugins/thold/alert.log`” ]; then
echo `cat /var/www/cacti/plugins/thold/alert.log`
/usr/local/tools/fetion/fetion –mobile=18888888888 –pwd=123456 –to=1888888882 –msg-type=1 –file-utf8=/var/www/cacti/plugins/thold/alert.log
echo “`cat /var/www/cacti/plugins/thold/alert.log`” >> /var/www/cacti/plugins/thold/sms.txt
echo “exit” >> /var/www/cacti/plugins/thold/sms.txt
echo “Usage:all sms sends”
fi

主要参考文章：
http://hi.baidu.com/ethanpan/blog/item/0c6d0bf0d1ce0ba7a50f5237.html
http://xok.la/2009/03/fetion_2009_to_rhel4_linux4.html
http://www.hiadmin.com/cacti%E9%85%8D%E7%BD%AEe-mail%E6%8A%A5%E8%AD%A6/
http://www.php-oa.com/2009/06/04/plugin-architecture.html

Cacti, Linux

thold设置报警无法获取所有数据源

2009年11月10日写评论作者 夜行人

解决方法：将thold_add.php的第490-523行替换成
if ($graph != ”) {
$dt = db_fetch_assoc(‘SELECT DISTINCT data_template_rrd.local_data_id
FROM data_template_rrd
LEFT JOIN graph_templates_item ON graph_templates_item.task_item_id = data_template_rrd.id
LEFT JOIN graph_local ON graph_local.id=graph_templates_item.local_graph_id
WHERE graph_local.id = ‘ . $graph);
/* show the data source options */
?>
<tr>
<td width=’70’ style=’white-space:nowrap;’>
 <b>Data Source:</b>
</td>
<td>
<select name=dsid onChange=”applyTholdFilterChange(document.tholdform, ‘ds’)”>
<option value=””></option><?php
foreach ($dt as $row1) {
$dss = db_fetch_assoc(‘SELECT DISTINCT id, data_source_name
FROM data_template_rrd
WHERE local_data_id = ‘ . $row1[‘local_data_id’] . ‘ ORDER BY data_source_name’);
foreach ($dss as $row) {
echo “<option value='” . $row[‘id’] . “‘” . ($row[‘id’] == $ds ? ‘ selected’ : ”) . ‘>’ . $row[‘data_source_name’] . ‘</option>’;
}}?>
<input type=hidden name=dt value=”<?php print $row1[‘local_data_id’];?>”>
</select>
</td>
</tr><?php
} else {
?>
<tr>
<td>
<input type=hidden name=dsid value=””>
</td>
</tr><?php
}

来自over大神

Cacti

BLFS-6.3编译 Xorg 7.2过程

2009年11月10日写评论作者 夜行人

LFS V6.3 & BLFS V6.3
LFS是中文文档,见http://youbest.cublog.cn
BLFS是英文文档.我是下载下来,开一个终端用lynx来浏览的,貌似links不支持鼠标复制.
参考网址: http://www.linuxfromscratch.org/blfs/view/stable/

本来是打算用SlackWare12.1 DVD ISO 里的Xorg源码来编译的,懒得下载嘛,但由于有些包编译顺序不对,导致很多东西都没编译好,所以后面一直出错.所以就参照Beyond Linux® From Scratch Version 6.3的英文文档,把需要的东西wget下载,然后按照文档指导,花了一天时间,把Xorg基本环境编译出来了.最后加了个fluxbox,目前也就只做到这里了.本来还不打算BLFS的,但过于无聊,就BLFS下.见笑了.

准备工作:
mkdir xc &&
cd xc

export XORG_PREFIX=”/usr”
export XORG_CONFIG=”–prefix=$XORG_PREFIX –sysconfdir=/etc \
–mandir=$XORG_PREFIX/share/man –localstatedir=/var”

install -v -m755 -d \
/etc/X11/{app-defaults,fs,twm,xdm,xinit,xkb,xsm} &&
install -v -m755 -d $XORG_PREFIX/lib/X11 &&

for link in \
/etc/X11/{app-defaults,fs,twm,xdm,xinit,xkb,xsm}
do
ln -sv $link $XORG_PREFIX/lib/X11
done

下面是编译过程:

1.Xorg Protocol Headers

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/proto-7.2.wget

mkdir proto &&
cd proto &&
grep -v ‘^#’ ../proto-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/proto/

#Begin wget_install
for package in $(grep -v ‘^#’ ../proto-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
./configure $XORG_CONFIG
make install
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-proto-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
cd ..

2.pkg-config-0.22

wget http://pkgconfig.freedesktop.org/releases/pkg-config-0.22.tar.gz

tar xvf pkg-config-0.22.tar.gz
cd pkg-config-0.22
./configure –prefix=/usr &&
make &&
make install &&
cd ..

3.Xorg Utilities

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/util-7.2.wget

mkdir util &&
cd util &&
grep -v ‘^#’ ../util-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/util/

#Begin wget_install
for package in $(grep -v ‘^#’ ../util-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
./configure $XORG_CONFIG
make
make install
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-util-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
cd ..

4.libXau-1.0.3

wget http://xorg.freedesktop.org/releases/individual/lib/libXau-1.0.3.tar.bz2

tar xvf libXau-1.0.3.tar.bz2
cd libXau-1.0.3
./configure $XORG_CONFIG &&
make &&
make install &&
cd ..

5.libXdmcp-1.0.2

wget http://xorg.freedesktop.org/releases/individual/lib/libXdmcp-1.0.2.tar.bz2

tar xvf libXdmcp-1.0.2.tar.bz2
cd libXdmcp-1.0.2
./configure $XORG_CONFIG &&
make &&
make install &&
cd ..

6.xcb-proto-1.0

wget http://xcb.freedesktop.org/dist/xcb-proto-1.0.tar.bz2

tar xvf xcb-proto-1.0.tar.bz2
cd xcb-proto-1.0
./configure $XORG_CONFIG &&
make &&
make install &&
install -dv -m755 ${XORG_PREFIX}/share/doc/xcb-proto-1.0 &&
install -v -m644 doc/* ${XORG_PREFIX}/share/doc/xcb-proto-1.0 &&
cd ..

7.libxml2-2.6.31

wget http://xmlsoft.org/sources/libxml2-2.6.31.tar.gz

tar xvf libxml2-2.6.31.tar.gz
cd libxml2-2.6.31
./configure –prefix=/usr &&
make &&
make install &&
cd ..

8.libxslt-1.1.22

wget http://xmlsoft.org/sources/libxslt-1.1.22.tar.gz

tar xvf libxslt-1.1.22.tar.gz
cd libxslt-1.1.22
./configure –prefix=/usr &&
make &&
make install &&
cd ..

第九步之前应是要先装这个：libpthread-stubs-0.1

9.libxcb-1.0

wget http://xcb.freedesktop.org/dist/libxcb-1.0.tar.bz2
wget http://www.linuxfromscratch.org/patches/blfs/6.3/libxcb-1.0-sloppy_lock-1.patch

tar xvf libxcb-1.0.tar.bz2
cd libxcb-1.0
patch -Np1 -i ../libxcb-1.0-sloppy_lock-1.patch &&
./configure $XORG_CONFIG –docdir=’${datadir}’/doc/libxcb-1.0 &&
make &&
make install &&
cd ..

10.Ed-0.8

wget http://ftp.gnu.org/pub/gnu/ed/ed-0.8.tar.bz2

tar xvf ed-0.8.tar.bz2
cd ed-0.8
./configure –prefix=/usr &&
make &&
make install &&
make install-man &&
cd ..
11.expat-2.0.1

wget http://downloads.sourceforge.net/expat/expat-2.0.1.tar.gz

tar xvf expat-2.0.1.tar.gz
cd expat-2.0.1
./configure –prefix=/usr &&
make &&
make install &&
install -v -m755 -d /usr/share/doc/expat-2.0.1 &&
install -v -m644 doc/*.{html,png,css} /usr/share/doc/expat-2.0.1 &&
cd ..

12.FreeType-2.3.7

wget http://downloads.sourceforge.net/freetype/freetype-2.3.7.tar.bz2
wget http://downloads.sourceforge.net/freetype/freetype-doc-2.3.7.tar.bz2

tar xvf freetype-2.3.7.tar.bz2
cd freetype-2.3.7

tar xf ../freetype-doc-2.3.7.tar.bz2 \
–strip-components=2 -C docs

sed -i -r -e ‘s:.*(#.*BYTE.*) .*:\1:’ \
-e ‘s:.*(#.*SUBPIX.*) .*:\1:’ \
include/freetype/config/ftoption.h &&
./configure –prefix=/usr &&
make &&
make install &&
install -v -m755 -d /usr/share/doc/freetype-2.3.7 &&
cp -v -R docs/* /usr/share/doc/freetype-2.3.7 &&
cd ..

13.Fontconfig-2.4.2

wget http://fontconfig.org/release/fontconfig-2.4.2.tar.gz

tar xvf fontconfig-2.4.2.tar.gz
cd fontconfig-2.4.2
./configure –prefix=/usr \
–sysconfdir=/etc –localstatedir=/var \
–disable-docs –without-add-fonts \
–with-docdir=/usr/share/doc/fontconfig-2.4.2 &&
make

make install &&
install -v -m644 doc/*.3 /usr/share/man/man3 &&
install -v -m644 doc/*.5 /usr/share/man/man5 &&
install -v -m755 \
-d /usr/share/doc/fontconfig-2.4.2/fontconfig-devel &&
install -v -m644 doc/*.{html,pdf,txt} \
/usr/share/doc/fontconfig-2.4.2 &&
install -v -m644 doc/fontconfig-devel/* \
/usr/share/doc/fontconfig-2.4.2/fontconfig-devel

cd ..

14.Xorg Libraries

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/lib-7.2.wget
wget http://www.linuxfromscratch.org/patches/blfs/6.3/libX11-1.1.2-badargs-1.patch
wget http://www.linuxfromscratch.org/patches/blfs/6.3/libXfont-1.2.8-pcf_parser-1.patch

mkdir lib &&
cd lib &&
grep -v ‘^#’ ../lib-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/lib/

#Begin wget_install
for package in $(grep -v ‘^#’ ../lib-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
case $(basename “$PWD”) in
libX11-1.1.2 )
patch -Np1 -i ../../libX11-1.1.2-badargs-1.patch &&
sed -i ‘s/_XGet/XGet/’ modules/im/ximcp/imDefLkup.c
;;
libXfont-1.2.8 )
patch -Np1 -i ../../libXfont-1.2.8-pcf_parser-1.patch &&
sed -i ‘s/(ft_isdigit/(isdigit/’ src/FreeType/fttools.c
;;
esac
./configure $XORG_CONFIG
make
make install
ldconfig
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-lib-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
cd ..

Tips:
这里要重新编译下libXfont-1.2.8,配置的时候加下面的参数,要不然的话后面xorg-server编译通过不

了.
./configure $XORG_CONFIG CFLAGS=’-Dft_isdigit=isdigit’
make
make install
ldconfig
15.Xbitmaps-1.0.1

wget http://xorg.freedesktop.org/releases/individual/data/xbitmaps-1.0.1.tar.bz2

tar xvf xbitmaps-1.0.1.tar.bz2
cd xbitmaps-1.0.1
./configure $XORG_CONFIG &&
make install &&
cd ..

16.libpng-1.2.29

wget http://downloads.sourceforge.net/libpng/libpng-1.2.29.tar.bz2

tar xvf libpng-1.2.29.tar.bz2
cd libpng-1.2.29
./configure –prefix=/usr &&
make &&
make install &&
install -v -m755 -d /usr/share/doc/libpng-1.2.29 &&
install -v -m644 README libpng-1.2.29.txt \
/usr/share/doc/libpng-1.2.29 &&
cd ..

17.libdrm-2.3.0

wget http://dri.freedesktop.org/libdrm/libdrm-2.3.0.tar.gz

tar xvf libdrm-2.3.0.tar.gz
cd libdrm-2.3.0
./configure –prefix=$XORG_PREFIX &&
make &&
make install &&
cd ..

18.MesaLib-6.5.2

wget http://downloads.sourceforge.net/mesa3d/MesaLib-6.5.2.tar.bz2

tar xvf MesaLib-6.5.2.tar.bz2
cd MesaLib-6.5.2
make linux-dri-x86 OPT_FLAGS=”-O2 -fno-strict-aliasing” \
DRI_DRIVER_INSTALL_DIR=${XORG_PREFIX}/lib/X11/modules/dri \
X11_INCLUDES=-I${XORG_PREFIX}/include \
EXTRA_LIB_PATH=-L${XORG_PREFIX}/lib

make install INSTALL_DIR=${XORG_PREFIX} \
DRI_DRIVER_INSTALL_DIR=${XORG_PREFIX}/lib/X11/modules/dri &&
install -dv ${XORG_PREFIX}/share/doc/MesaLib-6.5.2 &&
install -v -m644 docs/* ${XORG_PREFIX}/share/doc/MesaLib-6.5.2

ln -s -v ${XORG_PREFIX}/include/GL /usr/include
cd ..

19.Xorg Applications

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/app-7.2.wget

mkdir app &&
cd app &&
grep -v ‘^#’ ../app-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/app/

#Begin wget_install
for package in $(grep -v ‘^#’ ../app-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
./configure $XORG_CONFIG
make
make install
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-app-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
cd ..

20.xcursor-themes-1.0.1

wget http://xorg.freedesktop.org/releases/individual/data/xcursor-themes-1.0.1.tar.bz2

tar xvf xcursor-themes-1.0.1.tar.bz2
cd xcursor-themes-1.0.1
./configure $XORG_CONFIG &&
make &&
make install &&
cd ..
21.Xorg Fonts

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/font-7.2.wget

mkdir font &&
cd font &&
grep -v ‘^#’ ../font-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/font/

#Begin wget_install
for package in $(grep -v ‘^#’ ../font-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
./configure $XORG_CONFIG
make
make install
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-font-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
install -v -d -m755 /usr/share/fonts &&
ln -svn $XORG_PREFIX/lib/X11/fonts/OTF /usr/share/fonts/X11-OTF &&
ln -svn $XORG_PREFIX/lib/X11/fonts/TTF /usr/share/fonts/X11-TTF &&
cd ..

22.XML::Parser-2.34

wget http://cpan.org/authors/id/M/MS/MSERGEANT/XML-Parser-2.34.tar.gz

tar xvf XML-Parser-2.34.tar.gz
cd XML-Parser-2.34
perl Makefile.PL
perl Makefile.PL PREFIX=/home/me/perl INSTALLDIRS=perl
make
make install
cd ..

23.XKeyboardConfig-1.2

wget http://xlibs.freedesktop.org/xkbdesc/xkeyboard-config-1.2.tar.bz2

tar xvf xkeyboard-config-1.2.tar.bz2
cd xkeyboard-config-1.2
./configure $XORG_CONFIG –with-xkb-rules-symlink=xorg &&
make &&
make install &&
install -dv -m755 $XORG_PREFIX/share/doc/xkeyboard-config-1.2 &&
install -v -m644 docs/{README,HOWTO}* \
$XORG_PREFIX/share/doc/xkeyboard-config-1.2 &&
cd ..

24.Luit-1.0.2

wget http://xorg.freedesktop.org/releases/individual/app/luit-1.0.2.tar.bz2

tar xvf luit-1.0.2.tar.bz2
cd luit-1.0.2
./configure $XORG_CONFIG \
–with-localealiasfile=$XORG_PREFIX/share/X11/locale/locale.alias &&
make &&
make install &&
cd ..
25.Xorg-Server-1.2.0

wget http://xorg.freedesktop.org/releases/individual/xserver/xorg-server-1.2.0.tar.bz2
wget http://www.linuxfromscratch.org/patches/blfs/6.3/xorg-server-1.2.0-security-1.patch

tar xvf xorg-server-1.2.0.tar.bz2
patch -Np1 -i ../xorg-server-1.2.0-security-1.patch
./configure $XORG_CONFIG \
–with-mesa-source=/root/Mesa-6.5.2 \
–with-module-dir=$XORG_PREFIX/lib/X11/modules \
–with-dri-driver-path=$XORG_PREFIX/lib/X11/modules/dri \
–with-xkb-output=/var/lib/xkb \
–enable-install-setuid &&
make &&
make install &&
cd ..

Tips:
–with-mesa-source=/root/Mesa-6.5.2
因为我的Mesa-6.5.2的源代码在/root/下,官方文档说这里要用绝对路径
编译时间比较长.

26.Xorg Drivers

wget http://anduin.linuxfromscratch.org/files/BLFS/6.3/xorg/driver-7.2.wget

mkdir driver &&
cd driver &&
grep -v ‘^#’ ../driver-7.2.wget | wget -i- -c \
-B http://xorg.freedesktop.org/releases/individual/driver/

#Begin wget_install
for package in $(grep -v ‘^#’ ../driver-7.2.wget)
do
packagedir=$(echo $package | sed ‘s/.tar.bz2//’)
tar -xf $package
cd $packagedir
case $(basename “$PWD”) in
xf86-input-evdev-[0-9]* | xf86-video-ati-[0-9]* | \
xf86-video-fbdev-[0-9]* | xf86-video-glint-[0-9]* | \
xf86-video-newport-[0-9]* )
sed -i -e “s/\xc3\xb8/\\\\[\/o]/” \
-e “s/\xc3\xa4/\\\\[:a]/” \
-e “s/\xc3\x9c/\\\\[:U]/” man/*.man
;;
esac &&
./configure $XORG_CONFIG \
–with-xorg-module-dir=$XORG_PREFIX/lib/X11/modules &&
make &&
make install &&
cd ..
rm -rf $packagedir
rm -f $package
done 2>&1 | tee -a ../xorg-driver-7.2-compile.log #log the entire loop
#End wget_install

../wget_install &&
至此,Xorg 7.2的所有编译工作完成.接下来就是配置xorg,安装窗口管理器等,我自己编译的是fluxbox.

转载自：

http://hi.baidu.com/wtx358/blog/item/db40f9c4aa0533ae8226acc5.html/cmtid/03391e33fa30b6f31a4cffbd

Linux

mysql时区的修正

2009年11月7日写评论作者 夜行人

昨天暴风的技术人员找我要核对充值数据，说是时间对不上；我检查了之后发现二服的数据库的时间有问题，我使用from_unixtime()这个方法查看1257868800这个时间戳顯示的不是2009-11-11，而是2009-11-10 11:00:00，时间差了十三个小时。而后台显示那里是用from_unixtime()这个方法来显示时间格式的，所以所有的订单数据都对不上他们那边系统记录的时间。据说是因为装MYSQL的时候的时间不对，导致后来MYSQL的时区就不对了，后来系统虽然把时区改过来了，但是MYSQL的时区还是在装机的时候的那个时区，显示就错误了。

知道了原因之后就能解决了，上网搜索了一下，找到了解决的方法。现在把我的解决方式记录一下。

先检查MYSQL的时区，打开一台MYSQL时区正确的机器，然后打开有问题的机器，确认是时区错误。

先打开时区正确的机器：进入MYSQL，在命令行输入：mysql -uroot -p****(root的密码)，进去之后输入show variables like ‘%time_zone%’;然后回车，得到如下的显示：

然后再输入select from_unixtime(1257868800);回车，得到如下结果：

+—————————+
| from_unixtime(1257868800) |
+—————————+
| 2009-11-11 00:00:00 |
+—————————+
1 row in set (0.00 sec)

好了，再去有问题有机器上执行相同的操作发现执行show variables like ‘%time_zone%’;得到的结果是：

执行select from_unixtime(1257868800);得到的结果是：

+—————————+
| from_unixtime(1257868800) |
+—————————+
| 2009-11-10 11:00:00 |
+—————————+
1 row in set (0.00 sec)

时间差了十三个小时。怎么样把时区调回我们想要的呢？虽然网上说可以在命令行下执行set time_zone = ‘+8:00′;之后就设置了时区，但是这样的操作没有对全司有效。只是在执行这个之后再在命令行下执行其它的操作可以得到正确的数据。但是在phpmyadmin下得到的结果还是错的。所以要修改MYSQL的配置文件来达到修改全局变量的目的。

先去找到mysql的配置文件my.cnf，一般在/etc/my.cnf下面，可以cd /etc 然后find my.cnf找找，看能不能找到。找到之后就修改它，用VI打开：vi /etc/my.cnf，打开之后查找[mysqld]，在VI输入“/”然后输入[mysqld],就定位到[mysqld]所在的位置，在它的下面加上default-time-zone = ‘+8:00′这一行，然后保存退出，重新启动MYSQL，使时区生效。这个时候再去MYSQL下查看刚才的那两条命令，就会发现时区都设置正确了。

到此，时区不对的问题就解决了。

转载自：http://www.codeo4.cn/?p=318

MySQL

MySQL不断restarted

2009年11月6日写评论作者 夜行人

平时用得好好的创建数据库的命令，突然间用不了了，今天把MySQL重启，发现无法启动，终端输出信息为
Starting mysqld daemon with databases from /usr/local/mysql/var
091104 12:28:16 mysqld restarted
/usr/local/mysql/bin/mysqld_safe: line 390: 7558 Killed nohup /usr/local/mysql/libexec/mysqld –basedir=/usr/local/mysql –datadir=/usr/local/mysql/var –user=mysql –pid-file=/usr/local/mysql/var/s1.1199.com.pid –skip-external-locking –port=3306 –socket=/tmp/mysql.sock >> /usr/local/mysql/var/s1.1199.com.err 2>&1

Number of processes running now: 0

ps aux |grep mysql
发现有如下进程
ps aux |grep mysql
root 23070 0.2 0.0 63824 1212 pts/1 S 12:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe
mysql 26295 112 0.0 0 0 pts/1 Zl 12:22 0:01 [mysqld] <defunct>

cd /usr/local/mysql/var/
more s1.1199.com.err

发现错误如下
091104 12:19:29 mysqld started
/usr/local/mysql/libexec/mysqld: Error writing file ‘/usr/local/mysql/var/s1-slow.log’ (Errcode: 28)
091104 12:19:29 [ERROR] Could not use /usr/local/mysql/var/s1-slow.log for logging (error 28). Turning logging off for the whole dur
ation of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091104 12:19:30 InnoDB: Started; log sequence number 0 1511759772
091104 12:19:30 [ERROR] /usr/local/mysql/libexec/mysqld: Error writing file ‘/usr/local/mysql/var/s1.1199.com.pid’ (Errcode: 28)
091104 12:19:30 [ERROR] Can’t start server: can’t create PID file: No space left on device
df -h看了下
发现硬盘满了，删除掉多余文件，启动MySQL就可以了。

MySQL

每月存档十一月, 2009

CentOS_4.6_Cacti短信报警设置

thold设置报警无法获取所有数据源

BLFS-6.3编译 Xorg 7.2过程

mysql时区的修正

MySQL不断restarted

Search

文章归档

分类目录

链接表

功能

一	二	三	四	五	六	日
« 10月				12月 »
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30

每月存档 十一月, 2009

CentOS_4.6_Cacti短信报警设置

thold设置报警无法获取所有数据源

BLFS-6.3编译 Xorg 7.2过程

mysql时区的修正

MySQL不断restarted

Search

标签

文章归档

分类目录

链接表

功能

每月存档十一月, 2009