Monday, April 23, 2007

Install Alfresco from the Source Code in Fedoras

1. Install Java 1.5x
If you dont have the java downlaod it from
here

2. Install Tomcat 5.2x
Take tomcat 5 from
here

3. Install Ant 1.6x
Download latest Ant from
here

4. Set these Environment Variables: In Redhat/Fedora linux these vales can be
set in .bash_profile file
JAVA_HOME
TOMCAT_HOME
VIRTUAL_TOMCAT_HOME
(For virtual tomcat you need to install one more tomcat 5.2x)

5. Checkout Source Code from here:
$svn co svn://svn.alfresco.com/alfresco/HEAD
$cd HEAD/root/projects/installer/HEAD
(delete 3 files custom*)

6. $cd HEAD/root/
ant build-tomcat
This will create one alfresco.war file and copy it to the
TOMCAT_HOME/webapps/

7. copy mysql-java connector jar file form
HEAD/root/projects/3rd-party/lib/devenv/mysql-connector-java-5.0.3-bin.jar
to TOMCAT_HOME/common/lib

8. Create one alfresco database and grant all to alfresco user
Connect to mysql as root
mysql>create database alfresco;
mysql>grant all on alfresco.* to alfresco@localhost identified by 'alfresco';
mysql>grant all on alfresco.* to alfresco@localhost.localdomain identified by 'alfresco';

9. As default memory (heap size) allocated by tomcat for java is less than required to run the alfresco sp increase the heap size.Edit the tomcat/catalina.sh file and make

$_RUNJAVA.... line like this
$_RUNJAVA -Xmx512M $JAVA_OPTS $CATALINA_OPTS

10. Start Tomcat
$./catalina.sh run &

11. Point Browser to:
http://localhost:8080/alfresco

Friday, April 20, 2007

Change sugarCRM password from backend

If you forget your sugar admin password then dont be panic.
Can reset it from the mysql backend.

Connect to your sugar mysql database and execute this query:

For sugar version < style="font-family:verdana;">
update users set user_password=MD5('NewPass') where user_name='admin';

For sugar version >= 45
update users set user_hash=MD5('NewPass') where user_name='admin';

Wednesday, April 18, 2007

Install Java on Linux Machine

Download the latest JDK from http://java.sun.com/javase/downloads/index.jsp
Select jdk-xxx.xx.Linux.xxx.bin to download for Linux machine

This is a binary file so execute this file.

$ cd /usr
$ ./jdk-xxx.x-linux-i586.bin

Edit your bash profile file to set the Java home.

$cd
$vi .bash_profile
Add/edit these lines
PATH=/usr/jdk-xxx-x.x/bin

JAVA_HOME=/usr/jdk-xxx-x.x/
export JAVA_HOME

#Save and Exit from the vi

$source .bash_profile

Check the java version
$ java -version

Whats new in Ajuby 0.5