Creating an admin user in production on Spree

ruby-on-rails postgresql spree
Erwin Rooijakkers picture Erwin Rooijakkers · Oct 6, 2013 · Viewed 9k times · Source

I deployed my Spree app to a server. Locally I can login as an admin and change things, but on the server this password and account does not work. When I go to /admin I get the message authorization failure.

I did already run bundle exec rake spree_auth:admin:create and bundle exec rake db:migrate but this does not work. Furthermore, I can also login with my e-mailaddress and password I got from the hosting company, but I can not go to the admin page.

Does anyone know how I create an admin user?

Answer

manishie picture manishie · Oct 6, 2013

Deploying Spree doesn't (and shouldn't) copy your database from development to production.

So your development admin user doesn't exist on the production database.

SSH into your production server and try:

rake spree_auth:admin:create

Update:

Do this in /data/spree/current

Related questions

Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails

I'm getting the error: FATAL: Peer authentication failed for user "postgres" when I try to make postgres work with Rails. Here's my pg_hba.conf, my database.yml, and a dump of the full trace. I changed authentication to md5 …

Read More
Postgres could not connect to server

After I did brew update and brew upgrade, my postgres got some problem. I tried to uninstall postgres and install again, but it didn't work as well. This is the error message.(I also got this error message when I …

Read More
Can't find the 'libpq-fe.h header when trying to install pg gem

I am using the Ruby on Rails 3.1 pre version. I like to use PostgreSQL, but the problem is installing the pg gem. It gives me the following error: $ gem install pg Building native extensions. This could take a while... ERROR: …

Read More