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	941	August 19, 2016
How to specify alternate configuration in multisite Installation	24	2291	November 13, 2017
Create an admin account from the console Self-Hosting how-to	0	58730	July 6, 2014
What is the Rails command to create an admin user in Discourse? Support	10	1882	May 10, 2020
Set up a multisite development environment Developer Guides dev-install , how-to	0	1254	June 7, 2022

Creating admin using rake admin:create in multisite configuration

Related Topics