Citrix Netscaler Custom Log Format

This is an example log format for citrix netscaler:

logFormat Custom %h %l %u [%t] "%r" %s %B "%{Referer}i" "%{User-agent}i"

Alexa is The Global Leader in Analytics

In-depth coverage for over 125 countries.

Over 6.000.000 people visit alexa each moth.

Millions of toolbar users worldwide.

http://www.alexa.com

Oracle Analytic Functions

AVG(expression) : Returns average value of expression

CORR(expression1, expression2) : Returns the coefficient of correlation of a set of number pairs

COVAR_POP(expression1, expression2) : Returns the population covariance of a set of number pairs

COVAR_SAMP(expression1, expression2) : Returns the sample covariance of a set of number pairs

COUNT(expression) : Returns the number of rows returned by the query

Oracle Aggregate Functions

COUNT(*) : Returns the number of rows returned by the query.

MAX(expression) : Returns maximum value of expression.

MEDIAN(expression) : Returns the middle value or an interpolated value that would be the middle value once the values are sorted.

MIN(expression) : Returns minimum value of expression.

STDDEV(expression) : Returns the sample standard deviation of expression, a set of numbers.

SUM(expression) : Returns the sum of values of expression.

VARIANCE(expression) : Returns the variance of expression.

Using dig tool on windows

dig is one of the finest dns tools for unix and linux admins. ISC (Internet Systems Consortium) provides windows binary for the dig tool. In order to use it from windows machine, download bind zip file from http://www.isc.org downloads site. Then extract following files to your local folder that is already in your %PATH% environment variable or create a folder in the program files folder and add it to the %PATH% environment variable so you can use it from command line without writing the full path.

Google Cloud SQL

If you are in the IT business you probably know about the Cloud services. Google has Cloud services as well. Nowadays Google introduces a new six month trial at no charge until June 1, 2013. You can sign up here and start experiencing Cloud SQL.

ORA-39083 and ORA-02298

ORA-39083: Object type REF_CONSTRAINT failed to create with error:

ORA-02298: cannot validate <constraint_name> - parent keys not found

Failing sql is:

ALTER TABLE <detail_table_name> ADD CONSTRAINT <constraint_name> FOREIGN KEY <detail_table_column_name> REFERENCES <master_table_name> <master_table_column_name> ENABLE

Kinit failed

winbindd[2753] libsmb/cliconnect.c:1052(cli_session_setup_spnego)
Kinit failed: Clock skew too great

if you encounter this message and can not login via ssh using AD account. This is most probably because server's date and time are not set correctly.

Bash script for joining redhat linux computer to windows domain

#!/bin/bash

s1=$(cat /etc/redhat-release)
s2="release"
pos1=$(awk -v a="$s1" -v b="$s2" 'BEGIN{print index(a,b)}')
pos=$((pos1+7))
redhat_version=${s1:$pos:1}

Jboss installation script for Redhat Enterprise linux

First, prepare following files under the Jboss installation folder. Jboss AS zip packages are availeble at http://www.jboss.org/jbossas/downloads/ and java jdk packages are available at http://www.oracle.com/technetwork/java/javase/downloads/ 

jboss-4.2.2.GA.zip
jboss-4.2.3.GA.zip
jboss-as-7.1.1.Final.zip
jdk-6u37-linux-i586-rpm.bin
jdk-6u37-linux-x64-rpm.bin
jboss-as.conf
jboss-as-standalone.sh
jboss-install.sh

Tuning and slimming JbossAS 4

This is a quite good document for tuning and slimming JbossAS 4. Remove unneeded services and slim jboss installation.

https://community.jboss.org/wiki/JBossASTuningSliming

Redhat linux network configuration script

#!/bin/sh
time_stamp=$(date +%d_%m_%Y-%H_%M_%S)

JUDCon India 2013

JUDCon India is Back - Bigger and Even Better!

JUDCon, the premier developer event "By Developers, For Developers" is happening again from January 17-18 2013 in Bangalore.

The first JUDCon India held early this year was a huge success, and is still the world’s biggest JUDCon to-date. More than 800 attended to hear from the best and brightest developers, and to exchange ideas on JBoss technology, and JUDCon2013:India is going to be even bigger and better!

The JUDCon call for papers is open now through Nov 23, and session tracks will include:

App Servers and App Development
Cloud, NoSQL and Big Data
Rules, Workflow, SOA and EAI
Cool Stuff (that we just can't leave out)


JUDCon2013:India Call for Papers