Alfresco, Is it the OpenSource counterpart to Windows Sharepoint ??

Here’s how to…..
Installing Alfresco on RHEL-5 System

1. Download Information:
Download the binary alfresco-1.2i-linux-community.bin from
http://sourceforge.net/project/showfiles.php?group_id=143373&package_id=157460&release_id=396245

2. Setup permissions:
Assign execute permission on the binary
# chmod u+x alfresco-1.2i-linux-community.bin

3. Installation:
Installation takes place in an interactive fashion thus unless something goes really bad, it won’t
take more than couple of minutes;
Start installing with the help of the following command
# ./alfresco-1.2i-linux-community.bin
(Make sure, your X-server is up and running)
The default installation directory would be under /opt/alfresco-1.2
Note: Alfresco installer comes bundled with Tomcat (Application Server), MySQL database and an
openoffice suite.

4. Gotchas!!! If you have multiple MySQL….
If you already have one MySQL DB running (on default 3306 port) then assign a different port of
MySQL while installing Alfresco.
Also, please move the mysql configuration file that you have under /etc/
to /mysql_install_directory/share/
And at the same time, copy the /opt/alfresco-1.2/mysql/support-files/ my-small.cnf with a name
my.cnf under /opt/alfresco-1.2/mysql/share/my.cnf
Eg.
# cp /opt/alfresco-1.2/mysql/support-files/ my-small.cnf /opt/alfresco-1.2/mysql/share/my.cnf

MySQL Port and Socket files;
Edit the file; /opt/alfresco-1.2/mysql/share/my.cnf and make the following changes as
port = 3307
socket = /opt/alfresco-1.2/mysql/data/mysql.sock
You might need to modify the file
/opt/alfresco-1.2/tomcat/shared/classes/alfresco/extension/custom-repository.properties
And change the port as;
db.url=jdbc:mysql://localhost:3307/${db.name}

5. Start alfresco:
Although after a successful installation, alfresco would start up automatically. You might also
want start and stop the same later on, the scripts for doing that can be found under;
/opt/alfresco-1.2/alf_start.sh
/opt/alfresco-1.2/alf_stop.sh

6. How to access:
Open a browser and type http://localhost:8080/alfresco; this should bring up the login page.
(Initial admin credentials are Username: admin, Password: admin)

(I did not try to install it with Tomcat server already installed, if some one tries that do share)

Installing ORACLE 9i on RHEL5

Note: I have installed it successfully on "Red Hat Enterprise Linux Server release 5 (Tikanga)" 32 bit. Please understand; it involves tweaking of Kernel parameters, so take care while you do that.

Steps:
1. Create oracle User AccountLogin as root and create te user oracle which belongs to dba group.$ su - root
# groupadd dba# useradd -g dba oracle
2. Setting System parameters:Edit the /etc/sysctl.conf with an editor like vi and add following lines:kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144net.core.wmem_max=262144
Note: You need to execute "sysctl -p" to apply the above settings.
3. Setting Oracle EnviromentEdit the /home/oracle/.bash_profile file and add following lines:ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/920
ORACLE_SID=orcl
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORACLE_OEM_JAVARUNTIME=/opt/jre1.3.1_15
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH ORACLE_OEM_JAVARUNTIME PATH
Save the .bash_profile and execute following commands to load the new environment:
# cd /home/oracle.
# .bash_profile
4. Create base directory for OracleLogin as root and create base directory for Oracle ($ORACLE_BASE).
$ su - root
# cd /opt
# mkdir oracle# chown oracle:dba oracle
5. Download and install required .rpm packagessome additional packages may be required for successful installation . To check whether required packages are installed on your operating system use following command:

rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc
6. Download the Java Runtime Enviroment (I used j2re-1_3_1_19-linux-i586.bin) from the Sun website. Login as root, give the file execute permission and then execute it. When the JRE is exracted move the same under the directory "/usr/local" directory.# chmod +x j2re-1_3_1_19-linux-i586.bin
# ./ j2re-1_3_1_19-linux-i586.bin
# mv jre1.3.1_19 /usr/local/
7. Download the Oracle 9i (9.2.0.4) software from Oracle website. Extract the files using following command:

gunzip ship_9204_linux_disk1.cpio.gz
gunzip ship_9204_linux_disk2.cpio.gz
gunzip ship_9204_linux_disk3.cpio.gz
cpio -idmv "<" ship_9204_linux_disk1.cpio
cpio -idmv "<" ship_9204_linux_disk2.cpio
cpio -idmv "< "ship_9204_linux_disk3.cpio
mv Disk* /home/oracle/
chown –R oracle:dba Disk*

When all archives were extracted you've got three directories Disk1, Disk2 and Disk3.
Edit the Disk1/install/linux/oraparam.ini and modify JRE_LOCATION variable and set path to our JRE installation from Step 6. JRE_LOCATION=/usr/local/jre1.3.1_19 4.

Start the Oracle software installation process. To start the installation process; execute the following commands:

$ cd Disk1
$ ./runInstaller

***************************************************
Errors with solutions:
1. When network configuration assistant and database configuration assistant has failed during startup then do following steps:
Solution:
$ cd /opt/oracle/920
$ rm JRE $ ln -s /usr/local/jre1.3.1_19 JRE
$ su - root
# cd /opt/oracle/920/JRE/bin # ln -s java jre
# cd i386/native_threads
# ln -s java jre
2. If you encounter the following error:
ORACLE_HOME/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory Solution: Create a symbolic link
$ su - root
# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
3. If you encounter something like below at the very beginning of installation:
error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory
Solution:
$ su - root
# cd /usr/lib
# ln -s libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2
Now, run the installer again:
$ ./runInstaller
****************************************************
Note: If you encounter any more errors, please post it here

Heard about SQL Injection !!!

What is SQL Injection??
SQL Injection is one of the many web attack mechanisms. As a result data from organizations are stolen by Hackers. It is an application layer attack techniques used nowadays. It is the type of attack that takes advantage of falulty coding of web applications that allows hacker to inject SQL commands into say a login form to allow them to gain access to the data held within your database.

SQL Injection is the hacking technique which attempts to pass SQL commands (statements) through a web application for execution by the backend database. If not guarded properly, web applications may result in SQL Injection attacks that allow hackers to view information from the database and/or even wipe it out.

A simple instance;
Take for instance, a simple login page where a valid user would enter his username and password to view his personal details or upload his comments in a forum.
What actually happens When the legitimate user submits his details.... Once the user input data, an SQL query is generated from these details and submitted to the database for verification. If a match is found, the user is allowed access. In other words, the web application that controls the login page will communicate with the database through a series of pre-defined commands so as to verify the username and password combination. On verification, the legitimate user is granted appropriate access.

Through SQL Injection, the hacker may input specifically manipulated SQL commands with the intent of bypassing the login form barrier and seeing what lies behind it. This is only possible if the inputs are not properly sanitised (i.e., made invulnerable) and sent directly with the SQL query to the database. SQL Injection vulnerabilities provide the means for a hacker to communicate directly to the database
The impact of SQL Injection could be of the following;
An attacker may execute arbitrary SQL statements on the vulnerable system. This may compromise the integrity of your database and/or expose sensitive information. Depending on the back-end database in use, SQL injection vulnerabilities may lead to varying levels of data/system access for the attacker. It may also be possible to manipulate existing queries, to UNION (used to select related information from two tables) arbitrary data, use subselects, or append additional queries.
Thus, If an attacker can obtain access to your database, it could spell disaster.

Unfortunately the impact of SQL Injection is only uncovered when the theft is discovered.......

If.............

"If"

If you can keep your head when all about you

Are losing theirs and blaming it on you,

If you can trust yourself when all men doubt you,

But make allowance for their doubting too;

If you can wait and not be tired by waiting,

Or being lied about, don't deal in lies,

Or being hated, don't give way to hating,

And yet don't look too good, nor talk too wise:
If you can dream - and not make dreams your master,

If you can think - and not make thoughts your aim;

If you can meet with Triumph and Disaster

And treat those two impostors just the same;

If you can bear to hear the truth you've spoken

Twisted by knaves to make a trap for fools,

Or watch the things you gave your life to, broken,

And stoop and build 'em up with worn-out tools:
If you can make one heap of all your winnings

And risk it all on one turn of pitch-and-toss,

And lose, and start again at your beginnings

And never breath a word about your loss;

If you can force your heart and nerve and sinew

To serve your turn long after they are gone,

And so hold on when there is nothing in you

Except the Will which says to them: "Hold on!"
If you can talk with crowds and keep your virtue,

Or walk with kings - nor lose the common touch,

If neither foes nor loving friends can hurt you,

If all men count with you, but none too much;

If you can fill the unforgiving minute

With sixty seconds' worth of distance run,

Yours is the Earth and everything that's in it,

And - which is more - you'll be a Man, my son!!

-----Rudyard Kipling

Want to Hide yourself???

Do you want your Linux Box not to respond to ping request!
Here is how to do....

Check the value of /proc/sys/net/ipv4/icmp_echo_ignore_all
i.e.cat /proc/sys/net/ipv4/icmp_echo_ignore_all
Now, replace the current value by 1
i.e. echo 1 > /proc/sys/net/ipv4/icmp_echo_ignore_all

Now, try and ping your system from a different system...Are u getting any response????
Reboot ur system, and ur current settings is lost (Default is reverted back.. i.e. ping is enabled again.)

Want to make this a permanent one???
Make the following entry in /etc/sysctl.conf
net.ipv4.icmp_echo_ignore_all=1

Now, run the following command to make the change effective...
sysctl -p


You are Hidden!!!