what i've done

Installing Apache in Amazon web Service (AWS)

2012-02-15T04:41:00.005+05:30

I'm installing apache in Amazon Web Service. I have already created an amazon linux EC2 micro instance.

Connect using ssh client with yourKey.pem file.
Default user is ec2-user to your-public-dns

# ssh -i yourKey.pem ec2-user@your-public-dns

Install using yum install

# yum install httpd.x86_64

If the installation is successful, your web root will be created in

# cd /var/www/html

Remove libraries from startup

2011-11-07T07:31:00.002+05:30

= Open Registry Editor(start->regedit.exe)
= Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon
= Update the "Userinit" entry
= Change the value data to C:\Windows\system32\userinit.exe
= Restart the computer

reCAPTCHA

2010-12-24T00:05:00.004+05:30

Linux in VMware

2010-11-24T23:25:00.002+05:30

Just remembered a better way of scripting in Linux when you are using windows. Usually I work on VMware alone and switching windows was difficult.

1) Download putty (SSH client)
2) Open VMware and start linux box
2) Test SSH connection to the Linux running in VMware
3) In 'Edit->preferences' make sure the option to "run virtual machine after workstation closes" is checked.
4) Close VMware (machine will be running in the background)
5) Putty terminal will be able to communicate with Virtual Machine

Enjoy

How to add system call in Linux Kernel 2.4.X

2010-11-24T16:11:00.001+05:30

First, search for the include file: "/usr/src/linux/include/asm/unistd.h" and add the following:

#define __NR_test 259

under the line

#define __NR_set_tid_address 258

After that, search for the source file: "/usr/src/linux/kernel/sys.c" and add a function as following:

asmlinkage int sys_test(int a)

{

return a*2;

}

.Note that this function is just a test, and it will return twice of the input value (int a). Now, it comes to a difficult step, goto a source file: "/usr/src/linux/arch/i386/kernel/entry.S". Search for the last few lines, it should be like this:

.long SYMBOL_NAME(sys_lookup_dcookie)

.long SYMBOL_NAME(sys_ni_syscall)

.long SYMBOL_NAME(sys_ni_syscall) /* 255 sys_epoll_ctl */

.long SYMBOL_NAME(sys_ni_syscall) /* sys_epoll_wait */

.long SYMBOL_NAME(sys_ni_syscall) /* sys_remap_file_pages */

.long SYMBOL_NAME(sys_set_tid_address)

.rept NR_syscalls-(.-sys_call_table)/4

.long SYMBOL_NAME(sys_ni_syscall)

.endr

You should change the code to:

.long SYMBOL_NAME(sys_lookup_dcookie)

.long SYMBOL_NAME(sys_ni_syscall)

.long SYMBOL_NAME(sys_ni_syscall) /* 255 sys_epoll_ctl */

.long SYMBOL_NAME(sys_ni_syscall) /* sys_epoll_wait */

.long SYMBOL_NAME(sys_ni_syscall) /* sys_remap_file_pages */

.long SYMBOL_NAME(sys_set_tid_address)

.long SYMBOL_NAME(sys_test)

.rept NR_syscalls-(.-sys_call_table)/4

.long SYMBOL_NAME(sys_ni_syscall)

.endr

Another thing need to note is the last few lines, it defines the remaining

space for the system call symbol table. "NR_syscalls" is the

maximum system call.

.rept NR_syscalls-(.-sys_call_table)/4

.long SYMBOL_NAME(sys_ni_syscall)

.endr

OK, all the modification has been done. The next step is to recompile the kernel.

Follow the step in the note in here

After the compilation of kernel, you can use the following code to build a user-level process, which make use of the new system call:

* use_syscall.c

#include <>

static inline _syscall1(int, test, int, a)

void main()

{

printf("Return value: %d\n", test(5));

}

IMPORTANT: you will experience a series compiling error in this stage. It is because Rehat has done some nasty things:

"#include <>" means to include the file "/usr/include/linux/unistd.h".

The "/usr/include/linux/unistd.h", on the other hand, includes another file "/usr/include/asm/unistd.h".

However, in Redhat, "/usr/src/linux/include/asm/unistd.h" != "/usr/include/linux/asm/unistd.h".

Again, we use symbolic link to remedy this problem.

mv /usr/include/asm /usr/include/asm.old

ln -s /usr/src/linux/include/asm /usr/include/asm

Bom Sabado in orkut scrap

2010-09-25T15:22:00.003+05:30

An automated script is sending message from your browser.
Close Browser; clear cache and cookies.

If you visit an infected profile your account is also compromised.

Stay disconnected from Orkut until problem is solved

Clear cache and don't use "remember me" option for a little while in your browser

To be safe change your password and secret question immediately.

The Bom Sabado worm flooding scrapbooks and also it seems to be adding affected Orkuteers to new Orkut groups. Orkut Officials and Security Professionals advised users not to Log in Orkut until they clean the Worm

check forums for update

Linking Images in mod_newsflash

2010-08-07T14:44:00.003+05:30

Making the images in introtext of Joomla articles when displayed through newsflash module in Joomla

find the following code in helper.php on mod_newsflash:

if (!$params->get('image')) {
$item->text = preg_replace( '/]*>/', '', $item->text );
}

and append the following code:

/*******Custom********/
else{
$intro=$item->text;
$link=$item->linkOn;
$intro = str_replace("
$pos = strpos($intro, "/>");
$intro=substr_replace($intro, "/>", $pos,2);

$item->text=$intro;
}
/******Custom End*******/

Back to Opensource

2010-02-11T02:29:00.003+05:30

i'm back.
Started with a project in Joomla.

Find size of oracle table

2009-10-21T00:50:00.002+05:30

Find size of oracle table:

SELECT
owner, segment_name OBJECT, partition_name, TABLESPACE_NAME , segment_type AS TIPO,
BYTES "size_in_byTES", ROUND (BYTES / 1024, 2) "size_in_kb",
ROUND (BYTES / 1024 / 1024, 2) "size_in_Mb",
ROUND (BYTES / 1024 / 1024 / 1024, 2) "size_in_Gb"
FROM sys.dba_segments
WHERE segment_type IN ('TABLE', 'TABLE PARTITION')
AND owner = 'ownername'
AND segment_name = 'tablename'

Hot cup of tea with html and css

2009-07-28T01:29:00.002+05:30

I woke up by 11:00 and felt like doing something interesting. It was raining and i was not in a mood to go for an outing(as usual)
I thought of making a demo website. So here it is --
Create your own website 100% free of cost
1)Google free css templates
2)Download one that suits you need
3)Edit the html page using dreamweaver or whichever IDE you like
4)Create copies and name them to match your sitemap
5)Upload it in some freehosting(www.zymic.com) and register for some free domain(co.cc or us.to)
6)If you are good in server side scripting, rename the html file to php(that's what i did) or some other script file and add the script for your logic, or do some crazy stuff
7)That's it ;)

btw nandy's AOE game interrupted my website development.. so i haven't completed it ;}

End of discoverer

2009-07-28T01:21:00.002+05:30

I guess it's time to start with informatica. I've been working on discoverer for the past three months, now the etl side is having more issues than the report generation. So finally i've been asked to work in informatica.. I'm fine with anything, only issue is that, i miss the good old programming days. So if i'm staying in this project for a while you can see some interesting etl posts.

Hiding the navbar

2009-05-24T20:36:00.000+05:30

It's against blogger policy to remove the navigation bar as long as you publish blog in blogspot.com
If you are planning to publish your blog in your own domain, here's the code to remove blogger navigation bar

#code------------------------------------
/*-- (Hiding the navbar) --*/

#navbar-iframe {

height:0px;

visibility:hidden;

display:none

}

#-------------------------------------------------

If you do it repeatedly use scripting

2009-05-24T20:34:00.000+05:30

In most of the support jobs you have to do a set particular set of jobs repeatedly
in this case it's always best to automate the work by using scripting.
for example i got to do monitoring job in autosys(something similar to cron), to check the status of a list of jobs(140+)
confirm that all jobs are in On Ice(OI) state.
Unlike my college server, i had write permission in the server and had access to most of the commands.
so i created a checkjob.sh and i had joblist.txt which contains name of all jobs.

which contains:

#code-----------------------
while read line
do
autorep -w -j $line>>output.txt
done < joblist.txt
#------------------------------

the output was redirected and appended to output.txt which can be attached with the documentation of my work. happy day :)

Oracle DISCOVERER

2009-05-24T20:28:00.000+05:30

There are several components for discoverer.But I used only two components.
Discoverer Desktop and Discoverer administrator.
Desktop is for generating reports from the EUL(End User Layer) data
Administrator is for managing EUL data.

So if i tell the story in brief:
We have so many tables in our database, but these tables cannot be used directly by end user.
These tables belong to several applications (ERP, CRM or any other).
Using Discoverer Administrator we create EUL data, which is a meaningful collection of views from different tables
And the end users can use Discoverer Desktop to generate reports.
By the way .. these reports can be analysed to plan business(Business Intelligence)

Java Oracle example

2009-01-23T02:15:00.002+05:30

Steps in getting a connection and retrieving data.

1) Load JDBc driver

In order to connect to a database, you need to perform some initialization first.

Your JDBC driver has to be loaded by the Java Virtual Machine classloader,

and your application needs to check to see that the driver was successfully loaded.

2) Create a connection to the database

To connect to the database, we create a string representation of the database.

3) Using connection object to create statement and querry the database

In JDBC, we use a statement object to execute queries. A statement object is responsible

for sending the SQL statement, and returning a set of results, if needed, from the query.

Statement objects support two main types of statements - an update statement that is normally

used for operations which don't generate a response, and a query statement that returns data.

4) Close connection

Commit changes and close connection object

Connection connection = null;
try {
// Load the JDBC driver
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);

// Create a connection to the database
String serverName = "127.0.0.1";
String portNumber = "1521";
String sid = "mydatabase";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "username";
String password = "password";
connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
// Could not find the database driver
} catch (SQLException e) {
// Could not connect to the database
}

//Use connection object to create a statement

Statement statement = connection.createStatement();

//executeUpadate examples

statement.executeUpdate ("create table employee ( id int, name varchar(50))");

statement.executeUpdate ("insert into employee values (1, 'John Doe');");

connection.commit();

//executeQuerry examples

ResultSet result = db_statement.executeQuery ("select * from employee");

//do processing on result retrieved

while (result.next() )
{
// Use the getInt method to obtain emp. id
System.out.println ("ID : " + result.getInt("id"));

// Use the getString method to obtain emp. name
System.out.println ("Name : " + result.getString("name"));
System.out.println ();
}

// close connection

connection.close();

Sorry about Scheme

2009-01-23T02:01:00.004+05:30

I would like to continue my posts in scheme, but right now i cannot find time for that since i'm stuck with java/J2EE. Mail me any queries regarding scheme, i'll find a solution for your queries and will be posted.

Scheme o scheme

2008-12-03T17:27:00.003+05:30

recently i learned programming in scheme.
It's a multi paradigm programming language and apparently a good one for logic building.
To learn basics of programming, scheme is the right choice.
(Recommended for students under 18)
flawless implementation of programming concepts (procedural and OO).

about scheme: derived from LISP, different from LISP
(google "scheme guy steele 371" and "PLT scheme")
expect more posts about scheme

Upload with php!!

2008-10-15T15:35:00.008+05:30

Sample upload using PHP and HTML

create a folder uploads in the folder containing upload.php

HTML source:

PHP source:

$target_path = "uploads/".$_GET['teachername']."/";
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path))
{
$message= "OK ".basename( $_FILES['uploadedfile']['name'])." has been uploaded ";
}
else
{
$message= "ErrorThere was an error uploading the file, please try again!";
}
echo $message;

?>

Flex and MySQL Database Connection through Java using LCDS

2008-09-29T12:58:00.004+05:30

Flex can comminicate to a database through either java or php.Here we are using Life Cycle Data Services for the database communication.
For connecting Flex to MySql Database we need to configure the following things :
Create the Flex Application from flex save it inside the folder :-
C->Program Files->lcds->jrun4->servers->default->samples->Flex Project
For Mysql database, create java file for establishing the database connection,compile java file and put the class file inside classes directory of LCDS.
Install Java Jdk 1.4.2
Set path and classpath by right clicking My Computer->Properties->Advanced->Environment Variables->
Path C:\Program Files\Java\bin;
Classpath C:\Program Files\Java\jre\lib
Copy the Mysql connector jar file into Javas’ directory
C:\Program Files\Java\jre\lib\paste the mysqlconnector.jar here
Put the main java class file MySQLAdmin.class into
C-> Program Files->lcds->jrun4->servers->default->samples->WEB-INF->classes->put the java class file here. MySQLAdmin.class
Copy the mysqlconnector’ s jar file inside the lcds directory
C->Program Files->lcds->jrun4->servers->default->samples->WEB-INF->lib->paste here mysqlconnector.jar
Other wise it may show some error like this “ is there any server running on this port localhost:3306”
“server handshaking”
Inside the Flex use a RemoteObject Method , inside the RemoteObject specify the destination id corresponding to the location of our java class file.
Before specifying the destination , we have to edit one configuration file inside flex folder of lcds.
C-> Program Files->lcds->jrun4->servers->default->samples->WEB-INF->flex->remoting-config.xml

Inside this file add one destination and specify the source as the location of our java class file.

path of our java class file

Then coming back to our Flex project add the destination id as “id1” inside the RemoteObject Method.
Inside the RemoteObject specify the java methods we need to call inside flex .

We need to give this in the code

Then we can be able to call our java methods from flex as :-
remoteObj.executeSQL();

TCPClient.cpp

2008-08-22T13:43:00.002+05:30

To test the TCP server uploaded use this client program

// TCPClient.cpp
// A simple example for TCP client

#include
#include
#pragma comment(lib, "Ws2_32.lib")

#define PORTNUM 50000 /* random port number, we need something */

int main(int argc, char* argv[])
{
WORD wVersionRequested;
WSADATA wsaData;
int err;

wVersionRequested = MAKEWORD( 2, 2 );

err = WSAStartup( wVersionRequested, &wsaData );
if ( err != 0 ) {
/* Tell the user that we could not find a usable */
/* WinSock DLL. */
return 1;
}

struct sockaddr_in sa;
struct hostent *hp;
SOCKET s;

hp = gethostbyname("localhost");
if (hp == NULL) /* we don't know who this host is */
return INVALID_SOCKET;

memset(&sa,0,sizeof(sa));
memcpy((char *)&sa.sin_addr, hp->h_addr, hp->h_length); /* set address */
sa.sin_family = hp->h_addrtype;
sa.sin_port = htons((u_short)PORTNUM);

s = socket(hp->h_addrtype, SOCK_STREAM, 0);
if (s == INVALID_SOCKET)
return INVALID_SOCKET;

/* try to connect to the specified socket */
if (connect(s, (struct sockaddr *)&sa, sizeof sa) == SOCKET_ERROR) {
// you should check for error...
//int last = WSAGetLastError();
//....
closesocket(s);
return INVALID_SOCKET;
}

char str[] = "hello world";
char inStr[256];
int ret;

ret = send( s, str, sizeof(str), 0 ); /*you should check the ret value ...*/
ret = recv(s, inStr, sizeof(inStr), 0);
printf("Client Received: %s", inStr);

return 0;
}

TCPServer.cpp

2008-08-22T13:32:00.004+05:30

Typical TCP server program that proved useful to me.

// TCPServer.cpp
// A simple example for TCP server

#include
#include
#pragma comment(lib, "Ws2_32.lib")

#define PORTNUM 50000 /* random port number, we need something */

/* this is the function that plays with the socket. it will be called
* after getting a connection.
*/
void do_something(SOCKET s)
{
char inStr[256];
int ret;
printf("On new connection\n");

ret = recv(s, inStr, sizeof(inStr), 0);

printf("Server Received: %s\n", inStr);
char str[] = "hello world received :)";
ret = send( s, str, sizeof(str), 0);
}

/* code to establish a socket
*/
SOCKET establish(unsigned short portnum)
{
char myname[256];
SOCKET s;
struct sockaddr_in sa;
struct hostent *hp;

memset(&sa, 0, sizeof(struct sockaddr_in)); /* clear our address */
gethostname(myname, sizeof(myname)); /* who are we? */
hp = gethostbyname("localhost"); /* get our address info */
if (hp == NULL) /* we don't exist !? */
return(INVALID_SOCKET);
sa.sin_family = hp->h_addrtype; /* this is our host address */
sa.sin_port = htons(portnum); /* this is our port number */
s = socket(AF_INET, SOCK_STREAM, 0); /* create the socket */
if (s == INVALID_SOCKET)
return INVALID_SOCKET;

/* bind the socket to the internet address */
if (bind(s, (struct sockaddr *)&sa, sizeof(struct sockaddr_in)) ==
SOCKET_ERROR)
{
closesocket(s);
return(INVALID_SOCKET);
}
listen(s, 3); /* max # of queued connects */
return(s);
}

int main(int argc, char* argv[])
{
SOCKET s;
WORD wVersionRequested;
WSADATA wsaData;
int err;

wVersionRequested = MAKEWORD( 2, 2 );

err = WSAStartup( wVersionRequested, &wsaData );
if ( err != 0 ) {
/* Tell the user that we could not find a usable */
/* WinSock DLL. */
return 1;
}

char myname[256];
struct sockaddr_in sa;
struct hostent *hp;

memset(&sa, 0, sizeof(struct sockaddr_in)); /* clear our address */
gethostname(myname, sizeof(myname)); /* who are we? */
hp = gethostbyname("localhost"); /* get our address info */
if (hp == NULL) /* we don't exist !? */
return(INVALID_SOCKET);
sa.sin_family = hp->h_addrtype; /* this is our host address */
sa.sin_port = htons(PORTNUM); /* this is our port number */
s = socket(AF_INET, SOCK_DGRAM, 0); /* create the socket */
if (s == INVALID_SOCKET)
return INVALID_SOCKET;

/* bind the socket to the internet address */
if (bind(s, (struct sockaddr *)&sa, sizeof(struct sockaddr_in)) ==
SOCKET_ERROR)
{
closesocket(s);
return(INVALID_SOCKET);
}

if ((s = establish(PORTNUM)) == INVALID_SOCKET) { /* plug in the phone */
perror("establish");
exit(1);
}

SOCKET new_sock;
for (;;)
{ /* loop for phone calls */
new_sock = accept(s, NULL, NULL);
if (s == INVALID_SOCKET)
{
fprintf(stderr, "Error waiting for new connection!\n");
exit(1);
}
do_something(new_sock);
}
closesocket(new_sock);
return 1;
}

Convert a set of file extensions

2008-07-15T19:50:00.002+05:30

I was wondering how to convert a set of txt files to doc

this could be done using this shell script:

example:
for x in *.txt;
do mv "$x" "${x%.txt}.doc";
done

steps to reproduce:
# touch 1.txt 2.txt 3.txt # for x in *.txt;do mv "$x" "${x%.txt}.doc"; done # ls 1.doc 2.doc 3.doc

Call EXE from FLEX (AIR application)

2008-07-05T19:21:00.004+05:30

Finally i found a way to call an exe from AIR application.
A small Java socket progam listens in port (3244-my lucky number),

java code:

import java.io.*; import java.net.*; class SimpleServer { private static SimpleServer server; ServerSocket socket; Socket incoming; BufferedReader readerIn; PrintStream printOut; public static void main(String[] args) { int port = Integer.parseInt(args[0]); server = new SimpleServer(port); } private SimpleServer(int port) { System.out.println(">> Starting SimpleServer"); try { socket = new ServerSocket(port); for(;;) { incoming = socket.accept(); readerIn = new BufferedReader(new InputStreamReader(incoming.getInputStream())); printOut = new PrintStream(incoming.getOutputStream()); Runtime.getRuntime().exec("notepad.exe"); incoming.close(); } } catch (Exception e) { //System.out.println(e); } } }

The FLEX(AIR application) connects to this socket using XMLsockets.

FLEX code:

<?xml version="1.0" encoding="utf-8"?> <mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"> <mx:Script> <![CDATA[ import flash.net.XMLSocket; var xmlsock:XMLSocket; public function sendServer():void { xmlsock = new XMLSocket(); xmlsock.connect("127.0.0.1",3244); xmlsock.send("call\n"); } ]]> </mx:Script> <mx:Button name="button1" label="Click" click="{sendServer()}" x="197" y="377" width="152"/> </mx:WindowedApplication>

For each click in the AIR application opens a new notepad window.
The java server program can be made a service to maintain usability.

How to call exe from Flex!

2008-06-27T14:12:00.004+05:30

Flex is killing me with its security features.
"Usability and security are two sides of the same coin"

Calling exe from flex is not possible directly.
So I did it the other way.
First call a javascript from actionscript3 using
externalInterface object:

http://livedocs.adobe.com/flex/201/langref/flash/external/ExternalInterface.html

Then call exe from javascript, explained in last blog.

This works fine with a browser with ActiveX support.
But I could not do the same in AIR application(of course no ActiveX support)
There will be a way to do it ..

added:
To call exe from air application visit:
http://saasneo.blogspot.com/2008/07/calling-exe-from-flex-air-application.html

Calling exe from javascript

2008-06-17T19:38:00.001+05:30

Javascript is capavle of calling a .exe file from web browser. Usually the
javascript runs inside the sandbox to disable execution of commands (Security purpose),
but ActiveX objects can be used to execute exe files from trusted sites.
ie we have to include the website as a trusted one(in internet explorer).

the script is:

function loadexe() {
w = new ActiveXObject("WScript.Shell");
w.run('shutdown.exe /r');
return true;
}

This works for sure in IE, any probs...mail me.

Desktop capture Vs Desktop mirroring

2008-06-17T19:19:00.001+05:30

For Desktop sharing in web conference application, display mirroring technology is widely employed by remote desktop applications such as: NetMeeting, PC Anywhere, VNC, Webex, etc. Mirroring is a technically superior method when compared to primitive screen grabbing,
because it allows the capture of only the minimally updated regions and
retrieves the data directly, bypassing the intermediate copy.

links:
http://www.demoforge.com/dfmirage.htm
http://www.tightvnc.com/download.html

Screen Capture in linux

2008-06-13T12:44:00.000+05:30

In early posts i told you about different ways of
screen capture in windows.

In linux this is much easier

To capture full screen:
import -window root screenshot.jpg

To capture chosen area of screen
import screenshot.jpg

But in both linux and windows screenshot alternatives
mouse pointer is not captured.
This makes me fell that VH screen capture is better.

Capturing screenshot using JAVA

2008-06-13T12:32:00.000+05:30

VH Capture Driver works well but I was trying to
find another alternative. Security risks involved in using
VH Driver was too high.

Then i wrote this java program using robot class.

import java.awt.*;
import java.awt.image.*;
import java.io.*;
import javax.imageio.*;

public class Capture {
public static void main(String[] args) throws Exception {
Toolkit toolkit = Toolkit.getDefaultToolkit();
Dimension screenSize = toolkit.getScreenSize();
Rectangle screenRect = new Rectangle(screenSize);
Robot robot = new Robot();
BufferedImage image = robot.createScreenCapture(screenRect);
ImageIO.write(image, "jpg", new File(args[1]));
}
}

Since i am using FLEX, i need to find a way to call the java API
from FLEX.
Another problem is that i cannot use this code for LINUX.

VH Screen Capture Driver

2008-05-26T19:17:00.001+05:30

I'm working on an e-learning project for TBI, in which i'm doing a module for
capturing desktop and stream it through FMS server.
currently we are able to stream input from web cam.
We were doing this project in FLEX(Adobe) in which we cannot capture desktop
due to the sandbox problem. I was thinking of something like a flex-java bridge....since
we have robot class in java which helps us to take snapshots of desktop.

But now i got the perfect solution
http://www.hmelyoff.com/index.php?section=8
a 'web cam simulation driver' which captures the desktop and gives it as web cam input.
OS consider the input as the input from the web cam :)
Now things are simple, just stream it using flex(FMS)...

Happy day @ work