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 _______________________________________________ infrastructure mailing list -- infrastructure@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to infrastructure-leave@xxxxxxxxxxxxxxxxxxxxxxx
