How to design and implementing an network Part-2

How to design and implementing an network

for medium business or corporate

The article how to design andimplementing network part-1

had explained about what the point for making network plan and implementing to corporate. Example, the corporate have many employee that work using computer. From there we will split again, how many employee will be use internet when they're working and how many employee work without internet. okay let's move to do network plan for sample corporate. List of IT asset that will be use to build an business-medium network for one office branch is mentioned below:

1. 50 unit of computer
2. 5 printer server+potocopy
3. 2 printer dot matrix(optional)
4. 1 roll cable network
5. 1 box RJ45
6. 1 set Toolkit network
7. 1 unit PC Server
8. OS Ubuntu server 14.10 - setup as Server PDC + two Lan card
9. OS for client Ubuntu and Windows
10. UPS for Server
11. LAN card WIFI(Optional)
12. Switch Hub
13. Router
14. Pipe

AHS

Free networking utilities for making your network is powerfull

Free networking utilities for making 

your network is powerful

Make an network performance does not get much money to do unless you need specification to do. Here some of free networking utilities will be provided to you and perhaps becomes to reference to do best for your networking.

1. Spiceworks, this utilities can be use to manage network.
2. My ports 2010, Microsoft Network Monitor, Nagios,EasynetworkMonitor,BandwithD,etc. this utilities for check network traffic in an network.
3.ShareMonitor,Net Share Monitor, this software to keep tabs on files you're sharing over a network.
4. LastPass, an software to manage your password.
5.HostsMan,  this software for editing windows Hosts File
6.FastResolver, this software most quickly to match a batch of IP addresses to hostnames then NsLookup.
7.Untangle lite, is an software to make secure network with combination a gateway router and firewall with virus, spyware, spam, and phishing filters, and it includes VPN capabilities to boot.
8. Remote support such as teamviewer, Ammyy admin,login Me, is an software to remote desktop computer that need support from admin.

AHS

Installing Ubuntu 15.04, the next generation OS for us

Installing Ubuntu 15.04, the next  generation OS for us

Installing Ubuntu 15.04 desktop is same with old version installed. There is nothing different how to begin to install in our system. New features in 15.04 also involve to change such as:

1. Update package at rapid pace.

2. Linux Kernel 3.19

3. Boot and service management

4. Ubuntu Core (Snappy)

5. LibreOffice

6.Ubuntu Make

and other features have been change smoothly. you can refer to Ubuntu site about what a new features that release for Ubuntu 15.04.Here easy to install Ubuntu 15.04 and we need minimum system requirements such as:

1. 1 GHz processor (for example Intel Celeron) or better.
2. 1.5 GB RAM (system memory).
3. 7 GB of free hard drive space for installation.
4. Either a CD/DVD drive or a USB port for the installer media.
5. Internet access is helpful (for installing updates during the installation process). 

Here video about installation Ubuntu 15.04.

How to design and implementing an network Part-1

How to design and implementing an network

for medium business or corporate

Administrator network must have strong imagine to design a network for medium business or corporate beside his skill. Here one sample that I show you how to begin design and make network plan for corporate. of course what should you do to for making network plan and design that becomes have approved by your manager.  Without that your paper will be move to trash and make your idea is freeze. These is concept I ever made for corporate before and these case I only work my self. It begin from network design and plan without team until implementation.

1. How many computer will be connect to server
2. Router and switch that will be used
3. How many connection of internet will be share to client
4. Toolkit of network and network hardware(tester,cable, RJ45, Wireless card, Land card,etc)
5. What kind the UPS that will be use
6. Server will be active 24 hours or not?
7. Specify of server, printer server
8. Rack of server and must have Air conditioner when your server 24 hours actived.
9. Topology network and IP address
10. Application for server
11. Design firewall,SSH Server and configure.
12. other part design networking such as power/electric, stabilizer for client, OS for server, Management bandwith, management user, Create DNS, ect.

 These article only additional reference and will be continue as soon. wish usefull.

SUMPRODUCT of Function - Ms. Office Excel 2013

Sumproduct of Function - Ms. Office Excel 2013

SUMPRODUCT is meaning multiplies corresponding components in the given arrays, and returns the sum of those products.

Syntax:

=SUMPRODUCT(array1;array2;........;array255)

Remarks:

Array is fill numeric as arguments must have same dimension. when one dimension is zero, the SUMPRODUCT will be return to #Value! error.

AHS

Ms. Office Excel 2013 - About Cell and Range

Microsoft Office Excel 2013 - About Cell and Range

Understanding to know about cell and range on Microsoft Office Excel 2013 is most important. Need not bid to do when We want to work with Excel. You do not understand about what is Cell and Range when working with Microsoft Office Excel these is impossible to more work with Excel. and we have know about work with excel, everyone work with more cell, range,VBA and more function. One more time I remember you are, "take a look your time to understanding what is cell and range on Excel".

Cell in a spreadsheet is meaning intersection of row and column. example A12, it meant intersection of column "A" and row "12". Range  in a spreadsheet is meaning grouping of cell. example range of "A1:B3", it meant group of A1,A2,A3,B1,B2,B3.

1. Relative cell is meaning when you copy formula from C1 =A1+B1  to C2,that is adjust downward one by row and becomes C2=A2+B2.

2. Semi absolute cell is meaning one mark "$" both of row or colums. example

• Absolute of column : $A12
• Absolute of row : A$12

3. Absolute cell is meaning the row and column is locked and when you copy the formula it still same with source formula early. example of absolute cell is $A$12.
4. A cell reference is meaning the identifies the location a cell or group of cells in the worksheet.

Conclusion: cell and range as defenition to begin spreadsheet that most important to understanding spreadsheet work. Without that, working in spreadsheet is blind when create one formula in the worksheet.

AHS

Make Secure OpenSSH Server On Ubuntu Server 14.10

Make Secure OpenSSH Server On Ubuntu Server 14.10

1. Login as root
2. Goto /etc/ssh folder
3. Run nano -c sshd_config

4.  Change default SSH port, example : "Port 3456"  

and then run to test ssh.

5.  Disable root access via SSH : PermitRootLogin no

6.  Disable password based authentication : PasswordAuthentication no

7.  Limit user SSH to access (Allow or Deny Users/Group):

     example:   

           1. for Allow user:  AllowUsers anony

           2. for Deny user :  DenyUsers anony

           3. for Allow group: AllowGroups marketing

           4. for Deny group : DenyGroups marketing

8. Restrict SSH on network interface

      ListenAddress 192.168.111.123

      ListenAddress 202.xxx.xxx.21

9. Set idle user time interval to avoid unattended ssh session.

      ClientAliveInterval 300
      ClientAliveCountMax 0

10. Disable Host-Based Authentication :    HostbasedAuthentication no

11. Disable .rhosts Files : IgnoreRhosts yes

AHS

Install Kingsoft Office Suite for Ubuntu 14.04

Install Kingsoft Office Suite for Ubuntu 14.04

1. Login as root

2. Download Kingsoft Office from kingsoft site: "http://www.kingsoftstore.com/software"

 wget http://kdl.cc.ksosoft.com/wps-community/download/a16/wps-office_9.1.0.4945~a16p3_i386.deb

3. Next step, run and wait until installation complete.

AHS

First concept to network planning and design for networking of company

First concept to network planning and design 

for networking of company

We had know that doing task as network engineering is easy when We were understand about basic of networking and normally an administrator had basic skill of networking such as IP Address concept, how to route in the network, configure the security firewall, network plan, operating system that implement to Server, etc. and also and administrator network should be strongly to face and secure his network that most of threat come outside the network.

 
Most important to notice that I have mentioned about network plan and design does not about "a network planning methodology" concept. But concept to implementing when an company have IT asset sourcing. First step that I'm going to share is how to make network plan and design for company where we worked.

1. Specify location in each room who need of network.
2. Specify PC Server location who include support hardware networking such as Modem, Switch, AC, UPS, PC router, Mikrotik or Cisco (optional), printer server, cable network, RJ45, cable tester, and toolkit of networking.
3. Specify operating system for server.
4. Specify PC client and operating system.
5. Electric/Power
6. The company will be used WAN technology ?
7. Using WIFI connection or cable or both.
8. Specify application server that install to PC Server.
9. Specify topology design.
10. Purpose business planning, long term, medium term or short term network planning.
11. Helper administrator to do.

The basic rules above does most important for administrator networking when to do network plan and design. Without rules component of network plan, an administrator network going to work without maps. When he faced trouble in the network, He need more time to start from where to diagnose the problem come. for sample, I will share as soon.

AHS

Install MySQL/Maria DB Server on CentOS 7

Install MySQL/Maria DB Server on CentOS 7

When you have installed CentOS 7 as central server. actually you need more service that helping your performance server. such as web server when you made server as web server. automate services who needed to install is php, web server, database server (MariaDB). it depend for what your server you want. Here I show to you how to install MySQL/MariaDB on the CentOS 7.

1. Login as root

2. Mount your DVD Master CentOS 7

3. type command yum install mariadb-server and wait until finish to install.
4. After finish to install, type command systemctl start mariadb
5. type command systemctl enable mariadb
6. type command mysql_secure_installation

Configure about user MariaDB, I will share as soon.

AHS

How to easy install PHP on CentOS 7

How to easy install PHP on CentOS 7

Normally, to install PHP on CentOS 7 is very easy. Let's move.

1. Login to root.

2. Mount your DVD Master of CentOS 7

3. type this command on the terminal yum install php php-mysql php-gd php-pear -y
4. After installation finished, type this command again systemctl restart httpd.service

5. Create info.php on /var/www/html/

      
Vim /var/www/html/testphp.php
      <?php
       Phpinfo();
     ?>

6. and then save.

For testing this php is active or not, you can run from pc client that connected with this server CentOS 7.

AHS

Install Web Server Apache on CentOS 7

Easy to install web server apache on CentOS 7

Here I show you how to install web server on CentOS 7. let's move.

  

1. Login as root
2. Mount your DVD Master CentOS 7.

3. Type this command yum install httpd

4. After that type this command systemctl start httpd.service

5. Next, type this command systemctl enable httpd.service

6. Configure your firewall

        firewall-cmd --permanent --zone=public --add-service=http
       firewall-cmd --permanent --zone=public --add-service=https
      firewall-cmd –reload6. finish.

AHS

CentOS 7: Install and configure DHCP Server

CentOS 7 is a Linux operating system and can be used for server infrastructure. Here I will share how to install and configure the DHCP server.
The first step that you do, you must have centos 7 operating system. without that, We couldn't do more. :D
the second is: DVD master of CentOS 7, this is very important and if you have connection internet is very good to do. 

From your machine do this command from terminal.

1. yum install dhcp
2. After the system finished, go to /etc/sysconfig/network-scripts/ifcfg-enp0s3

Here as sample, I have used IP Address 192.168.56.102 and netmask 255.255.255.0 and gateway 192.168.56.105

DEVICE=”eth0”
HWADDR=08:00:27:59:43:C8
NM_CONTROLLED=”yes”
BOOTPROTO=static
IPADD=192.168.56.102
NETMASK=255.255.255.0
Gateway=192.168.56.105

3. go to /etc/sysconfig/dhcpd and see "DHCPARGS" and set to DHCPDARGS=eth0
4. and then go to vi /etc/dhcp/dhcpd.conf
#specify domain name
option domain-name "amrilhakimsihotang.com";
#specify DNS server ip and additional DNS server ip
option domain-name-servers 192.168.56.103, 192.168.56.101
#specify default lease time
default-lease-time 600;
#specify Max lease time
max-lease-time 7200;
#specify log method
log-facility local7;
#Configuring subnet and iprange
subnet 192.168.56.100 netmask 255.255.255.0 {
range 192.168.1.106 192.168.56.254;
option broadcast-address 192.168.56.255;
#Default gateway ip
option routers 192.168.56.105;
}
#Fixed ip address based on MAC id
host Printer01 {
hardware ethernet 02:34:37:24:c0:a5;
fixed-address 192.168.56.104; -> for IP printer
}
5. save and restart DHCP

# service dhcpd start

For CentOS 7
# cd /bin
# systemctl restart dhcpd.servicecd

6. and for booting dhcp auto
# chkconfig --levels 235 dhcpd on 

 AHS

ESC button on keyboard could be interupt service Virus infect from auto play

 Trick: ESC button on keyboard could be interupt service Virus infect from auto play

 The virus is a very dangerous threat to the data. When we save the data in the flash drive or portable HDD from a computer that is infected with the virus, the virus will be infect flash drive. And when we put the flash drive in the laptop or computer, the virus will infect when auto play is actived. to avoid viruses run via auto play, press the ESC key when the flash drive is detected and mount on system. For ten years I always used this technique before Antivirus works for scanning when I do to maintenance of computer network  and cleaning of viruses for my client. This technique may be useful to you.

AHS

Tutorial create logo

Here I share my video how to create Muhammadiyah logos for high school. please refer this link.

Disclaimer:

This entire video is strictly for educational, testing and demonstrating purpose only. modification use and/or publishing this information is entirely on your own risk.

I'm not liable for any direct or indirect damages caused as a result of using the information or demonstrations provided in any part of this advisory.

Fix error initramfs"No init found. Try passing init=bootarg" on Ubuntu desktop 14.04

Here I share how to fix error initramfs "No init found. Try passing init=bootarg" on Ubuntu desktop 14.04. this case had comes from error power off. that made my Ubuntu 14.04 is crash.

error message was displayed are:

mount: mounting /dev/disk/by-uuid/***************************** on /root
failed: Invalid argument

Create Local Repo on CentOS 7

Hi, here I share how to create local repo on CentOS 7 to you. and absolutly here nothing difficult to do. You only need laptop and CentOS 7. without that, you really could not create local repo. LOL. just kidding. okay, let's moved.

VirtualBox 4.3.26 error when Windows 10 run

When I installed Windows 10 technical preview on virtualbox, there are run smoothly. I ran again this Windows 10 technical preview, some error found and made the virtual box is crashed. I don't know really error in my virtualbox, always reset and force to shutdown and run again, the error still found and Windows 10 technical preview could not be run smoothly. We hope this problem solve after really launching final windows 10.

New generation for Keyboard Shortcuts in the Windows 10 Technical Preview

Welcome back the new operating system from Microsoft. New generation that mentioned to replace Windows 8 and more function will be present such as keyboard shortcuts, and we called him is Windows 10 for technical preview. To continue this article, please go to: new generation for new shortcuts on Windows 10 Technical Preview

Windows 10 is new generation of operating system.

What do you think about new generation  of product from Microsoft about operating system? of course one of all "very easy in touch of corner in this system to do something." Yes you're right, the Microsoft had been moved do the best for servicing people such as data computing fast and more. so you have to know what really about of new generation of operating system before you have to decision for buying and install in your laptop or pc. They called him "Windows 10". Okay, let's move to nice article :  really have to know about Windows 10

Installation Windows 10 Technical Preview

Hi friend,

Here I show you how to install windows 10 Technical Preview on Laptop or PC. Honestly there are not necessary an expert of skill to do. You only need what you want to do such as laptop or pc, time to do and Windows 10 DVD. Okay, Let's move.. :)

Before we start to install this windows, the better way we have to know what is the system need such as specification hardware,ram, etc.

Level: All.

System requirements:

• Processor: 1 gigahertz (GHz) or faster
•  RAM: 1 gigabyte (GB) (32-bit) or 2 GB (64-bit)
• Free hard disk space: 16 GB
• Graphics card: Microsoft DirectX 9 graphics device with WDDM driver
• A Microsoft account and Internet access