Testing: Difference between revisions

Latest revision as of 20:11, 8 January 2025

Test connectivity for the web service[edit]

Test connectivity for the web service

user client node[edit]

browser & device issue[edit]

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

Online IDE[edit]

Programming online (Online IDE)

browser plug-ins issue[edit]

e-mail testing issue[edit]

Email testing

monitoring the status or changes of files or registry[edit]

monitoring or generating the HTTP request sent to the server[edit]

HTTP request and response data tool

domain name issue[edit]

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^[1], Win 10 & Windows Server 2008 R2 Standard
On Windows 2003 server: edit the file located at C:\WINNT\system32\drivers\etc\hosts
On Linux , input the command sudo vi /etc/hosts

127.0.0.1       localhost
# ip            domain.com

On macOS , input the command sudo vi /private/etc/hosts ^[2]

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 macOS

handling form data[edit]

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[edit]

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.^[3]
Manually clear cookie and temporary files of browser

file upload[edit]

Generate a File - Fake File Generator allow to specify the filesize

excel format compatibility[edit]

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.

database issue[edit]

SQL
- SQL Fiddle support MySQL, MS SQL, Oracle, PosgreSQL, SQLite ...

server environment[edit]

Testing server environment

local server node (if you has permission to log in the server via SSH or Remote desktop service)[edit]

check the server/service logs

OS[edit]

Microsoft Windows[edit]

- XP / Vista: 控制台 --> 系統管理工具 --> 事件檢視器
- 事件和錯誤訊息中心: 基本搜尋

Web server[edit]

Apache[edit]

Apache HTTP server log: /etc/httpd/logs (location was set up in the configuration file /etc/httpd/conf/httpd.conf)

access.log
error.log - record when the apache service restarted/stopped

Using grep command to search the logs: grep -ir "string to search" /path/to/directory. More on Search text in files

IIS[edit]

Microsoft Internet Information Services (IIS) log (記錄檔)^[4]

C:\WINDOWS\system32\LogFiles\

Database server[edit]

MySQL[edit]

MySQL Server Logs:

step1: verify the system variable^[5]

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) ^[6]

[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[edit]

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

Other[edit]

PHP[edit]

PHP_errors#logging

Java[edit]

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.

console command[edit]

//write the console output to the file
command > log.txt

//append to the same file
command >> log.txt

find match string[edit]

grep 'string' filename -r
- manual, 教學

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.

@@ Line 2: / Line 2: @@
 == Test connectivity for the web service ==
 [[Test connectivity for the web service]]
-== Connection test ==
-=== 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: {{kbd | key =<nowiki>http://the.domain</nowiki>}} {{exclaim}} Note: Not [https://en.wikipedia.org/wiki/Private_network Private network] / Private IP address
-* or use the remote website monitoring services: [[Web Ping]]
-Using alternative web services if the Python was installed
-* (for python 2.x) {{kbd | key=<nowiki>python -m SimpleHTTPServer <port></nowiki>}}<ref>[https://docs.python.org/2/library/simplehttpserver.html 20.19. SimpleHTTPServer — Simple HTTP request handler — Python 2.7.17 documentation]</ref>
-* (for python 3.x) {{kbd | key=<nowiki>python -m http.server <port></nowiki>}}<ref>[https://docs.python.org/3.8/library/http.server.html?highlight=http%20server#module-http.server http.server — HTTP servers — Python 3.8.1 documentation]</ref>
-Using telnet client
-* (optional) [https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc771275(v=ws.10) Install Telnet Client | Microsoft Docs] on {{Win}}. [https://medium.com/@blackSource/bring-telnet-back-on-macos-high-sierra-11de98de1544 Bring telnet back on macOS high Sierra – Ayuth Mangmesap (blackSource) – Medium] on {{Mac}}
-* telnet ''DOMAIN_or_IP'' ''PORT'' ex: {{kbd | key = telnet the.domain 80}}
-** 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 {{Kbd plus | key1 = Ctrl | key2 = ]}} and (2) keyin {{Kbd | key = quit}} to end the telnet.
-** If failed. It will show the message: "telnet: Unable to connect to remote host: Connection refused"
-curl
-* {{kbd | key = curl -v -o /dev/null http://IP:Port}} If failed. It will show the message: "failed: Connection refused"
-tools
-# [http://check-host.net/ 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. {{access | date=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: {{kbd | key = <nowiki>http://127.0.0.1</nowiki> }}
-* [http://www.canyouseeme.org/ Open Port Check Tool]: ''Using browser'' to check the specified port of local machine from canyouseeme.org. {{exclaim}} it may returned wrong result if the server hosted with shared external IP
-* Linux command:
-*# (optional if lynx was not installed) {{kbd | key = <nowiki>yum install lynx</nowiki>}} for CentOS / {{kbd | key = <nowiki>sudo apt-get install lynx</nowiki>}} for Ubuntu<ref>[http://www.addictivetips.com/ubuntu-linux-tips/install-and-use-lynx-on-ubuntu/ Install and Use Lynx Browser on Ubuntu]</ref>
-*# {{kbd | key = <nowiki>lynx http://127.0.0.1</nowiki>}} <ref>[http://lynx.isc.org/lynx2.8.7/lynx2-8-7/lynx_help/Lynx_users_guide.html Lynx Users Guide v2.8.7]</ref> for {{Linux}}
-telnet
-# {{kbd | key = telnet 127.0.0.1 80}}
-# (after telnet-ed the web 80 port, key in) {{kbd_plus | key1 = get | key2 = SPACE}}
-# more on [http://www.simplescripts.de/http-check-port-80-telnet-command.htm HTTP Check Port 80 with the Telnet Command]
-netstat ex: find MySQL 3306 port
-# {{kbd | key = <nowiki>netstat -a | find "3306"</nowiki>}} (note: require the '''double quote''' symbol, not single quote symbol) for {{Win}}<ref>[http://technet.microsoft.com/en-us/library/bb490947.aspx Netstat]</ref> or {{kbd | key = <nowiki>netstat -npl | grep 3306</nowiki>}}<ref>[http://www.cyberciti.biz/faq/find-out-which-service-listening-specific-port/ Linux / UNIX Find Out What Program / Service is Listening on a Specific TCP Port]</ref> for {{Linux}}
-# more on [http://www.techrepublic.com/blog/security/list-open-ports-and-listening-services/443 List open ports and listening services]
-tools
-# {{Gd}} [http://www.nirsoft.net/utils/cports.html CurrPorts: Monitoring TCP/IP network connections on Windows]
-# [http://portforward.com/help/portcheck.htm PFPortCheck Program]: check TCP/UDP port from localhost(where you installed the program) to portforward.com
-# [http://technet.microsoft.com/en-us/sysinternals/bb897437 TCPView for Windows]
 == user client node ==
@@ Line 201: / Line 155: @@
 * Desktop search: [[Desktop search#Search_text_in_files | Search text in files]]
-: [[Image:Owl icon.jpg]] If the message text or code snippets was '''not found''' in the ''plain text files'', it may stored in the ''database''.
+{{Tips}} If the message text or code snippets was '''not found''' in the ''plain text files'', it may stored in the ''database''.
 == related topic ==
@@ Line 213: / Line 167: @@
 * [[Bug report template]]
-== references ==
+== References ==
 <references/>
@@ Line 229: / Line 183: @@
 [[Category:MySQL]]
 [[Category:Linux]]
+[[Category:Testing]]