Testing: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
(→PHP) |
mNo edit summary |
||
(126 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
== Test connectivity for the web service == | |||
[[Test connectivity for the web service]] | |||
== user client node == | == user client node == | ||
=== browser issue === | === 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)]] | |||
=== plug-ins issue === | === browser plug-ins issue === | ||
* [http://www.adobe.com/software/flash/about/ Test your Adobe Flash Player installation] | * [http://www.adobe.com/software/flash/about/ Test your Adobe Flash Player installation] | ||
* [http://www.adobe.com/shockwave/welcome/ Adobe - Test Adobe Shockwave Player] | * [http://www.adobe.com/shockwave/welcome/ Adobe - Test Adobe Shockwave Player] | ||
Line 75: | Line 24: | ||
=== e-mail testing issue === | === e-mail testing issue === | ||
[[Email testing]] | |||
=== monitoring the status or changes of files or registry === | === monitoring the status or changes of files or registry === | ||
Line 83: | Line 30: | ||
* [http://technet.microsoft.com/en-us/sysinternals/bb896652 RegMon for Windows] / [http://portable.easylife.tw/101 RegMon 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 the HTTP request sent to the server === | === monitoring or generating the HTTP request sent to the server === | ||
[[HTTP request and response data tool]] | [[HTTP request and response data tool]] | ||
=== domain name issue === | === domain name issue === | ||
Modify the following | 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> | * 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 | ||
* C:\WINNT\system32\drivers\etc\hosts | * On Windows 2003 server: edit the file located at {{kbd | key=<nowiki>C:\WINNT\system32\drivers\etc\hosts</nowiki>}} | ||
* {{kbd | key=<nowiki>/etc/hosts</nowiki>}} | * On {{Linux}}, input the command {{kbd | key=<nowiki>sudo vi /etc/hosts</nowiki>}} | ||
<pre> | <pre> | ||
127.0.0.1 localhost | 127.0.0.1 localhost | ||
# ip domain.com | # ip domain.com | ||
</pre> | </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]] | more on [[Web_Ping#DNS.E6.AA.A2.E6.9F.A5 | DNS checking]] | ||
Line 123: | Line 75: | ||
* 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}} | ||
== server environment == | |||
[[Testing server environment]] | |||
== local server node (if you has permission to log in the server via SSH or Remote desktop service) == | == local server node (if you has permission to log in the server via SSH or Remote desktop service) == | ||
Line 146: | Line 101: | ||
==== MySQL ==== | ==== MySQL ==== | ||
[http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: | [http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: | ||
* step1: 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> | * 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> | <pre> | ||
[mysqld] | [mysqld] | ||
Line 160: | Line 120: | ||
</pre> | </pre> | ||
* | * step3: restart MySQL service | ||
==== Microsoft SQL Server ==== | ==== Microsoft SQL Server ==== | ||
Line 170: | Line 129: | ||
=== Other === | === Other === | ||
==== PHP ==== | ==== PHP ==== | ||
[[PHP_errors#logging]] | |||
==== Java ==== | |||
<pre> | <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> | </pre> | ||
or using [https://netbeans.org/features/java/debugger.html NetBeans IDE - Debugger and Profiler] to setup the breakpoints. | |||
==== console command ==== | |||
<pre> | <pre> | ||
//write the console output to the file | |||
command > log.txt | |||
//append to the same file | |||
command >> log.txt | |||
</pre> | </pre> | ||
Line 237: | Line 164: | ||
* functional testing | * functional testing | ||
== | templates | ||
* [[Bug report template]] | |||
== References == | |||
<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:Software]] | ||
Line 244: | Line 182: | ||
[[Category:Web_Dev]] | [[Category:Web_Dev]] | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Linux]] | |||
[[Category:Testing]] |