Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 3 of 3
  1. #1
    Join Date
    September 2010
    Location
    vienna
    Posts
    5

    String length check failure (?) and client permission bug

    Noticed this when using "Permissions" -> "Client Permissions". When you enter "serveradmin" into the unique id field, the nickname will display "serveradmin from 127.0.0.1:40798" instead of "serveradmin" (which is actually what is in the database, i checked via sqlite)
    Code:
    sqlite> select * from clients where client_unique_id='serveradmin';
    1|0|serveradmin|serveradmin|serveradmin|RAynaiRL3LDnsSalivBDrAyR3KT=|0|0|0|0|0|0|
    On a side note, there's also some strange bug with client permissions, where the server can't find the permission anymore after some time (around a month) after it has been added, but the permission is still in the db.
    Code:
    clientpermlist cldbid=2834
    error id=1281 msg=database\sempty\sresult\sset
    but sqlite thinks differently:
    Code:
    sqlite> select * from perm_client;
    1|2834|0|b_serverinstance_info_view|1|0|0
    now, after doing this:
    Code:
    clientaddperm cldbid=2834 permid=3 permvalue=1 permskip=0
    error id=0 msg=ok
    i get
    Code:
    clientpermlist cldbid=2834
    permid=3 permvalue=1 permnegated=0 permskip=0
    error id=0 msg=ok
    and sqlite says
    Code:
    sqlite> select * from perm_client;
    1|2834|0|b_serverinstance_info_view|1|0|0
    1|2834|0|b_serverinstance_info_view|1|0|0
    The client in question is just used for server query and never connects to the server in a different way. It connects quite often (every few minutes) and gathers statistics. The "permission forgotten but actually still in database" already happened once, back then i deleted the whole user and permission and recreated it. This time i just re-added the permission (which is now in the db twice).

    Server is 3.0.10.1 on Linux
    Uptime is 71 days 12 hours 56 minutes 40 seconds

    The TS3 Server software runs on 1 year old server hardware with ECC, so memory errors are rather unlikely (though not impossible of course) and there are no issues at all with any other applications (~500 processes on this server, load at ~0.2).
    Feel free to ask for additional information.
    Regards,

    quirx

  2. #2
    Join Date
    September 2010
    Location
    vienna
    Posts
    5
    Okay the re-adding of the permission only fixed the problem for like one minute. Then the server fails to find the permission again, even though there are now *2* entries for it in the perm_client table.
    I also noticed that there is a strange entry in the sqlite database (the last entry btw) in the clients table:

    Code:
    2877|1|ServerQuery|Unknown from 127.0.0.1:40980|||1416354854|0|0|0|0|0|
    wtf? I think there's something reeeally wrong in the code... An exception that causes the adding of a new user??

    I just deleted the user and re-added it, now the permission needs to be added again, let's see if it works again then -_-

  3. #3
    Join Date
    June 2008
    Posts
    18,513
    We give no support for adding yourself into the query group!
    Whatever happens just happens.


    Please start your server db from scratch, to fix the problems. And then do not add users into the query group!
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Not possible] Check if client is whispering?
    By pompex in forum Client Support
    Replies: 1
    Last Post: August 15th, 2014, 01:01 PM
  2. [Resolved] Check client names, kick if not correct ?
    By kekke in forum Client Plugins / Lua Scripts
    Replies: 2
    Last Post: June 7th, 2011, 07:45 PM
  3. Can the logic for check if a new client is availible be fixed?
    By Screech in forum Suggestions and Feedback
    Replies: 2
    Last Post: February 23rd, 2011, 05:21 PM
  4. Teamspeak 3 Client Connection Failure
    By luxoar in forum Client Support
    Replies: 1
    Last Post: January 17th, 2011, 07:33 PM
  5. Replies: 14
    Last Post: January 10th, 2010, 12:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •