|
|
| (87 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
|
| |
|
| == troubleshooting steps for connection test == | | == Test connectivity for the web service == |
| find the problem occurred: (1)local service (2)server to LAN (3)server to WAN
| | [[Test connectivity for the web service]] |
| | |
| WAN ○ ------- ○ LAN ------- <span style="color:red">● localhost</span>
| |
| | |
| * testing on localhost:
| |
| ** Is service alive?
| |
| ** OS firewall
| |
| *** {{Linux}}
| |
| **** (1) {{kbd | key = iptables -L}} to list all rules<ref>[http://wiki.centos.org/HowTos/Network/IPTables HowTos/Network/IPTables - CentOS Wiki]</ref> (2) rule with lower line-number will override the rule with higherer line-number<ref>[https://fedoraproject.org/wiki/How_to_edit_iptables_rules?rd=User_talk:Rforlot How to edit iptables rules - FedoraProject]</ref>
| |
| **** [https://fedoraproject.org/wiki/FirewallD FirewallD] rules ex: {{kbd | key = <nowiki>firewall-cmd --list-all-zones</nowiki>}}<ref>[https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-firewalld-on-centos-7 How To Set Up a Firewall Using FirewallD on CentOS 7 | DigitalOcean]</ref>
| |
| **** [http://linux.die.net/man/8/semanage SELinux Policy Management] ex: {{kbd | key = <nowiki>semanage port -l</nowiki>}} to list open ports
| |
| *** {{Win}} Firewall option?
| |
| ** protected by antivirus?
| |
| ** connect to localhost ex: {{kbd | key= telnet 127.0.0.1 23}} where 23 is the port number where the service running
| |
| *** if the local service is web server, you can also try {{kbd | key = <nowiki>lynx http://127.0.0.1</nowiki>}} for {{Linux}}
| |
| * double [[Testing#check_the_server.2Fservice_logs | check the server/service logs]]
| |
| | |
| WAN ○ ------- <span style="color:red">● LAN ------- ● localhost</span>
| |
| | |
| * testing on LAN (local network, subnet scope): Is service alive? The different servers between LAN or with the same ip class (ex: 1.2.3.*) may not have the firewall limit.
| |
| ** connect to localhost ex: {{kbd | key= telnet 172.18.0.1 23}} (1) IP start with 172.18... is [http://www.itcom.itd.umich.edu/backbone/umnet/privateIP.html Private IP Network Numbers] (2) where 23 is the port number where the service running
| |
| *** if the local service is web server, you can also try {{kbd | key = <nowiki>lynx http://172.18.0.1</nowiki>}} for {{Linux}}
| |
| * double [[Testing#check_the_server.2Fservice_logs | check the server/service logs]]
| |
| | |
| <span style="color:red">WAN ● ------- ● LAN ------- ● localhost</span>
| |
| | |
| We met the trouble on WAN
| |
| * testing on WAN: Down for everyone or just me? Check by [[Web_Ping#同時從世界各處測試網站連線 | Web Ping]]
| |
| * is hardware firewall opened?
| |
| * is gateway alive?
| |
| * is DND alive?
| |
| | |
| other issue:
| |
| * bandwidth cost too much by certain users
| |
| * exceed the request limit of (hardware) firewall
| |
| * the external connection of updated Windows was down until reboot {{Win}}
| |
| * Amazon EC2 security group
| |
| * refresh browser cache: [http://refreshyourcache.com/en/cache/ Refresh your cache - When hitting F5 just isn't enough!]
| |
| | |
| == 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]]
| |
| | |
| telnet
| |
| * 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"
| |
| | |
| 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 == | | == user client node == |
|
| |
|
| === browser issue === | | === browser & device issue === |
| * browser version: [[Check Browser Compatibility]] & Validation service or [[Validator]]: Check Markup or CSS syntax | | * Browser version: [[Check Browser Compatibility]] & Validation service or [[Validator]]: Check Markup or CSS syntax |
| * 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 繞過瀏覽器快取]) | | * Multiple screen resolution test: [[CSS_tools#不同螢幕解析度檢視網頁 | 不同螢幕解析度檢視網頁]] |
| ** client temporary files | | * [[Mobile friendliness tool]] |
| * clear server cache ex: [http://www.smarty.net/manual/en/caching.php Smarty Caching] | | * 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 ==== | | ==== Online IDE ==== |
| * code snippet web-based editor / communication tools between developers/designers
| | [[Programming online (Online IDE)]] |
| ** [http://codepad.org/ codepad] {{access | date=2012-10-02}} {{access | date = 2014-10-07}}
| |
| ** [http://cssdesk.com/ CSSDesk] HTML, CSS {{access | date=2013-02-11}}
| |
| ** [http://dabblet.com/ The first commented line is your dabblet’s title ✿ dabblet.com]: view the [http://dabblet.com/gist/2779082 sample] of html and css {{access | date = 2012-08-22}}
| |
| ** [http://ideone.com/ Ideone.com] "Online IDE & Debugging Tool >> C/C++, Java, PHP, Python, Perl and 40+ compilers and interpreters"
| |
| ** [http://jsbin.com/ JS Bin - Collaborative JavaScript Debugging]: HTML, CSS, Javascript<ref>[http://blog.miniasp.com/post/2013/06/30/Useful-tool-JS-Bin-Collaborative-JavaScript-Debugging.aspx The Will Will Web - 介紹好用工具:JS Bin ( 網站前端工程師的學習利器 )]</ref>
| |
| ** [http://jsfiddle.net/ jsFiddle] {{access | date = 2014-10-07}}
| |
| ** [http://plnkr.co/ Plunker] {{access | date = 2014-10-07}}
| |
| * database testing
| |
| ** [http://ideone.com/ Ideone.com] support SQL {{exclaim}} not support REGEXP function {{access | date = 2015-03-09}}
| |
| ** [http://sqlfiddle.com/ SQL fiddle] support MySQL, MS SQL server, Oracle, PostgreSQL, SQLite ... {{exclaim}} data may not showed in couple days {{access | date = 2015-03-09}}
| |
| | |
| * Save or share source codes
| |
| ** [http://pastie.org/ Pastie] with syntax highlighting
| |
| ** [http://pastebin.com/ Pastebin.com - #1 paste tool since 2002!]
| |
| ** [http://tny.cz/ Tinypaste - The easiest way to host your text]
| |
|
| |
|
| === browser plug-ins issue === | | === browser plug-ins issue === |
| Line 112: |
Line 24: |
|
| |
|
| === e-mail testing issue === | | === e-mail testing issue === |
| Using the following e-mail service with name alias or alternative name
| | [[Email testing]] |
| * [https://gmail.google.com/ Google Gmail]: plus sign {{exclaim}} the plus sign is not allowed by some websites
| |
| * [http://get.live.com/mail/overview Windows Live™ Hotmail]: [http://windows.microsoft.com/zh-TW/hotmail/conquergraymail/advanced/alias Alias] / 在一個收件匣建立多個別名 {{access | date=2012-03-30}}
| |
| | |
| [https://technet.microsoft.com/zh-tw/library/aa995718(v=exchg.65).aspx 如何使用 Telnet 來測試 SMTP 通訊]
| |
|
| |
|
| === monitoring the status or changes of files or registry === | | === monitoring the status or changes of files or registry === |
| Line 127: |
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> | | * 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 for Windows 2003 server | | * 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>}} for {{Linux}} | | * 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 162: |
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 185: |
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 199: |
Line 120: |
| </pre> | | </pre> |
|
| |
|
| * step2: restart MySQL service | | * step3: restart MySQL service |
| | |
|
| |
|
| ==== Microsoft SQL Server ==== | | ==== Microsoft SQL Server ==== |
| Line 235: |
Line 155: |
| * 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 244: |
Line 164: |
| * functional testing | | * functional testing |
|
| |
|
| == references == | | 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}} | | {{Template:Build a website}} |
| Line 256: |
Line 183: |
| [[Category:MySQL]] | | [[Category:MySQL]] |
| [[Category:Linux]] | | [[Category:Linux]] |
| | [[Category:Testing]] |