The brief outage was due to a scheduled move of the servers to a separate rack and subnet dedicated to our work with the Center for Information Assurance & Cybersecurity (ciac) at the University of Washington Bothell (uwb), and a11y.com

I am currently exercising the new (to us) equipment and hope to winnow the less than awesome equipment over the next quarter. I spent the last six months finding the best in breed of the surplussed DL385 and DL380 chassis we (work) were going to have recycled. The team and I were able to find enough equipment to bring up one of each with eight and six gigs of memory, respectively. These will make excellent hypervisors for provisioning embedded instances of Slackware, Fedora, RHEL, CentOS, Debian, FreeBSD, OpenSolaris, OpenIndiana, FreeDOS, etc.

When I initially configured this xen paravirt environment, I failed to plan for integration with libvirt, so I am now re-jiggering the software bridges so …

(NOTE: If you’ve come here from http://planet.mysql.com my apologies. I’ve notified them to only follow my database related posts and hope they’ll not follow my full blog feed shortly.) I recently came across a new site which offers a GUI configuration tool for FreeSWITCH. Despite buying the FreeSWITCH 1.0.6 Book which is a very good [...]

There was a lot of talk about this being the next menace after email spam. I’m not actually sure what it’s called for VoIP systems, but my Asterisk setup has started to be attacked over the last few days. Lots of entries like: [Aug 27 19:20:30] NOTICE[18826] chan_sip.c: Registration from '"742"<sip:742@a.b.c.d>' failed for '208.109.86.187' - [...]

I hate losing useful SQL queries, so I tend to save them. Ever so often, I stumble across a file of queries from some work I was doing months ago. The following two queries are just such a case. I was analyzing some call data for a call center that uses Asterisk. I set up a temporary database for this, so I can't even run them again. Still, it's nice to save them away for a rainy day.

Call Center Call Volume by Day of Week and Hour

SET @tz = 'EST5EDT';
select 
  DAYNAME(CONVERT_TZ(start, 'GMT', @tz)) AS "Weekday",
  HOUR(CONVERT_TZ(start, 'GMT', @tz)) AS "Hour",
  COUNT(id), 
  SUM(duration), 
  SUM(billsec), 
  AVG(duration), AVG(billsec) 
  FROM cdr 
    WHERE dcontext IN ('Queue1', 'Queue2', 'Queue3', 'Queue4')
      AND duration > 60
    GROUP BY Weekday, Hour
    ORDER BY WEEKDAY(CONVERT_TZ(start, 'GMT', @tz)), Hour 
;

I was trying to figure out …

The future of MySQL. The SCO Group terminates Darl McBride. And more.

The future of MySQL
Monty Widenius urged Oracle to give up on MySQL in order to land Sun while Richard Stallman, Knowledge Ecology International (KEI) and the Open Rights Group sent a letter to the EC urging it to block Oracle’s acquisition of MySQL. All of which prompted Florian Mueller, who it should be noted is working with Widenius as part of his campaign, to claim that there is growing public opposition to Oracle owning Sun’s MySQL.

Meanwhile The VAR Guy reported on rumours that …

Oracle is keeping MySQL. Yahoo is selling Zimbra. Linus is feeling bloated. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Larry Ellison reportedly said Oracle has no intention of spinning off MySQL.

# Yahoo is trying to sell Zimbra, according to All Things D.

# Linus Torvalds said Linux is “bloated and huge”.

# GroundWork Open Source released GroundWork Monitor 6.0.

# Zend launched Simple API for Cloud Application …

Red Hat round-up. EC to review Oracle-Sun. Dedicated Ubuntu support. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Red Hat announcements round-up
Red Hat announced a whole heap of products and projects this week. They should have organized an event to coincide with all the announcements. Or something. The biggest news was probably the launch of Red Hat Enterprise Linux 5.4 including KVM and other virtualization capabilities, while Red Hat and HP partnered to optimize Red Hat Enterprise Virtualization for HP BladeSystem Matrix. The company also revealed that Red Hat Network Satellite …

Red Hat increases its service levels. Linux Foundation appoints Ted Ts’o CTO. Sun delivers VirtualBox update. Novell cancels BrainShare. BBC enables iPlayer for Linux. And more.

Note: This is the last 451 CAOS Links post of 2008. We’ll be back with a bumper holiday special on January 2. Happy holidays!

Official announcements
Red Hat Increases Service Levels and Reduces Costs for Customers with Extended Update Support Red Hat

Linux Foundation Appoints Ted Ts’o to Position of Chief Technology Officer Linux Foundation

…

We knew Marc Fleury couldn’t stay out of the business world for long. The founder of JBoss has leaked details of his new venture, an open source home automation community named OpenRemote.

The OpenRemote team also includes the creator of Asterisk Mark Spencer, JBoss veterans Juha Lindfors, Christian Bauer, Java X10 project creator Wade Wassenberg, and Linux Home Automation founder Neil Cherry.

Together they, and others, plan to create a complete open source home automation including the OpenRemote Controller hardware, OpenRemote Console Applications to make use of the iPhone and iTouch as a universal remote (although any device with browser will work), …

Curious about Digium's AsteriskNOW distribution? Mark has the following video up on YouTube showing how to install it.




(...and yes someday I'll get around to doing something like this for MySQL... its just hard to get a camera, a free afternoon, and a car that someone will let me blowup)