configure: error: failed to recognize APR_INT64_T_FMT on this platform

configure: Configuring python swig binding
checking for Python includes... -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7
checking for compiling Python extensions... cc -arch x86_64 -arch i386 -pipe
checking for linking Python extensions... cc -bundle -undefined dynamic_lookup -arch x86_64 -arch i386 -Wl,-F. -framework Python
checking for linking Python libraries... -bundle -undefined dynamic_lookup -Wl,-F. -framework Python
checking for apr_int64_t Python/C API format string...
configure: error: failed to recognize APR_INT64_T_FMT on this platform


在mac os 10.10的solution為：

$ xcode-select --install

mac OSX 10.10 安裝PHP pcntl extension

1.抓取php 5.5.14 source code

http://tw1.php.net/get/php-5.4.24.tar.bz2/from/a/mirror

2.Build the PHP pcntl extension

tar -jxvf  PHP-5.5.14.tar.bz2

cd php-5.5.14/ext/pcntl/

/usr/bin/phpize

./configure

make

sudo make install

3.Enable the extension

編輯 /etc/php.ini  並加入

extension=pcntl.so

4.Restart apache
 
sudo /usr/sbin/apachectl restart

mac os 10.10 mysql 慢查詢 (slow query log)

1.可由以下query得知相關參數

show variables like "%slow_query_log%

Variable_name	Value
slow_query_log	OFF
slow_query_log_file	/usr/local/mysql/data/server-slow.log

2.開啟慢日誌(slow query log)

vi /usr/local/mysql/my.cnf

加入

slow_query_log=on ＃開啟
slow_query_log_file=mysql-slow #檔案名稱
long_query_time=2 ＃2s

3.慢查詢分析方法

官方：MySQLdumpslow
其他: pt-query-digest

4.log_queries_not_using_indexes

Command-Line Format	--log-queries-not-using-indexes
System Variable Name	log_queries_not_using_indexes
Variable Scope	Global
Dynamic Variable	Yes
	Permitted Values
	Type	boolean
	Default	OFF

Whether queries that do not use indexes are logged to the slow query log.

install apache subversion on mac os 10.10

1.download apache subversion source code

2.build subversion

cd ~/Downloads/subversion-1.8.10

./configure

make

3.複製.so到apache

sudo cp subversion/mod_dav_svn/.libs/mod_dav_svn.so /usr/libexec/apache2

sudo cp subversion/mod_authz_svn/.libs/mod_authz_svn.so /usr/libexec/apache2



Note:

svn的設定檔在以下位置

/Library/Server/Web/Config/apache2/other/svn.conf

ERROR! The server quit without updating PID file (/usr/local/mysql/data/server.local.pid).

當開啟mysql時遇到以下error

Starting MySQL

.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/server.local.pid).

在網路上查了很多總解法都無效....

後來把ib_logfile0與ib_logfile1砍掉就搞定了

sudo rm -rf /usr/local/mysql/data/ib_logfile0

sudo rm -rf /usr/local/mysql/data/ib_logfile1

mysql upgarde on mac osx 10.9

停止mysql服務

sudo /usr/local/mysql/support-files/mysql.server stop

到mysql官網抓取安裝程式
在此安裝了mysql 5.6.20

點選下載下來的.pkg檔案,安裝MySQL Server

確認/usr/local/mysql是否指定新版的sql

1.ls -al /usr/local/mysql

2.lrwxr-xr-x  1 root  wheel  27  8 24 23:36 /usr/local/mysql -> mysql-5.6.20-osx10.8-x86_64

將舊版本data複製到新版

1.cd /usr/local

2.sudo cp -rf mysql-5.5.27-osx10.6-x86_64/data/  mysql-5.6.20-osx10.8-x86_64/data/

3.確認權限是否正確，如果不對，利用sudo chown -R 更改權限

啟動新版本的MySQL

sudo /usr/local/mysql/support-files/mysql.server start

執行升級程序 

1.sudo /usr/local/mysql/bin/mysql_upgrade

2.sudo /usr/local/mysql/support-files/mysql.server restart 

更新密碼 

/usr/local/mysql/bin/mysqladmin -u root password 'password' 

Note:

官方說明文件 

mac OSX 10.9安裝PHP extension

1.抓取php 5.4.24 source code

http://tw1.php.net/get/php-5.4.24.tar.bz2/from/a/mirror

2.Build the PHP XXX extension

cd ~/Downloads
unzip PHP-5.4.17.zip
cd php-src-PHP-5.4.17/ext/XXX/
/usr/bin/phpize
./configure
make
sudo make install

3.Enable the extension

編輯 /etc/php.ini file 並加入
extension=XXX.so

4.Restart apache

530 User xxxxx may not use FTP, mac os server

我在Mountain lion server.app下建立一個新用戶(沒有家目錄)，

並且妥當的設定了FTP文件夾的權限。

然而很不幸的，在ftp連線時總是得到以下錯誤回應：

'530 User <account> may not use FTP.'


解決辦法如下：

Server app -> Accounts -> Users ->在context menu選擇使用者

-> Advanced Options -> Login shell

->將Services only帳號預設的 /user/bin/false 改成 /bin/sh

大功告成！！