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示例程序

//本机
//$con = sqlrcon_alloc("sqldb",9001,"/tmp/mysqldb.socket","sqlrelay","123456",0,1);
//远程
$con = sqlrcon_alloc("192.168.1.112",9001,"/tmp/mysqldb.socket","sqlrelay","123456",0,1);
$cur = sqlrcur_alloc($con);
echo "Start:";
sqlrcur_sendQuery($cur,"select * from user");
     for ($row=0; $row             for ($col=0; $col                     echo sqlrcur_getField($cur,$row,$col);
                     echo ",";
             }
             echo "
";
     }
sqlrcur_free($cur);
sqlrcon_free($con);
?>