We are running Kaltura CE 10.16.0 in production. The one and only administrator left his position, and I am now responsible for Kaltura. I need to log on to the admin console to install a commercial certificate (among other things). Nobody in the entire enterprise has an account with administrator privilege with which to log on to the admin console.
As I see it, I can use mysql to directly add a user or I could possibly change the former administrator’s password.
I can log on as root, then…
mysql> use kaltura;
mysql> select screen_name, first_name, last_name, email, partner_id from kuser
mysql> select login_email, first_name , last_name, config_partner_id from user_login_data;
I can see all the users. I understand that partner_id -2 is the Kaltura Administrator, "firstname.lastname@example.org".
I need to create a new user who has the partner ID “-2”, or Admin Console associated with him.
Since I cannot log on to the Admin Console, can I change the value for sha1_password for the former administrator, or can I create a new user who is associated with partner ID -2 from the mysql prompt?