Editing Testing


== Test connectivity for the web service ==
[[Test connectivity for the web service]]

== user client node ==

=== browser & device issue ===
* Browser version: [[Check Browser Compatibility]] & Validation service or [[Validator]]: Check Markup or CSS syntax
* Multiple screen resolution test: [[CSS_tools#不同螢幕解析度檢視網頁 | 不同螢幕解析度檢視網頁]]
* [[Mobile friendliness tool]]
* Disable all extensions
* Clear browser cache by [http://en.wikipedia.org/wiki/Wikipedia:Bypass_your_cache Bypass your cache] ([http://zh.wikipedia.org/wiki/Help:%E7%BB%95%E8%BF%87%E6%B5%8F%E8%A7%88%E5%99%A8%E7%BC%93%E5%AD%98 繞過瀏覽器快取])
** Client temporary files
** [https://www.technipages.com/google-chrome-how-to-completely-disable-cache Google Chrome: How to Disable Cache]
* Clear server cache ex: [http://www.smarty.net/manual/en/caching.php Smarty Caching]

==== Online IDE ====
[[Programming online (Online IDE)]]

=== browser plug-ins issue ===
* [http://www.adobe.com/software/flash/about/ Test your Adobe Flash Player installation]
* [http://www.adobe.com/shockwave/welcome/ Adobe - Test Adobe Shockwave Player]
* test java: [http://www.java.com/en/download/testjava.jsp How do I test whether Java is working on my computer?]

=== e-mail testing issue ===
[[Email testing]]

=== monitoring the status or changes of files or registry ===
* [http://technet.microsoft.com/en-us/sysinternals/bb896642 FileMon for Windows] / [http://portable.easylife.tw/102 Filemon v7.04 - 檔案即時監控 :: 綠色工廠 Easylife Blog]
* [http://technet.microsoft.com/en-us/sysinternals/bb896652 RegMon for Windows] / [http://portable.easylife.tw/101 RegMon v7.04 - 註冊表監控 :: 綠色工廠 Easylife Blog]

=== monitoring or generating the HTTP request sent to the server ===
[[HTTP request and response data tool]]

=== 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<ref>[http://tommy.ironman.tw/windows-7-vista-hosts-error/ Azan 黃贊臣 » 在Windows 7 或 Vista 中修改hosts檔的方法]</ref>, Win 10 & Windows Server 2008 R2 Standard
* 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>}}  
<pre>
127.0.0.1       localhost
# ip            domain.com
</pre>
* On {{Mac}}, input the command {{kbd | key=<nowiki>sudo vi /private/etc/hosts</nowiki>}} <ref>[https://www.tekrevue.com/tip/edit-hosts-file-mac-os-x/ How to Edit the Hosts File on Mac OS X - TekRevue]</ref>


Clear the DNS cache
* [http://www.noip.com/support/knowledgebase/how-do-i-flush-my-windows-dns-cache/ How Do I Clear My DNS Cache on Windows? | Support | No-IP] for {{Win}}
* [https://support.apple.com/en-us/HT202516 Reset the DNS cache in OS X - Apple Support] for {{Mac}}

more on [[Web_Ping#DNS.E6.AA.A2.E6.9F.A5 | DNS checking]]

=== handling form data ===
before submit the form data
* (1)Use the [https://addons.mozilla.org/zh-tw/firefox/addon/web-developer/ Web Developer] plugin for {{Fx}} and (2)Menu -> Forms -> Display form details

after submit the form data
* PHP var_dump $_POST 或 $_GET
* [http://api.jquery.com/serialize/ .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 {{Fx}} & {{Chrome}}. Each time you turning on the privacy browsing, the logged status and cookie will not saved.<ref>[http://support.mozilla.org/en-US/kb/private-browsing-browse-web-without-saving-info Private Browsing - Browse the web without saving information about the sites you visit | Firefox Help]</ref>
* Manually clear cookie and temporary files of browser

=== file upload ===
* [http://www.fakefilegenerator.com/generate-file.php Generate a File - Fake File Generator] allow to specify the filesize

=== excel format compatibility ===
Using Microsoft [http://www.microsoft.com/en-us/download/details.aspx?id=10 Excel Viewer] to check the excel format compatibility. {{exclaim}} It's not save to check the excel file only by using the old version of Excel.


=== database issue ===
* SQL
** [http://sqlfiddle.com/ SQL Fiddle] support MySQL, MS SQL, Oracle, PosgreSQL, SQLite ... {{Gd}}

== server environment ==
[[Testing server environment]]

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

check the server/service logs
=== OS ===
==== Microsoft Windows ====
** XP / Vista: 控制台 --> 系統管理工具 --> 事件檢視器
** [http://www.microsoft.com/technet/support/ee/ee_basic.aspx 事件和錯誤訊息中心: 基本搜尋]

=== Web server ===
==== Apache ====
[http://httpd.apache.org/ 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: {{kbd | key=<nowiki>grep -ir "string to search" /path/to/directory</nowiki>}}. More on [[Desktop_search#Search_text_in_files| Search text in files]]

==== IIS ====
[http://www.iis.net/ Microsoft Internet Information Services] (IIS) log (記錄檔)<ref>[http://www.dotblogs.com.tw/jimmyyu/archive/2009/06/26/9006.aspx (ASP.NET)從Log追蹤錯誤 - gipi的學習筆記-職場規劃、專案管理、雲端運算部落格- 點部落]</ref>
*  C:\WINDOWS\system32\LogFiles\

=== Database server ===
==== MySQL ====
[http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: 
* step1: verify the system variable<ref>[https://dev.mysql.com/doc/refman/5.7/en/show-variables.html MySQL :: MySQL 5.7 Reference Manual :: 13.7.5.39 SHOW VARIABLES Syntax]</ref>
<pre>
mysql> SHOW VARIABLES LIKE '%general_log%';
mysql> SHOW GLOBAL VARIABLES LIKE '%general_log%';
</pre>
* step2: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) <ref>[http://blog.longwin.com.tw/2005/10/mysql_query_slow_find/ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog]</ref>
<pre>
[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
</pre>

* step3: restart MySQL service

==== Microsoft SQL Server ====
* [http://expressprofiler.codeplex.com/ ExpressProfiler] includes all SQL queries/commands
* [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] / [http://msdn.microsoft.com/zh-tw/library/ms187885(v=sql.105).aspx 檢視 SQL Server 錯誤記錄] "contains user-defined events and certain system events ..." quoted from [http://msdn.microsoft.com/en-us/library/ms187109.aspx SQL Server Error Log] ex: X:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG 
* [http://stackoverflow.com/questions/123781/logging-all-queries-on-a-sql-server-2008-express-database Logging ALL Queries on a SQL Server 2008 Express Database? - Stack Overflow] ''not tested''

=== Other ===
==== PHP ====
[[PHP_errors#logging]]

==== Java ====

<pre>
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
</pre>

or using [https://netbeans.org/features/java/debugger.html NetBeans IDE - Debugger and Profiler] to setup the breakpoints.

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

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

== find match string ==
* {{kbd | key= grep 'string' filename -r}}
** [http://www.gnu.org/software/grep/manual/ manual], [http://greenisland.csie.nctu.edu.tw/wp/2008/03/24/1267/ 教學]

* Desktop search: [[Desktop search#Search_text_in_files | Search text in files]]

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

== related topic ==
* [[Comment Syntax]] 
* 設定中斷點

related terms
* functional testing

templates
* [[Bug report template]]

== References ==
<references/>

further reading
* [http://help.trello.com/article/736-troubleshooting-browser-issues-with-trello Troubleshooting browser issues with Trello - Trello Help] {{access | date = 2017-03-28}}
* [https://asana.com/guide/help/faq/connectivity Supported browsers and troubleshooting steps for Asana | Product guide · Asana] {{access | date = 2017-03-28}}
* [https://ngrok.com/ ngrok - secure introspectable tunnels to localhost] {{access | date = 2020-02-20}}

{{Template:Build a website}}


[[Category:Software]]
[[Category:Programming]]
[[Category:Web_Dev]]
[[Category:MySQL]]
[[Category:Linux]]
[[Category:Testing]]