dear temans
aku mo buat graph pake mrtg, data yg ditampilkan data mysql dengan
command sbb:
#!/bin/bash
MYUSER="fetch"
MYPASS="12345"
MYDATA="labdata"
MYPROG=`which mysql`
mf=`$MYPROG -u $MYUSER -p$MYPASS $MYDATA -B -r -e "SELECT idvalue FROM
ttransrx2 WHERE seqno=1 ORDER BY idcurrentdate DESC LIMIT 0,1"`
et=`$MYPROG -u $MYUSER -p$MYPASS $MYDATA -B -r -e "SELECT idvalue FROM
ttransrx2 WHERE seqno=5 ORDER BY idcurrentdate DESC LIMIT 0,1"`
echo $mf |awk '{print $2}'
echo $et |awk '{print $2}'
sedangkan mrtc.cfg sbb:
# Created by
# ./cfgmaker --global WorkDir:/var/www/html/traf --global
'Options[_]:growright,bits' [EMAIL PROTECTED]
### Global Defaults
# to get bits instead of bytes and graphs growing to the right
# Options[_]: growright, bits
EnableIPv6: no
WorkDir:/var/www/html/traf/mysql
Options[_]:growright, nopercent
###mysql
Target[mysql2]:`/usr/local/mrtg-2/bin/lab.sh`
Title[mysql2]: Lab Data
PageTop[mysql2]: <h1>mysql2</h1>
MaxBytes[mysql2]: 1000000
YLegend[mysql2]: Index/s
ShortLegend[mysql2]: Idx/s
LegendI[mysql2]: Index Mf
LegendO[mysql2]: Index Et
Legend1[mysql2]: MF Data Sample
Legend2[mysql2]: ET Data Sample
RunAsDaemon: Yes
Interval: 5
Refresh: 300
tapi waktu aku jalanin gak ada data yg masuk ke grapik, padahal kalo aku
jalanin command tersebut muncul data sesuai data yg ada di mysql. kira2
gimana ya?
thx
gun
__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis
