Yeri Tiete

Category: Software

  • Bind mrtg stats

    Because I couldn’t find any that worked. (Dark blue: incoming queries, light blue: outgoing/recursive lookups) mrtg.cfg sample: # Bind Title[bind]: Bind Queries Target[bind]: `/etc/mrtg/bind-stats.sh` PageTop[bind]: <H1> Bind queries per minute on vm1 </H1> Options[bind]: growright,pngdate,nobanner,gauge,nopercent,noinfo MaxBytes[bind]: 50000 Ylegend[bind]: Queries/min ShortLegend[bind]: queries/min LegendO[bind]: Incoming Bind queries per minute LegendI[bind]: Outcoing Bind queries per minute Legend2[bind]: Incoming…

  • Call to undefined function http_post_data()

    After updating my server from testing to Squeeze it suddenly crashed after running a high CPU % perl script. Being unresponsive I reset the machine to reboot it. After booting up and testing websites running on it I came along an odd PHP error; Call to undefined function http_post_data() Probably due to PHP updates from…

  • Squid MRTG stats

    I talked about MRTG stats for Squid in the past but apparently forgot to include the .mib file. So, here it is. Download this file and put it in /usr/share/squid/mib.txt. I don’t quite remember where I found that mib file. Probably included with Squid on Gentoo or the world wide web… But I couldn’t find…

  • Debian MySQL Gem file error

    When installing the MySQL Gem, I had this error: Building native extensions. This could take a while… ERROR: Error installing mysql: ERROR: Failed to build gem native extension. /usr/bin/ruby1.8 extconf.rb –with-mysql-dir=/usr/include/mysql checking for mysql_query() in -lmysqlclient… no checking for main() in -lm… yes checking for mysql_query() in -lmysqlclient… no checking for main() in -lz… yes…

  • Squid: readable time format in log

    Change the time & date log format For Squid. From: 1295723692.628 24 192.168.200.6 TCP_MISS/200 3505 GET https://web.archive.org/web/20130823023017/http://i3.ytimg.com/vi/ru8ddkzOFUI/default.jpg – DIRECT/74.125.79.101 image/jpeg To: 22/Jan/2011:20:48:17 +0100.079 40 192.168.200.6 TCP_MISS/304 353 GET https://web.archive.org/web/20110124082452/http://s.ytimg.com/yt/cssbin/www-embed-vfl0GVaH1.css – DIRECT/74.125.79.101 – In the Squid config comment all “logformat” lines, and add: logformat squid %tl.%03tu %6tr %>a %Ss/%03Hs %<st %rm %ru %un %Sh/%<A %mt FYI; Default is:…

  • MRTG and network interfaces

    I tend to restart OpenVPN a lot due to config changes. As a result, this brings quite some issues to MRTG (or more precisely, SNMP), due to the fact tun devices change of ID. A while back, I found a quick fix for this; rename the interface targets from their respective ID to their name:…

  • Theme, blog, and stuff

    As you noticed… Or perhaps didn’t notice, I’ve started using a new, simplistic theme a couple of days ago. Kinda thought it might be too simplistic (I’ve hidden the sidebar, there’s no search or archive, etc), but I started to, you know, get attached to it. So it’s here to stay, for a year or…

  • Exchange error 0x6d9

    I noticed my “Offline Address Book” was no longer automatically updating. Running “get-offlineaddressbook |fl” in the EMS showed it last updated somewhere 16th November 2010. Trying to manually update it through EMC (“Organizational Configuration > Mailbox > Offline Address Book > right click Default Offline Address Book > click update”) it gave me this error:…

  • Blog changes

    Right, playing around with my blog again. Wasn’t really that happy anymore with my nginx rproxy caching. Especially that for some reason, lately, every (php) request got at least one hit to the backend Apache server, while it used to cache the generated html for 30 mins. And well, performance just wasn’t good enough. So…