Skip to content

The Rogue DBA Mystery Cache

This cache has been archived.

bassocantor: oh well Snapshot too old

More
Hidden : 8/20/2012
Difficulty:
3 out of 5
Terrain:
2 out of 5

Size: Size:   small (small)

Join now to view geocache location details. It's free!

Watch

How Geocaching Works

Please note Use of geocaching.com services is subject to the terms and conditions in our disclaimer.

Geocache Description:

A ROGUE DBA IS SENDING INSULTS TO THE USERS. YOU MUST STOP THIS RENEGADE BY SOLVING THE PUZZLE BELOW.


The cache is NOT at the posted coordinates.  You must first solve the puzzle.


A rogue database administrator has rigged up some nasty SQL. This code will soon activate, and send an insulting message to users. Your job is to figure out the message so that you can warn the users.  

You have these clues:

  • You have the message data, but it is encrypted using a famous visionary, tech titan's name as the encryption key. (This bearded titan will be at Oracle OpenWorld.)

     
    Here is the encrypted message:   DNRGQLZEBGCBWDJVCCLNPMACD
     
    The cache is at the location below-- derived from the last word of the secret message.

    N37 42.ABC  W121 53.DEF

    A = Number of letters in last word minus 6
    B = A
    C = First letter of last word plus 6
    D = First letter of last word
    E = Fourth letter of last word minus 5
    F = Second letter of last word minus 3


    This function may be used to decrypt the message  decrypt

     "Alert: You are about to download a file that contains further details needed to find this geocache. As the cache owner, I represent that this file is safe to download although it has not been checked by Groundspeak or by the reviewer for possible malicious content. Download this file at your own risk. “
     

    Good Luck!

     



    CONGRATS FOR FTF TO Team Yofa!

Additional Hints (Decrypt)

Chmmyr: Ur jbhyq or fb cebhq bs lbh! Purpxfhz bs gur 6 haxabja ahzoref = 25

Decryption Key

A|B|C|D|E|F|G|H|I|J|K|L|M
-------------------------
N|O|P|Q|R|S|T|U|V|W|X|Y|Z

(letter above equals below, and vice versa)