Testing: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
Line 63: Line 63:
** error.log - record when the apache service restarted/stopped
** error.log - record when the apache service restarted/stopped


* [http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) and restart MySQL service
* [http://dev.mysql.com/doc/refman/5.1/en/server-logs.html MySQL Server Logs]: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) and restart MySQL service<ref>[http://blog.longwin.com.tw/2005/10/mysql_query_slow_find/ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog]</ref>
<pre>
<pre>
general_log = 1
[mysqld]
general_log_file="general_log_file.log"
log-error=/var/log/mysql/error.log
slow_query_log = 1
log-slow-queries = /var/log/mysql/mysql-slow.log
slow_query_log_file="slow_query_log_file.log"
long_query_time = 5
log-long-format
</pre>
</pre>


Revision as of 14:05, 16 March 2012

Web site design and development process


remote node

browser

  • connect to http://ip:80
  • or use the website monitoring services: Web Ping

Validation service

Validator: Check Markup or CSS syntax


user client node

browser issue

plug-ins issue

e-mail testing issue

Using the following e-mail service with name alias or alternative name function

monitoring the status or changes of files or registry

local node (if you can login the server via SSH or Remote desktop service)

check the service port

from local node to service node

telnet

  1. telnet DOMAIN_or_IP PORT ex: telnet localhost 80 or telnet 127.0.0.1 80
  2. (after telnet-ed the web 80 port, ) key in GET and press ENTER
  3. more on HTTP Check Port 80 with the Telnet Command

netstat ex: find MySQL 3306 port

  1. netstat -a | find "3306"
  2. more on List open ports and listening services

tools

from local or remote node to service node

telnet

  1. telnet DOMAIN_or_IP PORT ex: telnet localhost 80 or telnet 127.0.0.1 80
  2. (after telnet-ed the web 80 port, key in) get + SPACE
  3. more on HTTP Check Port 80 with the Telnet Command

from remote node to service node

tools

  1. Good.gif Open Port Check Tool: Using browser to check the specified port of local machine from canyouseeme.org.
  2. PFPortCheck Program: check TCP/UDP port from localhost(where you installed the program) to portforward.com
  3. Web_Ping#網站連線測試: to test the port 80

check the server/service logs

  • 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
  • MySQL Server Logs: enable logging /var/log/mysql.log (location was set up in the configuration file /etc/my.cnf or my.ini) and restart MySQL service[1]
[mysqld] 
log-error=/var/log/mysql/error.log
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 5
log-long-format
  • PHP log: check the configuration file: /etc/php.ini (the location of configuration file can be verified by phpinfo() )

(for production site) unmark theese lines in the php.ini and restart Apache service 

log_errors = On
error_log = "php_error.log"

(for development site) using error_reporting 

error_reporting(E_ALL);

find match string

related topic

related terms

  • functional testing
  1. ↑ 找出 MySQL 哪些 Query 速度較慢 | Tsung's Blog
Retrieved from "https://wiki.planetoid.info/index.php?title=Testing&oldid=10869"