| View previous topic :: View next topic |
| Author |
Message |
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
 Posted: Thu Feb 17, 2011 4:42 pm Post subject: Teamspeak 3 server first time setup |
 |
|
I am not sure if this falls under unsupported software.
The runscript provided with the teamspeak ebuild states this:
| Code: | | Cannot add provide 'net', as a service with the same name exists! |
I am not sure, if the sript fails because of this. When I try to start the server from the commandline, all the *.sh scripts provides fail with
| Code: | | Could not find binary, aborting |
When I start the binary directly it states:
| Code: |
Logging started
2011-02-17 15:48:57.833384|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-17 15:48:57.834249|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2011-02-17 15:48:57.834590|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
2011-02-17 15:48:57.835274|INFO |DatabaseQuery | | checking database integrity (may take a while)
2011-02-17 15:48:57.860190|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
2011-02-17 15:48:57.880873|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2011-02-17 15:48:58.478393|INFO |FileManager | | listening on 0.0.0.0:30033
2011-02-17 15:48:58.523369|CRITICAL|VirtualServer | 1| Assertion "getVariableAsUInt64(VIRTUALSERVER_DEFAULT_CHANNEL_ADMIN_GROUP) != 0" failed at server/serverlib/virtualserver.cpp:4621;
|
Someone in the teamspeak forum stated, that this can not happen on the first run. Fine...now what? Has anyone managed to get this started? I suppose ts server is only supported on the two distros that guys know and everyone else is on his own. Has anyone brought this up and running using gentoo? Can someone state, what he/she did?
Regards
Lorgarn
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
 |
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Tue Feb 22, 2011 12:11 pm Post subject: |
|
|
So the teamspek forum is of no use. The only repeat tellin me to dump the the file in a /home/ folder and to start the .sh scripts, which do not work.
CAN THE ONE WHO CREATED THE EBUILD PLEASE DROP A LINE ON HOW TO USE THIS????
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
forrestfunk81
Guru
Joined: 07 Feb 2006
Posts: 567
Location: münchen.de
|
| Posted: Tue Feb 22, 2011 5:17 pm Post subject: |
|
|
The latest masked teamspeak 3 package works for me.
| Code: |
# /etc/init.d/teamspeak3-server restart
* Stopping TeamSpeak Server ... [ ok ]
* Starting TeamSpeak 3 Server ... [ ok ]
# ps -A | grep ts3
28044 ? 00:00:00 ts3server-bin
# /etc/init.d/teamspeak3-server stop
* Stopping TeamSpeak Server ... [ ok ]
# ts3server
TeamSpeak Server 3.0.0-beta29 [Build: 12473]
(c)TeamSpeak Systems GmbH
Logging started
2011-02-22 17:13:02.784504|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-22 17:13:02.785274|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2011-02-22 17:13:02.785467|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
2011-02-22 17:13:02.786215|INFO |DatabaseQuery | | checking database integrity (may take a while)
2011-02-22 17:13:02.825709|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
2011-02-22 17:13:02.856851|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2011-02-22 17:13:02.938163|INFO |FileManager | | listening on 0.0.0.0:30033
2011-02-22 17:13:03.110308|INFO |VirtualServer | 1| listening on 0.0.0.0:9987
2011-02-22 17:13:03.111991|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1,
2011-02-22 17:13:03.113217|INFO |Query | | listening on 0.0.0.0:10011
^X^C2011-02-22 17:13:33.040297|INFO |ServerMain | | Received signal SIGINT, shutting down.
2011-02-22 17:13:33.163021|INFO |VirtualServer | 1| stopped
# ps -A | grep ts3
# eix teamspeak -I
[I] media-sound/teamspeak-server-bin
Available versions: {M}(~)3.0.0_beta25!s {M}(~)3.0.0_beta28!s {M}(~)3.0.0_beta29!s
Installed versions: 3.0.0_beta29!s(18:10:54 22/02/11)
Homepage: http://teamspeak.com/
Description: TeamSpeak Server - Voice Communication Software
|
Maybe you should file a bug at https://bugs.gentoo.org/
_________________
# cd /pub/
# more beer |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Wed Feb 23, 2011 4:14 pm Post subject: |
|
|
| forrestfunk81 wrote: | The latest masked teamspeak 3 package works for me.
|
Have you configured anything by hand? My ebuild did not provide a database configuration *.ini file, neither for sqlite nor for mysql. Besides that, as I stated, the *.sh scrips can not find the binary and the runscript just exits with 2 red exclamation marks. I created a database for teamspeak in my mysql databese, along with a user and created a config for it, still no use. I fail to see, how this can differ so much after an emerge....
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
forrestfunk81
Guru
Joined: 07 Feb 2006
Posts: 567
Location: münchen.de
|
| Posted: Wed Feb 23, 2011 4:54 pm Post subject: |
|
|
No, i didn't configure anything. Just emerge and "/etc/init.d/teamspeak3-server start". The ts3server.sqlitedb seems to be created automatically. The binary is located at /opt/teamspeak3-server/ts3server-bin.
| Code: | # ls -al /opt/teamspeak3-server/
total 7524
drwxr-xr-x 7 teamspeak3 root 4096 Feb 22 18:13 .
drwxr-xr-x 5 root root 4096 Feb 22 18:11 ..
-rw-r--r-- 1 root root 26001 Feb 22 18:10 CHANGELOG
drwxr-xr-x 2 root root 4096 Feb 22 18:11 doc
drwx------ 3 teamspeak3 teamspeak3 4096 Feb 22 18:11 files
-rwxr-xr-x 1 root root 208590 Feb 22 18:10 libts3db_mysql.so
-rwxr-xr-x 1 root root 841030 Feb 22 18:10 libts3db_sqlite3.so
-rw-r--r-- 1 root root 24099 Feb 22 18:10 LICENSE
drwx------ 2 root root 4096 Feb 22 18:13 logs
-rw-r--r-- 1 teamspeak3 teamspeak3 1 Feb 22 18:11 query_ip_blacklist.txt
-rw-r--r-- 1 teamspeak3 teamspeak3 10 Feb 22 18:11 query_ip_whitelist.txt
drwxr-xr-x 2 root root 4096 Feb 22 18:11 serverquerydocs
drwxr-xr-x 4 root root 4096 Feb 22 18:11 sql
-rwxr-xr-x 1 root root 6363436 Feb 22 18:10 ts3server-bin
-rwxr-xr-x 1 root root 399 Feb 22 18:10 ts3server_minimal_runscript.sh
-rw-r--r-- 1 teamspeak3 teamspeak3 187392 Feb 22 18:13 ts3server.sqlitedb
-rwxr-xr-x 1 root root 2817 Feb 22 18:10 ts3server_startscript.sh
|
Furthermore there is a /usr/sbin/ts3server script which exports paths, cd teamspeak dir and executes the ts3server-bin.
_________________
# cd /pub/
# more beer |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Wed Feb 23, 2011 5:27 pm Post subject: |
|
|
| forrestfunk81 wrote: | No, i didn't configure anything. Just emerge and "/etc/init.d/teamspeak3-server start". The ts3server.sqlitedb seems to be created automatically. The binary is located at /opt/teamspeak3-server/ts3server-bin.
Furthermore there is a /usr/sbin/ts3server script which exports paths, cd teamspeak dir and executes the ts3server-bin. |
Same as in my case. Then I do not see it. Honestly.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Wed Feb 23, 2011 6:01 pm Post subject: |
|
|
The files reside in /opt/teamspeak3-server:
| Code: |
gremory teamspeak3-server # pwd
/opt/teamspeak3-server
gremory teamspeak3-server # ls -la
total 6280
drwxr-xr-x 7 teamspeak3 root 4096 Feb 21 15:29 .
drwxr-xr-x 3 root root 4096 Feb 17 15:59 ..
-rw-r--r-- 1 root root 26001 Feb 17 15:59 CHANGELOG
-rw-r--r-- 1 root root 24099 Feb 17 15:59 LICENSE
drwxr-xr-x 2 root root 4096 Feb 17 15:59 doc
drwx------ 2 teamspeak3 teamspeak3 4096 Feb 17 16:02 files
-rwxr-xr-x 1 root root 221435 Feb 17 15:59 libts3db_mysql.so
-rwxr-xr-x 1 root root 968825 Feb 17 15:59 libts3db_sqlite3.so
drwx------ 2 root root 4096 Feb 23 18:42 logs
drwxr-xr-x 2 root root 4096 Feb 17 15:59 serverquerydocs
drwxr-xr-x 4 root root 4096 Feb 17 15:59 sql
-rwxr-xr-x 1 root root 4942880 Feb 17 15:59 ts3server-bin
-rw-r--r-- 1 teamspeak3 teamspeak3 173056 Feb 21 15:29 ts3server.sqlitedb
-rwxr-xr-x 1 root root 399 Feb 17 15:59 ts3server_minimal_runscript.sh
-rwxr-xr-x 1 root root 2817 Feb 17 15:59 ts3server_startscript.sh
gremory teamspeak3-server #
|
Config resides in /etc/teamspeak3-server
| Code: |
gremory teamspeak3-server # pwd
/etc/teamspeak3-server
gremory teamspeak3-server # ls -la
total 16
drwx------ 2 teamspeak3 root 4096 Feb 23 18:38 .
drwxr-xr-x 51 root root 4096 Feb 23 18:25 ..
-rw-r--r-- 1 root root 0 Feb 17 15:59 .keep_media-sound_teamspeak-server-bin-0
-rw-r--r-- 1 root root 304 Feb 23 18:38 server.conf
-rw-r--r-- 1 root root 74 Feb 21 15:26 ts3db_mysql.ini
gremory teamspeak3-server
|
Config as follows:
server.conf
| Code: |
machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
licensepath=
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
dbplugin=ts3db_mysql
dbpluginparameter=/etc/teamspeak3-server/ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs/
logquerycommands=1
|
ts3db_mysql.ini
| Code: |
host=localhost
port=3306
username=ts
password=XXXXXXXXXXXXXX
database=teamspeak
|
Mysql user ist existing, and has full previledes on its database 'teamspeak'.
Starting the runscript tells me:
| Code: |
gremory teamspeak3-server # /etc/init.d/teamspeak3-server start
* Caching service dependencies ... [ ok ]
* Starting TeamSpeak 3 Server ... [ !! ]
gremory teamspeak3-server #
|
Starting the binary tells me:
| Code: |
gremory teamspeak3-server # ./ts3server-bin inifile=/etc/teamspeak3-server/server.conf
TeamSpeak Server 3.0.0-beta29 [Build: 12473]
(c)TeamSpeak Systems GmbH
Logging started
2011-02-23 17:40:30.180645|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-23 17:40:30.181311|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2011-02-23 17:40:30.181629|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mysql.so", halting!
gremory teamspeak3-server #
|
The script in /sbin gives this:
| Code: |
ts3server inifile=/etc/teamspeak3-server/server.conf
TeamSpeak Server 3.0.0-beta29 [Build: 12473]
(c)TeamSpeak Systems GmbH
Logging started
2011-02-23 17:42:01.801270|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-23 17:42:01.802070|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2011-02-23 17:42:01.802348|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mysql.so", halting!
gremory teamspeak3-server #
|
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
forrestfunk81
Guru
Joined: 07 Feb 2006
Posts: 567
Location: münchen.de
|
| Posted: Thu Feb 24, 2011 1:47 pm Post subject: |
|
|
Have you change your config to use mysql instead of sqlite?
The unchanged /etc/teamspeak3-server/server.conf on my server:
| Code: |
machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
licensepath=/opt/teamspeak3-server/
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
dbplugin=ts3db_sqlite3
dbpluginparameter=
dbsqlpath=/opt/teamspeak3-server/sql/
dbsqlcreatepath=create_sqlite/
logpath=/var/log/teamspeak3-server/
logquerycommands=0
|
It seems like your /opt/teamspeak3-server/libts3db_mysql.so is corrupt. Whats the result of
| Code: | | ldd /opt/teamspeak3-server/libts3db_mysql.so |
_________________
# cd /pub/
# more beer |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Thu Feb 24, 2011 4:27 pm Post subject: |
|
|
When I use the unchanged config file i get this error:
| Code: |
Logging started
2011-02-17 15:48:57.833384|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-17 15:48:57.834249|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2011-02-17 15:48:57.834590|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
2011-02-17 15:48:57.835274|INFO |DatabaseQuery | | checking database integrity (may take a while)
2011-02-17 15:48:57.860190|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
2011-02-17 15:48:57.880873|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2011-02-17 15:48:58.478393|INFO |FileManager | | listening on 0.0.0.0:30033
2011-02-17 15:48:58.523369|CRITICAL|VirtualServer | 1| Assertion "getVariableAsUInt64(VIRTUALSERVER_DEFAULT_CHANNEL_ADMIN_GROUP) != 0" failed at server/serverlib/virtualserver.cpp:4621;
|
That guy in the ts3 forum told me, this could not occur during the first start of the server.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Fri Feb 25, 2011 11:36 am Post subject: |
|
|
| forrestfunk81 wrote: |
It seems like your /opt/teamspeak3-server/libts3db_mysql.so is corrupt. Whats the result of
| Code: | | ldd /opt/teamspeak3-server/libts3db_mysql.so |
|
I did not read this at first, I am sorry. This is the output:
| Code: |
gremory ~ # ldd /opt/teamspeak3-server/libts3db_mysql.so
linux-vdso.so.1 => (0x00007ffff43ff000)
libmysqlclient.so.15 => not found
libstdc++.so.6 => /usr/lib/gcc/x86_64-pc-linux-gnu/4.4.4/libstdc++.so.6 (0x00007fde8987f000)
libm.so.6 => /lib/libm.so.6 (0x00007fde895fe000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007fde893e7000)
libc.so.6 => /lib/libc.so.6 (0x00007fde8908d000)
/lib64/ld-linux-x86-64.so.2 (0x00007fde89dd5000)
gremory ~ #
|
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
forrestfunk81
Guru
Joined: 07 Feb 2006
Posts: 567
Location: münchen.de
|
| Posted: Fri Feb 25, 2011 1:51 pm Post subject: |
|
|
Hmm.. I have no clue why sqlite is not working with your ts3 installation. But mysql does not work because it's linked against the false mysql version. I assume you've installed mysql 5.1 and the libts3db_mysql.so is linked against a lower mysql version.
There is a thread in the german subforum about this problem, maybe this helps. The linked thread in the other german gentoo forum states that ts3 is only compatible with <=mysql-5.0
Maybe sqlite is also expected in an other version than your installed version. It works for me with slotted sqlite versions 2.8.16-r4 and 3.7.5 installed.
| Code: | # eix sqlite -I
[I] dev-db/sqlite
Available versions:
(0) 2.8.16-r4!t
(3) 3.7.2 (~)3.7.3 (~)3.7.4 (~)3.7.5
{debug doc (+)extensions +fts3 icu nls +readline secure-delete soundex tcl test +threadsafe unlock-notify}
Installed versions: 2.8.16-r4!t(17:46:51 26/03/10)(nls -doc -tcl) 3.7.5(3)(10:58:22 07/02/11)(extensions fts3 readline threadsafe -debug -doc -icu -secure-delete -soundex -tcl -test -unlock-notify)
Homepage: http://sqlite.org/
Description: A SQL Database Engine in a C Library
|
_________________
# cd /pub/
# more beer |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Fri Feb 25, 2011 3:40 pm Post subject: |
|
|
Yes, i had already found that seaching for libmysqlclient.so. I am not downgrading my MySQL Database, since several services / application use it. If TS can not cope with the change form libmysqlclient.so from version 15 to 16, which was over a year ago, I must think of some other program. But anyhow thanks for the help.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
Ant P.
Watchman
Joined: 18 Apr 2009
Posts: 6920
|
| Posted: Fri Feb 25, 2011 6:10 pm Post subject: |
|
|
| Warhead wrote: | Starting the binary tells me:
| Code: |
gremory teamspeak3-server # ./ts3server-bin inifile=/etc/teamspeak3-server/server.conf
TeamSpeak Server 3.0.0-beta29 [Build: 12473]
(c)TeamSpeak Systems GmbH
Logging started
2011-02-23 17:40:30.180645|INFO |ServerLibPriv | | Server Version: 3.0.0-beta29 [Build: 12473], Linux
2011-02-23 17:40:30.181311|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2011-02-23 17:40:30.181629|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mysql.so", halting!
gremory teamspeak3-server #
|
|
What's the output when you use the script it tells you to use? |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Fri Feb 25, 2011 7:32 pm Post subject: |
|
|
| Ant_P wrote: |
What's the output when you use the script it tells you to use? |
Wrote that in my first post:
| Code: |
Could not find binary, aborting
|
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
balkira
Tux's lil' helper
Joined: 25 Dec 2004
Posts: 116
Location: /local/pub
|
| Posted: Fri Mar 04, 2011 1:05 pm Post subject: |
|
|
hey Warhead,
FYI, you're not alone in the dark, everything you reported, I've experienced it too.
I didn't have the time to dig further yet, maybe this weekend.
The startup script give me the same output, /etc/init.d/teamspeak3-server start fails.
I'll closely follow this thread and report if I get new input.
_________________
no way to happiness, happiness is the way |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Mon Mar 07, 2011 10:20 pm Post subject: |
|
|
| balkira wrote: |
FYI, you're not alone in the dark, everything you reported, I've experienced it too.
I didn't have the time to dig further yet, maybe this weekend.
|
Hi,
what could you possibly dig deeper in? There has been a new beta release and is STILL does not support the latest stable mysql version. If those guys are not able to support a mysql version which is stable for more then a year now, I do not see, what i could do about that. Those people can not even provide a runscript! They brag about being platform independet, but as soon as you use a distro different then suse, you are on your own. If you just want mysql support, it is simply not working when you use the latest stable version....
So the next step for me is using mumble and forgetting about teamspeak.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
balkira
Tux's lil' helper
Joined: 25 Dec 2004
Posts: 116
Location: /local/pub
|
| Posted: Mon Mar 21, 2011 3:03 pm Post subject: |
|
|
For some reason I can't have ts3server recognize the mysql backend. So by default it uses sqlite though I've configured it for mysql 
/etc/teamspeak3-server/server.conf:
| Code: | machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
licensepath=/opt/teamspeak3-server/
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
dbplugin=ts3db_mysql
dbpluginparameter=
dbsqlpath=/opt/teamspeak3-server/sql/
dbsqlcreatepath=create_sqlite/
logpath=/var/log/teamspeak3-server/
logquerycommands=0 |
/etc/teamspeak3-server/mysql.conf:
| Code: | [config]
host=127.0.0.1
port=3306
username=ts3
password=mypass
database=dbts3
socket= |
Don't bother with the init script, run 'ts3server'. Now it works for me.
| Code: | bordeaux ~ # ts3server
TeamSpeak Server 3.0.0-beta30 [Build: 12998]
(c)TeamSpeak Systems GmbH
Logging started
2011-03-21 16:44:50.210000|INFO |ServerLibPriv | | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2011-03-21 16:44:50.210000|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2011-03-21 16:44:50.210000|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2011-03-21 16:44:50.210000|INFO |DatabaseQuery | | checking database integrity (may take a while)
2011-03-21 16:44:50.240000|INFO |SQL | | pruning old database log entries where timestamp is older than 90 days
2011-03-21 16:44:50.260000|WARNING |Accounting | | Unable to find valid license key, falling back to limited functionality
2011-03-21 16:44:50.320000|INFO |FileManager | | listening on 0.0.0.0:30033
2011-03-21 16:44:50.430000|INFO |VirtualServer | 1| listening on 0.0.0.0:9987
2011-03-21 16:44:50.430000|INFO |CIDRManager | | updated query_ip_whitelist ips: 127.0.0.1,
2011-03-21 16:44:50.430000|INFO |Query | | listening on 0.0.0.0:10011 |
from there I login with ts3-client and it works.
_________________
no way to happiness, happiness is the way |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Mon Mar 21, 2011 5:20 pm Post subject: |
|
|
Hi there,
awesome that this approach works for you. But I want this in my mysql database, which I already backup from time to time. I do not wish to setup a sqlite db. If ts3 can not provide this functionality, it is ruled out.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
balkira
Tux's lil' helper
Joined: 25 Dec 2004
Posts: 116
Location: /local/pub
|
| Posted: Mon Mar 21, 2011 7:48 pm Post subject: |
|
|
ok, I know why it fails on recent gentoo.
| Code: | bordeaux teamspeak3-server # ls /usr/lib/mysql/libmysqlclient* -l
-rw-r--r-- 1 root root 1648762 Nov 3 17:26 /usr/lib/mysql/libmysqlclient.a
-rwxr-xr-x 1 root root 1031 Dec 23 12:05 /usr/lib/mysql/libmysqlclient.la
lrwxrwxrwx 1 root root 24 Nov 3 17:26 /usr/lib/mysql/libmysqlclient.so -> libmysqlclient.so.16.0.0
lrwxrwxrwx 1 root root 24 Nov 3 17:26 /usr/lib/mysql/libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rwxr-xr-x 1 root root 1479924 Nov 3 17:26 /usr/lib/mysql/libmysqlclient.so.16.0.0
-rw-r--r-- 1 root root 1660336 Nov 3 17:26 /usr/lib/mysql/libmysqlclient_r.a
-rwxr-xr-x 1 root root 1055 Dec 23 12:05 /usr/lib/mysql/libmysqlclient_r.la
lrwxrwxrwx 1 root root 26 Nov 3 17:26 /usr/lib/mysql/libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root root 26 Nov 3 17:26 /usr/lib/mysql/libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 root root 1488244 Nov 3 17:26 /usr/lib/mysql/libmysqlclient_r.so.16.0.0
bordeaux teamspeak3-server # |
| Code: | bordeaux teamspeak3-server # ldd libts3db_mysql.so
linux-gate.so.1 => (0xffffe000)
libmysqlclient.so.15 => not found
libstdc++.so.6 => /usr/lib/gcc/i686-pc-linux-gnu/4.4.5/libstdc++.so.6 (0xb778f000)
libm.so.6 => /lib/libm.so.6 (0xb7769000)
libgcc_s.so.1 => /usr/lib/gcc/i686-pc-linux-gnu/4.4.5/libgcc_s.so.1 (0xb774a000)
libc.so.6 => /lib/libc.so.6 (0xb7604000)
/lib/ld-linux.so.2 (0xb7890000)
bordeaux teamspeak3-server # l^C |
let's see where it's linked. Ah there it is the damn problem, it can't link.
ts3-server only seems to work with libmysqlclient.so.15
so you get:
| Code: |
bordeaux teamspeak3-server # cat /var/log/teamspeak3-server/ts3server_2011-03-21__16_49_00.080000.log
2011-03-21 16:49:00.080000|INFO |ServerLibPriv | | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2011-03-21 16:49:00.080000|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2011-03-21 16:49:00.080000|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mysql.so", halting!
bordeaux teamspeak3-server # |
Hence the sqlite plugin by default I experienced.
Download or compile your self an older mysqlclient lib ship it to /usr/lib/mysql and I'm pretty sure it'll work.
There, now I get:
| Code: | bordeaux teamspeak3-server # ./ts3server-bin dbplugin=ts3db_mysql
TeamSpeak Server 3.0.0-beta30 [Build: 12998]
(c)TeamSpeak Systems GmbH
Logging started
2011-03-21 21:34:55.950000|INFO |ServerLibPriv | | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2011-03-21 21:34:55.950000|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
2011-03-21 21:34:55.950000|INFO |DatabaseQuery | | dbPlugin version: 1
2011-03-21 21:34:55.960000|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)
Segmentation fault
bordeaux teamspeak3-server # |
which totally make sense in my case and note how the mysql plugin is loaded now which is by essence where you got stuck
The rest should be straighforward. Enjoy
_________________
no way to happiness, happiness is the way |
|
| Back to top |
|
|
balkira
Tux's lil' helper
Joined: 25 Dec 2004
Posts: 116
Location: /local/pub
|
| Posted: Mon Mar 21, 2011 7:49 pm Post subject: |
|
|
Note that you could try downgrading mysql to a version where libmysqlclient 1.5 is, revdep-rebuild and rerun the ts3server binary, it should work!!
_________________
no way to happiness, happiness is the way |
|
| Back to top |
|
|
balkira
Tux's lil' helper
Joined: 25 Dec 2004
Posts: 116
Location: /local/pub
|
| Posted: Mon Mar 21, 2011 8:02 pm Post subject: |
|
|
In fact a bug report should be created for the gentoo devs to:
1) write some error handling and lib checking within the ebuild and fail the install if libmysqlclient.1.5 is not found.
2) Or make a direct dependency to an older version of mysql.
3) Or download mysql and compile the lib only for ts3 purpose
3) makes more sense I guess for unexperienced users but 1) makes sense for advanced users, depends how you see it.
It's that simple. Seems like there is no support by TS yet for libmysqlclient 1.6, quite surprising coming from those guys.
If you're too lazy compiling it yourself, have a try with:
http://files.directadmin.com/services/es_5.0_64/libmysqlclient.so.15 64 bits
http://files.directadmin.com/services/es_5.0/libmysqlclient.so.15 32 bits
I would not count on the devs to fix this though, just hack it up yourself.
_________________
no way to happiness, happiness is the way |
|
| Back to top |
|
|
Warhead
Tux's lil' helper
Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany
|
| Posted: Mon Apr 11, 2011 6:46 am Post subject: |
|
|
It is astonishing and inspireing to see, how deep you dug into this. I had thought about downgrading mysql or compiling the needed .so by hand myself. But as I stated: Mysql runs several real world applications (well, they are only used by 3 to 11 people, but non the less) an I am not messing with that! I have installed mumble/murmur by now and it woks for me.
Regards
Warhead
_________________
To Rome said Nero: "If to smoke you turn
I shall not cease to fiddle while you burn."
To Nero Rome replied: "Pray do your worst,
'Tis my excuse that you were fiddling first."
--Orm Pludge |
|
| Back to top |
|
|
|
Unsupported Software
