Category — work

Heh, check out this error. I upgraded MySQL to version 5 on a server at work then some things (note not everything) decided to stop working when connecting through Perl. After some googling I discovered sweet fa. I decided to check the DBD/mysql.pm files manually and discovered that there were actually two of them! When I installed the new driver it had installed it to a different location than the old one, so it didn’t overwrite it. Some Perl scripts were loading the old one and giving the error below.

table tree connect failed -- install_driver(mysql) failed: DBD::mysql object version 4.004 does not match bootstrap parameter 3.0002 at /usr/local/lib/perl5/5.8.7/i686-linux/DynaLoader.pm line 253.

I removed the old DBD folder and all was well again. No pressure at all considering a large commerce site was down during all of this!

Wow! What a week! On Wednesday, valentines day, I got engaged and on Tuesday I was called with an offer for a new job. I’m going to work for a large company based in the centre of Manchester. I’ll be doing Perl stuff, pretty similar to what I do now, but with more emphasis on development. I’m really looking forward to it.

We have got most of our wedding sorted already. Janet is out trying on dresses as I type. We are getting married at church (where I’m a scout leader) and then having the reception at the Midland in Manchester. If it’s good enough for the labour party conference it’s good enough for us

Okay, so we have a table with columns A B C D in. A B C D each line in the table is unique and D is an integer. I need to find all the unique permutations of A B C with the minimum value of D. Not too hard you might think, a simple multiple group by and a MIN function. Only problem is that the table is actually 25+ columns, with 25 million rows. The simple multiple group by, now takes days to run….

I want to cry…

Anyone with any ideas please comment!!

Here my raw… I’m aware i’ve commented on this previously, but OpenPBX is not ready for mass consumption. I’ve now been in work 7 days straight thanks to the delightful phone system, and it’s still at my house! As far I can tell it’s massively unstable. It’s crashed a number of times doing nothing more complicated than making a call! Transfering calls seems to be totally impossible over SIP.

Â

I’ve spent a good chunk of today playing with OpenPBX, which is a fork of the Asterisk project. As far as I understand OpenPBX is aiming to be truly open source to make it more stable than Asterisk, which has some non open source codecs included, thus hopefully making it more stable. Well let me tell you now, it’s very stable for me…. stable in a non working state that is! Don’t get me wrong, I think it’s going to be great once I manage to get it working. The problem lies with the Digium card we bought. Digium support proved to be truly useless. I called them up, and seemed I knew more about the product than they did, and as I wasn’t using Asterisk, they offered me very little support and certainly wouldn’t take a look at our server.Â

Not perturbed I managed to compile the drivers manually after a while and it reports its up and running. However, now OpenPBX now fails to load, it reports an error initializing chan_misdn, returns -1. So now I’m in the middle of going through all the source code to trace the problem. Nightmare!

 On another note, I’ve just put a couple more photos of the garden up.

It’s true Cisco phones are officially evil. I’ve been through several hundread different methods to configure many supposedly identical phones, yet every time they require a different method of configuration to actually get a SIP image to load on them. They just don’t seem to want to play the game!

Anyway, back at work on a lovely Monday. Ain’t milk brilliant?