Teamspeak3 Server Database Crash

[zeekay]

Recently I created teamspeak 3.5 server on Linux system with Database Mysql
When I edit the permissions on the server group after some time it show database error then I go
Mysql Query Browser and check Schema it show all clear.
Then i go to Logs and its create this





2012-05-28 14:23:33.103798|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.5 (2012-04-23 04:46:12)
2012-05-28 14:23:33.184991|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2012-05-28 14:23:33.185159|INFO    |DatabaseQuery |   | dbPlugin version: 1
2012-05-28 14:23:34.346275|INFO    |Accounting    |   | Licensing Information
2012-05-28 14:23:34.346474|INFO    |Accounting    |   | type              : Non-profit
2012-05-28 14:23:34.346639|INFO    |Accounting    |   | starting date     : Sat Apr 21 00:00:00 2012
2012-05-28 14:23:34.346744|INFO    |Accounting    |   | ending date       : Sun Oct 21 00:00:00 2012
2012-05-28 14:23:34.346849|INFO    |Accounting    |   | max virtualservers: 10
2012-05-28 14:23:34.346950|INFO    |Accounting    |   | max slots         : 512
2012-05-28 14:23:34.432660|INFO    |FileManager   |   | listening on 10.101.10.42:30033
2012-05-28 14:23:34.892887|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 10.101.10.42, 10.132.4.46, 10.155.20.27, 
2012-05-28 14:23:34.893609|INFO    |Query         |   | listening on 0.0.0.0:10011
2012-05-28 14:28:50.776144|ERROR   |ParamParser   |   | Protocol mismatch, old client or old server?
2012-05-28 14:41:33.248843|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:42:07.218604|ERROR   |DatabaseQuery |   | db_exec() delete from perm_server_group where server_id = 1 and id1 = 14 and id2 error: Table 'teamspeak3-serverV5.perm_server_group' doesn't exist
2012-05-28 14:42:23.171113|ERROR   |DatabaseQuery |   | db_exec() delete from perm_server_group where server_id = 1 and id1 = 14 and id2 error: Table 'teamspeak3-serverV5.perm_server_group' doesn't exist
2012-05-28 14:42:37.646165|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'JYtBRiPX/9QrDSKGxelksu error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:42:40.670329|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'JYtBRiPX/9QrDSKGxelksu error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:43:08.057899|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'bblmhgPAwQNSDyOTOAcvmX error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:43:24.805069|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'bblmhgPAwQNSDyOTOAcvmX error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:43:48.946812|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = '5JkMVf7MaAw3F5F4arFl3k error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:44:02.242503|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'bblmhgPAwQNSDyOTOAcvmX error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:44:14.101144|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = '5JkMVf7MaAw3F5F4arFl3k error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:44:33.248811|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:47:00.636295|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'JYtBRiPX/9QrDSKGxelksu error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:47:33.248829|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:47:59.901455|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'JGT5OMv6zUVQY2iHPvWLUO error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:48:09.657416|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'wULB3DiUUVadY8ZJKxDREs error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:48:13.563585|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'wULB3DiUUVadY8ZJKxDREs error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:50:06.946562|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = '7ckClkOiLEsKQ31fsIf8VJ error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:50:11.011559|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = '7ckClkOiLEsKQ31fsIf8VJ error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:50:33.248889|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:50:54.296521|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'xQ65UVQd9GwH93WGb6yh09 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:51:02.770060|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'bg42vJzQ5oNXrLpY0XoZsU error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:51:31.576046|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'Hy7GRnCn0pSS7uIipggjuW error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:52:58.363694|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'BR4nfT/bnqfWt857X8QGk2 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:53:33.248812|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:53:46.315200|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'cvO6/aXviUbkJY8Y80XfO/ error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:53:53.454514|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'BR4nfT/bnqfWt857X8QGk2 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:53:56.613854|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'BR4nfT/bnqfWt857X8QGk2 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:54:02.291291|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'ServerQuery' and serve error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:54:02.292060|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_login_name = 'serveradmin' and clie error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:54:06.887082|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'BR4nfT/bnqfWt857X8QGk2 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:54:29.996263|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'BR4nfT/bnqfWt857X8QGk2 error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:54:54.612679|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_login_name = 'serveradmin' and clie error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:55:06.884469|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'bg42vJzQ5oNXrLpY0XoZsU error: Table 'teamspeak3-serverV5.clients' doesn't exist
2012-05-28 14:55:32.857878|INFO    |ServerMain    |   | Received signal SIGINT, shutting down.
2012-05-28 14:55:33.035848|ERROR   |DatabaseQuery |   | db_exec() delete from instance_properties where string_id = '' ; error: Table 'teamspeak3-serverV5.instance_properties' doesn't exist


then I close server and restart it now its is new.

Pleas Help me How can i Solve this thing

[SilentStorm]

Error in the Config Files or SQL Server Permissions.
The Server cannot find / access the specified Database or the clients Table was removed within that Database. Check Database exists exactly as written in the config Files no trailing spaces etc. and that the SQL User the Server uses to access the Database has permissions to read and write that Database and all of its tables.

[zeekay]

Thanks for Replay

Dear SilentStorm
-= TeamSpeak Addict =
I dont know whats the matter with my server when I create all Groups and Channel after I launch my server to Users its working fine but
after some time Mysql data base clear Automatically. Before Clear Date Base is working Fine.
Sir Is some one Hack MySql Database I Changed All the Root Access and MySql Access but problem is same.
I listen Humours from Some User is Someone Hack my teamspeak from SQL Injection or someting.
Please Help Is it Possible how can i protected.

[filimonic]

1) Check your distro - re-download it and replace sql directory with originals
2) For checking:
-- Use query log (carefully!) http://dev.mysql.com/doc/refman/5.1/en/query-log.html
3) DO NOT USE mysql full-privileged user
4) Create separate user for ts3, which can access `ts3databaseName`.`*`. Use this user for TS3 only. For web-interfaces (if any) use other users that are read-only.
5) Check other users (excl. 'root') do not have access to ts3 database (or read-only)
6) Do not run ts3 as root

You did not said WHEN the database becomes clear. Use logging of ts3.

[zeekay]

Dear Sir,
Here is my Setting of Server Still my Database is clear i tried every thing which i can do but result is same
i tried Server 3.6, 3.5, 3.2 but result is same.
When ever I launch server after a few minutes server show invalid client data base. then i check from Mysql Query Browser and see the client data base table i show cleare all data base where cleare mean 1 database which is really important. server still Running if i stop and re open the server it look like new no any channel new Query login name show.

ts3db_mysql.txt

ts3server.txt

[silentkiller99]

Zeekay,
there are some securities that need to be maintained to run teamspeak.if users are 150+.
some security scripts that would help your database to get secure and block the irrelevant connections.
if its on Linux there are bash scripts which just blocks the irrelevant access.
if you are linux expert then you can do that your self otherwise need a man.

[ARCHI]

Yes it looks like it's MySQL problem, not Teamspeak problem. You didn't tell us which linux distro you use but local MySQL settings should be located in /etc/mysql/my.cnf or /etc/my.cnf. Please check it for such limits, you can always double default values and check if it still generates such errors.

Good Luck.