Watch TV does not work - ERROR when trying to delete file

Just want to share..I noticed in one of my Mythtv box, I can not watch TV and mythtvbackend log shows following error.

ERROR when trying to delete file: myth://127.0.0.1:6543/1031_20090308215852.mpg

This error indicates that the metadata in the database exists for a non-existing recording. Well, the solution is to remove the data. There is a cool perl script myth.find_orphans.pl that can fix this problem for you. I use MythDora so for me, this file is /usr/share/doc/mythtv-docs-0.21/contrib/ location.

Try it if have similar issue.

-Vigyan

How to enable error reporting in PHP?

You can turn it on in the by including following in the file.

error_reporting(E_ALL);

Vigyan

How to Flush DNS Cache in Mac OSX 10.5 Leopard?

It is easy. Just type following command from your terminal.

dscacheutil -flushcache

-Vigyan

Software to Burn CD/DVD for Mac

I miss my favorite software Nero to burn CD/DVD but no worries, I found another cool software that works pretty well.

Here is what I found.

http://burn-osx.sourceforge.net/

It is very easy.

-VK

What works better on MAC?

Here are the applications that I found useful and works great for me on MAC.

Instant Messanging Client:  Adium  - http://www.adiumx.com/

Office: OpenOffice -  http://www.openoffice.org/

Image Manipulation Tool: GIMP - http://www.gimp.org/

SFTP Client: Fugu - http://rsug.itd.umich.edu/software/fugu/

SSH: iSSH - http://www.macserve.org.uk/projects/issh/ ( I use this for SSH tunnel)

Remote Desktop: Remote Desktop Mac - http://www.microsoft.com/mac/products/remote-desktop/default.mspx

Hope this apps list help you as well.

-VK

How to Install Oracle Database Client in MAC

Well, it is intersting getting familer with new tools that you have for Mac. The very first tool, I need to perform my job is the Oracle DB Client. The latest, version I could find for Mac is 10.1.0.3.

It is very easy to install Oracle client on Mac. Just download software from Oracle website http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/macsoft.html and unpack it in the directory where you want to have your ORACLE_HOME.

Oracle Database 10g Client Release 1 (10.1.0.3) for Apple Mac OS X

    ship_mac_client.cpio.gz (344,013,902 bytes) (cksum - 3052329470)

Now, set the env in the .bash_profile and you are good to go.

ORACLE_HOME=/Users/vkaushik/Library/Oracle/10103/client/ohome; export ORACLE_HOME
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib; export DYLD_LIBRARY_PATH
JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Home; export JAVA_HOME
PATH=$PATH:$ORACLE_HOME/bin; export PATH

Run the sqlplus.

-VK

My New Mac

Last month, I got my first MacBook Pro. I heard a lot about Mac but never had one. Man, I really like it.  I use keyboard shortcuts a lot and first few days my life was measurable as I could’t use all those techniques on my Apple keyboard.

Here is a link that give you a good mapping of PC vs Apple keyboard.

http://support.apple.com/kb/HT1167

I will be posting more on my Mac as I lean.

Thanks,
VK

Free - Oracle Database Performance Analyzer

I always think that there could be an easier method to parse AWR and Statspack report. Well, AWR report is in HTML format and easier to read then the txt output. In order to get the ifnromation that I am more interested in, I have written a parsor progran to parse the txt output from Statspack and AWR. I am sure this is not the perfact output a start to summarize the result.

If you may find bug in the tool as I have testing it against only few sample output of Statspack and AWR. Please let me know how I can improve this tool.

The URL for the tool is http://www.dbapool.com/analyzer/

-VK