
Originally Posted by
Chris
That is not query logging, or the log is from the wrong log file.
I'm sorry, but I do not posted the other log beause there was no query log except one which use a query login I created. Thats user "wbb" from my wbb board to have a ts3 overview in my forum.
Edit Virtual Server => More => Logs => all activated incl. ServerQuery + restart of the server.
Code:
2017-02-24 09:34:25.803567|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.6 (2016-11-08 08:48:33)
2017-02-24 09:34:25.803643|INFO |ServerLibPriv | |SystemInformation: Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.39-1 (2016-12-30) x86_64 Binary: 64bit
2017-02-24 09:34:25.803660|INFO |ServerLibPriv | |Using hardware aes
2017-02-24 09:34:25.804044|INFO |DatabaseQuery | |dbPlugin name: SQLite3 plugin, Version 3, (c)TeamSpeak Systems GmbH
2017-02-24 09:34:25.804066|INFO |DatabaseQuery | |dbPlugin version: 3.11.1
2017-02-24 09:34:25.804167|INFO |DatabaseQuery | |checking database integrity (may take a while)
2017-02-24 09:34:25.968748|INFO |Accounting | |Licensing Information
2017-02-24 09:34:25.968785|INFO |Accounting | |type : Non-profit
2017-02-24 09:34:25.968802|INFO |Accounting | |starting date : Sun Oct 9 00:00:00 2016
2017-02-24 09:34:25.968814|INFO |Accounting | |ending date : Wed Apr 12 00:00:00 2017
2017-02-24 09:34:25.968823|INFO |Accounting | |max virtualservers: 10
2017-02-24 09:34:25.968832|INFO |Accounting | |max slots : 512
2017-02-24 09:34:26.348078|INFO | | |Puzzle precompute time: 367
2017-02-24 09:34:26.348354|INFO |FileManager | |listening on 0.0.0.0:30033, :::30033
2017-02-24 09:34:26.358092|INFO |CIDRManager | |updated query_ip_whitelist ips: 127.0.0.1/32, xxx.xxx.xxx.xxx/32, xxx.xxx.xxx.xxx/32,
2017-02-24 09:34:26.358239|INFO |Query | |listening on 0.0.0.0:10011, :::10011
2017-02-24 09:36:53.498736|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49865 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 09:37:14.613741|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49867 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 09:37:23.914405|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49868 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 09:37:38.722961|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49869 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 09:37:45.889727|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49870 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 09:38:34.851277|INFO |Query | |query from 46 xxx.xxx.xxx.xxx:49871 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:11:48.013152|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49900 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:12:02.227618|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49903 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:12:09.280333|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49904 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:12:16.599781|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49905 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:12:32.392106|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49908 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:13:01.894397|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49910 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
2017-02-24 10:13:18.409542|INFO |Query | |query from 47 xxx.xxx.xxx.xxx:49911 issued: login with account "wbb"(J8D343B9Myit8K+fmdt48WDqb5I=)
................................................ etc.....................
There is no new or other entry in that time the spammer is active. Other logs than this or the other I posted are not available in ts3\logs
After I follow your hints in post#1 to close the permission issue I to the self-test:
Telnet without login
use port=9987
sendtextmessage targetmode=1 target=1 msg=Spam! =>
Code:
sendtextmessage targetmode=1 target=1 msg=Spam!
notifytextmessage targetmode=1 msg=Spam! target=1 invokerid=6 invokername=Unknown\sfrom\s95.33.19.201:58168 invokeruid=ServerQuery
error id=0 msg=ok
sendtextmessage targetmode=2 target=1 msg=Spam! =>
Code:
error id=2568 msg=insufficient\sclient\spermissions failed_permid=217
sendtextmessage targetmode=3 target=1 msg=Spam! =>
Code:
error id=2568 msg=insufficient\sclient\spermissions failed_permid=216
And in any 3 cases no message on the Server!!!
Nethertheless every few hours any user on the still server got/get a private message:
Code:
"Server": Monitor your TS3 server or game server, custom your banner and more stats : *AdLink Removed*
Chat partner disconnected our of view.
Any idea?