Creating admin using rake admin:create in multisite configuration

Hammad_Abbasi · August 14, 2016, 2:24pm

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.

zogstrip · August 14, 2016, 5:38pm

You have to switch database using the RAILS_DB=<name_of_db> prefix before the command

RAILS_DB=site1 rake admin:create

Hammad_Abbasi · August 19, 2016, 6:30am

It’s still creating admin account for first web site

Hammad_Abbasi · August 19, 2016, 6:50am

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”

Hammad_Abbasi · August 19, 2016, 8:29am

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 ?

tgxworld · August 19, 2016, 8:25am

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

tgxworld · August 19, 2016, 8:35am

Try RAILS_DB=b_discourse rake admin:create?

Hammad_Abbasi · August 19, 2016, 8:36am

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

tgxworld · August 19, 2016, 8:52am

Hmm I’m not sure why it isn’t working for you. I just tested locally and it works fine.

Yup you can

github.com

discourse/discourse/blob/main/lib/tasks/admin.rake#L31-L89


      
              :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

Hammad_Abbasi · August 19, 2016, 8:59am

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

tgxworld · August 19, 2016, 9:09am

Try RAILS_DB=secondsite instead.

Hammad_Abbasi · August 19, 2016, 10:49am

Bingo - It worked

Thanks alot

Topic		Replies	Views
Troubleshooting multi-site databases Support	2	943	August 19, 2016
Create an admin account from the console Self-Hosting how-to	0	59167	July 6, 2014
How to specify alternate configuration in multisite Installation	24	2293	November 13, 2017
What is the Rails command to create an admin user in Discourse? Support	10	1917	May 10, 2020
Set up a multisite development environment Developer Guides dev-install , how-to	0	1308	June 7, 2022

Creating admin using rake admin:create in multisite configuration

Related topics