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.

Try RAILS_DB=secondsite instead.

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

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 connecting to both databases using sudo -u postgres psql b_discourse but when i run select * from users ( it returns nothing ) I tried running “rake admin:create RAILS_DB=b_discourse”- but this is creating the user on first site. I ran “SiteSetting.notification_email” command in rails console it shows email from 1st Site - is there any way i can switch database in rails console ?

RAILS_DB=b_discourse rails console or RAILS_DB=b_discourse rails runner

[תמונה] Hammad_Abbasi: rake admin:create RAILS_DB=b_discourse Try RAILS_DB=b_discourse rake admin:create?

[תמונה] 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 for your Help

Hmm I’m not sure why it isn’t working for you. I just tested locally and it works fine. [תמונה] 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 :user_email, type: "account_created", user_id: user.id, email_token: email_token.token, ) end desc "Creates a forum administrator" task "admin:create" => :environment do require "highline/import" begin email = ask("Email: ") existing_user = User.find_by_email(email) # check if user account already exists if existing_user # user already exists, ask for password reset admin = existing_user reset_password = This file has been truncated. show original

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 just realized “RAILS_DB=b_discourse rails console” is also connecting to first database

Bingo - It worked :smiley: Thanks alot

Creating admin using rake admin:create in multisite configuration

Product Support Self-hosting

Hammad_Abbasi (Hammad Abbasi) 19 באוגוסט,‏ 2016,‏ 6:30am 3

It’s still creating admin account for first web site

נושא		תגובות	צפיות
Troubleshooting multi-site databases Product Support	0	1015	19 באוגוסט,‏ 2016
How to specify alternate configuration in multisite Self-hosting	23	2652	13 בנובמבר,‏ 2017
Set up a multisite development environment Developer Guides dev-install , how-to	0	2198	7 ביוני,‏ 2022
Commandline restore specific site in multi-site configuration Product Support	2	750	12 בינואר,‏ 2018
Create an admin account from the console Self-Hosting how-to	1	64852	2 בינואר,‏ 2025

Creating admin using rake admin:create in multisite configuration

נושאים קשורים