On Fri, Feb 16, 2018 at 04:12:15PM +0100, Aurelien Bompard wrote:
In the normal vm case, I have a couple questions:
- What will my URL be?
https://hubs.stg.fedoraproject.org I guess?
yes
- What's the Ipsilon instance I should register with? I used
to register
on
iddev.fedorainfracloud.org but I guess that's no good for staging
I'll let Patrick answer, but I believe this is going to be id.stg.fp.o for which
the registration is different (ie: not self-service)
- I need the following passwords set in the ansible private repo
(proposed
ansible variable name) :
 - for the hubs DB user (hubs_db_pass)
 - for the Flask session secret key (hubs_session_secret), this can be
30-50 chars.
Both created
Do we still require two DB users, one with CRUD permissions and
one with
full permissions? I haven't seen it used outside the hyperkitty playbook.
If so, I'll need a password for the admin user too, and I'm interested in
the way you give the privileges on the tables to the non-admin user. For
HyperKitty I use a rather clumsy handwritten script, but there may be a
better way.
I know that I started using two users at one point but I ended up going back to
a single one for most use-case as managing the permissions was clumsy indeed.
Updating the database schema required adjusting the permissions on table, on
indexes and forgetting one, getting a permission denied error and adjusting
again :s
Are you sure you want two users?
I can create an user (hubs_db_user) and a database (hubs_db) and give the user
full access to the db if that works for you.
Pierre