Completed Serveradmin Query Verbindung

[alientim]

Mahlzeit, bei dem versuch mich als Serveradmin ein zu Logen bekomme ich immer einen Fehler (ausnahme YatQa).

Der funktionierende YatQa Login ist ganz oben zu sehen.

[2019-01-06 02:47:08] [INFO]  QUERY | Got new client from 87.118.112.224:48198
[2019-01-06 02:47:08] [INFO]  QUERY | Got new authenticated client. Username: ddd, Unique-ID: my609gddQ/m2d/T3zJSVH2+b7ZQ=, Bounded Server: 2
[2019-01-06 02:47:09] [ERROR]     2 | Command handling of command login needs 415ms
[2019-01-06 02:47:10] [ERROR]     2 | Command handling of command logout needs 1004ms
[2019-01-06 02:47:10] [ERROR] QUERY | [87.118.112.224:48198/ServerQuery#87.118.112.224/18108 | 4] Failed to read! Code: 0 errno: 0 message: Success
[2019-01-06 02:47:10] [INFO]    GEN | [Query] 87.118.112.224:48198 disconnected. (Requested by manager)
[2019-01-06 02:47:10] [CRITICAL] QUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)
[2019-01-06 02:47:26] [INFO]  QUERY | Got new client from 87.118.112.224:48204
[2019-01-06 02:47:28] [ERROR] QUERY | [87.118.112.224:48204/ServerQuery#87.118.112.224/48204 | 0] Failed to read! Code: 0 errno: 0 message: Success
[2019-01-06 02:47:28] [INFO]    GEN | [Query] 87.118.112.224:48204 disconnected. (Requested by manager)
[2019-01-06 02:47:28] [CRITICAL] QUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)
[2019-01-06 02:47:28] [ERROR] QUERY | Tried to disconnect a client twice!
[2019-01-06 02:47:53] [INFO]  QUERY | Got new client from 87.118.112.224:48208
[2019-01-06 02:47:55] [ERROR] QUERY | [87.118.112.224:48208/ServerQuery#87.118.112.224/48208 | 0] Failed to read! Code: 0 errno: 0 message: Success
[2019-01-06 02:47:55] [INFO]    GEN | [Query] 87.118.112.224:48208 disconnected. (Requested by manager)
[2019-01-06 02:47:55] [CRITICAL] QUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)
[2019-01-06 02:47:58] [INFO]  QUERY | Got new client from 87.185.92.74:62077
[2019-01-06 02:47:59] [INFO]  QUERY | Got new authenticated client. Username: serveradmin, Unique-ID: serveradmin, Bounded Server: 0

Erstelle ich allerdings einen Query-Login im Client,
funktioniert der "neue" Login-Benutzer und das Passwort

 

[WolverinDEV]

[2019-01-06 02:47:58] [INFO]  QUERY | Got new client from 87.185.92.74:62077
[2019-01-06 02:47:59] [INFO]  QUERY | Got new authenticated client. Username: serveradmin, Unique-ID: serveradmin, Bounded Server: 0

Seems to work within the last lines. In the lines before it seems like the connection was closed by your script.
With which script are you trying to use the query?

 

[alientim]

That was a YatQa connection too.
I tried Psycho´s Webinterface and many other with same results...
All Interface tells me wrong password/username except YatQa

 

[Chazotu]

Have you changed your MOTD ?

 

[alientim]

Have you changed your MOTD ?

 #Notes:
  #  If not like Tea*Speak then some applications may not recognize the Query
  #  Default Tea*Speak 3 MOTD:
  #  TS3\n\rWelcome to the Tea*Speak 3 ServerQuery interface, type \"help\" for a list of commands and \"help <command>\" for information on a specific command.\n\r
  #  NOTE: Sometimes you have to append one \n\r more!
  #The value must be a string
  motd: "TS3\r\nWelcome to the Tea*Speak 3 ServerQuery interface, type \"help\" for a list of commands and \"help <command>\" for information on a specific command.\r\n"

Maybe change \r\n ?

 

[WolverinDEV]

May, this is sometimes tricky

 

[alientim]

May, this is sometimes tricky

That means?

motd: "TS3\r\nWelcome to the Tea*Speak 3 ServerQuery interface, type \"help\" for a list of commands and \"help <command>\" for information on a specific command.\r\n"

motd: "TS3\n\rWelcome to the Tea*Speak 3 ServerQuery interface, type \"help\" for a list of commands and \"help <command>\" for information on a specific command.\n\r"

Error in login() on line 2306: ErrorID: 520 | Message: invalid loginname or password extra_msg=username or password dose not match 
Failed to read! Code: 0 errno: 0 message: Success

Both wont let me Connect via Interface as "serveradmin" - as an Clientside Query i still can Connect
YatQa is still able to Connect as "serveradmin"

 

[WolverinDEV]

sername or password dose not match you've entered a wrong password

 

[alientim]

sername or password dose not match you've entered a wrong password

You Think your Funny?
Again: SAME DATA - YatQa can connect all other not - BUT only as serveradmin

Means: YatQa = username: serveradmin, password:"the right one" - result is LOGIN
Web-Interface = username: serveradmin,password:"the right one" - result is WRONG PASSWORD

If i create a QueryLogin-User both works!

 

[WolverinDEV]

Does you web interface may encode the password wrong? Or uses unknown parameters?
I recommend you to try to debug that. You could also try to set the password to an easy one (type passwd <password> <password> within the TeaSpeak terminal) (for test purposes only!)

 

[alientim]

Its the Psycho interface thats update...
found this in the TeaSpeak Forums...

 

[alientim]

You could also try to set the password to an easy one (type passwd <password> <password> within the TeaSpeak terminal) (for test purposes only!)

Changed it a password with only Numbers but same error...
The thing is that i still can connect via the webinterface if i create an query-user via Tea*Speak

 

[WolverinDEV]

Could you enable verbose mode? You see there what the query sends in raw, may there is a difference.

 

[Kevinos]

Changed it a password with only Numbers but same error...
The thing is that i still can connect via the webinterface if i create an query-user via Tea*Speak

Personally : i use the motd motd: "TS3\r\nWelcome on the TeaSpeak ServerQuery interface.\r\n"

Working on YatQa and the last Psycho interface.

Test this motd

 

[alientim]

Well, the errorer is actually another one, the Console says Password Changed, but its acutally not doing it =D

May i have to reinstall it...

 

[Kevinos]

Well, the errorer is actually another one, the Console says Password Changed, but its acutally not doing it =D

May i have to reinstall it...

Or download sqlitebrowser, open the file TeaData.sqlite in sqlitebrowser, check the table queries and change the password here. and reupload the TeaData.sqlite and restart.

 

[alientim]

Well it seems that you cant use signs like "!$%&/()=?" in the password for login to TeaSpeak
Result is after editing the SQL i can login...

Next Problem the view of Query clients?
Rights are set, even YatQa cant see query clients too

 

[WolverinDEV]

b_virtualserver_select_godmode if this permission is granted, a query could be connected without being visible or bound to an channel until he moves or joins.

 

[alientim]

Your my hero =D
An is it possible to set the godmode only in 1 instance?

 

[alientim]

So the solution was the sql edit vial sqlbrowser, dont know why i can change password via passwd in ./teastart_minimal.sh!