Installing webmin in Ubuntu server

Dear friends,

In our last post we see that how we can access our home ubuntu server online. After installing the ubuntu server we have only the default webpage of the server is available to access from any browser. And we cannot access the command line of the server from other computers. If we need access the command line of the server from other computers, we have to use the putty software in the clint computer. And by using the username and password we can access the server. Otherwise  the command line of the server can directly access through the connected monitor of the server. But managing the server through only the command line is little difficult, util you are not expert in that. So in this post we will explain  how to Installing webmin in Ubuntu server. This will act as a interface between server and us. through this we can easily manage our server. And it can access from browser of any computers. So after the installation of webmin wecan remove  server monitor and other accessory.

Installing webmin in Ubuntu server

Please proceed the following steps to install webmin in you ubuntu server.

Copy and paste below cmand in your command line of the server and hit enter. This command is use to down load the latest version of the webmin package to our server.

wget http://www.webmin.com/download/deb/webmin-current.deb

Run the below command. It is used to update the apt-get index file for latest updates of the packages. And this step is very important.

sudo apt-get update

Run the below command to get required dependency for the webmin package.

sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-sh

Now we can run the below command to install the webmin package.

sudo dpkg --install webmin-current.deb

After the successful installation ww can see the output saying that,

Webmin install complete. You can now login to https://ip-XXX-XX-XX-XXX:10000/
as root with your root password, or as any user who can use sudo.

Now at this point we can access the webmin  package of our server through any browser in our home network. For that we have to type https:our server ip:10000.

now we can see our webmin control panel as shown below.

webmin control panel

By this control panel we can do almost everything to our ubuntu server. If you need any help and support regarding this matter you are welcome to contact us through our forum.

thanks and regars

 

How can access our home router from outside home (port forwarding)

Introduction

Dear friends In my last post I wrote about how we can setup an ubuntu server. And also we see that how we can access our server in the browser of any devices connected in our home network. In this post we will study how we can access the server from outside our home and how we can do the port forwarding , that means anywhere from the world. for that purpose we have to study two things. One is remote management of router and other is port forwarding. That I will explain below one by one.

Remote management of the router

In this section we will study how we can enable the remote management of the router. Through this we can enable or disable the remote management of the router. After enabling this option we can access the router from outside our local network. To access the remote management enabled router from outside, we have to type the public IP address of our router in any browser of the device which is connected with the internet. Then  we can see the default gateway page and we can make any changes of the setting of the router from outside. In order to connect the router from inside our home we can directly type the default gateway IP  address in the browser of any computer connected in our home network.

Practical example

In this Example we will see how we can enable the remote management of the TPLINK router. Once you understand this setting in the TP LINK router we can do with other company model also.

Consider your home network is connected with a TP LINK router. Open your favorite browser like google chrome, and type ( 192.168.0.1), this is the default gateway ip address of your router. By default all the company is normally set this IP address as the default ip address of the device. If your computer and router is connected properly and you are not getting the default page of the router, then please check the default IP address of your particular router in its operating manual. The default username and password can also see in the manual. For TP LINK the default user name is admin and password is adminadmin.  For D-LINK the username is admin and password is blank.

TP link router port forwarding
TP link router port forwarding
CHANGE setting
  1. Once you connected properly you can see the page as same as above. Now we can go to the security option, remote management. In that page we can see two option,  first one is web management port. the default value of this is 80. We can keep this value as it is. But some internet service provider block this port or incoming traffic, That case you can change this port number (0_65000). If you change this port other than 80, then we have to type the public ip address like “publicipaddress:new_port_number”. In order to get your public IP address you can search “public ip” in google ad you can see that. Or you can see the ip address under status option of the router, in than under WAN we can see the IP address.
  2.  the second option is Remote Management IP Address:. The default value is 0.0.0.0. we have to change this value 255.255.255.255. So that we can access the router from any computer from anywhere. If you want only allow the access from a particular IP you can mention that IP here. Please also remember to change the default password of the router under the system  tools menu, password option.  
Port forwarding

In the above section we studied how we can access the router from anywhere. In this section we will see how we can access our or office ubuntu server from anywhere. For that we have to do port forwarding function. In order to do that please go to the forwarding menu of the router.

Here we can enter the service port number example 1213. Internal port  example 80. IP address, this is our ubuntu server IP address which we note it down in a paper during the installation. So now someone browse our “public ip address: 1213” the he/she will get our ubuntu server default page. So at this point anyone can get our server content like audio, video and images if we kept that in our server. for public use.

Making server IP as static

In the above section we see that how can we access home  server from outside. But please remember the router will forward the incoming traffic to the server always in the server IP we mentioned in the port forwarding section. But we have to know that the router may assign different Ip address to all devices connected to it through it DHCP  server at different time. This is called dynamic IP address allocation of the router. So we have to keep our ubuntu server have a constant IP.  For that we have to go to the DHPC menu of the router. From that menu  go to Address Reservation option and click on add new. Then enter the mac address  and the IP address of our ubuntu server, which we noted down in a paper during the installation of the server. the s=ave the setting and re boot the router. That it.  Now we can always access our home server from anywhere through our public ip address and the port number we assigned to it.

If you require any support regarding this mater always you can contact through our forum

Thank you for reading this article.

 

Uses Of Ubuntu Server In Our Home or Small Business

How to install ubuntu server in our home computer

Dear friends

In this post  I like to explain the uses of a Ubuntu server in our home. And also I will explain How to install ubuntu server. Before that I like to tell you what is a server . A server can made up with any computer by installing the server software. A server can provide lot of services to  all other  computers or mobile phone and other devices  in our home. as well as it can be access from our outside home. Ubuntu server is a open source free licensed server software from Linux. So everyone can use it freely without violating any privacy policy.

How to install ubuntu server

For a home application we can select any old or new computer to make a Ubuntu home server. The monitor, keyboard, mouse are only required for the installation only. For the normal working of the server only the cpu is enough. Installation is very simple and all the step by step instruction is given in this article , if you have any doubt for setting up the Ubuntu server at any point you can contact me through  our Technology forum. After installing the server as explained in the article we can make the use of the server as in the following ways. You can also see the released version of ubuntu server here

Uses of ubuntu server
  1. File storage: The ubuntu server can use as a files hub for everybody in the home. everyone can use to store their files and access it from any devices connected int the home. It can also be access from outside home. we can also upload our huge number valid document to it. And can be very easily accessed by search with in seconds. And this type of data can be save permanently and cannot be deleted, so it will be available in our whole life. As people are accessing the server through browsers for there file, they cannot make any damage to the server so it will run long time without any error.
  2. Samba file sharing: By this we can make common folders in the server. And that folder can access from any device in our home, as one of the folder in that device itself.
  3. Office management: By  use of this server we can manage our office functionality like accounts, Invoice, customer , supplier register and much more as required. Please see the demo software for our hardware shop.

These are some of the uses only we can also make use of lot of things like Email Server,webserver, database server, CCTV camera system, intercom IP phone network and much much more.

How to put the server in functionality
How to install ubuntu
How to install ubuntu

After completing the installation  as mentioned inthe how to install ubuntu server ,  wecan log in to the server by giving the username and password. Then the server will show the command prompt in the screen. Please remember to connect the internet or in the home network from the beginning of installation and keep it always. Now we can run the below command in the cond line.

ifconfig

It will show your network card along with it mac address and connected IP address, please note them in a paper. Remember that, the IP address may change time to time. This is because the server, other computers in the home network is connected to the home router. This router have a dynamic DHCP server and it will change the  IP address to the connected devices time to time. Please make the server IP address static in the router so the Ip address will be same always. Now you can access your new server from any connected device in your home network. For that we have to type the ip address of the server in the browser. So it will display the default webpage in the server.

Please we remember to ask any doubt at any time through the forum above mentioned.

Thank you

How can show PHP,HTML AND JAVASCRIPT code in wordpress post

PHP tutorial part-02

showing codes in wordpress

Dear friends,

In this post I like to write about how we can write PHP, HTML and JavaScript code in a wordpress post. If you write the code in plane text it will not appear in the  browser properly.  And if somebody copy and paste that code in their program it will not work properly so we had to write the codes in a different method in the wordpress post. in this post I will explain the two different method of how we can write the PHP, HTML and JavaScript code in the wordpress post.

Method-1

In the first method  click the post edit window, at the point where we want to insert the code. Then click to the text editor, that is available in the right side top corner of the editor window. There we can change the editor mode in Visual or text mode. In the text mode you can click on the code tab from the top menu, then it will open a code opening tag in the writing place. Then we can manually type <pre>tag. Now you can type or paste your actual code which one you want to show to your reader. Then close the </pre> tag first and click on the code tab on the top menu, then  code tab will be closed automatically. Now you can change  the editor mode in visual, and you can see your code in a coloured box. Now you can change the color of the text also. Her the code tag will say the browser to execute the thing inside the code tabe as a html code and the pre tag is the code to execute the things inside it as a plane text as it is without any modification or change to it. So the reader can copy and paste this code in there programs.

Method – 2

In this method you have to use one wordpress plugin. The name of the plugin is “tiny MCE” advanced. For checking weather this plugin is installed in your WordPress, you have to log in your wordpress account and in the left side navigation bar go to the plugin option.  If it is not installed click on the add new plugin tab at the top side. after installing the plug-in, activate and go to the setting of the “tiny MCE advaced”. We can add lot of the editing tools here.Please add the code tab. Now click on the save changes button and can go to the post option in which post we want to show the PHP or HTML codes. Inthe post editor window paste the code, which you want to show your reader,  and select them with mouse and click on the code tab in the toolbar. That is it, now your code will be shown to your reader as it is, and the reader can copy and paste the code  in their application. In this case that box background  will not be made ask like the first method. I hope this article is helpful for you. If you have any doubt please give me a comment surely I will give a reply.

Thank you for reading



Easy And Tasty Garlic Pickle

Hi friends,

In this post I like to explain you how we can make a very tasty and easy garlic pickle please read my post fully.

INGREDIENTS

Garlic 900 gram

Ginger chopped – 50 gram

Gingelly oil [ nalana ] – 300 ml

Curry leaves – five leaves

Kashmiri Chilli – 5 tablespoon

Yellow powder – 1 teaspoon

Fenugreek powder – 1 teaspoon

Kayam powder [Asafoetida powder] – 1 teaspoon

Salt – As required

Procedure

Clean  the  garlic  by  removing  the  outer  cover. Cut  each  piece  of  Garlic  into pieces  by  its  middle. Please  take  around  hundred  gram  of  garlic  and  chop them. Then  keep  it  in  a  bowl. Now  clean  the  Ginger  also  chop  and  keep  it  in the  bowl. Then  Keep  a  pan  on  the  stove  and   put  the  gingelly  oil  [ nalana ] and  wait  till  it  boil. Then  put  the  chopped  Ginger  and  garlic  together  in  the pan. And  stir  until  the  garlic  and  Ginger  get  golden  brown  color. Then  we  can  put  the  chilly  powder  yellow  powder  along  with   Kayam   powder [Asafoetida  powder]  in  the  pan  and  mix  well. Now  we  can  put  the  garlic which  we  previously  kept  ready.  And   boil  until   2-3  minutes  without  adding any  water. After  that  switch  off  the  stove. After  sometime  we  can  add  2-3 tablespoon  Vinegar. And  also  add  the  salt  as  required.

Now  our  tasty  garlic  pickle  is  ready!

Garlic pickle

Yummmm!

Thank  you!  for  reading  our  article.

 

Various PHP SQL statement for reading database data from a table

php tutorial

Hi my dear friends,

In my last post I wrote about the how we can read and display multiple rows  of data from a mySQL database server. In that Post I used the following my SQL statement to read the data from the table.

$sql="SELECT * FROM material_transaction_register WHERE search1 LIKE '%$q%' ";

So now I will explain the structure of the statement. In the above SQL statement the SELECT , FROM, WHERE and LIKE are the keywords. The table name is the name of the table from where we want to fetch the Data.  search1 is one of the column name. Now I will explain how it will work . This statement is saying that,  select the table “table name” from the database which is mentioned in the connection parameter. And from that table verify the data from the column name “search1” . And also saying that  the data should be “LIKE” the variable mentioned in the single quote. The percentage symbol shows that, any word before the variable and ANY WORD after the variable is not considering, that means if a sentence in the Column name search1 having the any word same like the “q” variable then that row will be selected for fetch. All this type of selected row will be fetch and asigned to the variable “sql”.

2. 

$sql1 = "SELECT * FROM table_name WHERE search1 = '$item_code' ";

In the second SQL statement is also work same as the first one. But in this case it will select the rows from the table_name table wherever the column name “search1” have the value exactly same as “item_code” variable. Here in the single quote we are declare a variable, you can also directly place any string there. So this SQL statement will send all the rows to the sql1 variable from the table wherever the search one column have data exactly equal to the item_code variable.

3.

$sql="SELECT * FROM table_name ORDER BY id DESC LIMIT 25;";

Here is the third SQL statement. This one is one of the very important SQL statement, because it is generally used to read the entire data from a table.  In the previous SQL statement we are used WHERE keyword to select the rows but in this case we are using ORDER BY keyword which will select all the rows in the column name “id” and DSE keyword is used to store this rows in descending order. Instead of DSE we can use ASC for ascending order.  and the LIMIT keyword is used to limit the number of rows to 25 in this case. We can adjust this number as per the number of rows required. We can avoid to use the limit keyword along with it number, so that all the rows will be assigned to “sql” variable.




Here Also we can see that the keyword ORDER BY , DSC/ASC and LIMIT can also  use with the SQL statement 1 and 2 given above as shown below. In this type of case the rows will be selected from the column  name “search1” according to the condition. And it will be ordered by ascending or descending manner according to the  column name “id” .

$sql="SELECT * FROM table_name   WHERE search1 LIKE '%$q%' ORDER BY id DESC LIMIT 100 ";

$sql1 = "SELECT * FROM table_name WHERE search1 = '$item_code' ORDER BY id DESC LIMIT 100 ";

4.

$sql1 = "SELECT * FROM input_vat_register WHERE id = 10 AND time_stamp = 1529359200 ";

Here the fourth SQL statement is the one of the greatest SQL statement. Because it is playing with multiple columns, here input_vat_ register is nothing but the name of the table. By using the WHERE keyword we are checking to column name  “id” and “time_stamp”.  Both conditions are connected with and operator, so whenever both condition will be satisfy the row will be selected for fetching. Instead of and we can use OR also, in that case if any one of the condition satisfied then particular row  will be selected for fetching. Here  the conditions are equal to operator but we can use less than or greater than or combination of both. We can also use this one to select a rose from the single column . For example if you have a column name “date” then we can check the condition of rows lying between two particular dates, by using the less than or greater than operator. Here we can connect more than two conditions also with operators but that one I am not tested. I hope by the use of these combination of  things you can make various type of data reading operation from mySQL database table. If you have any doubt regarding this topics please give me a comment. So that I can help you. Thank you for reading this post.

Nadan Chembu Curry Recipe [Colocasia]

Hi Friends,

Welcome Back , Today I Am Going To Share you a Recipe of a tasty Nadan Chembu Curry [Colocasia]

Also See The Ingredients Below

INGREDIENTS

Colocasia – 7 Psc

Chilly Powder – 1 Teaspoon

Yellow Powder – Half Teaspoon

Curry Leaves – 5 leaves

Red chilly – 3 pcs

Water – As Required

Scraped Coconut

Tumin [ Geragum]

Small Onion

Yogurt (curd)- 1 Cup

Mustard

colocasia ,chilly powder,
coconut and onion

PROCEDURE

Clean, cut and Wash  colocasia and put it in a bowl, along with  chilly powder, yellow powder , some curry leaves and  enough water. Place  it over  a stove and allowed  it to boil  by keep it lid closed.  And grind scraped coconut, tumin [geragum]  and small onion. Mix till this becomes smooth paste. After cook the colocasia  put this paste into the bowl and allow it to boil. Then add  yogurt (curd) and mix it . Don’t boil this time just make the curry hot. Now, take another pan  put some oil and keep it on a stove and wait the oil get hot. then put mustard and wait until the mustard flutter and add some curry leaves and  read chilly . You can put red chilly or green chilly. Also fry these things till it gives a pleasant smell. Then put these things into the curry . This will also give good smell and decoration to the curry.

chilly and onion

Chembu curry [ colocasia ]
Hurry! Your Yummy Nadan Chembu Curry Recipe Is Ready

Nadan Fish Curry Recipe

Fish curry kerala style

Hi Friends,

I am back Again ! with a nice recipe to share with you. It is a yummy! Fish Curry [ Kerala Style ].

please see! the Ingredients below

INGREDIENTS

Fish  – 750 Gram

Mustard

Garlic

Curry Leaves

Ginger – 1 Peice

Chilli Powder – 2 Table Spoon

Fenugreek Powder [ Uluva Powder ]

Yellow Powder – Half Teaspoon

Tamarind (valen-puley) -5 Pcs in half glass water.

Water – 1 Glass

Coconut Oil

ginger and garlic
Chilly powder

PROCEDURE

Wash and keep the fish aside. Then put some oil in a muddy bowl [chatti].              When the oil is hot put mustard, then put garlic, curry leaves and ginger.                After half fry , add chilly powder and yellow powder. Mix all this ingredients together and heat well until mild smell and little smoke. Now we can add the soaked tamarind along with it’s water. Add 1 glass water more and wait until boiled well . Now add the washed fish into the muddy bowl. Shake the muddy bowl in order to spread the gravi all over the fish and add fenugreek powder . Close the muddy bowl with a lid and leave in a low flame upto 30 min. Switch of the flame and spread 1 tablespoon coconut oil and curry leaves over the curry. This will add more test and wil give decoration also to the dish. This is basically naden kerala style fish curry. This is also non as kottayam style fish curry.

Tamarind
Fish curry




Feature plans

In Order to get our more recipes please visit our cooking category . We are also requesting you to please send your suggestion and comments on below comment section. so that we can improve our posts. Our future   plan is  to make more see food dishes like prons and karimeen. And also planning to start a cooking forum for our community in this site. currently we have a technology forum in this site. Please remember to give your comment regarding to star the cooking forum.

Thank you very much for reading this post.

How can read and show multiple row of data from mysql database table using PHP

php tutorial

Hi Friends,

In this post I like to explain how we can  read and display the datas from a mysql database table using php.

Step-1

First we have to make the database connection with following php code

<?php 
$servername = "localhost";
$username = "user_name";
$password = "password";
$dbname = "database_name";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

?>

 

Here the variable $con holding the connection details. such as server address, user name, password and database name.

Now we can use the following codes to read the data from the
“table_name” table of the database “your_database_name”.

$sql="SELECT * FROM table_name WHERE search1 LIKE '%$q%'";
$result = $conn->query($sql);

$num=$result->num_rows;

$i=0;
while ($i < $num) {
$row = $result->fetch_assoc();
$id=$row['id'];
$customername =$row['customername'];
$address =$row['address'];
$contactname=$row['contactname'];
$contactnumber=$row['contactnumber'];
$fax_no=$row['fax'];
$tr_no=$row['trn'];

?>
<div id="menu" style="background-color:#ccff99;width:5%;
float:left;">
<?php echo"$id " ?> </a>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$customername";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$address";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$contactname";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:10%;
float:left;">
<?php
echo"
$contactnumber";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:10%;
float:left;">
<?php
echo"
$fax_no";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:15%;
float:left;">
<?php
echo"
$tr_no";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:100%;
float:left;">
<hr>
</div>

<?php

$i++;
}

?>
<?php
mysqli_close($conn);
?>

Here in the first line of code the variable $sql will hold the  sql statement. The structure and different type of sql data reading statement will explain in another post.  Second line of code will connect to the database with the $con variable and request for the data as per the  $sql variable and store the result in the result variable.

$num=$result->num_rows; 

this line of code will store the total number of rows which is stored in the result variable.

At this point we will start a while loop with a variable i with initial value 0. and the loop condition is the loop will execute until the loop variable i grater than or equel to the number of row in the num variable.

$row = $result->fetch_assoc(); this is the first statement in the loop. When it execute the first row of data which is stored in the result will asigin to the variable row. $id=$row[‘id’]; Now during the execution of this statement, the value of the column name id will store in the variable $id.  Like this, as shown in the code we can get values of any column name in that particular row currently stored in the result variable. The following code is used to write out  the variable values in a table manner. In the fiel step the loop variable will increase and the loop will continue. In the second loop fetch_assoc(); function will store the second row values from the result variable to the row the variable. And this process will continue until all the fetched row is write out in a table manner.

mysqli_close($conn); This statement is used to close the database connection.

Hope this post is help full for you. And thank you for your commend.