Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to manage the Template Account #199

Closed
visomar opened this issue Jul 17, 2014 · 9 comments
Closed

Unable to manage the Template Account #199

visomar opened this issue Jul 17, 2014 · 9 comments

Comments

@visomar
Copy link

visomar commented Jul 17, 2014

Hi everyone.
I've done a fresh install of 9.18 and when I try to configure the template account (accessing via admin_console->Publishers->Template account->actions->manage), the kmc throws the error "Invalid object id [0]". If I use the action KMC Users, and then login with the Template user, I can access without any problem. The thing is, when I login this way, I'm in a "Manager" account, and not in a "Publisher administrator" which is the one I want to use.

Log error:

2014-07-17 11:53:39 [0.000933] [10.178.169.77] [1267705630] [API] [KalturaFrontController->getExceptionObject] ERR: exception 'KalturaAPIException' with message 'Invalid object id [0]' in /opt/kaltura/app/api_v3/services/UserRoleService.php:91
Stack trace:
#0 [internal function]: UserRoleService->getAction(0)
#1 /opt/kaltura/app/api_v3/lib/KalturaActionReflector.php(233): call_user_func_array(Array, Array)
#2 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(117): KalturaActionReflector->invoke(Array)
#3 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(230): KalturaDispatcher->dispatch('userrole', 'get', Array)
#4 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(102): KalturaFrontController->handleMultiRequest()
#5 /opt/kaltura/app/api_v3/web/index.php(20): KalturaFrontController->run()
#6 {main}
@visomar
Copy link
Author

visomar commented Jul 17, 2014

The application is trying to retrieve a userRole whose id is 0:
SELECT user_role.ID, user_role.STR_ID, user_role.NAME, user_role.DESCRIPTION, user_role.PARTNER_ID, user_role.STATUS, user_role.PERMISSION_NAMES, user_role.TAGS, user_role.CREATED_AT, user_role.UPDATED_AT, user_role.CUSTOM_DATA, user_role.SYSTEM_NAME FROMuser_roleWHERE user_role.ID='0' AND user_role.STATUS<>'3' AND user_role.PARTNER_ID IN ('0','99')
but in the table of the DB there isn't any user_role with an id=0.
Shouldn't it look for a "PARTNER_ADMIN_ROLE" in the table?

@visomar
Copy link
Author

visomar commented Jul 17, 2014

Jess, in case you read this,
I've found your post:
#102 (comment)
in reference of a user who had the same problem I'm experiencing. But I checked, and user 'kaltura' has all privileges:

mysql> SHOW GRANTS FOR 'kaltura';
+--------------------------------------------------------------------------------------------------------+
| Grants for kaltura@%                                                                                   |
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'kaltura'@'%' IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXX' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `kaltura`.* TO 'kaltura'@'%'              |
| GRANT SELECT, INSERT, UPDATE ON `kaltura_sphinx_log`.* TO 'kaltura'@'%'                                |
+--------------------------------------------------------------------------------------------------------+

@krarey
Copy link

krarey commented Jul 17, 2014

The Template KMC Account (Published ID 99), to my knowledge, cannot be used as a standard KMC publisher account. You will need to select 'Add New Publisher' within the Publishers tab of the admin console and fill in the required information to have a fully-fledged publisher initialized. In doing so, Kaltura will also generate a valid KMC Publisher Administrator user that you can use to log in from the KMC and manage your content.

If you're trying to set up your own template account to use as a baseline for additional new publishers, you can then change your customized publisher to type 'Template Template' in the Publisher -> Actions -> Configure screen of the admin console.

@visomar
Copy link
Author

visomar commented Jul 17, 2014

I actually don't want to use the template account as a publisher account, but as a template. I want to configure everything I can in that account before start creating my actual publisher accounts.

The way it lets me login (action->KMC Users->Template Partner->action->login) is also allowing me to configure things such as conversion profiles or players, so maybe you're right, and I don't "need" to login as a publisher administrator in that account. But until now, I was proceeding like this, and it didn't throw me any errors.

@jessp01
Copy link
Contributor

jessp01 commented Jul 18, 2014

Hello,

Yes, this is a valid operation that should work.
Will look into && thanks for the report.

@shaktidhar
Copy link

Getting same error here, using 9.18.0.5 ...
Any suggestions for a workaround for the time being?

@visomar
Copy link
Author

visomar commented Jul 28, 2014

You can do as I said in the first post. Instead of hitting "manage" in the action select of the publisher, you can go to "KMC Users". It should appear a window, and there you can press "Login" in the action column of the only user you should have (Template Partner). This way you can at least work with some features of the template.

@shaktidhar
Copy link

@visomar thanks. Yes. Logging in as a publisher works. Solves some of the immediate issues. Hope the rest is resolved as well in next update.

@jessp01
Copy link
Contributor

jessp01 commented Jul 28, 2014

We're hoping to release one soon.
Thanks,

May the source be with you,

Jess Portnoy

Watch the video recordings from Kaltura Connect 2014, and pre-register for 2015 - http://connect.kaltura.com/

On Sun, 27 Jul 2014, shaktidhar wrote:

Getting same error here, using 9.18.0.5 ...
Any suggestions for a workaround for the time being?


Reply to this email directly or view it onGitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyMjEwNTQxOCwiZGF0YSI6eyJpZCI6MzcyNDg0Mjl9fQ==--bd64a3abeac405
981ebf4e4a549a795254417c51.gif]

@jessp01 jessp01 closed this as completed Aug 23, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

4 participants