Chore: Migrate Email Dashboard from Heroku to Fly.io

[nelsonic]

Migrate email dashboard from Heroku to Fly.io? https://dwylmail.herokuapp.com/

related to: dwyl/learn-heroku#52

Todo

• Backup Environment variables see: Get List of Environment Variables from Heroku learn-heroku#35
• Create PR to capture work
• Setup auto-deploy for Fly.io
• Manually deploy to confirm everything working

[nelsonic]

$16/month is the lowest we would pay to run this ultra-low volume/overhead App on Heroku:
https://www.heroku.com/pricing

For that I would prefer to pay Keila who have a much more advanced Email Drafting, Sending & Tracking App #60

[nelsonic]

https://dashboard.heroku.com/apps/dwylmail

As you can see, Heroku kindly already deleted all our data:

So even if we wanted to pay Salesforce $16/month to host this for us ... we'd be starting from scratch. 🤦‍♂️

Going to try and re-boot this ...

https://dashboard.heroku.com/apps/dwylmail/resources/new?addonService=heroku-postgresql

https://dwylmail.herokuapp.com/

Restart all dynos ... ⏳

Yah! 🎉

https://dashboard.heroku.com/apps/dwylmail/logs

Useless.

[nelsonic]

Just tried to run this on localhost with Elixir 1.14.3 and got hundreds of warnings! 😖

Tried running: mix ecto.reset got:

warning: use Mix.Config is deprecated. Use the Config module instead
  config/config.exs:8

warning: use Mix.Config is deprecated. Use the Config module instead
  config/dev.exs:1

The database for App.Repo has been dropped
The database for App.Repo has been created

10:18:52.527 [info] == Running 20191113100513 App.Repo.Migrations.CreateTags.change/0 forward

10:18:52.529 [info] create table tags

10:18:52.533 [info] == Migrated 20191113100513 in 0.0s

10:18:52.549 [info] == Running 20191113100912 App.Repo.Migrations.CreateStatus.change/0 forward

10:18:52.549 [info] create table status

10:18:52.551 [info] == Migrated 20191113100912 in 0.0s

10:18:52.552 [info] == Running 20191113100920 App.Repo.Migrations.CreatePeople.change/0 forward

10:18:52.552 [info] create table people

10:18:52.556 [info] create index people_status_index

10:18:52.557 [info] create index people_tag_index

10:18:52.558 [info] == Migrated 20191113100920 in 0.0s

10:18:52.560 [info] == Running 20191113114340 App.Repo.Migrations.AddPersonIdToTag.change/0 forward

10:18:52.560 [info] alter table tags

10:18:52.560 [info] == Migrated 20191113114340 in 0.0s

10:18:52.561 [info] == Running 20191113141229 App.Repo.Migrations.AddPersonIdToStatus.change/0 forward

10:18:52.561 [info] alter table status

10:18:52.566 [info] == Migrated 20191113141229 in 0.0s

10:18:52.567 [info] == Running 20191130210036 App.Repo.Migrations.AddPictureLocaleToPeople.change/0 forward

10:18:52.567 [info] alter table people

10:18:52.568 [info] == Migrated 20191130210036 in 0.0s

10:18:52.570 [info] == Running 20200224224024 App.Repo.Migrations.CreateSent.change/0 forward

10:18:52.570 [info] create table sent

10:18:52.574 [info] create index sent_person_id_index

10:18:52.575 [info] create index sent_status_id_index

10:18:52.576 [info] == Migrated 20200224224024 in 0.0s
MacOSX 10.7 or later required for --file-events
[notice] Application app exited: App.Application.start(:normal, []) returned an error: shutdown: failed to start child: AppWeb.Endpoint
    ** (EXIT) shutdown: failed to start child: Phoenix.PubSub.PG2
        ** (EXIT) shutdown: failed to start child: Phoenix.PubSub.PG2Server
            ** (EXIT) an exception was raised:
                ** (UndefinedFunctionError) function :pg2.create/1 is undefined or private
                    (kernel 8.5.3) :pg2.create({:phx, App.PubSub})
                    (phoenix_pubsub 1.1.2) lib/phoenix/pubsub/pg2_server.ex:43: Phoenix.PubSub.PG2Server.init/1
                    (stdlib 4.2) gen_server.erl:851: :gen_server.init_it/2
                    (stdlib 4.2) gen_server.erl:814: :gen_server.init_it/6
                    (stdlib 4.2) proc_lib.erl:240: :proc_lib.init_p_do_apply/3
[notice] Application phoenix_live_view exited: :stopped
[notice] Application hackney exited: :stopped
[notice] Application metrics exited: :stopped
[notice] Application ssl_verify_fun exited: :stopped
[notice] Application certifi exited: :stopped
[notice] Application mimerl exited: :stopped
[notice] Application idna exited: :stopped
[notice] Application unicode_util_compat exited: :stopped
[notice] Application poison exited: :stopped
[notice] Application ex_aws_lambda exited: :stopped
[notice] Application ex_aws exited: :stopped
[notice] Application joken exited: :stopped
[notice] Application jose exited: :stopped
[notice] Application fields exited: :stopped
[notice] Application html_sanitize_ex exited: :stopped
[notice] Application mochiweb exited: :stopped
[notice] Application syntax_tools exited: :stopped
[notice] Application xmerl exited: :stopped
[notice] Application argon2_elixir exited: :stopped
[notice] Application comeonin exited: :stopped
[notice] Application plug_cowboy exited: :stopped
[notice] Application cowboy exited: :stopped
[notice] Application ranch exited: :stopped
[notice] Application cowlib exited: :stopped
[notice] Application jason exited: :stopped
[notice] Application phoenix_live_reload exited: :stopped
[notice] Application file_system exited: :stopped
[notice] Application phoenix_html exited: :stopped
[notice] Application phoenix_ecto exited: :stopped
[notice] Application runtime_tools exited: :stopped
** (Mix) Could not start application app: App.Application.start(:normal, []) returned an error: shutdown: failed to start child: AppWeb.Endpoint
    ** (EXIT) shutdown: failed to start child: Phoenix.PubSub.PG2
        ** (EXIT) shutdown: failed to start child: Phoenix.PubSub.PG2Server
            ** (EXIT) an exception was raised:
                ** (UndefinedFunctionError) function :pg2.create/1 is undefined or private
                    (kernel 8.5.3) :pg2.create({:phx, App.PubSub})
                    (phoenix_pubsub 1.1.2) lib/phoenix/pubsub/pg2_server.ex:43: Phoenix.PubSub.PG2Server.init/1
                    (stdlib 4.2) gen_server.erl:851: :gen_server.init_it/2
                    (stdlib 4.2) gen_server.erl:814: :gen_server.init_it/6
                    (stdlib 4.2) proc_lib.erl:240: :proc_lib.init_p_do_apply/3

[nelsonic]

This is going to require way too much effort to update.

Deleted the postgres instance and shut down the dyno. RIP Heroku. 💀

[nelsonic]

I've poured enough time into attempting to revive this project ... ⏳

Just going to cut my losses and move on!

[nelsonic]

Even if we wanted to use Heroku ... we would be forced to upgrade the stack in a few months:

The Heroku-18 stack is deprecated
This app is using the Heroku-18 stack, which is deprecated. 
From April 30th, 2023, Heroku-18 will be end-of-life 
and no longer receive security updates. 
From May 1st, 2023, builds will be disabled. 
Please upgrade your app to a newer Heroku stack. 
[ Visit here to learn more](https://help.heroku.com/X5OE6BCA/heroku-18-end-of-life-faq)

That would mean updating the email app to use latest Elixir
and then all the warnings noted above #61 (comment) ⬆️
would be a consistent source of pain.

So the only option would be to manually upgrade the App to Phoenix 1.6.X which is already out-of-date. ⏳