Why a Hoosier Never Gets to Complain About Property Taxes

Information sourced from Zillow.com.

A random house in Terre Haute, IN:

Tax History 

Year	Property taxes	Change	Tax assessment	Change
2010	$339	-15.3%	$88,100	-5.3%
2009	$400	4.0%	$93,000	1.1%
2007	$385	-36.3%	$92,000	19.2%

A random house in Cincinnati, OH during the same time period:

Tax History 

Year	Property taxes	Change	Tax assessment	Change
2010	$1,944	3.8%	$32,860	--
2009	$1,873	1.8%	$32,860	--
2008	$1,839	17.5%	$32,860	2.6%

But remember, Cincinnati is ranked by conservative sources as the #1 place to do business among large US metropolitan areas, with the ninth best tax environment for new business and the seventh best tax environment for established businesses.

Reset an unknown MP2 superuser password

The built in administrator account for MP2 is SUPERUSER. There is no default password on the SUPERUSER account, but if someone set one and you don't know it:

To access your MP2 using the SUPERUSER account, have the SQL Administrator run the following script on the MP2 database:

UPDATE MP2USER SET KEYWORD = '3MMM' WHERE USERID = 'SUPERUSER'

This will set the password to 111, which was also the default password out of the box.

6.0 and prior supports Oracle. If you're using Oracle the statement may require a ; after the statement and possibly a COMMIT; statement as well. Other than that, the SQL syntax and table names are the same.

Missing a SUPERUSER account? It's possible it's been renamed. Run the following to determine which accounts have similar permissions:

SELECT * FROM USERSITE WHERE ROLETYPE = 'S' AND ROLENAME = 'System Administrator';

Passwords in Nagios XI Monitoring Wizards

The time may come when you may need to change the password for a host you setup in Nagios XI via a monitoring wizard. There is no way to do this via the web interface. Login to the XI server via ssh and browse to /usr/local/nagiosxi/etc/components/(WIZARD_NAME)/ and the username/password will be in a text file prefixed with the hostname.

Unconfigured Named MSSQL Instance

If your installation errors out half way through, you may wind up with an unconfigured named instance. Short of uninstalling all of Microsoft SQL, you'll have to manually remove the instance in order to re-use the name.

Use regedit to find the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server


Under Instance Names\SQL, delete the value corresponding to your unconfigured instance. Now look for the corresponding MSSQLxx_xx.InstanceName key and delete it.

You will also want to delete the corresponding instance folder, the default path would be C:\Program Files\Microsoft SQL Server\MSSQLxx_xx.InstanceName.

Rooting the Coby Kyros

This was tested with the MID7022. This newer version of the Kyros comes with Android 2.3 and APK Installer pre-installed. If you have a different MID version, stop at step 7 and refer to CyanogenMod site for correct ClockworkMod image file. I'm using Windows 7 for the following:

1. Install Android SDK per CyanogenMod instructions.
2. Replace the contents of C:\android-sdk-windows\extras\google\usb_driver with the Telechips, Inc adb driver.
3. Connect your phone to your computer via USB, put your phone in USB debugging mode and do not mount SD card to your computer.
4. Install SuperOneClick and click Root.
5. Once complete, remount Nand and then SD card in Settings.
6. Make a backup of your current recovery image:
1. Download dump-recovery-signed.zip and save as update.zip on your SD card.
2. Turn off USB storage and go to Settings-About device-System Updates-Install system update. Choose from SD card.
3. The stock recovery will automatically be dumped as dumped_recovery.img and /proc/mtd will be copied as dumped_proc_mtd.txt on root of SD card. Keep them in safe place.
7. Install ROM Manager (ClockworkMod) from AppsLib. "Flash ClockworkMod Recovery" option does not yet work for Telechips, so we'll flash it manually:
1. Download KYROS7022-8K-recovery-signed.zip and save as update.zip on your SD card. Do the same thing as you did in step 6 to install.
2. Open ROM Manager and choose Reboot into Recovery. Allow the superuser request. To navigate the recovery screen:  MENU- = next(down), HOME/POWER = select, BACK = back
3. Go to Backup and Restore - Backup. This will create a backup of your entire system image onto your SD card. When it's complete choose Reboot system now.
8. Because CyanogenMod doesn't yet support a bunch of features (including the Kyros' strange software-based volume up/down control), I'm keeping the (rooted) stock image but I'd rather have Google Market. Here's how to install it:
1. Download Market.rar. Extract the contents of the Market folder to your SD card.
2. Remount your SD card to your tablet, open APK Installer and install in the following order:
1. OneTimeInitializer.apk (the one with the blank name)
2. SetupWizard.apk
3. GoogleServicesFramework.apk
4. Vending.apk (name shows as Market)
3. Turn your tablet off and turn it on again.
4. Next time you press the home button, a window saying “Complete action using” will appear, mark “Use by default” and choose the “Launcher”. Also, the camera shortcut on your home screen will stop working, all you have to do is delete it and re-add it.

Once you have Market on there, you'll find some things still missing. Here's a link to the latest Netflix app (1.5.2 as of 12/25/2011), Adobe Flash (10.3.186.3  as of 12/25/2011) and Pandora.