Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Teamspeak 3 server first time setup
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Thu Feb 17, 2011 4:42 pm    Post subject: Teamspeak 3 server first time setup Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Tue Feb 22, 2011 12:11 pm    Post subject: Reply with quote

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
View user's profile Send private message
forrestfunk81
Guru
Guru


Joined: 07 Feb 2006
Posts: 567
Location: münchen.de

PostPosted: Tue Feb 22, 2011 5:17 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Wed Feb 23, 2011 4:14 pm    Post subject: Reply with quote

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
View user's profile Send private message
forrestfunk81
Guru
Guru


Joined: 07 Feb 2006
Posts: 567
Location: münchen.de

PostPosted: Wed Feb 23, 2011 4:54 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Wed Feb 23, 2011 5:27 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Wed Feb 23, 2011 6:01 pm    Post subject: Reply with quote

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
View user's profile Send private message
forrestfunk81
Guru
Guru


Joined: 07 Feb 2006
Posts: 567
Location: münchen.de

PostPosted: Thu Feb 24, 2011 1:47 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Thu Feb 24, 2011 4:27 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Fri Feb 25, 2011 11:36 am    Post subject: Reply with quote

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
View user's profile Send private message
forrestfunk81
Guru
Guru


Joined: 07 Feb 2006
Posts: 567
Location: münchen.de

PostPosted: Fri Feb 25, 2011 1:51 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Fri Feb 25, 2011 3:40 pm    Post subject: Reply with quote

forrestfunk81 wrote:

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

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
View user's profile Send private message
Ant P.
Watchman
Watchman


Joined: 18 Apr 2009
Posts: 6920

PostPosted: Fri Feb 25, 2011 6:10 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Fri Feb 25, 2011 7:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
balkira
Tux's lil' helper
Tux's lil' helper


Joined: 25 Dec 2004
Posts: 116
Location: /local/pub

PostPosted: Fri Mar 04, 2011 1:05 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Mon Mar 07, 2011 10:20 pm    Post subject: Reply with quote

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
View user's profile Send private message
balkira
Tux's lil' helper
Tux's lil' helper


Joined: 25 Dec 2004
Posts: 116
Location: /local/pub

PostPosted: Mon Mar 21, 2011 3:03 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Mon Mar 21, 2011 5:20 pm    Post subject: Reply with quote

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
View user's profile Send private message
balkira
Tux's lil' helper
Tux's lil' helper


Joined: 25 Dec 2004
Posts: 116
Location: /local/pub

PostPosted: Mon Mar 21, 2011 7:48 pm    Post subject: Reply with quote

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
View user's profile Send private message
balkira
Tux's lil' helper
Tux's lil' helper


Joined: 25 Dec 2004
Posts: 116
Location: /local/pub

PostPosted: Mon Mar 21, 2011 7:49 pm    Post subject: Reply with quote

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
View user's profile Send private message
balkira
Tux's lil' helper
Tux's lil' helper


Joined: 25 Dec 2004
Posts: 116
Location: /local/pub

PostPosted: Mon Mar 21, 2011 8:02 pm    Post subject: Reply with quote

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
View user's profile Send private message
Warhead
Tux's lil' helper
Tux's lil' helper


Joined: 09 Oct 2003
Posts: 122
Location: Verden, near Bremen, Germany

PostPosted: Mon Apr 11, 2011 6:46 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum