sysadmin

Utilising old desktops around the office

So over the years, we have some old desktops in the office which aren't really good enough to use for development any more. I've started breathing new life into them by using them to backup our Subversion repositories by using svnsync.By setting up cron jobs to sync every x minutes or even hours you can have a huge amount of redundancy for next to no cost.The read only mirrors are also handy for other applications that create load on your repositories (build servers etc) so I use a near real-tim...

mysql schema…. finally

I know this has taken waaay to long to post. But here it is if anyone still wants it. # CREATE DATABASE voip; # USE voip; # # Table structure for table 'allocation' # # DROP TABLE IF EXISTS allocation; CREATE TABLE `allocation` ( `allocation_id` int(11) NOT NULL auto_increment, `asset_id` int(11) NOT NULL default '0', `site_id` int(11) NOT NULL default '0', `extension` int(11) NOT NULL default '0', PRIMARY KEY (`allocation_id`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COLLATE...

Glintech integrates Asterisk, Jabber for open source UC platform

A week or so ago, my boss came to me asking if I could write something on what'd I'd done internally with XMPP and Asterisk for someone he knew at Computerworld. I was only too happy to have someone listen to my ramblings, so I wrote up some replies to some of the questions his friend had asked.Last night my boss sent me a link to the article. Unfortunately, the article makes it look like he was the one who replied to the questions instead of me, but it's nice to get some of my work out there an...

Erratic Sendmail problems…

I've recently installed Drupal 6, and was having problems sending out emails (specifically for new users and password resets). The problem was that sometimes the mail was coming through, and other times it wasn't (it didn't even appear in our mail server logs). After lots of scouting around, I noticed that in /var/log/maillog (on FC6), the relay kept on changing. On our network, we have 3 domain controllers, one of which is a mail server. Send mail was using it's "Smart" relay to figure out w...

Asterisk Bootcamp

Just a quick post to mention that I'm heading to Melbourne next month for the Asterisk Bootcamp (care of work). Should be a good opportunity to learn a lot of info about Asterisk and VoIP in general.