TS don't work more than 5 minutes [Archive] - TeamSpeak Community Forums

View Full Version : TS don't work more than 5 minutes

mofel

01-11-2005, 13:49

Hello,

Since today we have a probleme with our TS Server.
After few minute started the server stop and the following error is the log file:

"01-11-05 09:35:13,ERROR,All,SQL, SQL file not found /opt/teamspeak2-server/sql/read_client_login.sql"

We use this server since more than one month without any problem and we haven't touched to any configuration of the server.

The problem is that the file really exists.

Does somebody have ever seen this kind of weird problem?

Thanks
Mofel

marcelrx

01-11-2005, 14:08

DaviXX

01-11-2005, 14:26

Permissons of the User that starts teamspeak. You you read this file with that user?

(I'm working with mofel)

Yeh all the files and directory needed by teamspeak are goods.
I don't understand why i have this problem: i don't have edit anything on this dedicated server sine a month... and i have this problem since a few days...

...
01-11-05 14:19:08,ALL,Info,server, Starting VirtualServer id:149 with port:8878
01-11-05 14:19:09,ALL,Info,server, Server init finished
01-11-05 14:19:09,WARNING,Info,server, TeamSpeak Server daemon activated
01-11-05 14:20:07,ERROR,All,SQL, SQL file not found /opt/teamspeak2-server/sql/read_client_login.sql

and so :

srv38 opt # ls -ld /opt /opt/teamspeak2-server /opt/teamspeak2-server/sql /opt/teamspeak2-server/sql/read_client_login.sql
drwxr-xr-x 3 root root 4096 Sep 18 16:53 /opt
drwxr-xr-x 5 ts2 users 4096 Oct 31 22:16 /opt/teamspeak2-server
drwxr-xr-x 2 ts2 users 4096 Oct 31 22:22 /opt/teamspeak2-server/sql
-rw-r--r-- 1 ts2 users 124 Oct 31 22:16 /opt/teamspeak2-server/sql/read_client_login.sql

Thanks.

marcelrx

01-11-2005, 14:57

(I'm working with mofel)

Yeh all the files and directory needed by teamspeak are goods.
I don't understand why i have this problem: i don't have edit anything on this dedicated server sine a month... and i have this problem since a few days...

and so :

Thanks.

OK. Permissions of the server looks ok. But Why do you have a folder called "sql".
Have you download teamspeak from this page? In the offical package there is only a folder called "sqlite_sql".

DaviXX

01-11-2005, 15:13

OK. Permissions of the server looks ok. But Why do you have a folder called "sql".
Have you download teamspeak from this page? In the offical package there is only a folder called "sqlite_sql".

I use Gentoo Package, it's launching teamspeak as follow :
/opt/teamspeak2-server/server_linux \
-db=/var/lib/teamspeak2-server/server.dbs \
-ini=/var/lib/teamspeak2-server/server.ini \
-log=/var/log/teamspeak2-server/server.log \
-pid=/var/run/teamspeak2-server/server.pid \
-sql=/opt/teamspeak2-server/sql/ \
-tcpquerydocs=/opt/teamspeak2-server/tcpquerydocs \
-httpdocs=/opt/teamspeak2-server/http/

So, teamspeak have to search his sql file in the "/opt/teamspeak2-server/sql/" directory, and the error show that were are in this case : "SQL file not found /opt/teamspeak2-server/sql/read_client_login.sql"

Teamspeak is so searching an existing and a readable file at the place i want to store sql files.

Thanks to you for your help.
I really (excuse me if i say it again), don't understand why my configuration works with no problem during some weeks, and, a day, it decide to crash.

I think there is another explication to this problem that only the teamspeak dev's can clearly explain and understand...

I hope someone can help me to solve this problem.

Thanks.

ScP

01-11-2005, 15:15

How many virtual servers are running on your machine? On Unix-based systems, more than 85 servers in a single TeamSpeak 2 instance can cause this weird errors.

01-11-05 14:19:08,ALL,Info,server, Starting VirtualServer id:149 with port:8878

DaviXX

01-11-2005, 15:22

How many virtual servers are running on your machine? On Unix-based systems, more than 85 servers in a single TeamSpeak 2 instance can cause this wierd errors.

What to do so ?
Using Windows ? (never !)

So i have to use max 80 Servers by Instance, and create an instance with an ip so

instance 1 => ip 1 => 80 servers max
instance 2 => ip 2 => 80 servers max

?
I don't see another issue

Maybe the developpers can solve the problem in theirs codes ?
(maybe they accept i "help" them, i'm a developper C/C++)

Thanks.

marcelrx

01-11-2005, 15:30

What to do so ?
Using Windows ? (never !)

So i have to use max 80 Servers by Instance, and create an instance with an ip so

instance 1 => ip 1 => 80 servers max
instance 2 => ip 2 => 80 servers max

?
I don't see another issue

Maybe the developpers can solve the problem in theirs codes ?
(maybe they accept i "help" them, i'm a developper C/C++)

Thanks.

You didn't need another ip.
You have only to edit the query and webinterface port in the server.ini

DaviXX

01-11-2005, 15:33

You didn't need another ip.
You have only to edit the query and webinterface port in the server.ini

... and be sure that i don't create the same virtual server (port) than another instance...

thanks.

marcelrx

01-11-2005, 15:33

... and be sure that i don't create the same virtual server (port) than another instance...

thanks.

Yes of course. And no problem for help

ScP

01-11-2005, 15:47

Sorry guys, but this is a well known problem in the Linux version of TeamSpeak 2.

DaviXX

01-11-2005, 16:31

Sorry guys, but this is a well known problem in the Linux version of TeamSpeak 2.

Maybe it's.
But i know that only since few hours.

may be they have to say it explainly at the download page and in the README file :)