Archive for the ‘Technology’ Category

Playing with gl_fusion

Sunday, June 22nd, 2008

I have been using geeklog on a number of websites. Geeklog just released 1.5.0 which enabled openid support and a few other things, but gl Labs just released a drop in replacement for geeklog call glfusion. Unfortunately it wasn’t a drop in replacement for me, not because of GL Labs, but because of Geeklog’s dumb ass way of implementing paths in their new database based configuration settings. I tend to move the paths around when upgrading so I don’t completely bork a site in the process. So after installing glfusion in the glfusion-1.0.0 directory, nothing worked, I just got a message saying “Unfortunately, an error has occurred rendering this page”. So I hacked the error handler to give me something something more useful to point me in the right direction. I then had to manually update the conf values in the database, this brings me to dumb assessed part of the implementation, look at this row


| path_language | s:41:"/www/eduni-dc.org/geeklog-1.5.0/language/"; | text | Core | s:0:""; | 0 | -1 | 100 | 3 |

That s:41 actually means string of length 41. Took me a little while to work that one out. Come on guys have you never head of strlen()? Next why the F…. does this all have to be in one column, if you really need to know that something is a string of 41 characters then put them in a different columns.

So now I have got my rant out of the way, glFusion has some cool stuff it it. It comes with a number of plugins built in and ready to go. It also has mooTools built in to the nouveau theme. See my test page for some of the extra formatting fluff you get

I am most impressed that glLabs is watching the bug tracker for geeklog and has already applied a patch I submitted to geeklog before geeklog has even confirmed it as a bug. So one less thing I need to patch when upgrading my geeklog sites.

If you want to see my first glFusion site go to www.eduni-dc.org

The disadvantage of going electronic for you bills and statements

Monday, June 16th, 2008

Today I needed to pull up the last pay slip from my old company. The company in question doesn’t offer the benefit of mailing out payslips, only the ability to view them online. For some dumb reason, like maybe the possibility that you might have to document your pay and contributions to the IRS I figured that i would have access to these records for a reasonable period of time say 2-5 years, but today a few months after leaving the company I get this message…..

Fortunately after my years of dealing with the USCIS I decided to print a copy of my pay slips so I am 99% sure I have the payslip I need at home.

I also noticed a similar thing when I closed a credit card, all of a suddenly you loose access to the online records, the same thing also happened when I closed a bank account.

This whole save the environment go to e-statements and e-bills is just an excuse for the company in question to save on printing and mailing costs. If they really wanted to save the environment they would allow you to access the records for 5 years after closing the account, that way you don’t have to print at your own expense copies of the statements.

So make sure you have copies of all your bank statements, bills, pay slips before you terminate your relationship with a company because you are more than likely going to be loosing access to the online versions of those documents as well.

Fileserver has a new home

Saturday, June 7th, 2008

I bought a Coolmaster case a few months back from the CompUSA liquidation sale, I didn’t really need it but it was a good price at the time. It sat in the garage till I had time and a reason to do something with it. Last week I bought a cpu/motherboard/memory combination at Microcenter with the thought that I could put it in the case. When I bought the computer guts I wasn’t quite sure what I was going to do with them. Then last week I officially ran out of disk space on the file server. So that was it, I found a purpose for all my new toys. I got Best Buy to price match a western digital 500 GB hard drive and I spent this morning putting it all together. I transfered all the drives from the old file server and added the new 500 gig.

So now I have
AMD 64 dual core X2 4800+
2 Gigs of ram
1 x 320 Western Digital pata drive
2 x 320 Western Digital sata drives
1 x 500 Western Digital sata drive
1 x 500 Seagate sata drive
1 x 500 Western Digital Green sata drive

The first 320 is the OS drive, scratch space, and backup.
The two 320 sata drives are a mirrored pair for personal files and src and mail
the three 500’s are going to be raid 5 and be used for media storage

Radio Head Nude remix

Friday, June 6th, 2008

This is freakishly good, specially if you remember loading games from tape on a sinclair spectrum 48K

IP to Numeric

Friday, June 6th, 2008

To followup on my previous post about doing ip to numeric address conversions. It turns out that the sql functions I linked to didn’t quite work, they were written with the assumption that you were storing the data as an INT rather than a BIGINT, so for values over 127.0.0.1 it would store the number as a negative number in the database. My source data uses bigint so I got errors back when feeding in data that overflowed the int.

If you are interested I have included the edited functions after the link

(more…)

MS SQL numeric to ip

Thursday, June 5th, 2008

I love the fact that I know SQL and can go against the database directly instead of having to accept someone elses preconceived ideas of what kind of data I need.

I needed to find out all hits in a database from a specific range of IP addresses range. the table stores the IP’s in a numeric form which is a no brainer on mysql you just use inet_ntoa and inet_atoa to convert back and forward, but Microsoft SQL Server (mssql) doesn’t support that so a little googling later I came up with this page, which has some stored procedures for doing the convertion, now I am just waiting for the database to come back with the data. SWEET

New Laptop

Wednesday, June 4th, 2008

So HY was kind enough to bring my new laptop home with her yesterday. After the initial unboxing and savoring that new computer smell I plugged it in. I decided to transfer all my files from my old 12 inch Powerbook since it was rebuilt a few months back and the machine will become a ‘public’ computer for anyone who needs it at the house. After waiting and cursing apple for lying about how long it would take all my files and settings were transferred over. From a normal user experience this is great since it gets you up and running very quickly and everything is set up exactly as you are used to….. but….. I am feel I am missing the ritual that you get when you defile a fresh install of an OS by tweaking, install and customizing till you happy with it.

For a mac my standard install list would be
Firefox (get the beta of V3)
Quicksilver
Adium
Microsoft RDC client (get the new beta version)
Chicken of VNC
Dev Tools
Darwin Ports
For intel macs I would also add vmware fusion (need to try out virtual box)

Vuln in ClamAV

Monday, April 14th, 2008

I should do some more reading on this, but I am amused by the US Cert comment at the end

ClamAV PE Scanning Vulnerability
added April 14, 2008 at 09:21 am

US-CERT is aware of a report of a buffer overflow vulnerability affecting ClamAV. This heap-based buffer overflow vulnerablity may allow an attacker to execute arbitrary code on an affected system.

US-CERT recommends that users do not scan PE files from untrusted sources.

Isn’t the hole point of running an av product to test for viruses in untrusted files?

Geek Christmas

Monday, January 7th, 2008

Since I had some time off over Christmas and we didn’t have any major plans so I decided to tackle some outstanding IT project in the house.

The first thing was to clean out all the computer that used to live close to the litter box in HY’s old appartment. That was the most icky of the projects, vacuuming out the layer of the cat litter dust, stripping out all the drives, and wiping down everything. I also needed to wipe down all the stuff I dumped in the basement after moving for similar reasons.

I ran nine cat 5 cables, 2 to the TV in basement, 2 to the TV in living room and 4 to basement room with all the computers and one to the phone demark. I still need to find out if I can easily pull some cables up into the attic and over to HY’s office.

I rebuilt the asterisk server with PBX in a flash and hooked the Sipura 2002 into the house telephone lines so we can use normal cordless phones for making calls. I also signed up for axvoice to get 200 minutes of US/Canada minutes. The international rates also appear to be good.

I also needed to centralize all my mp3/acc files on one computer, over the years the files have spead out over a number of computers. I also borked my raid array on the file server a couple years back and had a lot of MP3’s that didn’t play all the way through. So I wrote a script that copies all the mp3 from my laptop to the file sever. If it was already on the fileserver then it would over write the file, if it didn’t then it added the song to a ‘new’ folder. After after a month or so and a couple iterations fixing dumb things like ; and ‘ in the song names I had all the files in one location which are being sharing out via iTunes on the mac mini.

I also backed up all my files on my laptop and installed Leopard (macos 10.5). Apple makes it really hard to accidentally wipe your computer so took me few goes to work out how to do a full wipe. The first time I missed the small “options button” in the install that gives you the non idiot upgrader. The second time i selected to do a fresh install, but preserve user applications and files in a separate folder option. I didn’t realize it was going to copy in all saved files and applications back into the normal folders after installing. So the third time I did the nuke and destroy option to wipe the computer then install. After all that I now have a fresh install with just the applications I want. It runs nice and fast now.

I am really like 10.5, the time machine option is nice and easy for backing up the computer. The Screen Sharing App is the best way to remotely control another Mac, very very fast compared to Chicken of VNC or Vine. I had some issues with X11 doing control click for pasting till I found the developers site where I could install an unofficial update. I am not impressed with the new version of Front Row. Apple synced Front Row to match the version that comes with the AppleTV’s. It seems slower especially when viewing media on another mac. They also removed the extra level between selecting a TV Season and the episodes so you it now goes straight from TV Show to all the episodes. This sucks if you have 4 or 5 seasons of a show and only want to watch season 3.

The final thing on my geek list was to upgrade the file server to something less ancient than Suse 9.3. Ubuntu has been my Linux distro of choice for over a year now, but it doesn’t have a nice gui for setting up LVM and RAID partitions so I wanted to see what open suse 10.3 was like. I tried out the live cd on another computer and wasn’t hugely impressed with the newer version of KDE. I didn’t like the equivalent of the start menu, the final decision was made when I couldn’t get the live cd to boot on file server, so ubuntu it was. After installing I had some issues with the raid drives. I wasted most of Sunday trying different things, but both raid arrays are now online and keep working even after rebooting. I had a number of issues, first the partitions on two of the disks wouldn’t show up in /dev till I removed the entry in /etc/blckid.tab. I then had to build the raid mirror with just one drive, then wipe the super block on the other drive, reboot, then add the second drive back in. The only thing I can think of is that the drive had the superblock in both the /dev/sdd and /dev/sdd1 which was confusing it.

I still have to install vmware server, setup samba and some other junk on the file server but nfs is up and running and the macmini can see all the media.

Oh and I got a Garmin GPS Bike computer from Hongying that allows my to track my heart rate and the path I took.

So thats my Christmas geek fest.

What did everyone else do?

Postman Pat

Sunday, January 6th, 2008

I called in to cancel my series 1 tivo which I have had since sept 2000 and they offered me an HD tivo for $200. I ended up getting it since it it will let me transfer shows back and forward between the HD Tivo and the Series 3 I already have. I got it a couple days ago and I finally got everything set up so I can transfer shows between them and now I am watching Postman Pat which was recorded on the tivo HD in the basement and then transfered to the Series 3 in family room.

I can’t believe it they have changed the theme song, and Postman Pat now has kids, they even have cultural diversity now with an Indian family. HY is looking at me strangely………