MySQL現階段參數值

1.點phpMyAdmin資訊
2.mysql> show variables (like '%size');

/usr/bin/dvips: ! DVI file can't be opened.

moodle內有支援tex(latex)
因為是直接調控主機內的程式，所以安裝了
tetex-latex
及其他相依程式

測試過後發現圖片出不來
檢查/etc/httpd/logs/error_log

kpathsea: Running mktexfmt latex.fmt
kpathsea: Running mktexfmt latex.fmt
fmtutil: format directory `/.texmf-var/web2c' does not exist.
fmtutil: format directory `/.texmf-var/web2c' does not exist.
This is dvips(k) 5.95a Copyright 2005 Radical Eye Software (www.radicaleye.com)
/usr/bin/dvips: ! DVI file can't be opened.
sh: /var/www/html/moodle/filter/tex/mimetex.linux: Permission denied
This is dvips(k) 5.95a Copyright 2005 Radical Eye Software (www.radicaleye.com)
/usr/bin/dvips: ! DVI file can't be opened.
sh: /var/www/html/moodle/filter/tex/mimetex.linux: Permission denied
sh: /var/www/html/moodle/filter/tex/mimetex.linux: Permission denied
sh: /var/www/html/moodle/filter/tex/mimetex.linux: Permission denied
kpathsea: Running mktexfmt latex.fmt
fmtutil: format directory `/.texmf-var/web2c' does not exist.
This is dvips(k) 5.95a Copyright 2005 Radical Eye Software (www.radicaleye.com)
/usr/bin/dvips: ! DVI file can't be opened.
convert: unable to open image `/backup/temp/latex/d1e56126337cd6e29b16fe759232ce90.ps': No such file or directory.

將/moodledata/temp/latex內修改權限便可以看到圖片了

Metadata file does not match checksum

當執行yum時如果出現
Metadata file does not match checksum
可以在yum.conf裡添加

http_caching=none

參考網址
http://plone.lucidsolutions.co.nz/linux/rpm/yum-metadata-file-does-not-match-checksum

PHP 取得client IP

僅作備忘用

if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip=$_SERVER['HTTP_CLIENT_IP'];
else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
else
$ip=$_SERVER['REMOTE_ADDR'];
原文連結

Call to undefined function mssql_connect() in

這不是什麼新聞了...
網路上都在流傳把php_mssql.dll及ntwdblib.dll複製到system32底下重開阿帕契便行了
しかぁぁぁぁぁぁし
事情沒有憨人想的那麼簡單...就是找不到function!!
我把那二個檔案能貼的地方都去貼一貼，還是一樣...
突然!!　想到我是灌win7 64bit耶...
把檔案貼到SysWOW64重開apache........
好了=..=

//
時代在進步，搜尋出來的資料也要找新一點的才行XD

Spreadsheet_Excel_Writer

安裝依附套件OLE
http://pear.php.net/package/OLE/download
pear install OLE-1.0.0RC1
安裝
http://pear.php.net/package/Spreadsheet_Excel_Writer/download
pear install Spreadsheet_Excel_Writer-0.9.2

PHP Warning: PHP Startup: Unable to load dynamic library 'C:/AppServ\php5\ext\php_exif.dll'

灌完appserv後想說裝個pear，點了go-pear.bat後卻出現mbstring.dll錯誤及標題錯誤。
其實是因為exif是依附在mbstring上，要先inclue mbstring才能include exif，所以在php.ini裡把mbstring拉到exif前面去就可以囉!

參考網頁:
http://blog.yam.com/koli09/article/20020227