This article will help you to upgrade Ubuntu 12.04 LTS to Ubuntu 14.04 LTS. Read more about Ubuntu 14.04 LTS.

Note: Before starting release upgrade on Ubuntu, We recommend to take backup of impotent data to other remote system or backup drive. We do not grantees that below steps will work for you properly. The commands use in this article has been taken from here.

To download Ubuntu 12.04 Trusty Tahr ISO images, Visit to http://releases.ubuntu.com/trusty/

Step 1: Install Ubuntu Core Update Mamanger

Generally update-manager-core was installed on system by default, but in case you do not have it, You can install it using following commands.

$ sudo apt-get update
$ sudo apt-get install update-manager-core

Step 2: Check Current Version and Available Upgrade

To check your current running version use lsb_release command.

$ lsb_release -a

LSB Version:    core-2.0-ia32:core-2.0-noarch:core-3.0-ia32:core-3.0-noarch:.....
Distributor ID: Ubuntu
Description:    Ubuntu 12.04 LTS
Release:    12.04
Codename:   precise

Now check for new Ubuntu release available to update

$ sudo do-release-upgrade --check-dist-upgrade-only --devel-release

Checking for a new Ubuntu release
New release '14.04' available.
Run 'do-release-upgrade' to upgrade to it.

The above output showing that newer release 14.04 is available to upgrade

Step 3: Upgrade to Ubuntu 14.04 LTS

Lets execute following command to upgrade ubuntu release to Ubuntu 14.04 LTS (Trusty Tahr).

$ sudo do-release-upgrade --devel-release

The above command will take long time to execute depends on your system configuration and internet speed. This will also ask for confirmation to proceed. Using –devel-release will upgrade to development (Unstable) release

Read More

If you are trying to connect with remote mysql database to perform remote management or connectivity with some web app to add data into the db , and sees the following error

Connection failed: Access denied for user ‘zaib’@’x.x.x.x’ (using password: YES)

OR

Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server

Then you need to grant access to the user from any hostname. This is how you add new privilege from mysql command line.

NOTE: Please beware that this is for just example purpose only , and you MUST take good security measures like Strong Password, and allow only specific IP address to access etc.

CREATE USER 'zaib'@'localhost' IDENTIFIED BY 'zaib1234';

 

GRANT ALL PRIVILEGES ON *.* TO 'zaib'@'localhost' WITH GRANT OPTION;

 

CREATE USER 'zaib'@'%' IDENTIFIED BY 'zaipassword';

 

GRANT ALL PRIVILEGES ON *.* TO 'zaib'@'%' WITH GRANT OPTION;

 

FLUSH PRIVILEGES;

Sample PHP page to test Remote Mysql connection

Now you can test it with sample php page. change the host name of remote mysql server, and the id , password we just created in above steps.

<?php
$servername = "remote.mysql.host.ip.or.name";
$username = "zaib";
$password = "zaibpass";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully. Hurraahhhhh/Alhamdolillah";
?>

Read More

Mikrotik hotspote login page Free Download

Green Hotpost login page have Packages, Services and Contact Us pages.

Read More

Below i will show you how to block facebook and youtube sites using Mikrotik L7 Protocols (Layer 7). here i use RouterBoardOS RB1100.

STEP 1:
you have to create new Regexp rule at Layer7 Protocols by Press  , and name it as “DENIED” (withoue quote), see details below:

You can Copy & Paste the code above at below:

^.+(facebook.com|youtube).*$

STEP 2:
Now create Filter Rules, as follow:

At General Tabs for Chain, Please Choose : Foward

At Advanced tabs, select ‘DENIED’ (rule that you have create at step 1) for Layer7 Protocols

Choose Action ‘DROP’

And At last, your Filter rule to block facebook and youtube should have effected to your network.

try to access facebook & youtube, and you will see that the two sites will not able to access.

this can be see from the filter rule you have created, it will catch the bytes for denied sites in your network.

Read More