Testing: Difference between revisions

Latest revision as of 14:49, 14 August 2023

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 Mac , 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 Mac

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 3: / Line 3: @@
 [[Test connectivity for the web service]]
-== Connection test ==
 == user client node ==
@@ Line 168: / Line 167: @@
 * [[Bug report template]]
-== references ==
+== References ==
 <references/>
@@ Line 184: / Line 183: @@
 [[Category:MySQL]]
 [[Category:Linux]]
+[[Category:Testing]]