TeamSpeak2 linux mysql5.0

 

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
wget

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;(只能是一行)