Drupal
1. Drupal new version installation was giving error on ubuntu. After asking query on IRC the answer was drupal database needs to be created with following options and then web installation works properly without any errors.
CREATE DATABASE drupal7 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE
utf8_general_ci;
Also one can check PHP RAM size and increase it to 512 MB instead of 128 MB.
2. To enable drop down menu in default bartik theme it is necessary to first download nice_menu and install it and then open /drupal/themes/bartik/templates/page.tpl.php and remove line from 128 to 139 and add following lines
<?php
// id, direction, depth should have the values you want them to have.
$menu = theme('nice_menus', array('id' => 0, 'direction' => 'down', 'depth' => 5, 'menu_name' => 'main-menu', 'menu' => NULL));
print $menu['content'];
?>
3. Also found other easy way to get drop down in default batik theme using superfish menu. We need to install superfish and libraries module and enable both these modules. For superfish while selecting configure option select as number of blocks as '1'. Then download superfish libraries from
https://github.com/mehrpadin/Superfish-for-Drupal and download zip file and then unzip this file and rename it as superfish and move this folder to drupal/sites/all/libraries/ and then in drupal installation click on Configuration-Superfish and carry out configuration to use superfish block in header section and as a main menu. This easily enables superfish to use drop down menu in main menu in bartik theme. Also enable this single superfish block in structure-blocks-Superfish-header area. I referred following link to understand this feature
http://www.practicalclouds.com/content/guide/proper-drop-down-menus-superfish