Grimsy's Blog

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

SPA942 and Daylight Saving

Well daylight savings just hit for the first time since we've had the SPA942s and needless to say I overlooked that parameter when setting them up. Unfortunately it wasn't as simple as ticking a box or setting a parameter to 1 or 0 which I was kind of hoping it would be, instead you need to have a 'Daylight Saving Time Rule' which I guess is fair enough as different states and countries treat it differently. Also unfortunate was Linksys' decision to not allow daylight savings rules to span more ...

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

Problems with latest SPA942 Firmware (5.1.10)

I've noticed that the spacfg.xml seems to be malformed and it's causing my scripts to break :'( It seems that Linksys have added which presumably due to the fact that it starts with the number 2 is breaking it :( I've posted over on the Linksys boards and hopefully someone will be able to shed some light on it.

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