解决Mantis挂mysql上传大附件

问题:Mantis采用$g_file_upload_method=DATABASE;模式，无法上传大于900k的附件51Testing软件测试网hj2{;g Q6TP1Y|;\?v
解决方法:51Testing软件测试网6TQ`s Z$nd1x
1.修改mantis的config_inc.php，添加
g7|Od?)N|d%M0    $g_preview_attachments_inline_max_size = 800000000;51Testing软件测试网7cMlc6Y*x o
$g_allowed_files = ''51Testing软件测试网"OtCL;u
51Testing软件测试网2gW9o2W+AS)L
2.修改php的php.ini配置，修改相关参数51Testing软件测试网,OCf%h$UdP^#u

• file_uploads=On
• upload_max_filesize=90M
• max_input_time=90
• memory_limit=128M
  -jemI,m9X0
• max_execution_time=90
• post_max_size=80M

3.修改mysql的my.ini,在[mysqld]的下面添加如下参数
|"e'['yg%[L0[mysqld]
V(B1c'U/X n0log-bin51Testing软件测试网8U7K5`dtHa(iM
P
#log-bin="c:/mysql/logs/bin.log"51Testing软件测试网^3ti)cK6^
#log-error="c:/mysql/logs/error.log"51Testing软件测试网:@ XeP `woB7Ul
#log="c:/mysql/logs/mysql.log"
8k,Bhr1e w3Gz0skip-locking
;}Y&?kW0key_buffer = 384M51Testing软件测试网!V-PD
l Z#}.a
max_allowed_packet = 32M
$F,m+J"sN Y0table_cache = 51251Testing软件测试网;CQa-R:W Y wS
sort_buffer_size = 2M
L%\5zVA5LC,_0read_buffer_size = 2M
!k K
{\pg6}{z0read_rnd_buffer_size = 8M51Testing软件测试网(I4` ] U
j0Ap
myisam_sort_buffer_size = 64M
K[#b`1dn|#Z3c*B0thread_cache_size = 8
nS kY2JjP0query_cache_size = 32M51Testing软件测试网"B'B!C3aG+V+_
51Testing软件测试网7i4Jef)D
51Testing软件测试网"l^j&i+v$_de
参考链接:
[a'JD I-Y:[0http://www.mantisbt.org/bugs/view.php?id=485051Testing软件测试网SCm)@)X,G0~1A
51Testing软件测试网Q7A-yL5o1]3T3H/n
http://www.radinks.com/upload/config.php51Testing软件测试网%LvQ {Gj'JF

B&qx6w!w`!AE B0http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
)lz{dx+^)k051Testing软件测试网;@{)LF#i'u+VK
51Testing软件测试网S9U0| QqRB0x!f