English

How to find arbitrary data in an Oracle database

Sometimes you've to reverse engineer a database (or an app using a database) and all you've is some piece of data that is used in whatever function(ality) you're looking into. Eg. you see some message/text on a screen of the app and you've to figure out where and how it is used. For this you've to first find the table and the row where that data is stored. Here comes this little PL/SQL procudure handy.

Adblock Plus and the statusbar/add-on bar icon

In Firefox 4 statusbar was replaced with add-on bar which is just another toolbar like eg. the navigation toolbar (which we used to call "the toolbar"). However Adblock Plus still contains support for the old statusbar which might confuse users a bit. Eg. in the ABP preferences documentation both the defaultstatusbaraction and the defaulttoolbaraction preferences are still there.

How to install Oracle Database Express Edition 11g Release 2 (11.2) on Debian Squeeze x86_64

There's a very good howto on installing this particular Oracle RDBMS version on Ubuntu 11.10 here. However Ubuntu is not Debian, there're a few differences. Mostly you've to skip a few steps:

List photos and videos from Picasa Web Albums/Google+ that are over a specified width, height or duration

Google provides free/unlimited storage for both Picasa Web Albums and Google+ users under certain conditions. If you're a Google+ user, you can upload unlimited photos that fit into 2048x2048 pixels and videos not longer than 15 minutes. If you're a Picasa Web Album user without a Google+ registration, you can upload unlimited photos up to 800x800 resolution and videos with a length up to 15 minutes.

How to log (eg. iptables) messages based on message body in a separate file using rsyslogd

In Debian the default /etc/rsyslog.conf includes all *.conf files from /etc/rsyslog.d. The contents of these config files are read by rsyslogd before the default rules, so you easily override any defaults.

Apache SSHD

"Apache SSHD is a 100% pure java library to support the SSH protocols on both the client and server side. This library is based on Apache MINA, a scalable and high performance asynchronous IO library. SSHD does not really aim at being a replacement for the SSH client or SSH server from Unix operating systems, but rather provides support for Java based applications requiring SSH support."

Don't track me Google

Today Google decided to force Google Search users into enabling cookies for *.google.com domains. Previously you could prevent Google from tracking your search results (and still use Google's services) if you blocked cookies for google.com and allowed cookies for various Google services (accounts.google.com, plus.google.com, mail.google.com, etc.). But today Google search click tracking does not work anymore with google.com cookies blocked.

Siebel MTOM Attachments

"This article highlights the importance of MTOM in the enterprise, provides a high level overview of the challenges that I faced bringing the MTOM standard into Siebel. However due to the proprietary nature of the environment, the source code for the implementation cannot be provided, but it is hoped that this article will provide a strategy for system designers/architects out there wishing to achieve the same goal and bring their project forward into the 21st century. (...)"

How to remove all messages from Exim's mail queue


# list messages in the queue
exim -bp
# remove a single message
exim -Mrm 1RsGHp-0008Kz-6P
# remove all messages
exim -bp | exiqgrep -i | xargs exim -Mrm

Syndicate content