Install LAMP (Linux Apache MySQL PHP) & Drupal

PART 0 - DOWNLOAD DRUPAL

1. Download the latest Drupal from here.

PART 1 - INSTALLING & CONFIGURE LAMP (Linux Apache MySQL PHP)

STEP 1 - Installing APACHE

1. Open a terminal and type:

sudo apt-get install apache2

2. To make sure that Apache is installed open a web browser and type:

http://localhost

3. You should see something like this:

STEP 2 - Installing PHP

1. Again open a terminal and type:

sudo apt-get install php5 libapache2-mod-php5

2. Now you must restart Apache:

sudo /etc/init.d/apache2 restart

3. To ensure that there are no issues with PHP run:

sudo gedit /var/www/testphp.php

4. A file called testphp.php will open.
5. Copy and paste the following into the testphp.php
6. Save the file and exit
7. Now open a web browser and type:

http://localhost/testphp.php

8. If it works then PHP is installed!

STEP 3 - Installing MySQL

1. Open a terminal and type:

sudo apt-get install mysql-server

2. The above command will install MySQL
3. Now comes the tricky part!
4. Log in MySQL by typing:

mysql -u root -p

5. Now you need to set a password (Change yourpassword with the password you want. Do not remove ' '. Type your password between ' '.)

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

6. For example:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('12345');

7. The next step is installing phpMyAdmin (A tool for editing your databases)

sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

8. Now you must edit the php.ini file in order to get PHP to work with MySQL

gksudo gedit /etc/php5/apache2/php.ini

9. Uncomment the following line by removing the semicolon (;)

;extension=mysql.so

10. For example:

extension=mysql.so

11. Finally restart Apache:

sudo /etc/init.d/apache2 restart

That's it your web server is up and running!

PART 2 - DRUPAL

1. Open a terminal and type:

sudo gedit /etc/apache2/apache2.conf

2. apache2.conf will open
3. In order for Drupal to functioning properly with Apache and PHP type the following at the the end of the file:

AddType application/x-httpd-php.html

4. Click Save
5. Now it's time to create a Database
6. Type the following and enter your password:

mysql -u root -p

7. To create a Database type:

//Use whatever name you like instead of drupal
CREATE DATABASE drupal;

8. Now you need to create a user

CREATE USER yourname@localhost;

9. Finally define a password for the newly created user

SET PASSWORD FOR yourname@localhost = PASSWORD('yourpassword');

10. Now you need to grand permissions for the user

GRANT ALL PRIVILEGES ON drupal.* TO yourname@localhost IDENTIFIED BY 'yourpassword'

11. Go to the location that your Drupal was downloaded in PART 0 and unpack it
12. Then copy the unpacked Drupal folder to /var/www/

cp /home/user/Downloads/drupal-7.21 /var/www/

13. Now head to /var/www/ and change directory to drupal

cd drupal-7.21

14. Change the permissions

sudo chmod a+w sites/default

cd sites/default

15. Copy default.settings.php to settings.php

cp default.settings.php settings.php

16. Change the permissions

sudo chmod a+w settings.php

17. Finally create a directory named files

sudo mkdir files

18. and change permissions

sudo chmod a+w files

19. That's it!
20. Now open a web browser and type:

http://localhost/drupal-7.21

21. Finally follow the on screen Drupal instructions to install Drupal

[HOW TO] Extract frames from video - Linux

To extract frames from a video do the following:

Install ffmpeg:

sudo apt-get install ffmpeg

Then decide how many frames you want to extract and do one of the following:

To extract each and every frame:

ffmpeg -i Video.mpg Pictures%d.jpg

For example:

ffmpeg -i /home/user/Desktop/Video.mpg Pictures%d.jpg

If you want to specify the number of frames to be extracted, the quality of the extracted frames or to start extracting from a particular point adjust your command by adding one of the following flags or all of them.

• -r How many frames you want to be extracted per second (The default value is 25).
• -f Defines the format.
• Picture%3d.jpg %3d means that the names of the images will be like Picture001, Picture002 and so on. You can use any format you like.
• -s You can define the image size.
• -t You can set the duration of the extraction.
• -vframes You can define how many frames you want to be extracted.
• -ss Defines the time you want the extraction to start.

For example:
To extract 1 frame every second type:

ffmpeg -i Video.mpg -r 1 Picture%3d.jpg

To extract the frames from the first 10 seconds of the video type:

ffmpeg -i Video.mpg -t 10 Picture%3d.jpg

To start the extraction at a given time type: (for example: 0:34:14)

ffmpeg -i Video.mpg -ss 0:34:14 Picture%3d.jpg

To define the number of frames you want to be extracted type: (for example 80)

ffmpeg -i Video.mpg -vframes 80 Picture%3d.jpg

You can also be more specific by using all of the above flags together:

ffmpeg -i Video.mpg -r 2 -t 150 Picture%3d.jpg

The above command will extract 2 frames per second for 150 seconds.

[HOW TO] Install Guitar Pro - Linux Ubuntu 64bit

1. Download the latest .deb from Guitar Pro's website.
2. install ia32-libs by typing:

sudo apt-get install ia32-libs

3. Now you need to edit the .deb file to remove the gksu dependency.
1. To do that you must create a script first.
• To create the script open a terminal and type:

vi debscript

• This will create a new file named debscript.
• debscript is just an example name. You can use whatever name you want.
• Now type or copy/paste the following:

#!/bin/bash

if [[ -z "$1" ]]; then
  echo "Syntax: $0 debfile"
  exit 1
fi

DEBFILE="$1"
TMPDIR=`mktemp -d /tmp/deb.XXXXXXXXXX` || exit 1
OUTPUT=`basename "$DEBFILE" .deb`.modfied.deb

if [[ -e "$OUTPUT" ]]; then
  echo "$OUTPUT exists."
  rm -r "$TMPDIR"
  exit 1
fi

dpkg-deb -x "$DEBFILE" "$TMPDIR"
dpkg-deb --control "$DEBFILE" "$TMPDIR"/DEBIAN

if [[ ! -e "$TMPDIR"/DEBIAN/control ]]; then
  echo DEBIAN/control not found.

  rm -r "$TMPDIR"
  exit 1
fi

CONTROL="$TMPDIR"/DEBIAN/control

MOD=`stat -c "%y" "$CONTROL"`
vi "$CONTROL"

if [[ "$MOD" == `stat -c "%y" "$CONTROL"` ]]; then
  echo Not modfied.
else
  echo Building new deb...
  dpkg -b "$TMPDIR" "$OUTPUT"
fi

rm -r "$TMPDIR"

• Press Esc.
• Now to save the file

type :w

• Finally to quit vi

type :q

2. Now its time to edit the .deb file.
3. Move the script in the same folder as the Guitar Pro .deb file.
4. You now need to make debscript executable.
5. Open a terminal and type:

chmod +x debscript

6. Then type:

debscript gp6-full-linux-r11201.deb

7. Now delete gksu.
8. To delete gksu move next to gksu and press x.
9. To save the edited .deb file hit Esc and

type :w

10. Exit by

typing :q

11. A new file named gp6-full-linux-r11201.modfied.deb will be created.
12. Do not close the terminal until the new .deb file is created.
4. You can now install Guitar Pro 6.
5. In the same terminal or in a new one type:

sudo dpkg -i gp6-full-linux-r11201.modfied.deb

6. That's it! Enjoy!

[HOW TO] Create a script - Linux

This tutorial will show you how to create a script in Linux. In this tutorial I am going to use vi. You can also use gedit or anything else if you want.
Open a terminal and type:

vi (name of the script)

For example "testscript". This will create a script named testscrip.

vi testscript

vi editor will open.
Now its time to start writing your script. Below is an example of a basic script that launches Firefox:

#!/bin/sh
echo “welcome”
firefox

Save your script by pressing Esc. Then:

Type :w

Quit vi by:

Typing :q 

Next type the command below to make the script executable:

chmod +x testscript

Finally to run the script type:

./testscript

That's it! Enjoy creating scripts!

[HOW TO] Install Cinnamon - Ubuntu/Fedora

To install the latest Cinnamon on your Linux Ubuntu/Fedora do the following:

• Ubuntu

• 12.04/12.10

Open the terminal and add the repository

sudo add-apt-repository ppa:gwendal-lebihan-dev/cinnamon-stable

Update the database

sudo apt-get update

Install Cinnamon

sudo apt-get install cinnamon

After the installation is complete log out and choose cinnamon.

• 11.04/11.10

Open the terminal and add the repository

sudo add-apt-repository ppa:merlwiz79/cinnamon-ppa

Update the database

sudo apt-get update

Install Cinnamon

sudo apt-get install cinnamon

After the installation is complete log out and choose cinnamon.

• Fedora

Before the cinnamon installation check if your system is up-to-date
Open the terminal
Once inside the terminal login as root

su --login

Check for updates

yum updates

Install Cinnamon

yum install cinnamon

After the installation is complete log out and choose cinnamon by clicking Session.

[HOW TO] Access files/folders with spaces - Linux

If you want to access a folder that has a name with a space for example the folder named New Folder do one of the following:

// If it's the only file/folder that starts with Ne

$ cd Ne*

// Or by using \ after each space

$ cd New\ Folder

// By using " "

$ cd "New Folder"

// By pressing Tab

$ cd (press tab)