Server Error : Timeout expired September 1, 2011
Posted by jbanju in Programming ASP.NET.add a comment
แก้ไข Error
Server Error in ‘/’ Application.
——————————————————————————–
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
ให้แก้ไขที่ web.config โดยเพิ่ม Timeout
<system.web>
<httpModules>
<add name=”Progress” type=”WebSupergoo.ABCUpload5.ProgressModule, ABCUpload5, Version=5.3.0.0, Culture=neutral, PublicKeyToken=1f89539196ce5fbf”/>
</httpModules>
<compilation>
<assemblies>
<add assembly=”ABCUpload5, Version=5.3.0.0, Culture=neutral, PublicKeyToken=1f89539196ce5fbf” />
</assemblies>
</compilation>
<httpRuntime
maxRequestLength=”1048576″
executionTimeout=”3600″
/>
<sessionState
timeout=”60″
/>
ในส่วนของ code program ตรงส่วนของ connection
Command.CommandTimeout=90//time in sec’s
…
phpMyAdmin ตั้ง size limits และ timeout เวลา import mysql data ขนาดใหญ่ August 31, 2011
Posted by jbanju in LINUX CentOS.add a comment
แก้ไขขนาด file upload /etc/php.ini
post_max_size = 8M
upload_max_filesize = 2M
แก้ไขค่า Timeout ที่
file http.conf
Timeout 60000
file php.ini
max_execution_time = 60000
max_input_time = 60000
memory_limit = 2000M
file config.inc.php ที่ phpmyadmin
$cfg['Servers'][$i]['ExecTimeLimit'] = 60000;
MySQL Change root Password August 31, 2011
Posted by jbanju in LINUX CentOS.add a comment
If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
$ mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use the following command:
$ mysqladmin -u root -p’oldpassword’ password newpassFor
example, If the old password is abc, you can set the new password to 123456, enter:
$ mysqladmin -u root -p’abc’ password ’123456′
ตรวจสอบ log ในการ start service ต่างๆ August 31, 2011
Posted by jbanju in LINUX CentOS.add a comment
ตรวจสอบ log ในการ start service ต่างๆ สามารถดูได้ที่
vi /var/log/messages
