To show relationship among different tables in database.

* SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.

* It is free software that is distributed under the terms of the Lesser GNU Public License 2.1.

* Install Graphviz by running following command in terminal(Alt+Ctrl+T):

sudo apt-get install graphviz

* SchemaSpy uses the dot executable from Graphviz to generate graphical representations of the table/view relationships.

* Run the following command in terminal:

sudo apt-get install libmysql-java

* After thet download the SchemaSpy Software from the following link:

* Rename the downloaded package to your suitable name (say SchemaSpy).

* Now run the SchemaSpy with the following given command.Make appropriate changes in below command before running, like :

java -jar schemaSpy.jar -t mysql -o library -host localhost -db db_name   -u user -p password -dp /usr/share/java/mysql-connector-java.jar

Description of parameters used in above command:

    -t databaseType: Type of Database(e.g ora,db2 etc.)
-db db_name: Name of the Database to connect to.
-u user: Valid database user id with read access.
-s schema: Database schema.
-p password: Password associated with that user.
-o output Directory: Directory to write the generated HTML/graphs to.
-dp path/T/oDrivers: Looks for drivers here before looking in driverPath in [databaseType].properties. The drivers are usually contained in .jar or .zip files and are typically provided by your database vendor.

* Your Library folder has been created in /home/downloads , open the library folder and you can run any of the files in browser and understand relationships among different tables in database.

Note: In some cases,  it gives following error after running the above command :

The program ‘java’ can be found in the following packages:
 * default-jre
 * gcj-4.6-jre-headless
 * openjdk-6-jre-headless
 * gcj-4.5-jre-headless
 * openjdk-7-jre-headless
Try: sudo apt-get install <selected package>

* Run following commands to satisfy all the needs :

apt-cache search jdk

sudo apt-get install openjdk-7-jdk openjdk-7-jre

* Now again run the SchemaSpy with the above given command.It wll work.

Thats all 🙂


How to install Blender (software).

Blender is a popular 3D graphics tool that’s often used for modeling, texturing, UV unwrapping, rigging, smoke and water simulation, rendering, animating, and skinning. It is also used for simulating, editing non-linear work, compositing and for the making of 3D applications including visual effects, video games, and animated film.


Features of Blender include simulation tools that are very advanced, such as realistic body simulators, cloth, fluid, dynamics for soft body rendering, animation tools for creating powerful bodies, node based materials, and script embedding technology. Blender has a feature set that is robust, and is comparable to high-end software such as Maya Cinema 4D, LightWave, and 3ds Max.

Download Blender

You can download the latest version of blender from the following link :

Now install blender through terminal (command line tool) with the following command:

sudo apt-get install blender

To work on blender , type blender in terminal and you will get the following screen:

Your blender is ready to work 🙂

Installation of Yii Framework based on PHP.

Introduction to Yii

Yii is a high-performance PHP framework best for developing Web 2.0 applications.Yii is pronounced as Yee or [ji:], and is an acroynym for “Yes It Is!”.

Yii is a free, open-source Web application development framework written in PHP5 that promotes clean, DRY design and encourages rapid development. It works to streamline your application development and helps to ensure an extremely efficient, extensible, and maintainable end product.

Steps to install Yii

  • Download the latest Yii package and unpack it in your web accessible directory (/var/www).
  • Make sure that the unpacked Yii folder should have following files/directories:

demos/                 demos      

framework/           framework source files      

requirements/        requirement checker      

CHANGELOG      describing changes in every Yii release      

LICENSE              license of Yii      

README              this file      

UPGRADE            upgrading instructions


The minimum requirements by Yii is that your Web server supports
PHP 5.1.0 or above. Yii has been tested with Apache HTTP server Linux operating systems.
Please access the following URL to check if your Web server reaches
the requirements by Yii, assuming “YiiPath” is where Yii is installed:

Example : http://localhost/Yii/requirements/index.php
It will show the following screen if it is satisfied with requirements.

Quick Start

  • On command line , type in the following commands :

                       $ cd YiiPath/framework

 $ ./yiic webapp ../testdrive 

Yii comes with a command line tool called “yiic” that can create
a skeleton Yii application for you to start with.

The new Yii application will be created at “YiiPath/testdrive”.
You can access it with the following URL:


That all 🙂

How to Install Limesurvey2 Release Candidate 2 (LS2RC2) on Server.

This version of limesurvey has released but it is not stable because it is under development not completely developed. I installed it to test it & to report the bugs in it.

Follow the steps to install the Limesurvey 2.0 RC2:

  • Go to the following link to download the limesurvey version 2(not yet released) and click on the suitable package.


  • After downloading it , extract it and then upload this extracted folder on server by using following command in terminal (alt+ctrl+T):

$scp -r /path/to/extracted folder folder_name username@server IP address:~/home_directory

         For Example :

$  scp -r /Desktop limesurvey2RC2 rimpy@

Note: This package is not having complete files and folders as were in the limesurvey 1.92+ (released version).

  • Copy the files and folders from the limesurvey folder which you have installed earlier  & paste those files/folders in your new limesurvey folder.
  • Go the config.php file and make the changes as follows:
  1. $databaselocation   =   ‘localhost’;
  2. $databasename       =   ‘ ‘;
  3. $databaseuser       =   ‘root’;
  4. $databasepass       =   ‘ ‘;
  5. $dbprefix           =   ‘lime_’;
  6. $rooturl            =   “http://{$_SERVER[‘HTTP_HOST’]}/path/to/limesurvey2RC2”;
  7. //Installation Set up
  8. $defaultuser  = ‘admin’;
  9. //This is the username when Limesurvey is installed and the administration user is created on installation
  10. $defaultpass  = ‘password’;
  • In the above url, if your limesurvey folder is different than “limesurvey2RC2” then you also have to reflect that changes in $rooturl variable. To do that simply replace the name folder at the end of the $rooturl variable with newer one. See the line 6 in above code.
  • Now go to your server link (e.g and click on the uploaded folder as in my case it is limesurvey2RC2.
  • Then it will start actual installation steps.
  • First it will ask you about default language selection that will be used throughout the whole installation process.Screenshot is shown below:

  • After selecting the language click on the start installation button.
  • In next step , it will ask you about the agreement with GNU General Public License.

  • Click on the “I accept” button .
  • After doing agreement, it will check for the requirements for your Limesurvey2.0RC2 & also report the permission errors if any.

  • After setting permissions, click on the try again button it will show the following screen with next button.

  • Click on the next button & it will then ask for database configuration as in following screen.

  • Giving the  suitable information in mandatory fields & click on the next button.
  • Then it will ask you to populate your database which you have created.

  • Click on the populate database button.
  • Then it will ask for the optional settings as shown in below screen.

  • Click on the next button & it will show the screen of successful  installation with username & password.

  • Click on the administration button & it will show the first login screen as below.

  • Give your username (in most of cases it is “admin“) & password & after login it will show the following Limesurvey screen.

  • Your Limesurvey tool is ready to create surveys .

Thats all . Enjoy with different surveys 🙂

How to insert Google Map Service in Limesurvey.

Limesurvey supports Google Map Service in questions. It will ask the user to point out the location with balloon and it will automatically give values of latitude/longitude in the text box.

To insert Google map in any survey , you need to get an API key .Using an API key enables you to monitor your application’s Maps API usage, and ensures that Google can contact you about your application if necessary.

How to get Google Maps API:

  • Create your Google account.
  • Visit the APIs Console at and log in with your Google Account.
  • Click the Services link from the left-hand menu.
  • Activate the Google Maps API v3 service.
  • Click the API Access link from the left-hand menu.
  • Your API key is available from the API Access page, in the Simple API Access section.

How to use Google API key in Limesurvey to use Gmap service :

  • Create the question in which you want to use Google Map Service.
  • Choose the question type “Short free text“.
  • Go to advance settings & choose “Google Maps” in “Use mapping service” option.
  • Set “default position” option to “Yes” if you want to set any default position on map.
  • Set “zoom level” to appropriate value. (say 20).
  • Give latitude/longitude values of the default position in Default Position text box if you set it to yes earlier.
  • Give settings of map width & height according to your wish.
  • Save the question.

Global Settings :

  • In the main administration toolbar , click on the global settings icon as shown below:

  • In Global Settings , go to the General Settings  & give the Google API Key in “Google Maps API Key“.(which you got in Simple API Access section).

  • Click on the save settings & your map service is ready to use.

Enjoy different locations on map 🙂


Creating Quiz in Limesurvey using Assessments.

LimeSurvey has the ability to create “assessments” on your survey , even for multilingual surveys.

Assessments are rules which evaluate the responses to a survey immediately after it is submitted, and then display text blocks to the participant based on that evaluation.

Example :

Suppose you have two questions in your survey.

Q1) “Sum of 2 and 5 ? ” and the question is given with three possible answers (i) 7 with assessment value 5 (ii) 8 with assessment value 0 (iii) 10 with assessment value 0.

Q2)”Difference of 10 and 5 ? ” and this question is given with three possible answers (i) 7 with assessment value 0 (ii) 5 with assessment value 5 (iii) 3 with assessment value 0.

If the participant answer both the questions with right option then he/she will score 10 marks at the end.

How to use Assessments ?

  • Go to the General settings & then to Notification & data management.
  • Set the Enable assessment mode? to Yes & then save.

Set assessment value for each answer

After enabling the assessment mode,when you now edit an answer of a question you will see an additional field right beside each code field where you can set an assessment value for that answer. As shown in given screen shot:

Define Assessment Rules

  • To set assessment rules, click the assessment icon Image in one of the menus on the survey administration tool bar.
  • You will see the following screen after clicking on the icon:

In the “Add/Edit” box you can choose the following:

  • Scope: It is the scope of the assessment. Choose either “Total” which will create an assessment based on the sum of all the answers in the entire survey, or you can choose “Group” which will create an assessment based on the sum of all the answers in a group (chosen in the next row).
  • Group: If the scope of this assessment is for the current “Group”, from here you have to choose which group you want to assess.
  • Minimum: The minimum “sum” of answers to which this assessment will apply.
  • Maximum: The maximum “sum” of answers to which this assessment will apply.
  • Heading: The heading of the assessment which will display to the participant if this assessment is shown.

Example : Assessment PASS  or Assessment FAIL.

  • Message: The actual message for this assessment. Inside the message you can use the tags {PERC} or {TOTAL} to show the related score in that particular message.

                    Example: Congratulations

                     You Scored {TOTAL}

  • You can create as many assessments as you like, and you can create more than one assessment to display for a given score.

Note :It is important to note that if you use assessments, you must ensure that you have not chosen to autoload the URL at the end of the survey in the general survey setup, because the assessments only show on the final “completed” page after submitting a survey.

Assessment Placeholders :

When using assessments the following placeholders are available:

  • {PERC}: Displays the score of the current group. Only available at assessment message.
  • {TOTAL}: Displays the total score. Only available at assessment message.


Hope it will help you a lot.