Tukang nggame tips for backup mysql with Linux

Tukang nggame tips. Many ways to perform backups automatically mysql databasee, and can even in the automatic transfer it to the other srver also, here is one of them. This is very simple and just for dummy. :d
SERVER I.
Buat file dump.sh

#!/bin/bash

TheDATE=`date +%Y-%m-%d_`
W=`date +%A`
jamscript=`date +%Hh%Mm`
myfiles="mywebdb_"$TheDATE"_"$jamscript"_"$W".sql"

cd /var/www/bekap

/usr/bin/mysqldump -u myuser --all --password=mypassword mywebdb > $myfiles

if [ -e $myfiles ]; then
gzip -c $myfiles > $myfiles".gz"
fi

if [ -e $myfiles ]; then
rm -f $myfiles
fi

exit 0

Run the script at 06:00 and 18:00.

#chmod 755 dump.sh
#crontab -e
00 6 * * * /home/arisnb/dump.sh
00 18 * * * /home/arisnb/dump.sh

Create a username and password for your web. Example username is arisnb and password mypassword.

#htpasswd -c /var/www/bekap/.htpasswd arisnb

Create a file /var/www/bekap/.htaccess

AuthName "Please Login !!!"
AuthUserFile /var/www/bekap/.htpasswd
Require valid-user

ads : Please support me at Stop Dreaming Start Action :d

SERVER II (BACKUP)
Create a script for download, example download.sh

#!/bin/bash

TheDATE=`date +%Y-%m-%d_`
W=`date +%A`
jamscript="`date +%Hh%Mm`"
myfiles="mywebdb_"$TheDATE"_06h00m_"$W".sql.gz"
myfiles2="mywebdb_"$TheDATE"_18h00m_"$W".sql.gz"

cd /home/arisnb/bekap

if [ "$jamscript" = "06h30m" ]; then
wget -c --http-user=arisnb --http-passwd=mypassword https://10.10.10.1/bekap/$myfiles --no-check-certificate
fi

if [ "$jamscript" = "18h30m" ]; then
wget -c --http-user=arisnb --http-passwd=mypassword https://10.10.10.1/bekap/$myfiles2 -no-check-certificate
fi

exit 0

Run the script at 06:30 and 18:30.

#chmod 755 download.sh
#crontab -e
00 6 * * * /home/arisnb/download.sh
00 18 * * * /home/arisnb/download.sh

Check the backups files at /home/arisnb/bekap directory.

ads: Don't forget support me at Stop Dreaming Start Action

Read More

Tukang nggame tips:ARP Linux Command

tukang nggame tips~The Address Resolution Protocol (ARP) is the method for finding a host's link layer (hardware) address. ARP is primarily used to translate IP addresses to Ethernet MAC addresses. Media Access Control address (MAC address) is a unique identifier assigned to most network adapters. This is example Ethernet  HWaddr/Mac Address 00:1c:11:19:c1:11

With GNU/Linux we can use a command line to manipulate the system ARP cache. The command is arp. Arp manipulates or displays the kernel's IPv4 network neighbour cache. It can add entries to the table, delete one or display the current content. ARP stands for Address Resolution Protocol, which is used to find the media access control address  of  a  network neighbour for a given IPv4 Address.

Howto use it ?
From manual page Linux we get a synopsis to use it :

SYNOPSIS
       arp [-vn] [-H type] [-i if] [-a] [hostname]

       arp [-v] [-i if] -d hostname [pub]

       arp [-v] [-H type] [-i if] -s hostname hw_addr [temp]

       arp [-v] [-H type] [-i if] -s hostname hw_addr [netmask nm] pub

       arp [-v] [-H type] [-i if] -Ds hostname ifname [netmask nm] pub

       arp [-vnD] [-H type] [-i if] -f [filename]

With that command we can define the client mac address with fix ip address and acquaint it to router.

CLIENT/COMPUTER 1,2..n (c1,c2,..cn) -------------ROUTER

c1 mac address 00:1c:11:19:c1:11 IP address  192.168.1.1
c1 mac address 00:1c:11:19:b1:12 IP address  192.168.1.2

with that arp Linux command

#/usr/sbin/arp -s 192.168.1.1     00:1c:11:19:c1:11
#/usr/sbin/arp -s 192.168.1.1     00:1c:11:19:b1:12

or we create a bash file, example arp.sh. That content

#!/bin/bash
#tukang nggame computer
/usr/sbin/arp -s 192.168.1.1     00:1c:11:19:c1:11
#John computer
/usr/sbin/arp -s 192.168.1.1     00:1c:11:19:b1:12

Then, change permision for execution.

#chmod  755 arp.sh

The running that file

#./arp.sh

What advantage that methode ?
Now, router have database mac address and IP Address every computer. So a network administrator manage the router more easy. Because client can't change their Mac address offhand, if they was changed mac address or IP address that same with router database, so their computer can connect to router. It useful if you combine apply with squid/proxy server.

tukang nggame Ref:

http://en.wikipedia.org/wiki/MAC_address

http://en.wikipedia.org/wiki/Address_Resolution_Protocol

Share this post :

Prev article :Tell Sory contest clip by tukang nggame

Read More

Tukang Nggame Linux: SSH and Denyhosts Security with Linux Debian

Tukang nggamer write this tips/tutorial for SEO Contest with keyword tukang nggame. I hope tukangnggame to be a winner as tukang nggamer for nggame.

tukang nggame Linux -If your Linux router run ssh service or the other service. And You will yoursef to access it. You can secure your GNU/Linux Debian router from everyone. How do it ? Simple.
Stop root user to remote your Linux router.
Edit /etc/ssh/sshd_config

PermitRootLogin no

Restart ssh services

#/etc/init.d/ssh restart
Restarting OpenBSD Secure Shell server: sshd.

And install denyhosts aplication

apt-get install denyhosts

Then edit /etc/denyhosts.conf

# DENY_THRESHOLD_INVALID: block each host after the number of failed login.
# attempts has exceeded this value. This value applies to invalid
# user login attempts (eg. non-existent user accounts)
#
DENY_THRESHOLD_INVALID = 5
#
##########################################################
# DENY_THRESHOLD_VALID: block each host after the number of failed.
# login attempts has exceeded this value. This value applies to valid
# user login attempts (eg. user accounts that exist in /etc/passwd) except
# for the "root" user
#
DENY_THRESHOLD_VALID = 10
#
##########################################################
#
# DENY_THRESHOLD_ROOT: block each host after the number of failed.
# login attempts has exceeded this value. This value applies to.
# "root" user login attempts only.
#
DENY_THRESHOLD_ROOT = 1
#
##########################################################
#
# DENY_THRESHOLD_RESTRICTED: block each host after the number of failed.
# login attempts has exceeded this value. This value applies to.
# usernames that appear in the WORK_DIR/restricted-usernames file only.
#
DENY_THRESHOLD_RESTRICTED = 1

# To block all services for the offending host:
#BLOCK_SERVICE = ALL
# To block only sshd:
BLOCK_SERVICE = sshd

#Email will report if there someone failed login
ADMIN_EMAIL = aris@nggames.com
SMTP_HOST = mail.nggames.com
SMTP_PORT = 25

SMTP_FROM = DenyHosts denyhosts-report@nggames.com
# SMTP_SUBJECT: you can specify the "Subject:" of messages sent
# by DenyHosts when it reports thwarted abuse attempts
SMTP_SUBJECT = DenyHosts Report

You can edit the other as you like. Then restart denyhosts services

# /etc/init.d/denyhosts restart
Restarting DenyHosts (warning).
Stopping DenyHosts: denyhosts.
Starting DenyHosts: denyhosts.

If the are user failed login as rule (DENY_THRESHOLD_INVALID), IP Address that user automate added in /etc/hosts.deny

example screenshoot:

sshd: 222.215.119.33
sshd: 203.158.221.21

But if we choice BLOCK_SERVICE = ALL

all: 222.215.119.33
all: 203.158.221.21

If your special IP (exp : 10.11.1.1 ) will not block at every time, add in /etc/hosts.allow

sshd:10.11.1.1

Bingo! Tukang Nggame congrate to you.

Share this post :

Prev article : The Winner by tukang nggame

Read More

Tukang Nggame Summary : Olsen Aviary by inkista with SPi-V interactive Viewer

tukang nggame - An aviary is a large enclosure for confining birds, that allow birds a larger living space where they can fly. And aviaries often contain plants and shrubbery to simulate a natural environment, so birds can adapted it. There are two type of aviary : Public aviary and Home aviary. See http://en.wikipedia.org/wiki/Aviary

This galerry of aviary :

• The Snowdon Aviary London Zoo
• Spacious walk-in aviary at Jurong BirdPark in Singapore
• 1904 Flight Cage St. Louis Zoo

The other gallery are (Olsen Aviary by inkista) at Flickr.com. And you can browse that picture in the SPi-V interactive viewer, click that links. But you must install manual add-ons (plugin) shockwave_installer_slim, get it at http://get.adobe.com/shockwave/. Tukang Nggame was install with Firefox 3.0.

After install, restart your browser and browse that URL. You can drag about to change the point of view; shift to zoom in; control to zoom out. Enjoy it !

 

Share this post :

Read More

Tukang Nggame SEO

tukang nggame SEO is Search Engine Optimization for our web/blog to get SERP (Search Engine Result Page) number one at search engine with keyword "Tukang Nggame". In this term, search engine is http://www.google.com. How to get it ? We must optimize our web/blog tag (HTM code) standard. See http://www.w3schools.com/html/DEFAULT.asp. Check your meta tag.

Other tips, you must publish your web/blog to public (online and offline). Online, you must comment your friend's web/blog or you call your friend to link your URL in their web/blog. Offline, invite your friend to browse your web/blog by phone, mail or call face to face. Aim to increase who access your blog. Who browse your web/blog is getting increase , SERP your blog is better. So you must get backlinks for the other web/blog.

Write more articles who people like it, so who browse your blog will revisit again in the other time. You can write tips as this Tukang Nggame tips about SEO or the other ( maybe your hobby).

Submit/ping your web/blog sitemap to search engines. Patient a few days, then search in www.google.com , bingo !!!

Share this post :

Read More

Tukang Nggame news, Free Services Manager

Tukang Nggame News. Now, www.mypagerank.net added new services. It's called "Free Services Manager". It's dedicated to help users to setup their own free services site. The service run in their own web server and fetch data from mypagerank.net server. This is methode better from all. First prevent spammers, all site have their unique ip this speed index in search engines.

Tukang Nggame weblog will use that services, but don't do it, because web server http://nggametukang.blogspot.com not yet suported PHP language programming, whereas the web server require PHP ( url fopen, GD ). The other requirement to run that services are Apache ( mod rewrite ) , Ioncube loader.

This step by step to install it :
1 - Create Site
2 - Site design and settings
3 - Activate addons
4 - Site Pages
5 - Install files
6 - Copy the code to site then access with your web browser.

Detail news browse http://freeservicesmanager.mypagerank.net/.

Share this post :

Read More