- 1 troubleshooting steps for connection test
- 2 connection test
- 3 user client node
- 3.1 browser & device issue
- 3.2 browser plug-ins issue
- 3.3 e-mail testing issue
- 3.4 monitoring the status or changes of files or registry
- 3.5 monitoring or generating the HTTP request sent to the server
- 3.6 domain name issue
- 3.7 handling form data
- 3.8 login issues into different accounts
- 3.9 file upload
- 3.10 excel format compatibility
- 3.11 database issue
- 4 server environment
- 5 local server node (if you has permission to log in the server via SSH or Remote desktop service)
- 6 find match string
- 7 related topic
- 8 references
troubleshooting steps for connection test
find the problem occurred: (1) local service at the server (localhost) (2) from LAN to server (3) from WAN to server
(1) local service
WAN ○ -------> ○ LAN -------> ● server
Testing on localhost if you have the administrative permission to manage the server.
- Check if your computer/server Is being assigned the IP Address.
- Is service alive? Is the port occupied by other process?
- Win Using the software CurrPorts to check the process and port. e.g. Apache will not running if the 80 port was occupied by skype.
- Is the port open to external users? OS firewall or protected by antivirus software.
- iptables: (1) to list all rules (2) rule with smaller line-number will override the rule with larger line-number
- FirewallD rules: (1) return 'public' (2)  (3) Allow port with FirewallD
- SELinux Policy Management: (1) After installed , input to list open ports. (2) Allow port with semanage.
- Win Windows Firewall with Advanced Security -> configure firewall rules
- protected by antivirus software?
- connect to localhost ex:
where 23 is the port number where the service running
- Install Telnet Client on Win
- if the local service is web server, you can also try Linux for
- double check the server/service logs
(2) from LAN to server
WAN ○ -------> ● LAN -------> ● server
- testing on LAN (local network, subnet scope): Is service alive? The different servers between LAN or with the same ip class (ex: 1.2.3.*) may not have the firewall limit.
- connect to localhost ex: Private IP Network Numbers (2) where 23 is the port number where the service running (1) IP start with 172.18... is
- double check the server/service logs
(3) from WAN to server
WAN ● -------> ● LAN -------> ● server
We met the trouble on WAN (wide area network). If we do no have the administrative permission, the tests we can do as follows:
- Down for everyone or just me? more on Web Ping
- Switch to different ISP? Is hardware firewall enabled?
- Is gateway alive?
- Is DNS alive?
- Is the external IP correct?
- bandwidth cost too much by certain users
- exceed the request limit of (hardware) firewall
- the external connection of updated Windows was down until reboot Win
- Amazon EC2 security group
- refresh browser cache: Refresh your cache - When hitting F5 just isn't enough!
case 1: Access the server from outside network ex: WAN
Where are you? Access the server from outside network ex: Wide Area Network (WAN) or Local Area Network (LAN)
open the browser from outside network ex: Wide Area Network (WAN) or Local Area Network (LAN)
- and type the address: Note: Not Private network / Private IP address
- or use the remote website monitoring services: Web Ping
Using telnet client
- (optional) Install Telnet Client | Microsoft Docs on Win . Bring telnet back on macOS high Sierra – Ayuth Mangmesap (blackSource) – Medium on Mac
- telnet DOMAIN_or_IP PORT ex:
- If connected. The console windows will show the message "Escape character is '^]'. " for Linux . Or show a blank window for Win If you want to end the telnet command. You can (1) press + and (2) keyin to end the telnet.
- If failed. It will show the message: "telnet: Unable to connect to remote host: Connection refused"
- If failed. It will show the message: "failed: Connection refused"
- Check server: Check host - online website monitoring, Check IP "checks the possibility of a TCP connection to host's specified port from different locations around the world." quoted from website. [Last visited: 2015-08-02]
case 2: Access the server from inside ex: localhost or Local LAN
If you has permission to log in the server via SSH or Remote desktop service.
- (1)open the browser, (2)type the address:
- Open Port Check Tool: Using browser to check the specified port of local machine from canyouseeme.org. it may returned wrong result if the server hosted with shared external IP
- Linux command:
- (after telnet-ed the web 80 port, key in) +
- more on HTTP Check Port 80 with the Telnet Command
netstat ex: find MySQL 3306 port
- Win  or  for Linux (note: require the double quote symbol, not single quote symbol) for
- more on List open ports and listening services
- CurrPorts: Monitoring TCP/IP network connections on Windows
- PFPortCheck Program: check TCP/UDP port from localhost(where you installed the program) to portforward.com
- TCPView for Windows
user client node
browser & device issue
- Browser version: Check Browser Compatibility & Validation service or Validator: Check Markup or CSS syntax
- Multiple screen resolution test: 不同螢幕解析度檢視網頁
- Mobile friendliness tool
- Disable all extensions
- Clear browser cache by Bypass your cache (繞過瀏覽器快取)
- Client temporary files
- Google Chrome: How to Disable Cache
- Clear server cache ex: Smarty Caching
code snippet web-based editor / communication tools between developers/designers
- codepad [Last visited: 2012-10-02] [Last visited: 2014-10-07]
- CSSDesk HTML, CSS [Last visited: 2013-02-11]
- The first commented line is your dabblet’s title ✿ dabblet.com: view the sample of html and css [Last visited: 2012-08-22]
- Ideone.com "Online IDE & Debugging Tool >> C/C++, Java, PHP, Python, Perl and 40+ compilers and interpreters"
- jsFiddle [Last visited: 2014-10-07]
- Plunker [Last visited: 2014-10-07]
- Implode.io for PHP [Last visited: 2018-03-15]
- Ideone.com support SQL not support REGEXP function [Last visited: 2015-03-09]
- SQL fiddle support MySQL, MS SQL server, Oracle, PostgreSQL, SQLite ... data may not showed in couple days [Last visited: 2015-03-09]
Save or share source codes
- Pastie with syntax highlighting
- Pastebin.com - #1 paste tool since 2002!
- Tinypaste - The easiest way to host your text
browser plug-ins issue
- Test your Adobe Flash Player installation
- Adobe - Test Adobe Shockwave Player
- test java: How do I test whether Java is working on my computer?
e-mail testing issue
monitoring the status or changes of files or registry
- FileMon for Windows / Filemon v7.04 - 檔案即時監控 :: 綠色工廠 Easylife Blog
- RegMon for Windows / RegMon v7.04 - 註冊表監控 :: 綠色工廠 Easylife Blog
monitoring or generating the HTTP request sent to the server
domain name issue
Modify the following files if you want to test the domain name before the mapping of domain name and ip was changed really
- C:\WINDOWS\system32\drivers\etc\hosts for Win XP, Win7, Win 10 & Windows Server 2008 R2 Standard
- C:\WINNT\system32\drivers\etc\hosts for Windows 2003 server
- Linux for
127.0.0.1 localhost # ip domain.com
- Mac  for
Clear the DNS cache
- How Do I Clear My DNS Cache on Windows? | Support | No-IP for Win
- Reset the DNS cache in OS X - Apple Support for Mac
more on DNS checking
handling form data
before submit the form data
- (1)Use the Web Developer plugin for Firefox and (2)Menu -> Forms -> Display form details
after submit the form data
- PHP var_dump $_POST 或 $_GET
- .serialize() | jQuery API Documentation
login issues into different accounts
If you need to clear the cookie frequently for the testing account issue
- Using the privacy browsing for Firefox & Chrome . Each time you turning on the privacy browsing, the logged status and cookie will not saved.
- Manually clear cookie and temporary files of browser
- Generate a File - Fake File Generator allow to specify the filesize
excel format compatibility
Using Microsoft Excel Viewer to check the excel format compatibility. It's not save to check the excel file only by using the old version of Excel.
- SQL Fiddle support MySQL, MS SQL, Oracle, PosgreSQL, SQLite ...
local server node (if you has permission to log in the server via SSH or Remote desktop service)
check the server/service logs
- XP / Vista: 控制台 --> 系統管理工具 --> 事件檢視器
- 事件和錯誤訊息中心: 基本搜尋
Apache HTTP server log: /etc/httpd/logs (location was set up in the configuration file /etc/httpd/conf/httpd.conf)
- error.log - record when the apache service restarted/stopped
Using grep command to search the logs: Search text in files. More on
- step1: verify the system variable
mysql> SHOW VARIABLES LIKE '%general_log%'; mysql> SHOW GLOBAL VARIABLES LIKE '%general_log%';
- step2: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) 
[mysqld] ## includes all SQL queries/commands # general_log = 1 # general_log_file="general_log_file.log" log-error=/var/log/mysql/error.log log-slow-queries = /var/log/mysql/mysql-slow.log #another syntax #slow_query_log_file = mysql-slow.log long_query_time = 1 log-long-format
- step3: restart MySQL service
Microsoft SQL Server
- ExpressProfiler includes all SQL queries/commands
- SQL Server Error Log / 檢視 SQL Server 錯誤記錄 "contains user-defined events and certain system events ..." quoted from SQL Server Error Log ex: X:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG
- Logging ALL Queries on a SQL Server 2008 Express Database? - Stack Overflow not tested
System.out.println("Boston, We Have A Problem" + variable); //output to Tomcat consile out.println("Boston, We Have A Problem" + variable); //output to JSP webpage
or using NetBeans IDE - Debugger and Profiler to setup the breakpoints.
//write the console output to the file command > log.txt //append to the same file command >> log.txt
find match string
- Desktop search: Search text in files
- If the message text or code snippets was not found in the plain text files, it may stored in the database.
- Comment Syntax
- functional testing
- How to restart the networking service? - Ask Ubuntu
- 7 Linux Grep OR, Grep AND, Grep NOT Operator Examples
- How to solve WAMP and Skype conflict on Windows 7? - Stack Overflow
- HowTos/Network/IPTables - CentOS Wiki
- How to edit iptables rules - FedoraProject
- How To Set Up a Firewall Using FirewallD on CentOS 7 | DigitalOcean
- semanage command not found on CentOS 7 and RHEL 7
- networking - Command for determining my public IP? - Ask Ubuntu
- Install and Use Lynx Browser on Ubuntu
- Lynx Users Guide v2.8.7
- Linux / UNIX Find Out What Program / Service is Listening on a Specific TCP Port
- The Will Will Web - 介紹好用工具：JS Bin ( 網站前端工程師的學習利器 )
- Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法
- How to Edit the Hosts File on Mac OS X - TekRevue
- Private Browsing - Browse the web without saving information about the sites you visit | Firefox Help
- (ASP.NET)從Log追蹤錯誤 - gipi的學習筆記-職場規劃、專案管理、雲端運算部落格- 點部落
- MySQL :: MySQL 5.7 Reference Manual :: 188.8.131.52 SHOW VARIABLES Syntax
- 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog
- Troubleshooting browser issues with Trello - Trello Help [Last visited: 2017-03-28]
- Supported browsers and troubleshooting steps for Asana | Product guide · Asana [Last visited: 2017-03-28]