Set up a staging server

[nathank (Nathan Kershaw)]

That is kind of the point of the setup above; it is super useful to have the staging server pointing at the same bucket as this makes it much easier to keep them in sync.

However, you don’t want it contributing any backups automatically (or deleting any) - hence these is turned off by these settings:

@nathank

  DISCOURSE_AUTOMATIC_BACKUPS_ENABLED: false
  DISCOURSE_S3_DISABLE_CLEANUP: true

Agree that the CDN needs to be turned off for your staging site. I haven’t messed with that myself, but once you work how to do that please do update / add to the wiki in the OP.

[Octoberon]

Thanks, Nathan. I saw mention of S3 backups making things easier but a backup is different to the site assets so I wasn’t sure.

I’ve already turned off backups and emails so all good there. I’ll get on with pointing the staging server to the existing bucket and make sure it isn’t using the CDN.

[pfaffman (Jay Pfaffman)]

Sharing backups is really nice because it makes it easy to copy your production database to staging.

[Richie (Richie Rich)]

I plan to create a mirror of my production Discourse by using the rsync method.

I have a couple of other web sites which integrate with Discourse, so having the dev/test versions of those sites being able to hit and interact with a dev/test/staging version of Discourse would be ideal.

Therefore I would only power it on when needed, and I would restore a database backup of my PROD on to my STAGING periodically - not daily and maybe as little as once per month.

If I do this, how do I stop it changing some settings back when I do the database restore?

These for example, would be invaluable:

@nathank

However, you don’t want it contributing any backups automatically (or deleting any) - hence these is turned off by these settings:

@nathank

  DISCOURSE_AUTOMATIC_BACKUPS_ENABLED: false
  DISCOURSE_S3_DISABLE_CLEANUP: true

Is there a way I could restore a database backup and then maybe manually apply some settings before starting Discourse? Any other ideas, suggestions, gotchas?

[pfaffman (Jay Pfaffman)]

If you keep backups on S3 and configure that via ENV variables, then you can pretty easily spin up a new site that can restore that backup. Just spin up a new VM, clone discourse, copy the yml, rebuild and restore. You can override settings in the database with ENV variables as in the quote in your post.

[Richie (Richie Rich)]

@pfaffman

You can override settings in the database with ENV variables

Perfect, it sounds almost too easy

[denvergeeks]

Am I missing a step? I’m pretty sure this worked a year ago or so. But now, while it does populate, it doesn’t add any Topics or posts beyond the About the Category… has something changed?

@nathank

If what you want is a test server to see what Discourse is like, though, you might want to check things out with some fake data, and if you do, you can do this:

./launcher enter app
ALLOW_DEV_POPULATE=1 bundle install
ALLOW_DEV_POPULATE=1 rake dev:populate

This will seed your forum with some fake data so that you can see what things look like with whatever themes and plugins you want. If you haven’t started your forum yet, this will give you some idea what things are likely to look like.

[pfaffman (Jay Pfaffman)]

@denvergeeks

But now, while it does populate, it doesn’t add any Topics or posts beyond the About the Category… has something changed?

When I tried it just now, it created group and user records, but when creating categories failed with

ActiveRecord::RecordInvalid: Validation failed: Category Name has already been taken (ActiveRecord::RecordInvalid)

It seems like it should be smart enough not to try to create a category with an existing name.

Mine was not an empty site, however. There is also a dev:repopulate task, which first wipes the database.

[denvergeeks]

Thank you Jay! Here’s a screen showing what I tried… It looks like I need to be in “development environment”. How do I enter that?

[denvergeeks]

I ended up restoring an old backup from one of my discourse instances where I had previously used this method to populate. I had to do this, but it worked.

[pfaffman (Jay Pfaffman)]

There’s a thing you have to do to be able to drop the database. If you do the db:drop rake task it’ll tell you what it is. So I guess you’d need to sv stop unicorn and then drop, create, and migrate the database before running the task. Or that’s the next thing I would try, but you’ve got another solution…