Set and Deploy on Heroku

Install on Heroku

I am working on setting OFN Greece. Here is how I deployed openfoodnetwork on hekoru from ubuntu. I am ruby/rails newbie, be indulgent, so my deploy is not perfect but works :

1. Install first locally on ubuntu (on your machine/virtual machine) according to the instructions :

https://github.com/openfoodfoundation/openfoodnetwork/blob/master/README.md

2. Open a heroku account

3. Download again a clone of this git, unpack

4. add this version to heroku :

git init

git add .

git commit -m "example"

heroku create

heroku addons:create heroku-postgresql

git push heroku master

5. You may stumble on the same error than I did, this is how I solved them

   a. copying config/application.yml.example into config/application.yml and setting heroku config:set TIMEZONE=UTC solved the following error : remote: Value assigned to config.time_zone not recognized.Run "rake -D time" for a list of tasks for finding appropriate time zone names.

   b. removed all dalli from env & gem files to solve an error trying to connect to dalli service during service installation. You can enable dalli in heroku by using credit card as verification of account, but I did not want to (yet).

c. next I stumbled upon the following error, due to not setting the db content before asset precompilation : remote: ActiveRecord::StatementInvalid: PG::Error: ERROR: relation "spree_countries" does not exist. What I did first is to recompile locally the assets (with the db we setup in 1.) "set TIMEZONE=UTC" and "rake assets:precompile". I got a Peer authentication failed for user "ofn", so I changed /etc/postgresql/9.1/main/pg_hba.conf peer to md5. I got this next : PG::Error: FATAL: database "open_food_network_prod" does not exist, I solved with "rake assets:precompile RAILS_ENV=test". Finally I got NoMethodError: undefined method iso' for nil:NilClass`, application.rb (or .yml ?) was missing + rake db:seed solved the problem.

d. now "git push heroku master", and you see he find the manifest and precompiled assets. The git pushed fine and deployed the app, great !

e. the database is still not set so the application cannot run correctly. I tried to execute "heroku rake openfoodnetwork:dev:load_sample_data", like in local, but it never made it. So what I did is simply to copy the local database into the remote. You must replace localhost by your full url (use/password included) :

heroku pg:push localhost postgresql-pointy-35385

I am sure this is not the exact right way, but it works. So I hope you'll help me improve the steps.

Post-install setup

• Country : To open a shop/producer account, I needed to add my country. I added my country directely to my heroku app db (tables spree_countries ans spree_states), using an sql request with jackdb, using data from this table : https://github.com/spree/demo/blob/master/db/default/spree/countries.yml.

• Producer/Shop OFN setup : The user guide is easy to follow. Validated my email (validate in db, untill email config, see further). Then, after creating the shop, adding product require to create a taxonomy with admin account. Then I created a product. In entreprises define delivery, payment (update twice), create a order cycle. Then the product and the shop became visible.

• Google Maps : Then I had to get an api key from google dev page. and add it to heroku config with "heroku config:set GOOGLE_API_KEY=MY_API_KEY".

• Confirmation email : This one is difficult. No email sent, but no error message in heroku log. It took me days of tinkering around. The spree standard mail method page could not send test or confirmation emails, neither locally nor on heroku. I don't understand what is wrong with it, but even the interface is bugging, e.g. dont keep changes after you update. I couldn't figure out how to find logs of the mail sending operation neither, to see if the setup I did is effectively used. But here's a workaround. You can disable Spree and use actionmailer default config :

• make sure your smtp mail is usable : I activated the unsecure apps , use the gmail captcha unlock.

• I tried locally in development.rb, something like this and it worked very well (I tried 4 smtp sever all working) : "config.actionmailer.performdeliveries = true config.actionmailer.raisedeliveryerrors = true config.overrideactionmailerconfig = false ActionMailer::Base.default :from => '[email protected]' config.actionmailer.deliverymethod = :smtp config.actionmailer.smtpsettings = { address: 'smtp.mail.yahoo.com', domain: 'yahoo.com', port: 25, username: '[email protected]', password: 'password', authentica`ti--n: 'plain' }"

• But when deployed, it stopped strangely to send emails. Even when user/pass are wrong, no error show up, the browser confirm sucessfully and heroku mention "email sent to ...". Gmail even detect an attempt to connect if you do not activate the unsecure apps. My mistake was to think that "config.override_actionmailer_config = false" is sufficient to disable spree from overriding my actionmailer config. No, I also had to remove all mail methods defined in the standard interface. Strangely enough, locally it wasn't necessary and I could even send test mails when clicking the button (that used the smtp config of my development.rb and not the one defined in the mail method list).

• There may be a required additional step, I am not sure, credit card verify the account with heroku and enable worker dyno. I hate that our info and bank card is used like this, but before finding out about removing all mail spree methods, in dispair, I gave a try to the verification, and enabled sendgrid plugin. It didn't help at the time, but now that removed spree methods and the emails are received I see the logs, the email is effectively sent by a worker dyno, that was not available, nor activable without credit card verification, even when I use no sendgrid plugin (with other smtp server than sendgrid). I guess the emails is sent in a delayed job, but I am not sure the unverified account with no worker can do it.

• Now you may have a problem with FROM field. As spree find no mail method, OFN use the default smtp config but cannot find a "from" address. So I had to add "ActionMailer::Base.default[:from]" to app/mailers/spree/base_mailer_decorator.rb, so that it uses also actionmailer default "from" field.

• My final config in development.rb with sendgrid on heroku is : config.action_mailer.perform_deliveries = true config.action_mailer.raise_delivery_errors = true config.override_actionmailer_config = true

ActionMailer::Base.default :from => '"OpenFoodNetwork-Greece" [email protected]' config.action_mailer.delivery_method = :smtp config.action_mailer.smtp_settings = { address: 'smtp.sendgrid.net', domain: 'heroku.com', port: 587, user_name: ENV['SENDGRID_USERNAME'], password: ENV['SENDGRID_PASSWORD'], authentication: 'plain', enable_starttls_auto: true }

Now I/You need to customize everything to be not only running but usable by my/your local producers. I will report back with instructions on this step upon completion.