Problem SuperUser

It crashed, it is bugged, ...

Problem SuperUser

Postby xlkiller » Thu Apr 08, 2010 2:05 pm

Hello

I currently have several servers using MySQL Mumble.
When I log in on some server SuperUser no password is required and I find myself connected with the pseudo SuperUser like any other user ...

Do you have a solution ?
Is there also a command that checks the error of the database ?

Image
xlkiller
 
Posts: 7
Joined: Wed Feb 17, 2010 5:20 pm

Re: Problem SuperUser

Postby kissaki » Fri Apr 09, 2010 6:04 pm

"on some server"
does that mean it's not on all MySQL-using servers?
Is the superuser pw set?
Do you have it in your access-tokens (passwords) list? (client)
The server log should at least write about you connecting. If you're logging in about that as well. Maybe it does state something?
MumPI: Your Mumble Web Interface in PHP
User avatar
kissaki
Team member
Team member
 
Posts: 1280
Joined: Sat Jan 09, 2010 12:15 pm

Re: Problem SuperUser

Postby xlkiller » Tue Apr 13, 2010 4:48 pm

On mumble-server.log:

Code: Select all
<W>2010-04-13 18:54:39.400 12 => <2:(-1)> New connection: 82.240.163.20:56583
<W>2010-04-13 18:54:40.085 12 => <2:(-1)> Client version 1.2.3 (Win: 95c274)
<W>2010-04-13 18:54:40.715 12 => Starting voice thread
<W>2010-04-13 18:54:40.932 12 => CELT codec switch ffffffff8000000b 0 (prefer ffffffff8000000b)
<W>2010-04-13 18:54:41.096 12 => <2:SuperUser(-1)> Authenticated


On MySQL:
server_id = 12

murmur_users = No user on the server 12

murmur_user_info = No user on the server 12

If i use dbus:

dbus-send --system --print-reply --dest=net.sourceforge.mumble.murmur --type=method_call / net.sourceforge.mumble.Meta.setSuperUserPassword int32:12 string:MyPassword

Same problem, No SuperUser password required.

If i reboot my server, all SuperUser Password are reset.
Where SuperUser Password stored ?
xlkiller
 
Posts: 7
Joined: Wed Feb 17, 2010 5:20 pm

Re: Problem SuperUser

Postby kissaki » Wed Apr 14, 2010 12:58 pm

xlkiller wrote:Where SuperUser Password stored ?


The password is stored in the users table in the database.
Each server (server_id) has the superuser account (or "user") with user_id 0. And that one also has a pw field.
MumPI: Your Mumble Web Interface in PHP
User avatar
kissaki
Team member
Team member
 
Posts: 1280
Joined: Sat Jan 09, 2010 12:15 pm

Re: Problem SuperUser

Postby xlkiller » Wed Apr 14, 2010 4:26 pm

Look my problem

I HAVE 73 Mumble Server on my Database

I have restarted my server yesterday and now i have just 2 User with 0 user_id ! :arrow: http://www.monsterup.com/upload/1271262128386.jpg
I have restarted my server now and in my database i have all SuperUser Account. :arrow: http://www.monsterup.com/upload/1271262183877.jpg

Between yesterday and today I see nothing in the logs that talks about removing SuperUser Account

it's a bug or a server hack?
xlkiller
 
Posts: 7
Joined: Wed Feb 17, 2010 5:20 pm

Re: Problem SuperUser

Postby kissaki » Thu Apr 15, 2010 12:16 pm

SuperUser account can't be removed.
At least that's how it's supposed to be.
Of course you could query mysql directly and do it.
But Mumble/Murmur denies removing superuser accounts (thus also via Ice for example).
MumPI: Your Mumble Web Interface in PHP
User avatar
kissaki
Team member
Team member
 
Posts: 1280
Joined: Sat Jan 09, 2010 12:15 pm

Re: Problem SuperUser

Postby xlkiller » Thu Apr 15, 2010 4:19 pm

Probleme solved. I found an error in my PHP file ... Sorry and Than'ks you very much !
xlkiller
 
Posts: 7
Joined: Wed Feb 17, 2010 5:20 pm


Return to Technical

Who is online

Users browsing this forum: No registered users and 2 guests