Hi, I am running discourse multi-site setup, I am wondering how can i create administrator using rake admin:create It creates the administrator on first site.

You have to switch database using the RAILS_DB=<name_of_db> prefix before the command RAILS_DB=site1 rake admin:create

It’s still creating admin account for first web site

I am also trying to connect to 2nd database manually using su -c ‘psql discourse’ postgres but it throws error “no password entry for user postgres”

Hi, I have setup a multi-site up and running however I am unable to create admin or configure notification email for 2nd site so i have few questions How can i configure SiteSettings in app.yml for a) 2nd Site b) ALL SITES exec: rails r “SiteSetting.notification_email=‘’” I have tried manually…

RAILS_DB=b_discourse rails console or RAILS_DB=b_discourse rails runner <command>

[image] Hammad_Abbasi: rake admin:create RAILS_DB=b_discourse Try RAILS_DB=b_discourse rake admin:create?

[image] tgxworld: RAILS_DB=b_discourse rake admin:create I did but didn’t work (creating on first site) I am however able to use 2nd db using "RAILS_DB=b_discourse rails console " Can i create an admin user or change password of existing user using this console ? Please advice. Many Thanks…

Hmm I’m not sure why it isn’t working for you. I just tested locally and it works fine. [image] Hammad_Abbasi: Can i create an admin user or change password of existing user using this console ? Yup you can :slight_smile: lib/tasks/admin.rake main :…

Below is my app.yml for 2nd site ( First site is using default - discourse_hostname) before_bundle_exec: - file: path: $home/config/multisite.yml contents: | secondsite: adapter: postgresql database: b_discourse pool: 25 timeout: 5000 db_id: 2 host_names: - community.mydomain.com I j…

Bingo - It worked :smiley: Thanks alot

Creating admin using rake admin:create in multisite configuration

Product Support Self-hosting

tgxworld (Alan Tan) August 19, 2016, 9:09am 11

Try RAILS_DB=secondsite instead.

Topic		Replies	Views
Troubleshooting multi-site databases Product Support	0	1006	August 19, 2016
How to specify alternate configuration in multisite Self-hosting	23	2603	November 13, 2017
Set up a multisite development environment Developer Guides dev-install , how-to	0	2169	June 7, 2022
Commandline restore specific site in multi-site configuration Product Support	2	729	January 12, 2018
Create an admin account from the console Self-Hosting how-to	1	64571	January 2, 2025

Creating admin using rake admin:create in multisite configuration

Related topics