Table of Contents: Tech

Most Popular: Tech

Browse Recent: Tech

Posted on

Install MySQL Activity Report from Source

MySQL Activity Report is a handy database reporting tool that uses RRD (Round Robin Database) to display hourly, daily, weekly, and monthly graphs and gives helpful performance tuning recommendations for your MySQL installation. Here are the steps to install it from source on Ubuntu Server 12.04.3 while logged in as root. This assumes that you have the build-essentials, header files, etc necessary to build software already installed.

1. Change into your local source directory

cd /usr/local/src

2. Download the source files for rrdtool and mysqlard

wget http://oss.oetiker.ch/rrdtool/pub/rrdtool-1.4.8.tar.gz
wget http://gert.sos.be/downloads/mysqlar/mysqlard-1.0.0.tar.gz

3. Unzip the files

tar -zxvf rrdtool-1.4.8.tar.gz
tar -zxvf mysqlard-1.0.0.tar.gz

4. Change into the rrd directory

cd rrdtool-1.4.8

5. Install dependencies

apt-get install libpango1.0-dev libxml2-dev

6. Build rrdtool (will install to the /opt/rrdtool-1.4.8 directory)
Continue reading “Install MySQL Activity Report from Source”

Posted on

Outlook 2010 Hijacked

Today I received an email in my inbox that had auto-previewed and then Outlook immediately became non-responsive afterwards. I killed the task and re-opened the program only to find that was now attempting to connect to \\googleads.some.url and another site called \\pixel.quantserve.com\pixel at startup. After that Outlook would no longer open up fully and I would keep having to kill the task. The only way I was able to get the program to open was by running Outlook in safe mode.
Continue reading “Outlook 2010 Hijacked”

Posted on

Bash Script – Move Asterisk Call Files into Spool Directory

After running into permission issues trying to get PHP’s shell_exec command to chown call files as the asterisk user(which only root can do), I decided to make this script.

As a side note, you should be able to get the shell_exec command to work using sudo by adding the www-data user to the sudoer’s file without a password but that wouldn’t work in my particular environment. The server I was working on was extremely outdated and didn’t even have sudo installed.

Add this to /etc/sudoers
www-data ALL=NOPASSWD: /path/to/script

The following code runs the script as a daemon. You will need to update rc to start this script at default run levels and also make sure to chmod +x this file to make it executable.

filename: /etc/init.d/mvcallfile

#!/bin/bash
# Move asterisk call file daemon startup script
# Author: Nathan Thomas

PROG=mvcallfile
 Continue reading "Bash Script – Move Asterisk Call Files into Spool Directory"
Posted on

Startup Script for OpenMeetings Open-Source Video Conferencing Server

/etc/init.d/openmeetings startup script for Ubuntu Server 12.04.2
OpenMeetings Version 2.0-INCUBATING

A few notes:
– Make sure to change path for RED5_HOME variable
– Make sure to chmod +x the init script
– This assumes openmeetings is running under a user/group with the same name
– This assumes you are using libreoffice (not openoffice) for the whiteboard file import service

#!/bin/bash
#
# Author: Nathan Thomas
#
### BEGIN INIT INFO
# Provides:          red5
# Required-Start:    $local_fs $remote_fs $network $syslog $named $time
# Required-Stop:     $local_fs $remote_fs $network $syslog $named $time
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# X-Interactive:     true
# Short-Description: Start/stop OpenMeetings java based conferencing webapp
### END INIT INFO
PROG=red5
DESC="Red5 flash streaming server"
RED5_HOME=/usr/local/openmeetings
DAEMON=$RED5_HOME/$PROG.sh
PIDFILE=/var/run/$PROG.pid
# Plugin Variables
#OO_HOME=/usr/lib/openoffice/program
OO_HOME=/usr/lib/libreoffice/program
 Continue reading "Startup Script for OpenMeetings Open-Source Video Conferencing Server"
Posted on

Cisco VPN Client Won’t Connect on Windows 7 x64 via 3g Modem

It turns out there is no support for WWAN connections on the 64 bit Cisco VPN Client (version 5.0.07.0440-k9) so the client will connect but you can’t ping anything on the remote network and you will only see packets showing a bypassed status on the statistics page. Fortunately for some, you can resolve this issue by doing the following:
Continue reading “Cisco VPN Client Won’t Connect on Windows 7 x64 via 3g Modem”

Posted on

Fixing 500 OOPS: vsftpd: refusing to run with writable root inside chroot ()

The latest upgrade on Ubuntu 12.04 updates vsftpd to version 2.3.5 and they have made a change that requires the chroot directory to no longer be writable which produces this error when trying to connect. They have made an option called allow_writeable_chroot=YES in the latest build that had to be backported to use this functionality.
Continue reading “Fixing 500 OOPS: vsftpd: refusing to run with writable root inside chroot ()”