TeamSpeak2 linux mysql5.0

Foolsegg

SET PASSWORD FOR ''@'localhost' = OLD_PASSWORD('')
==========================================================
mkdir /opt/teamspeak
cd /opt/teamspeak
groupadd teamspeak
groupadd servers
useradd -d /opt/teamspeak -g teamspeak -G servers teamspeak
passwd teamspeak
wget ftp://ftp.freenet.de/pub/4players/teamspeak.org/releases/ts2_server_rc2_20201.tar.bz2
tar xvjf ts2_server_rc2_20201.tar.bz2
cp -r tss2_rc2/* .
rm -r tss2_rc2/
chown -R teamspeak:teamspeak .

cd /usr/lib
wget http://dafox.nb4f.de/files/libmysqlclient.so.10.0.0
wget http://dafox.nb4f.de/files/libmysqlclient_r.so.10.0.0
ln -s libmysqlclient.so.10.0.0 libmysqlclient.so.10
ln -s libmysqlclient_r.so.10.0.0 libmysqlclient_r.so.10

# ls -l /usr/lib/libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 198920 jan 29 2003 /usr/lib/libmysqlclient_r.so.10.0.0
# ls -l /opt/teamspeak2-server/libsqlmy.so
-rwxr-xr-x 1 teamspeak nogroup 131736 mar 30 2005 /opt/teamspeak2-server/libsqlmy.so


mysql -u root -p
mysql> create database teamspeak;
mysql> grant all privileges on teamspeak.* to teamspeak@localhost;
mysql> set password for teamspeak@localhost = OLD_PASSWORD('');


[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=127.0.0.1
User_name=teamspeak
Password=xxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10
LibraryName=./libsqlmy.so
Active=1


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ts with mysql >4.0


vi sqlite_sql/read_servers.sql  

select * from ts2_servers WHERE i_server_id > 0;

vi sqlite_sql/read_channel_privilege.sql

select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID;(只能是一行)





本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/14202/showart_473974.html