Z-Car

Using a Windows XServer to access the Gnome desktop on a Linux Server

By Jimmy March 26, 2010 Other No Comments

Sexy-girl

I wanted to throw a shout-out to a software package called Xming X Server.  I have been using this nifty piece of software to access the Gnome desktop of our corporate Linux servers from the comfort of my Windows based laptop.  Xmind does this my running a XServer under Windows, and using a customized version of Putty to forward all the X packets across a SSH connection.  Even on Internet connection, the performance is very acceptable, and when on a local LAN, it approaches native speed.

A limited version of Xming has been released into the public domain, but throw Mr Colin Harrison £10 and he will send you an unencumbered version.  I am interested to hear from other folks who are using a Windows XServer to connect to a Linux or Mac.

Toyota SDK8

By Jimmy March 26, 2010 Toyota, Toyota SDK8 264 Comments

I have a 1984 Toyota SDK8 that I bought a number of years ago.  It is a great skid loader, but because they are no longer imported into the US, it is a real pain to find any info.  I am going to start posting all of the information I have about it on this page, hopefully some other folks will add any information that they may have.  Right now I am focused on getting the starter turning over reliably, it usually only turns over about once every four or five tries.

My bucket attachment is also all mangled up, I am curious if anyone has replaced their’s with a BobCat Quick Tach attachment plate?

Repair manual which covers the inspection, adjustment and repair procedures for the overhaul of the engine, chassis and materials handling system of the Toyota Skid Steer Loader 2SGK6, 2SDK6, 2SDK7, and 2SDK8.

Fuel Filter Napa 3386

Oil Filter Napa 1521
Hydraulic Napa 51551

Fan Belt Mitsubishi 99523-11 52

Motor for SDK8 is a Toyota 2J diesel. Diesel Forklift truck CPCD80-2,80-2J,TOYOTA 2J ENGIN D B 4CY, 2.5 LTR

Go here to find some mini-skid steers.

Pictures

Toyota SDK8
Not a BobCat
Toyota Bobcat Called SDK8
Toyota Skid Steer Loader
Toyota Bobcat Called SDK8
Toyota Skid Steer Loader

MySQL Foreign Key Night-mare

By Prodromus March 26, 2010 MySQL 1 Comment

redhead girl using computer

I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB structure was very poorly written and caused all sorts of problems when the foreign keys were applied. I had to quickly remove all the foreign keys from about 160 tables.  I can never understand why developers will create foreign keys, however then not write their code properly to prevent errors, or at least attempt to catch those errors.

The code below will quickly create a script that removes all Foreign Keys from a database.  Many folks will simply change the engine type to MyIsam and then back to InnoDB.  This may work, but it is very slow if you already have a lot of data in your tables.

select concat(‘alter table ‘,table_schema,’.’,table_name,’ DROP FOREIGN KEY ‘,constraint_name,’;’) from information_schema.table_constraints
where constraint_type=’FOREIGN KEY’;

You can limit by schema by adding the line : AND table_schema rlike ‘Schema Name’

Remember, Foreign keys are only valid when using Innodb, MyISAM does not support foreign keys.

MySQL – How to drop all Foreign Keys on a table

By Jimmy March 2, 2010 MySQL 4 Comments
Hot Girl Fixing MySQL

MySQL – How to drop all Foreign Keys on a table

I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB structure was very poorly written and caused all sorts of problems when the foreign keys were applied. I had to quickly remove all the foreign keys from about 160 tables. The code below will quickly create a script that removes all Foreign Keys from a database.

select concat(‘alter table ‘,table_schema,’.’,table_name,’ DROP FOREIGN KEY ‘,constraint_name,’;’) from information_schema.table_constraints
where constraint_type=’FOREIGN KEY’;

You can limit by schema by adding the line : AND table_schema rlike ‘Schema Name’

Remember, Foreign keys are only valid when using Innodb, MyISAM does not support foreign keys.

Thanks to Prodromus for providing some of this information.  They have a great site that lists a ton of MySQL tips and tricks.  And, if you are a non-profit, they even perform pro-bono MySQL DBA work.  Look them up.

Lockheed Martin RQ-170 Sentinel – Beast of Kandahar

By Jimmy December 9, 2009 Lockheed Martin, Planes, RQ-170 Sentinel No Comments

rq170_001

The US Air Force today confirmed that it is using a drone named the RQ-170 Sentinel, in Afghanistan. The stealthy unmanned aircraft system is developed by the Lockheed Martin’s Skunk Works division, the same company that developed the F-117 Stealth Fighter. However, the RQ-170 looks like a scaled down version of the B-2 Spirit Stealth Bomber. The USAF confirms that the RQ-170 Sentinel is in development, and is expected “to provide reconnaissance and surveillance support to forward-deployed combat forces”, according to a statement released on 4 December.

This announcement comes after a series of images of a jet-powered, stealthy aircraft have appeared on the internet last April, including a clear shot of the aircraft that circulated widely in early December. Besides describing the RQ-170 as stealthy, the USAF released no further technical information about its new UAV, or any photos. This plane has also been rumored to be called the “Beast of Kandahar”. The main purpose of the drone has been reported to be providing aerial and strategic information to the ground forces battling in Afghanistan. “RQ” represents that the aircraft is unmanned and unarmed, which is different from other drones named with “MQ” which are loaded with laser guided weapons.

The aviation authorities coined the name of the aircraft as “Beast of Kandahar” after its 2007 pictures were released which showed the aircraft in action in Afghanistan. The pictures gave the description of an aircraft that resembles a drone that has the ability to cheat radar and has the shape which resembles that of a stealth aircraft. Several aviation journals have made speculations about this mysterious aircraft and have published its pictures. The presence of “Beast of Kandahar” in the region has questioned why the U.S. is using such technology in a warzone where there are no radar systems available to militants. This has pointed towards the possible us of the drone over Iran and Pakistan. According to reports, the U.S. air force has targeted many terrorists in Pakistan with the help of Predators and Reaper drones.
rq-170-2