Minimum sql privileges for TV-Server (1 Viewer)

[AtreX]

Hi guys!

I've been trying to get a TV-Server up and running the last few days on 1.6 final using a mysql-server I allready had around.
What I can't seem to figure out is why on earth the tvserver service will not start unless it has FULL (and I mean absolutely FULL) rights to the WHOLE mysql server (including full rights to all schemas, not just the one it uses, and also including the rights to affect other schemas, users, user privileges, and so on).
I really can see no reason for this as it works fine if you give it full rights for the startup and then remove the rights for everything except its own schema, which is what it should need.
So either I've missed testing something out or someone decided to make a very unnessecary privilege-check before the tv-server service starts.

What I would like to know is, is there a way to disable this mysql privilege-check in the startup of the tvserver service?
Or even better, is there a way to have the developers check if they have the rights they actually need, instead of just taking the easy way out and demand everything?

 

[mm1352000]

Hello AtreX

I've been trying to get a TV-Server up and running the last few days on 1.6 final using a mysql-server I allready had around.

Okay.

What I can't seem to figure out is why on earth the tvserver service will not start unless it has FULL (and I mean absolutely FULL) rights to the WHOLE mysql server (including full rights to all schemas, not just the one it uses, and also including the rights to affect other schemas, users, user privileges, and so on).

AFAIK this is not true.
It does require SELECT privileges on the mysql schema (and obviously full - SELECT, UPDATE, DELETE etc. privileges on our own schema)... but that's it. I think the mysql schema requirement is only to check that no other schemas with the same name already exist when we create our schema.

So either I've missed testing something out or someone decided to make a very unnessecary privilege-check before the tv-server service starts.

As above. I don't think there is anything more I can add. The check for an existing schema seems quite reasonable to me.

mm

[edit: I should also say, AFAIK that mysql privilege should only be required during install at creation of the schema, but maybe I'm wrong about that.]

 

[Wiedmann]

What I can't seem to figure out is why on earth the tvserver service will not start unless it has FULL (and I mean absolutely FULL) rights to the WHOLE mysql server (including full rights to all schemas, not just the one it uses, and also including the rights to affect other schemas, users, user privileges, and so on).

AFAIK this is not true.
It does require SELECT privileges on the mysql schema (and obviously full - SELECT, UPDATE, DELETE etc. privileges on our own schema)... but that's it. I think the mysql schema requirement is only to check that no other schemas with the same name already exist when we create our schema.

The mysql schema isn't used (and is not needed) to do this check. IMHO it's just a bug: https://forum.team-mediaportal.com/...r-have-only-rights-to-the-mp-database.124312/