Installing Discourse (Rails) on OpenBSD

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Installing Discourse (Rails) on OpenBSD

opendaddy
Hi!

Trying to install the Discourse forum (https://github.com/discourse/discourse) manually without Docker. I got PostgreSQL 9.4, Redis and my bundle all set up, however the migration seems to fail:

== 20120921162512 AddMetaDataToForumThreads: migrating ========================
-- execute("CREATE EXTENSION IF NOT EXISTS hstore")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedFile: ERROR:  could not open extension control file "/usr/local/share/postgresql/extension/hstore.control": No such file or directory
: CREATE EXTENSION IF NOT EXISTS hstore/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR:  could not open extension control file "/usr/local/share/postgresql/extension/hstore.control": No such file or directory
: CREATE EXTENSION IF NOT EXISTS hstore
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
PG::UndefinedFile: ERROR:  could not open extension control file "/usr/local/share/postgresql/extension/hstore.control": No such file or directory
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

I then did a `touch /usr/local/share/postgresql/extension/hstore.control` and now on `rake db:migrate` I get:

ps: %p|$|%a: keyword not found
ps: no valid keywords
== 20120921162512 AddMetaDataToForumThreads: migrating ========================
-- execute("CREATE EXTENSION IF NOT EXISTS hstore")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::InvalidParameterValue: ERROR:  version to install must be specified
: CREATE EXTENSION IF NOT EXISTS hstore/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
ActiveRecord::StatementInvalid: PG::InvalidParameterValue: ERROR:  version to install must be specified
: CREATE EXTENSION IF NOT EXISTS hstore
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
PG::InvalidParameterValue: ERROR:  version to install must be specified
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Only Docker installs are supported meaning the Discourse team won't help me with this one. Docker or not though, it's still odd that the migration should fail like this.

O.D.

Reply | Threaded
Open this post in threaded view
|

Re: Installing Discourse (Rails) on OpenBSD

Edho Arief
On Sat, Jun 13, 2015 at 10:37 PM,  <[hidden email]> wrote:
> Hi!
>
> PG::UndefinedFile: ERROR:  could not open extension control file "/usr/local/share/postgresql/extension/hstore.control": No such file or directory
> : CREATE EXTENSION IF NOT EXISTS hstore/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in `change'
> ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR:  could not open extension control file "/usr/local/share/postgresql/extension/hstore.control": No such file or directory
> : CREATE EXTENSION IF NOT EXISTS hstore

You need to install postgresql-contrib.

Reply | Threaded
Open this post in threaded view
|

Re: Installing Discourse (Rails) on OpenBSD

opendaddy
Hi!

On 13. juni 2015 at 1:47 PM, "Edho Arief" <[hidden email]> wrote:
>
>You need to install postgresql-contrib.

That did the trick - thank you so much!

O.D.

Reply | Threaded
Open this post in threaded view
|

Re: Installing Discourse (Rails) on OpenBSD

opendaddy
In reply to this post by Edho Arief
On 13. juni 2015 at 1:47 PM, "Edho Arief" <[hidden email]> wrote:
>
>You need to install postgresql-contrib.

Have you managed to install Discourse yourself? Not via Docker but as a regular Rails app. If so, would you happen to know how to make it send emails? All my normal Rails apps can send emails just fine (Action Mailer + OpenSMTPD, localhost).

Thanks.

O.D.