381
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 233:
Line 233: − + + + + + − + − + − + − −
→POSTGRES setup
</syntaxhighlight>add the initial admin user manually to the user database (we need to be the koji user to do this)
</syntaxhighlight>add the initial admin user manually to the user database (we need to be the koji user to do this)
We can add additional users and change privileges of those users via the koji command line tool after this<syntaxhighlight lang="bash">
We can add additional users and change privileges of those users via the koji command line tool after this
{{Note box|For the user_perms, we check the user_id of the user we created.
If it's not 1, the user_perms line should be
insert into user_perms (user_id, perm_id, creator_id) values (<user_id>, 1, <user_id>);}}<syntaxhighlight lang="bash">
su - koji
su - koji
psql
psql
koji=> insert into users (name, status, usertype) values ('admin-user-name', 0, 0);
koji=> insert into users (name, status, usertype) values ('kojiadmin', 0, 0);
koji=> select * from users;
koji=> select * from users;
koji=> insert into user_perms (user_id, perm_id, creator_id) values (<id of user inserted above>, 1, <id of user inserted above>);
koji=> insert into user_perms (user_id, perm_id, creator_id) values (1, 1, 1);
\q
\q
exit
exit
</syntaxhighlight>We can now set up the hub itself.
</syntaxhighlight>We can now set up the hub itself.<nowiki><br></nowiki>As we are using SSL certificates, we need to tweak the httpd configs<syntaxhighlight lang="bash">
As we are using SSL certificates, we need to tweak the httpd configs<syntaxhighlight lang="bash">
nano /etc/httpd/conf.d/kojihub.conf
nano /etc/httpd/conf.d/kojihub.conf
</syntaxhighlight>and uncomment the lines as below<syntaxhighlight lang="ini">
</syntaxhighlight>and uncomment the lines as below<syntaxhighlight lang="ini">
