{"id":62,"date":"2012-05-08T18:38:41","date_gmt":"2012-05-08T18:38:41","guid":{"rendered":"http:\/\/blog.chury721.cz\/?p=62"},"modified":"2021-04-06T22:50:07","modified_gmt":"2021-04-06T20:50:07","slug":"teamspeak3-server-mysql-linux-x86","status":"publish","type":"post","link":"https:\/\/blog.chury721.cz\/?p=62","title":{"rendered":"TeamSpeak3 Server + MySQL => LINUX x86"},"content":{"rendered":"

Potr\u00e1pil jsem se tro\u0161ku s rozchozen\u00edm TeamSpeak3 Server pod Linuxem, spojen\u00fd s databaz\u00ed MySQL. Pokus\u00edm se srozumiteln\u011b popsat jak na to \ud83d\ude42 Nejd\u0159\u00edve ze v\u0161echo pot\u0159ebujeme st\u00e1hnout bal\u00ed\u010dek s TeamSpeak3 Server, kter\u00fd z\u00edsk\u00e1me nejl\u00e9pe na ofici\u00e1ln\u00edm webu: http:\/\/www.teamspeak.com\/?page=downloads
\n<\/a>
\nV Shellu nap\u00ed\u0161eme p\u0159\u00edkaz na sta\u017een\u00ed bal\u00ed\u010dku a rovnou p\u0159ejmenov\u00e1n\u00ed:<\/p>\n

    wget http:\/\/teamspeak.gameserver.gamed.de\/ts3\/releases\/3.0.5\/teamspeak3-server_linux-x86-3.0.5.tar.gz\u00a0-O ts3.tar.gz<\/pre>\n
Rozbal\u00edme bal\u00ed\u010dek:<\/p>\n
 tar -xvzf ts3.tar.gz<\/pre>\n
P\u0159esuneme rozbalenou slo\u017eku do \/etc\/ts3:
\n mv teamspeak3-server_linux-x86 \/etc\/ts3
\nD\u00e1me pr\u00e1va slo\u017ece ts3:<\/p>\n
 chmod -R 777 ts3<\/pre>\n
P\u0159epneme se do \u0161lo\u017eky ts3:<\/p>\n
  cd \/etc\/ts3<\/pre>\n
Pokud nem\u00e1me, tak nainstalujeme Mysql Server a ostatn\u00ed pluginy\/knihovny:<\/p>\n
 sudo apt-get install mysql-server mysql-client libmysqlclient15-dev phpmyadmin<\/pre>\n
P\u0159ipoj\u00edme se do DBS a vytvo\u0159\u00edme datab\u00e1zi pro ts3:<\/p>\n
 mysql -u root -p CREATE DATABASE teamspeak3; quit<\/pre>\n
Nyn\u00ed se vr\u00e1t\u00edme zp\u011bt a vytvo\u0159\u00edme soubor  ts3server.ini <\/em> :<\/p>\n
  cat > ts3server.ini <<END\r\n  machine_id=\r\n  default_voice_port=9987\r\n  voice_ip=0.0.0.0\r\n  licensepath=\r\n  filetransfer_port=30033\r\n  filetransfer_ip=0.0.0.0\r\n  query_port=10011\r\n  query_ip=0.0.0.0\r\n  dbplugin=ts3db_mysql\r\n  dbpluginparameter=ts3db_mysql.ini\r\n  dbsqlpath=sql\/\r\n  dbsqlcreatepath=create_mysql\/\r\n  logpath=logs\r\n  logquerycommands=0<\/pre>\n
D\u00e1le vytvo\u0159\u00edme\u00a0  ts3db_mysql.ini <\/em> :<\/p>\n
  cat > ts3db_mysql.ini <<END\r\n  [config]\r\n  host=localhost\r\n  username=root\r\n  password=password ----- (heslo do dbs<\/strong>)\r\n  database=teamspeak3\r\n  socket= END<\/pre>\n
Nap\u00ed\u0161eme p\u0159\u00edkaz na zji\u0161t\u011bn\u00ed sou\u010d\u00e1st\u00ed plugin\u016f:<\/p>\n
  ldd libts3db_mysql.so<\/pre>\n
Pokud n\u00e1m na v\u00fdpisu vypadne n\u011bco podobn\u00e9ho, tak n\u00e1m chyb\u00ed plugin na komunikaci s MySQL:<\/p>\n
  linux-gate.so.1 => (0xb7791000)\r\n  libmysqlclient.so.15 => not found\r\n  <\/strong><\/span>libstdc++.so.6 => \/usr\/lib\/libstdc++.so.6 (0xb74ab000)\r\n  libm.so.6 => \/lib\/tls\/i686\/cmov\/libm.so.6 (0xb7484000)\r\n  libgcc_s.so.1 => \/lib\/libgcc_s.so.1 (0xb7465000)\r\n  libc.so.6 => \/lib\/tls\/i686\/cmov\/libc.so.6 (0xb730c000)\r\n  libpthread.so.0 => \/lib\/tls\/i686\/cmov\/libpthread.so.0 (0xb72f3000)\r\n  libcrypt.so.1 => \/lib\/tls\/i686\/cmov\/libcrypt.so.1 (0xb72c1000)\r\n  libnsl.so.1 => \/lib\/tls\/i686\/cmov\/libnsl.so.1 (0xb72a9000)\r\n  libz.so.1 => \/lib\/libz.so.1 (0xb7294000)\r\n  \/lib\/ld-linux.so.2 (0xb7792000)<\/pre>\n
To oprav\u00edme t\u00edm, \u017ee st\u00e1hneme knihovnu:   libmysqlclient.so.15.0.0 <\/a> <\/strong> .<\/p>\n
  wget http:\/\/blog.chury721.cz\/all\/libmysqlclient.so.15.0.0<\/pre>\n
a pou\u017eijeme n\u00e1sleduj\u00edc\u00ed p\u0159\u00edkazy:<\/p>\n
  mv libmysqlclient.so.15.0.0 \/usr\/lib\/mysql\r\n  cd \/usr\/lib\/mysql\r\n  ln -s libmysqlclient.so.15.0.0 libmysqlclient.so.15\r\n  cd \/usr\/lib\r\n<\/code>  ln -s mysql\/libmysqlclient.so.15 libmysqlclient.so.15<\/span><\/code><\/pre>\n
a po t\u00e9 vyrastartujeme MySQL Server:<\/p>\n
  \/etc\/init.d\/mysql restart<\/pre>\n
Po t\u00e9 s pou\u017eit\u00edm p\u0159\u00edkazu<\/p>\n
  ldd libts3db_mysql.so<\/pre>\n
bychom m\u011bli vid\u011bt n\u011bco podobn\u00e9ho:<\/p>\n
  linux-gate.so.1 => (0xb77ce000) \r\n  libmysqlclient.so.15 => \/usr\/lib\/libmysqlclient.so.15 (0xb75dd000)\r\n  libstdc++.so.6 => \/usr\/lib\/libstdc++.so.6 (0xb74e8000) \r\n  libm.so.6 => \/lib\/tls\/i686\/cmov\/libm.so.6 (0xb74c1000) \r\n  libgcc_s.so.1 => \/lib\/libgcc_s.so.1 (0xb74a2000) \r\n  libc.so.6 => \/lib\/tls\/i686\/cmov\/libc.so.6 (0xb7349000) \r\n  libpthread.so.0 => \/lib\/tls\/i686\/cmov\/libpthread.so.0 (0xb7330000) \r\n  libcrypt.so.1 => \/lib\/tls\/i686\/cmov\/libcrypt.so.1 (0xb72fe000) \r\n  libnsl.so.1 => \/lib\/tls\/i686\/cmov\/libnsl.so.1 (0xb72e6000)\r\n  libz.so.1 => \/lib\/libz.so.1 (0xb72d1000)\r\n  \/lib\/ld-linux.so.2 (0xb77cf000)<\/pre>\n
To by m\u011blo b\u00fdt OK. Potom sta\u010d\u00ed pou\u017e\u00edt m\u016fj vytvo\u0159en\u00fd script na spou\u0161t\u011bn\u00ed, kter\u00fd st\u00e1hnete  ZDE <\/a> a st\u00e1hneme ho do slo\u017eky \/etc\/ts3:<\/p>\n
  wget http:\/\/blog.chury721.cz\/all\/ts.sh<\/pre>\n
P\u0159i\u0159ad\u00edme mu pr\u00e1va:<\/p>\n
  chmod 777 ts.sh<\/pre>\n
a po t\u00e9 spust\u00edme:<\/p>\n
  .\/ts.sh<\/pre>\n
Vid\u00edme v\u00fdpis:\u00a0  Je potreba vypsat prikaz: <\/em><\/p>\n
  .\/ts.sh {start|stop|restart|status}<\/pre>\n
Funguj\u00ed na n\u011bj standardn\u00ed dodate\u010dn\u00e9 p\u0159\u00edkazy Tak\u017ee nyn\u00ed ji\u017e sta\u010d\u00ed spustit:<\/p>\n
  .\/ts.sh start<\/pre>\n
Vyp\u00ed\u0161e se n\u00e1m:<\/p>\n
  TeamSpeak 3 server started, for details please view the log file<\/pre>\n
Kdy\u017e se mrkneme do MySQL p\u0159es phpMyAdmina, tak vid\u00edme n\u011bco podobn\u00e9ho:<\/p>\n
 \"\" <\/a>
\nNyn\u00ed se sta\u010d\u00ed p\u0159ipojit pomoc\u00ed klienta, kter\u00e9ho sthneme zde(j\u00e1 se nach\u00e1z\u00edm ve Win7, tak\u017ee st\u00e1hnu Windows client verzi):<\/p>\n
 http:\/\/www.teamspeak.com\/?page=downloads <\/a><\/p>\n
Po\u010de\u0161t\u011bn\u00ed programu provedete n\u00e1sledovn\u011b. St\u00e1hneme  lagos_cs.qm <\/a> a ulo\u017e\u00edme ho do:<\/p>\n
  c:\\Program Files\\TeamSpeak 3 Client\\translations\\<\/pre>\n
Po t\u00e9 sta\u010d\u00ed program pustit a p\u0159ipojit se na server.<\/p>\n
 \"\" <\/a>
\n  * <\/span> <\/strong> Pro administr\u00e1torsk\u00e1 pr\u00e1va je pot\u0159eba p\u0159i prvn\u00ed p\u0159ihl\u00e1\u0161en\u00ed zadat kl\u00ed\u010d kter\u00fd najdeme na serveru ve slo\u017ece:  \/etc\/ts3\/logs <\/em><\/p>\n
\n
Je\u0161t\u011b mal\u00fd upgrade, proto\u017ee m\u011b poka\u017ed\u00fd, kdy\u017e jsem se p\u0159ipojil na server, nebavilo hledat a vzpom\u00ednat, kde ts3 zdrojov\u00e9 kody jsou(kv\u016fli spou\u0161t\u011bj\u00edc\u00edm script\u016fm).<\/p>\n
Vytvo\u0159\u00edme ALIAS p\u0159\u00edmo pro ovl\u00e1d\u00e1n\u00ed jednoho p\u0159\u00edkazu z shellu.<\/p>\n
Nejprve je pot\u0159eba upravit soubor \/etc\/ts3\/ts.sh:<\/p>\n
  nano \/etc\/ts3\/ts.sh<\/pre>\n
Kde p\u0159ed v\u0161echny scripty v Casu vlo\u017e\u00edme \/etc\/ts3\/ , tak\u017ee nap\u0159\u00edkad pro spu\u0161t\u011bn\u00ed script vypadal:<\/p>\n
  ts3server_startscript.sh start inifile=ts3server.ini<\/pre>\n
a po \u00faprav\u011b vypd\u00e1:<\/p>\n
  \/etc\/ts3\/ts3server_startscript.sh start inifile=ts3server.ini<\/pre>\n
a takto to uprav\u00edme u v\u0161ech \u010dty\u0159ech a ulo\u017e\u00edme. D\u00e1le uprav\u00edme soubor .bashrc, kter\u00fd se nach\u00e1z\u00ed(pro ka\u017ed\u00e9ho u\u017eivatele\u00fa) v \/home\/nejakyUzivatel\/.bashrc . J\u00e1 budu opravovat u\u017eivatele root, tud\u00ed\u017e to budu upravovat zde:<\/p>\n
  nano \/root\/.bashrc<\/pre>\n
Kde p\u0159id\u00e1me n\u00e1sleduj\u00edc\u00ed \u0159\u00e1dek:<\/p>\n
  alias ts='\/etc\/ts3\/ts.sh'<\/pre>\n
a ulo\u017e\u00edme. Nyn\u00ed sta\u010d\u00ed odhl\u00e1sit\/p\u0159ihl\u00e1sit (ukon\u010dit\/za\u010d\u00edt sezen\u00ed v Conzoli). a napsat v Conzoli:<\/p>\n
  ts start, ts stop<\/pre>\n
a v\u0161e by m\u011blo fungovat zap\u00ednat\/vyp\u00ednat TS3 server<\/p>\n","protected":false},"excerpt":{"rendered":"
Potr\u00e1pil jsem se tro\u0161ku s rozchozen\u00edm TeamSpeak3 Server pod Linuxem, spojen\u00fd s databaz\u00ed MySQL. Pokus\u00edm se srozumiteln\u011b popsat jak na to \ud83d\ude42 Nejd\u0159\u00edve ze v\u0161echo pot\u0159ebujeme st\u00e1hnout bal\u00ed\u010dek s TeamSpeak3 Server, kter\u00fd z\u00edsk\u00e1me nejl\u00e9pe na ofici\u00e1ln\u00edm webu: http:\/\/www.teamspeak.com\/?page=downloads V Shellu nap\u00ed\u0161eme p\u0159\u00edkaz na sta\u017een\u00ed bal\u00ed\u010dku a rovnou p\u0159ejmenov\u00e1n\u00ed: Rozbal\u00edme bal\u00ed\u010dek: P\u0159esuneme rozbalenou slo\u017eku do \/etc\/ts3: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-linux","category-server"],"_links":{"self":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/62"}],"collection":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=62"}],"version-history":[{"count":51,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":1865,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions\/1865"}],"wp:attachment":[{"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.chury721.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}