Jump to content

Testing: Difference between revisions

From LemonWiki共筆
← Older edit
 
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
[[Test connectivity for the web service]]
[[Test connectivity for the web service]]


== Connection test ==
== user client node ==
== user client node ==


Line 36: Line 35:
=== domain name issue ===
=== 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
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<ref>[http://tommy.ironman.tw/windows-7-vista-hosts-error/ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法]</ref>, Win 10 & Windows Server 2008 R2 Standard
* For {{win}} XP, Win7<ref>[http://tommy.ironman.tw/windows-7-vista-hosts-error/ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法]</ref>, Win 10 & Windows Server 2008 R2 Standard: {{kbd | key=<nowiki>C:\WINDOWS\system32\drivers\etc\hosts</nowiki>}}
* On Windows 2003 server: edit the file located at {{kbd | key=<nowiki>C:\WINNT\system32\drivers\etc\hosts</nowiki>}}
* On Windows 2003 server: edit the file located at {{kbd | key=<nowiki>C:\WINNT\system32\drivers\etc\hosts</nowiki>}}
* On {{Linux}}, input the command {{kbd | key=<nowiki>sudo vi /etc/hosts</nowiki>}}   
* On {{Linux}}, input the command {{kbd | key=<nowiki>sudo vi /etc/hosts</nowiki>}}   
Line 74: Line 73:


=== database issue ===
=== database issue ===
* SQL
SQL
** [http://sqlfiddle.com/ SQL Fiddle] support MySQL, MS SQL, Oracle, PosgreSQL, SQLite ... {{Gd}}
 
* [http://sqlfiddle.com/ SQL Fiddle] support MySQL, MS SQL, Oracle, PosgreSQL, SQLite ... {{Gd}}
* [https://www.db-fiddle.com/ DB Fiddle - SQL Database Playground] supports SQLite, MySQL, MariaDB, PostgreSQL
* [https://playcode.io/sql-playground SQL Playground - Free SQL Sandbox with Sample Databases] supports SQLite & PostgreSQL


== server environment ==
== server environment ==
Line 156: Line 158:
* Desktop search: [[Desktop search#Search_text_in_files | Search text in files]]
* 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 ==
== related topic ==
Line 168: Line 170:
* [[Bug report template]]
* [[Bug report template]]


== references ==
== References ==
<references/>
<references/>


Line 184: Line 186:
[[Category:MySQL]]
[[Category:MySQL]]
[[Category:Linux]]
[[Category:Linux]]
[[Category:Testing]]

Latest revision as of 16:59, 18 September 2026

Test connectivity for the web service[edit]

Test connectivity for the web service

user client node[edit]

browser & device issue[edit]

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

  • For Win XP, Win7[1], Win 10 & Windows Server 2008 R2 Standard: C:\WINDOWS\system32\drivers\etc\hosts
  • 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 icon_os_mac.png , input the command sudo vi /private/etc/hosts [2]


Clear the DNS cache

more on DNS checking

handling form data[edit]

before submit the form data

  • (1)Use the Web Developer plugin for Firefox browser_firefox.png and (2)Menu -> Forms -> Display form details

after submit the form data


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 browser_firefox.png & 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]

excel format compatibility[edit]

Using Microsoft Excel Viewer to check the excel format compatibility. Icon_exclaim.gif It's not save to check the excel file only by using the old version of Excel.


database issue[edit]

SQL

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]

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]

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]

If the message text or code snippets was not found in the plain text files, it may stored in the database.

related topic[edit]

related terms

  • functional testing

templates

References[edit]

  1. ↑ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法
  2. ↑ How to Edit the Hosts File on Mac OS X - TekRevue
  3. ↑ Private Browsing - Browse the web without saving information about the sites you visit | Firefox Help
  4. ↑ (ASP.NET)從Log追蹤錯誤 - gipi的學習筆記-職場規劃、專案管理、雲端運算部落格- 點部落
  5. ↑ MySQL :: MySQL 5.7 Reference Manual :: 13.7.5.39 SHOW VARIABLES Syntax
  6. ↑ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog

further reading


Web site design and development process

Retrieved from "https://wiki.planetoid.info/index.php?title=Testing&oldid=26469"