14,958
edits
| Line 114: | Line 114: | ||
== 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) == | ||
check the server/service logs | |||
=== OS === | |||
==== Microsoft Windows ==== | |||
** XP / Vista: 控制台 --> 系統管理工具 --> 事件檢視器 | ** XP / Vista: 控制台 --> 系統管理工具 --> 事件檢視器 | ||
** [http://www.microsoft.com/technet/support/ee/ee_basic.aspx 事件和錯誤訊息中心: 基本搜尋] | ** [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) | [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 | * access.log | ||
| Line 127: | Line 127: | ||
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]] | 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> | [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\ | * C:\WINDOWS\system32\LogFiles\ | ||
=== Database server === | |||
==== 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: 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> | ||
| Line 151: | Line 151: | ||
==== Microsoft SQL Server ==== | |||
[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'' | [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 ==== | |||
native error logging | native error logging | ||
* [http://www.php.net/ PHP] log: check the configuration file: /etc/php.ini (the location of configuration file can be verified by [http://php.net/manual/en/function.phpinfo.php phpinfo()] ) | * [http://www.php.net/ PHP] log: check the configuration file: /etc/php.ini (the location of configuration file can be verified by [http://php.net/manual/en/function.phpinfo.php phpinfo()] ) | ||
| Line 191: | Line 191: | ||
more on [http://php.net/manual/en/language.constants.predefined.php PHP: Magic constants] | more on [http://php.net/manual/en/language.constants.predefined.php PHP: Magic constants] | ||
==== Java ==== | |||
<pre> | <pre> | ||