Wednesday, April 26, 2006

Installation of MediaWiki and SugarCRM on windows XP

Introduction

    In this task, I have successfully installed MediaWiki and SugarCRM on
    Windows XP. I did some customization in each application.

    MediaWiki

After installation and changed the skin to “chick” by modifying
LocalSettings.php as follows.


a. Locate LocalSettings.php in Apache public_html / wiki directory. In
my case the file was located at C:\Program Files\Apache
Group\Apache2\htdocs\wiki.


b.Configure skin using parameter as follows

$wgDefaultSkin = 'chick';


The resultant main page is as follows:





SugarCRM

I performed following tasks after downloading sugarCRM.

1. Created a new account.


2. Created a new contact.




3. Modified “Account List” screen by swapping “user”
and “city” columns.





Tuesday, April 25, 2006

Opensource software business readiness

If you are CTO, IT director or manager and wish to adopt open source software for your organization then visit www.openbrr.org.
One of the challenge is to select software from thousands of available software. Business readiness rating will help you to determine business maturity of the software. You can also contribute to these standards. I don't want to sound like I am trying to market this framework. However, I encourage you to visit openbrr.org and make use of it.

Installation of common OpenSource software on windows XP

This documents discusses the installation of various open source software on windows XP. The document talks about web site from which the software got downloaded, information source for installation and useful information which will help others to install these software n their own.

Installing Openoffice 2.0

Downloaded from: http://www.openoffice.org/

Installation tips:
1. Go to http://www.openoffice.org/

2. Click on green box with text “get Openoffice.org version 2.0.” and follow the instructions. Select “Install with JRE”. It will download Ooo_2.0.2_Win32Intel_install_wJRE.exe.

3. Run the executable file downloaded in step 2. It will install OpenOffice.

Testing:
1. On windows, go to Start->All Programs->OpenOfficeOrg2.0 and verify that you can see following products in the list
OpenOffice.org Base
OpenOffice.org Calc
OpenOffice.org Draw
OpenOffice.org Impress
OpenOffice.org Math
OpenOffice.org Writer

2. Open Writer and write few lines and save document.

3. Open Microsoft Word document using Writer.

4. Open Microsoft excel document using Calc.


Installing Apache 2.0

Downloaded from: http://httpd.apache.org/download.cgi

Installation tips:

Open a web page http://a51.neostrada.pl/. This web page is a tutorial to show you how to install Apache2 with PHP5 and MySQL. The instructions are very clear and everything worked for me as described. You can use download links from this web page or you can download it from http://httpd.apache.org/download.cgi.

1. Click on “Win32Binary(MSI Installer):” link on above web page.

2. It will download apache_2.0.55-win32-x86-no_ssl.msi file. Run this file by choosing “Run” option. It will open up installation wizard as follows.

1. Follow the instructions on installation wizard to install Apache.

2. Here are the key settings which I used whenever asked by installation wizard.
1. Network Domain : localhost
2. Server name : localhost
3. Installation : Typical

Testing :
1. Click on a feather-like icon on the task bar. Right-click and select "Open Apache Monitor".
If the monitor comes up with “Apache2” along with green button then we can assume that the
Apache server is started.

2. Now visit http://localhost/ You will see following web page.

3. Using Apache monitor stop and restart the apache server.


Installing PHP5

Downloaded from: http://www.php.net/downloads.php

Installation tips:

1.Follow the instructions mentioned in http://a51.neostrada.pl/

2. The instructions will configure apache for PHP5. It is achieved by configuring httpd.conf.
We need to add following text at the bottom in httpd.conf
LoadModule php5_module C:/Server/php/php5apache2.dllPHPIniDir C:/Server/phpAddType application/x-httpd-php .php

3. You will also need to copy some dll files from ph5 installation directory to Apache2 installation directory. The detail instructions are available in http://a51.neostrada.pl/

Testing:

1. Create phpinfo.php with following content


2. Copy phpinfo.php to Apache2/htdocs directory.

3. Re-start Apache.

4. Visit http://localhost/phpinfo.php. You will see following page.




Installing MySQL5.0

Downloaded from : http://dev.mysql.com/downloads/mysql/5.0.html

Installation tips :

1. Click download link associated with Windows (x86)

2. It will download mysql-5.0.19-win32.zip file.

3. Click on the “Setup” after double clicking above zip file. Follow the instructions shown by setup wizard.

4. Choose custom installation and follow the instructions given in http://a51.neostrada.pl/

5. Download phpMyAdmin from http://www.phpmyadmin.net/home_page/downloads.php

6. Extract the file to Document Root\pma (In my case “C:\Program Files\Apache Group\Apache2\htdocs\pma”)

7. Edit config.default.php located in pma folder by following the instructions in http://a51.neostrada.pl/

8. Restart Apache2.

9. Visit http://localhost/pma/. It will come up with following page, which confirms that the installation is successful.

10.Click on “Show MySQL runtime information”. This page fetches information from database and confirms that MySQL is correctly configured.


Installing FireFox 1.5

Downloaded from : http://download-firefox.org/free-downloads/

Installation tips : The installation is very straightforward. Just follow the instructions.

Testing

1. Visit some web sites using firefox.

2. Create RSS feed using “Manage bookmarks”.


Thunderbird

Downloaded from : http://www.mozilla.com/thunderbird/

Installation tips : The installation is very straightforward. Just follow the instructions.



Azureus

Downloaded from : http://azureus.sourceforge.net/download.php

Installation tips : The installation is very straightforward. Just follow the instructions.


Eclipse

I already use eclipse 3.0 for Java development. The download is available from
http://www.eclipse.org/


Summary
The installations were very straightforward for most of the software. Some configuration is involved for running Apache+PHP+MySQL together. The detail instructions for configuring Apache+PHP+MySQL are available on http://a51.neostrada.pl/.