Posts

MikroTik Access Point Configuration

Image
Configuration setup Our basic configuration setup is Muhammad Waseem Mayo +923007396305 Access Point Configuration Connect to the router via  Winbox Setup  Wireless  interface, necessary configuration options are  mode =ap-bridge  band =ap_operated_band  frequency =ap_operated_frequency  ssid =network_identification These settings are enough to establish wireless connection, additionally you need to add IP address for the wireless interface for IP routing, optionally add security and other settings. Station Configuration Wireless client configuration example is for MikroTik RouterOS, other vendor OS configuration should be looked in the appropriate documentation/forum/mailing list etc. Connect to the client router via the same way and proceed to the  Wireless  interface configuration. Necessary configuration options are  mode =station  band =band_ap_operates_on  ssid=ap_network_ssid These setting...

Application Example - Load Balancing

Image
Consider the following network layout: Muhammad Waseem Mayo +923007396305 Quick Start for Impatient Configuration export from the gateway router: / ip address add address=192.168.0.1/24 network=192.168.0.0 broadcast=192.168.0.255 interface=LAN add address=10.111.0.2/24 network=10.111.0.0 broadcast=10.111.0.255 interface=ISP1 add address=10.112.0.2/24 network=10.112.0.0 broadcast=10.112.0.255 interface=ISP2 / ip firewall mangle add chain=prerouting dst-address=10.111.0.0/24 action=accept in-interface=LAN add chain=prerouting dst-address=10.112.0.0/24 action=accept in-interface=LAN add chain=prerouting in-interface=ISP1 connection-mark=no-mark action=mark-connection \ new-connection-mark=ISP1_conn add chain=prerouting in-interface=ISP2 connection-mark=no-mark action=mark-connection \ new-connection-mark=ISP2_conn add chain=prerouting in-interface=LAN connection-mark=no-mark dst-address-type=!local \ per-connection-classifier=both-addresses:2/0 action=mark-conn...

Backup MySQL Database to Dropbox Using Backup Box

Image
In this tutorial, we’ll learn that how we can take the backup of database using the tool named My Backup Box, which is nothing but just a website that is used to help transferring files between different services. Create a free account using this  link : Sign-in to your email account and verify your email address (if you have created new account on Backup Box): Press “ Click to Connect “: Select “ MySQL “: It will ask the following information: Note : Before providing these information, you need to allow Backup Box IP address (107.23.5.209), so that it can access your database. Login to MySQL server and check the databases: mysql -u root -p SHOW DATABASES; Create new user (in my case, it is  bkupuser ) and allow it to access  one or all database(s) ( TENDO   database, in this example) from 107.23.5.209 ip address: GRANT ALL PRIVILEGES ON TENDO.* TO bkupuser @'107.23.5.209' IDENTIFIED BY 'password'; FLUSH PRIVILEGE...

Backup MySQL DBs to Amazon S3 Bucket using Python

Image
In this tutorial I’ll show you the simple Python script that takes the compressed MySQL dumps and then upload it to AMAZON S3 Bucket. The script will also automatically delete the backup that are older than the days (mentioned in the script). Requirements: This script requires boto. Install boto using pip: sudo pip install boto Configuration: The script requires the following configuration parameters AWS Details: AWS_ACCESS_KEY_ID = ' You-AWS-ACCESS-KEY-ID ' AWS_SECRET_ACCESS_KEY = ' You-AWS-SECRET-ACCESS-KEY ' S3_BUCKET = ' Your-S3-Bucket ' MySQL Details: DB_HOST = ' DB-HOST-ADDRESS ' # Can be RDS/localhost DB_USER = ' USERNAME ' DB_USER_PASSWD = ' PASSWORD ' BACKUP_PATH = ' /tmp/dbbackup ' # location on local host to save dump before upload it to S3 DeleteOlderThan = 10 # Delete the dumps older then mentioned days Paste the below code into the script after the modifying the above configuration: [g...

OSPF routing between Cisco,Ubuntu,CentOS and Mikrotik Router!

Image
Scenario: Routers : 1 Ubuntu Linux with 3 nics, 1 Centos Linux with 3 nics, 1 Cisco 3640 Router with 3 FastEthernet interfaces and 1 Mikrotik Router with 2 interfaces. Clients : 3 Windows Xp with 1 nic. IP Details All the Routers in this scenario have a default password of “ zebra “. Cisco Router : fe0/0: 10.10.10.1/24 fe1/0:10.10.50.1 /24 fe2/0: Getting through DHCP UbuntuRouter : eth0: 10.10.10.2/24 eth1: 172.16.10.1/24 eth2: 10.10.100.1/24 CentOSRouter: eth0: 172.16.10.2/24 eth1: 192.168.10.1/24 eth2: 10.10.150.1/24 Mikrotik Router: ether1: 192.168.10.2/24 ether2: 10.10.200.1/24 Clients: Ubuntu-Desktop: 10.10.50.50/24 WinXP-1: 10.10.100.50/24 WinXP-2: 10.10.150.50/24 WinXP-3: 10.10.200.50/24 Cisco Router Configuration: UbuntuRouter Configuration: Restart the Router!!! CentOSRouter Configuration: Restart the Router!!! Mikrotik Router Configuration: Neighbor verif...