sqlrelay安装手记

    sqlrelay如果要支持php，则要求php为tar.gz包安装，用rpm包安装的php没有测试成功，mysql可以用rpm安装。安装sqlrelay之前先要安装rudiments，安装环境为as4u4x_86。

#安装rudiments0.31
tar xvzf rudiments-0.31.tar.gz
cd rudiments-0.31
./configure --with-mysql-prefix=/usr/local/mysql --with-php-prefix=/usr/local/php5
make
make install
#安装sqlrelay-0.39.4(如果此包不能安装成功，可换sqlrelay-0.39)
tar xvzf sqlrelay-0.39.4.tar.gz
cd sqlrelay-0.39.4
./configure --with-mysql-prefix=/usr/local/mysql --with-php-prefix=/usr/local/php5 --disable-ruby
make
make install

#配置php.ini
vi /usr/local/php5/etc/php.ini
extension_dir = "./"  更改为：
extension_dir = "/usr/local/php5/lib/php/extensions/no-debug-non-zts-20060613"
#(路径视具体情况而定)，然后添加so库
extension=sql_relay.so

#配置sqlrelay
vi /usr/local/firstworks/etc/sqlrelay.conf


  
   
  
  
   
  

#启动sqlrelay
/usr/local/firstworks/bin/sqlr-start -id sqldb
#php示例程序