Forum

Page 2 of 16 FirstFirst 123412 ... LastLast
Results 16 to 30 of 233
  1. #16
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    The Admin Server Query is always for every server. That's the way it was intended. If you are looking just to put people into Server Admin group with sql the command would be like this...

    insert into group_server_to_client (group_id, server_id, id1, id2) values (2, 1, 6, 0);

    The bolded 2 is the group_id. Server Admin group id for me is 6. So I'd put a 6 there.You can find the group id by going into TS3 client and under Server Groups (in permissions) there will be a number next to each group. Put that number in place of the 2. Then just follow the rest of the guide to get server id correct and client id. (which is shown as 1 and 6 respectively)

  2. #17
    Join Date
    December 2009
    Location
    UK
    Posts
    75
    Thanks for the help

  3. #18
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Each virtual server made should give you a token to be Server Admin. Wouldn't it be easier to e-mail it to the customer or display it on their account page?

    --- Merged ---

    Wooo, I made sticky.
    Last edited by florian_fr40; March 26th, 2012 at 08:50 AM.

  4. #19
    Join Date
    March 2009
    Location
    Netherlands
    Posts
    39
    Hi Soljia,

    I have an challenge for you

    Do you know why the server replies this:
    Code:
    error id=0 msg=ok  (68 ms)
    error id=2568 msg=insufficient\sclient\spermissions failed_permid=17283  (45 ms)
    Total: 113 ms
    after giving command:
    Code:
    login serveradmin xxxxxxxxx
    use 1
    servergroupaddclient sgid=2 cldbid=70
    logout
    Edit: I know why this error is given:
    I accidently deleted all groups except for Server Admins and Guests
    Any way on how to restore/recreate those groups :S:S

    second edit:
    I personally think that it's not that difficult to add new groups for Admin Server Query,
    I mean those groups aren't unique to every server right?
    Hope someone knows the solution to my prob
    Last edited by ThaLegend; January 9th, 2010 at 12:02 AM.

  5. #20
    Join Date
    July 2005
    Location
    Toronto,CA
    Posts
    56
    thanks for the password generator replaced it in mysql for the serveradmin user and it works like a charm +1

  6. #21
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Quote Originally Posted by ThaLegend View Post
    Hi Soljia,

    I have an challenge for you

    Do you know why the server replies this:
    Code:
    error id=0 msg=ok  (68 ms)
    error id=2568 msg=insufficient\sclient\spermissions failed_permid=17283  (45 ms)
    Total: 113 ms
    after giving command:
    Code:
    login serveradmin xxxxxxxxx
    use 1
    servergroupaddclient sgid=2 cldbid=70
    logout
    Edit: I know why this error is given:
    I accidently deleted all groups except for Server Admins and Guests
    Any way on how to restore/recreate those groups :S:S

    second edit:
    I personally think that it's not that difficult to add new groups for Admin Server Query,
    I mean those groups aren't unique to every server right?
    Hope someone knows the solution to my prob
    Actually, I'm in the (slow) process of adding more features, and this is one. Where you can import and export groups. Give me a day or so, I'll see what I can do.

  7. #22
    Join Date
    July 2002
    Location
    Germany
    Posts
    2,192
    Hi,

    first off, thanks for making these nice guids, some useful stuff here

    Quote Originally Posted by Soljia View Post
    Choose any user to be in the Admin Server Query group. [Using sqlite]
    Can you please remove this? It is a very bad idea to put normal users into the Admin Server Query group, and it does not give them any powers within the client that a normal server admin doesn't already have, so all I see is potential danger and no benefit?

    Also I would like to suggest, since you have multiple guides here, to split them up in separate threads, that way you could also put the actual documentation straight into the thread and not have to link to google docs. This should lead to your guides to be easier to find and to comments to each guide be easier to browse.

    PS: Something you might want to point out about resetting the serveradmin password via sqlite is that this method works on a running server, the "easy" way that R. Ludwig posted is only viable if you are ok with restarting your server.

    Thanks
    You think my answer is stupid ? Read This:
    http://www.catb.org/~esr/faqs/smart-...ons.html#intro

    In a world without fences and walls - who needs windows and gates ?

  8. #23
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    I will indeed do this. As for removing in general, I'll just move it and put your warning on it. But I will make this thread solely for changing server admin password.

    Quote Originally Posted by Peter View Post
    Hi,

    first off, thanks for making these nice guids, some useful stuff here


    Can you please remove this? It is a very bad idea to put normal users into the Admin Server Query group, and it does not give them any powers within the client that a normal server admin doesn't already have, so all I see is potential danger and no benefit?

    Also I would like to suggest, since you have multiple guides here, to split them up in separate threads, that way you could also put the actual documentation straight into the thread and not have to link to google docs. This should lead to your guides to be easier to find and to comments to each guide be easier to browse.

    PS: Something you might want to point out about resetting the serveradmin password via sqlite is that this method works on a running server, the "easy" way that R. Ludwig posted is only viable if you are ok with restarting your server.

    Thanks

  9. #24
    Join Date
    March 2009
    Location
    Netherlands
    Posts
    39
    Quote Originally Posted by Soljia View Post
    Actually, I'm in the (slow) process of adding more features, and this is one. Where you can import and export groups. Give me a day or so, I'll see what I can do.
    I will wait

    Would be a cool feature since I deleted it

  10. #25
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Having difficulties with the program. Arg. Also switching to the TS3QueryLib.

  11. #26
    Join Date
    November 2009
    Location
    United States
    Posts
    40
    I've got a problem with this, I keep getting the error...

    Code:
    error id=520 msg=invalid\sloginname\sor\spassword
    I know I'm putting the right password in when I am trying to login to server query via the client. I have the Authentication set to "Login command" and I run the following command:

    Code:
    login serveradmin fiQN50+x7Qj6CNOAY/amqRRiqBU=
    use 1
    servergroupaddclient sgid=2 cldbid=2
    My only thought would be the = sign at the end, maybe that's causing a problem, but no matter how many I generate they ALL have the = sign at the end. Help me out, what could I be doing wrong here?

    Here's my full output, I'm pulling a second error if I let it run long enough...though I'd be happy fixing these one at a time if needed.

    Code:
    error id=520 msg=invalid\sloginname\sor\spassword  (10 ms)
    Total: 10 ms
    error id=0 msg=ok  (180532 ms)
    error id=0 msg=ok  (44 ms)
    error id=2568 msg=insufficient\sclient\spermissions failed_permid=17282  (15 ms)
    Total: 180591 ms
    error id=0 msg=ok  (179841 ms)
    Total: 179841 ms
    P.S. I have manually entered those codes somebody else posted to put into your SQLite version if you started with Beta 1 and then upgraded (which I did), and I used sqlliteman to do the file editing as well. If you need me to run any other tests let me know.

    Thanks in advance!

  12. #27
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Quote Originally Posted by Schlup View Post
    I've got a problem with this, I keep getting the error...
    Code:
    login serveradmin fiQN50+x7Qj6CNOAY/amqRRiqBU=
    use 1
    servergroupaddclient sgid=2 cldbid=2
    The password that you are inputting is incorrect. You are currently inputting the encrypted password. You need to put in the password that you typed in originally that gave you that output.

  13. #28
    Join Date
    November 2009
    Location
    United States
    Posts
    40
    Oh man, you rock, that was it! Thanks a million for helping me out with that, server query has been granted to myself now!

  14. #29
    Join Date
    March 2009
    Location
    Netherlands
    Posts
    39
    Can't I just copy the Admin Server Query Group from an fresh install?

  15. #30
    Join Date
    November 2009
    Location
    United States
    Posts
    40
    Not positive but I highly doubt it...that would make the servers very unsecure and easily hackable.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to get my Query Admin password?
    By lalal in forum Server Support
    Replies: 6
    Last Post: March 10th, 2015, 02:55 PM
  2. Server Query Admin password
    By Honza1616 in forum Permission System
    Replies: 1
    Last Post: July 12th, 2014, 02:48 PM
  3. How to get query admin and password
    By qutip in forum Linux / FreeBSD
    Replies: 1
    Last Post: May 29th, 2012, 12:58 PM
  4. Admin Server Query password changing
    By chris_pl in forum Linux / FreeBSD
    Replies: 1
    Last Post: January 4th, 2011, 06:43 PM

Tags for this Thread

Posting Permissions

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