Follow these steps:

1. Download MySQL Setup :

2. Double click to start installation

3. After installation is complete start “MySQL Server Instance Configuration”

4. Select all default option except Charset to “Best Support Multilingualism” (for utf 8 support)

5. Once instance is created, start MYSQL Commandline Client Console using “Start > MySQL > MySQL Server 5.0 > Command Line”

6. Enter root password to continue. You will get MySQL> prompt

7. You will need to create Database first in order to start using MySQL.

8. Enxecute command “create database opencms” (note “opencms” is the name of database i have choosen)

9. I have selected other clients to continue further usage.

10. Connect to MySQL using following parameter

Database Name: opencms

JDBC Driver Class: com.mysql.jdbc.Driver

Class Location: mysql-connector-java-3.1.14-bin.jar (Note you can find this under MySQL Installation folder)

Connection URL: jdbc:mysql://localhost:3306/opencms

user ID: root

Password: ***** (this should match with the password you entered while server installation)

11. You should able to create tables and use it.

12. Create user using following command line command

create user ‘testcms’@’localhost’ IDENTIFIED BY ‘password’;

13. Grant nse user access to database using following command

GRANT ALL PRIVILEGES ON ‘opencms\_%’ . * TO ‘testcms’@’localhost’;

14.  View all available grants using following command

SHOW GRANTS FOR ‘testcms’@’localhost’;


Follow these simple steps to install and test OpenCMS.

1. Download openCMS
2. Copy/import war file into eclipse environment
3. Add opencms war project on tomcat server(you can merge steps 2 & 3 by copying war file directly uner tomcat webapp directory)
4. Configure opncms.proeprties for database connection strings
5. In case your database user doesnt have rights to create new database then follow next step
6. Use table creation script  /setup/database/mysql_41/create_tables.sql directly to create tables yourself using sql admin
7. Start tomcat server(note you will see few exceptions on console, ignore those for now, you should able to follow next steps)
7. Login to setup console using http://localhost:8080/opencms/setup/
8. Continue with steps(Note: here you need to specify the database name if its existing and uncheck the “Create Database & Table option, as we have already created tables)
9. Continue till setup imports all required files
10. Once completed, Login to application workspace using http://localhost:8080/opencms/opencms/system/login/

– jQuery/Lightwindow – Enhanced javascripting (e.g. Overlay )

– Flowplayer – Flash Video Player

– FusionChart – Charts/Graph

– HeySpread/TubeMogul – Video Distribution

– Handshakes – Social Networking Site

– UBR Uploader – Progress Bar during file uploading

– FFMpeg/Mencoder – Video Encoding/Watermarking

Search Sites to register your website:

1. Yahoo:

2. Google:

Basic guidelines:

  1. Make sure to add relevant keywords and Page/site description using meta tag
  2. Make sure your page has most of the keywords mentioned in meta tag
  3. Avoid duplicate content on same page (Hint: Duplicate content dilutes relevancy)
  4. Avoid 302 redirects on the page. Use 301 Redirects (301 redirects informs the engine of the new destination page for your old urls)  Link:
  5. Prepare SEO friendly URLs example instead of
  6. Use <title> tag with relatvent page title.
  7. Make use of <h1> whereverpossible. Add <h1> tags that include targeted keywords
  8. Add sitemap on page to expose all possible links to search engine. Example:
  9. Links should be created for keywords of interests (hint: increases value and ranking of the linked pages)
  10. On a related note, provide to links from home page to the pages those are required to appear most. (hint:  Pages linked form homepage gets higher ranking)
  11. add html copy for flash content as search engine cannot read flash content.
  12. Improve copy by using specific name vs generic name. Example: use product name like ‘Apple iPod Manual’, ‘Apple iTune Manual’ instead of naming it as ‘Product Manual’
  13. Avoid images used for representing text. If you cannot avoid then use ALT tag of <img to specify same text. This ensures all copy on the page is able to read by engine.
  14. Use descriptive and unique words in thenfilenames and alt tags
  15. Include targeted  keywords in the titles and filenames of all videos (this improves ranking of the pages and videos on search engine. Also allows user to link directly to videos.

Useful links:

I will be adding few more .. stay tuned. feel free to respond with your comments and suggestion to improve the information.



  • Shamrao
  • Small business bible – Steve Strauss
  • The perfect Business – Mickael LeBoeuf
  • Pour Your Heart Into it: How Starbucks Built a Company One Cup at a Time – Howard Schultz

Apache Setup:

1. Download Apache installation from ( apache_2.2.9-win32-x86-no_ssl-r2.msi)
2. Install by double click on .msi file
3. Leave default values.
4. verify setup by invoking http://localhost/

PHP Module Setup:

5. Download php package using (
6. Double click on php-5.2.6-win32-installer.msi to start installation
7. Provide the directory name “example: C:\Ajay\Installed Programs\PHP\
8. Click Next and select Apache webserver (2.2.x)
9. Click Next and provide directory of apache Directory (by default its C:\Program Files) i used “C:\Ajay\Installed Programs”
10. Click Next and let it finish the setup
11. On completion it will prompt an error saying “Configuration failed you need to modify httpd.conf manually”
12. httpd.conf can be found under C:\Ajay\Installed Programs\Apache Software Foundation\Apache2.2\conf
13. Add following lines somewhere under  “LoadModule ” statements ends somewhere after line 128
LoadModule php5_module “C:/Ajay/Installed Programs/PHP/php5apache2_2.dll”
14. Add following lines under <IfModule mime_module> section somewhwre after existing line 386 “AddType application/x-gzip .gz .tgz”
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
15. Stop Apache server and Start again.

Test PHP Page:

16. Create test.php file under C:\Ajay\Installed Programs\Apache Software Foundation\Apache2.2\htdoc with following content

17. test php file using http://localhost/test.php in browser. You should able to see output.

Note: if for any reason you are not able to star tapache then please start apache using command line ..
example: Go to command prompt. -> change directory to apache bin > execute command “httpd.exe” (you should able to see error in case of any)

Following is the wsdl file i was trying to use with Jax-RPC runtime. It worked fine with Axis but giving issues when i used Jax-RPC.

  <xsd:schema    xmlns:xsd=”
   <xsd:complexType     name=”VIMSBaseDomain”>
     <xsd:element       type=”xsd:dateTime”
     <xsd:element       type=”xsd:int”
   <xsd:complexType     name=”County”>
     <xsd:extension       xmlns:tp=”java:com.xx.vims.domain”
       <xsd:element         type=”xsd:string”

Issue: When there is Complextype used in wsdl it gives following error for Jax-RPC

faultString: org.xml.sax.SAXException: WSWS3047E: Error: Cannot deserialize element lastUpdatedTime of bean XXXXXXX.

Child element lastUpdatedTime does not belong in namespace .

If you look in wsdl you will notice elementFormDefault=”qualified” which we need to change to elementFormDefault=”unqualified

Note: Make changes in all the places where you see  elementFormDefault=”qualified”  and generate client classes again to resolve the issue.


Good luck. Let me know if it resolves your issue.