LINUX :RH AS3
PHP Version 4.3.11
FreeTDS: freetds-0.63
RUDIMENTS: rudiments-0.30
SQL Relay: sqlrelay-0.38/usr/local/freetds/etc/treetds.conf:
===========================================
[mstest]
host = 192.168.1.152
port =1433
tds version = 7.0
client charset = GB2312
===========================================
/usr/local/sqlrelay/etc/sqlrelay.conf
============================================================
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd"><instances> <!-- Regular SQL Relay Instance -->
<instance id="mstest" port="1433" socket="/tmp/mstest.socket" dbase="freetds" connections="5" maxconnections="10
" maxqueuelength="0" growby="1" ttl="60" endofsession="commit" sessiontimeout="5" runasuser="nobody" runasgroup="nobody" cursors="5"
authtier="listener" handoff="pass"> <users>
<user user="sa" password="sa"/>
</users>
<connections>
<connection connectionid="mstest" string="user=sa;password=sa;" metric="1" behindloadbalancer="no"/>
</connections>
</instance>
</instances>
=============================================================现在问题是,
单独启动/usr/local/freetds/bin/tsql -S 192.168.1.152:1433 -U sa
可以看到1>,应该表示可操控数据库使用PHP写了一段
<?
$conn = mssql_connect("mstest","sa","sa");
mssql_select_db("news");$SQL = "SELECT title FROM matter_news";
$res = mssql_query($SQL,$conn);
$arr = mssql_fetch_array($res);
while($arr = mssql_fetch_array($res)) {
echo "TITLE=".$arr['title']."<br>";
}
?>
程序也可以正常输出只是,如果使用SQL RELAY的时候,
[root@MYDB bin]# sqlr-start -id mstestStarting listener:
sqlr-listener -id mstest -config /usr/local/sqlrelay/etc/sqlrelay.confStarting 5 connections to mstest :
sqlr-connection-freetds -id mstest -connectionid mstest -config /usr/local/sqlrelay/etc/sqlrelay.conf
sqlr-connection-freetds: error while loading shared libraries: libct.so.3: cannot open shared object file: No such file or directorysqlr-connection-freetds failed to start.
Thanks to MP3.com for sponsoring:
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring:
Query routing and filtering.
WEB页面没办法正常输出,请高手检查一下,我是哪里错了呢
PHP Version 4.3.11
FreeTDS: freetds-0.63
RUDIMENTS: rudiments-0.30
SQL Relay: sqlrelay-0.38/usr/local/freetds/etc/treetds.conf:
===========================================
[mstest]
host = 192.168.1.152
port =1433
tds version = 7.0
client charset = GB2312
===========================================
/usr/local/sqlrelay/etc/sqlrelay.conf
============================================================
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd"><instances> <!-- Regular SQL Relay Instance -->
<instance id="mstest" port="1433" socket="/tmp/mstest.socket" dbase="freetds" connections="5" maxconnections="10
" maxqueuelength="0" growby="1" ttl="60" endofsession="commit" sessiontimeout="5" runasuser="nobody" runasgroup="nobody" cursors="5"
authtier="listener" handoff="pass"> <users>
<user user="sa" password="sa"/>
</users>
<connections>
<connection connectionid="mstest" string="user=sa;password=sa;" metric="1" behindloadbalancer="no"/>
</connections>
</instance>
</instances>
=============================================================现在问题是,
单独启动/usr/local/freetds/bin/tsql -S 192.168.1.152:1433 -U sa
可以看到1>,应该表示可操控数据库使用PHP写了一段
<?
$conn = mssql_connect("mstest","sa","sa");
mssql_select_db("news");$SQL = "SELECT title FROM matter_news";
$res = mssql_query($SQL,$conn);
$arr = mssql_fetch_array($res);
while($arr = mssql_fetch_array($res)) {
echo "TITLE=".$arr['title']."<br>";
}
?>
程序也可以正常输出只是,如果使用SQL RELAY的时候,
[root@MYDB bin]# sqlr-start -id mstestStarting listener:
sqlr-listener -id mstest -config /usr/local/sqlrelay/etc/sqlrelay.confStarting 5 connections to mstest :
sqlr-connection-freetds -id mstest -connectionid mstest -config /usr/local/sqlrelay/etc/sqlrelay.conf
sqlr-connection-freetds: error while loading shared libraries: libct.so.3: cannot open shared object file: No such file or directorysqlr-connection-freetds failed to start.
Thanks to MP3.com for sponsoring:
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring:
Query routing and filtering.
WEB页面没办法正常输出,请高手检查一下,我是哪里错了呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货