Recover Cisco Switch Ports from err-disabled State
8How to view and recover Cisco Switch ports from err-disabled state
How to quickly import CSV file into MySQL table
11Import CSV into MySQL This is a simple version of LOAD DATA command to import simple CSV file into MySQL table. It look only .02 seconds to import 40+ records. LOAD DATA INFILE ‘c:\datafolder\t_order_details.csv” INTO TABLE t_order_details FIELDS TERMINATED BY ‘;’ LINES TERMINATED BY ‘\n’ ..
How to get size of each table of a MySQL Database
18This SQL query provides you with list of all tables with largest size in a MySQL database that is executed. SELECT table_schema AS `Database` , table_name AS `Table` , ROUND( ( ( data_length + index_length ) /1024 /1024 ) , 2 ) `Size in MB` FROM information_schema.TABLES ..
SNMP vs Trap
Commands to manage F5 Active Connections
82View All Active Connections Use the command tmsh show /sys connection to view all active connections of all Virtual Servers of F5 unit [root@F5LB] config # tmsh show /sys connection Really display 1000 connections? (y/n) y Sys::Connections 220.127.116.11:50254 192.168.2.103:443 192.168.2.203:50254 192.168.2.41:7003 ..
Logging WL-Proxy-Client-IP and X-Forwarded-For to determine Client IP behind F5
53In order to determine the client IP that sends requests to a Web Server placed behind an F5 appliance, you can attach this iRule to your virtual server. This iRule logs the requested Client IP address under System > Logs > Local Traffic. This iRule logs following Client IP address Request URL X-Forwarded-For ..
Configure HTTP Monitor in F5
98Before we begin configuring the HTTP Monitor, use POSTMAN or other HTTP sniffer tool to understand REQUEST (Send String) and RESPONSE (Receive String) pair of the health check page. SEND STRING In this example, when client browser browse the health check web page /…/healthcheck.html, the client ..
Create SPF record for my domain
49Sender Policy Framework (SPF) helps to fight against email spoofing for your organization. SPF is generally a TXT record in DNS Zone file that lists the host name or IP address authorized for sending emails for a specific domain name. There is no other configuration required however the recipients must ..
tcpdump useful commands
91tcpdump is a packet sniffing command line tool to capture TCP/IP packets that are received or transmitted on a specific interface. This tool has been used widely for troubleshooting purpose, as well as for security assessments. The output of tcpdump command can be viewed using free wireshark tool. The above ..