Grimsy's Blog

New battery for ClearOne Max Conference Phone

We have a ClearOne Max conference phone at work that has been in need of a new battery for a while. When we do get new batteries for it, they never seem to last as long as they should and always need to be ordered in. Solution: Use an RC battery pack. The battery in the conference unit is a 7.2V 1800mAh NiMH battery pack. The RC battery pack is 3000mAH so we get much longer out of it on a single charge. We're still able to use the normal charger that came with the phone too. Sure it might be ...

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...

Follow up to SPA942 Personal Directory with LDAP

I just wanted to follow up on my previous post about using LDAP and PHP to push the directories on the SPA942. I've included a whole lot of code below, and please note that a lot of this is me just getting the job done. The code is probably messy and poorly written, and some of it is taken from other sites/samples. Unfortunately, blogger seems to take away all my nice formatting (indents etc...), so you'll have to bear with me. Also, long comments appear across multiple lines in here, so that co...

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.

More SPA942 Firmware stuff

Well I'm trailing out the 5.15a firmware for the SPA942 phones. Firstly, I have figured out the problem I was having previously with the first line being one pixel out of alignment. For our users, we display $EXT - Line # on each of the lines, so for me it appears as:6004 - Line 16004 - Line 26004 - Line 36004 - Line 4In the previous (5.1.5) firmware, this was left aligned, where as the newer firmwares are right aligned. Because the number 1 is thinner than the numbers 2,3 and 4, the text looked...

SPA942 Personal Directory with LDAP

A while ago, I posted a blog about the SPA942 Personal Directory. Well I've built on it a bit now and managed to get it populated from the information taken out of our LDAP server (Microsoft Active Directory). When we allocate a phone to someone, we fill in the ipphone field with their extension. We then also add two other ipphone entries, the first being the MAC address of the phone, the second being the phone's IP. I'm also managing calling groups (queues) in LDAP by creating security groups...

SPA942 Personal Directory

I've been setting up Asterisk at work recently, as our old PABX has reached it's limits. We picked up half a dozen SPA942's for some initial testing. I have to say that while the phones are nice as an end user, however some of the administration functions seem to come up a bit short. One of the big issues for us was that the personal directory on the phones doesn't actually have to option to be populated from Asterisk (or any other PBX other than SPA9000). I have to admit though, I'm not really ...