Ran into a random issue on install of Akkoma

RedAndFoxy commented

2022-11-05 16:07:33 +00:00

root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix phx.server

16:03:10.444 [error] The following migrations were not applied:
- add_default_text_search_config (20210121080964)
- add_last_active_at_to_users (20210122151424)
- remove_duplicates_from_activity_expiration_queue (20210128092834)
- add_pinned_objects_to_users (20210202110641)
- add_featured_address_to_users (20210203141144)
- move_pinned_activities_into_pinned_objects (20210205145000)
- remove_pinned_activities_from_users (20210206045221)
- add_disclose_client_to_users (20210218223811)
- remove_hashtags_objects_duplicate_index (20210222183840)
- change_hashtags_name_to_text (20210222184616)
- user_notification_settings_fix (20210401143153)
- delete_hashtags_objects_cascade (20210420204354)
- add_poll_to_notifications_enum (20210717000000)
- add_user_id_to_apps (20210818023112)
- create_user_notes (20211121000000)
- force_pinned_objects_to_exist (20211125110126)
- add_suggestions (20211126191138)
- add_last_status_at_to_users (20211222165256)
- add_is_discoverable_index_to_users (20211225154802)
- user_relationships_target_id_relationship_type_index (20211229075801)
- add_mastofe_settings (20220108213213)
- add_language_to_users (20220302013920)
- create_announcements (20220308012601)
- add_index_hotspots (20220506175506)
- change_thread_visibility_to_be_local_only_aware (20220509180452)
- add_update_to_notifications_enum (20220605185734)
- upgrade_oban_to_v11 (20220718102634)
- remove_remote_cancelled_follow_requests (20220805123645)
- remove_local_cancelled_follows (20220831170605)
- generate_unset_user_keys (20220905011454)
- add_user_frontend_profiles (20220911195347)
- ensure_mastofe_settings (20220916115149)
If you want to start Pleroma anyway, set
config :pleroma, :i_am_aware_this_may_cause_data_loss, disable_migration_check: true

16:03:10.451 [info] Application pleroma exited: exited in: Pleroma.Application.start(:normal, [])
    ** (EXIT) an exception was raised:
        ** (Pleroma.ApplicationRequirements.VerifyError) Unapplied Migrations detected
            (pleroma 3.3.1-65-gccdf55ac-develop) lib/pleroma/application_requirements.ex:32: Pleroma.ApplicationRequirements.handle_result/1
            (pleroma 3.3.1-65-gccdf55ac-develop) lib/pleroma/application.ex:55: Pleroma.Application.start/2
            (kernel 8.2) application_master.erl:293: :application_master.start_it_old/4
[os_mon] memory supervisor port (memsup): Erlang has closed
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
{"Kernel pid terminated",application_controller,"{application_start_failure,pleroma,{bad_return,{{'Elixir.Pleroma.Application',start,[normal,[]]},{'EXIT',{#{'__exception__' => true,'__struct__' => 'Elixir.Pleroma.ApplicationRequirements.VerifyError',message => <<\"Unapplied Migrations detected\">>},[{'Elixir.Pleroma.ApplicationRequirements',handle_result,1,[{file,\"lib/pleroma/application_requirements.ex\"},{line,32}]},{'Elixir.Pleroma.Application',start,2,[{file,\"lib/pleroma/application.ex\"},{line,55}]},{application_master,start_it_old,4,[{file,\"application_master.erl\"},{line,293}]}]}}}}}"}
Kernel pid terminated (application_controller) ({application_start_failure,pleroma,{bad_return,{{'Elixir.Pleroma.Application',start,[normal,[]]},{'EXIT',{#{'__exception__' => true,'__struct__' => 'Elixir.Pleroma.ApplicationRequirements.VerifyError',message => <<"Unapplied Migrations detected">>},[{'Elixir.Pleroma.ApplicationRequirements',handle_result,1,[{file,"lib/pleroma/application_requirements.ex"},{line,32}]},{'Elixir.Pleroma.Application',start,2,[{file,"lib/pleroma/application.ex"},{line,55}]},{application_master,start_it_old,4,[{file,"application_master.erl"},{line,293}]}]}}}}})

Crash dump is being written to: erl_crash.dump...done

not sure how to go about fixing this

``` root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix phx.server 16:03:10.444 [error] The following migrations were not applied: - add_default_text_search_config (20210121080964) - add_last_active_at_to_users (20210122151424) - remove_duplicates_from_activity_expiration_queue (20210128092834) - add_pinned_objects_to_users (20210202110641) - add_featured_address_to_users (20210203141144) - move_pinned_activities_into_pinned_objects (20210205145000) - remove_pinned_activities_from_users (20210206045221) - add_disclose_client_to_users (20210218223811) - remove_hashtags_objects_duplicate_index (20210222183840) - change_hashtags_name_to_text (20210222184616) - user_notification_settings_fix (20210401143153) - delete_hashtags_objects_cascade (20210420204354) - add_poll_to_notifications_enum (20210717000000) - add_user_id_to_apps (20210818023112) - create_user_notes (20211121000000) - force_pinned_objects_to_exist (20211125110126) - add_suggestions (20211126191138) - add_last_status_at_to_users (20211222165256) - add_is_discoverable_index_to_users (20211225154802) - user_relationships_target_id_relationship_type_index (20211229075801) - add_mastofe_settings (20220108213213) - add_language_to_users (20220302013920) - create_announcements (20220308012601) - add_index_hotspots (20220506175506) - change_thread_visibility_to_be_local_only_aware (20220509180452) - add_update_to_notifications_enum (20220605185734) - upgrade_oban_to_v11 (20220718102634) - remove_remote_cancelled_follow_requests (20220805123645) - remove_local_cancelled_follows (20220831170605) - generate_unset_user_keys (20220905011454) - add_user_frontend_profiles (20220911195347) - ensure_mastofe_settings (20220916115149) If you want to start Pleroma anyway, set config :pleroma, :i_am_aware_this_may_cause_data_loss, disable_migration_check: true 16:03:10.451 [info] Application pleroma exited: exited in: Pleroma.Application.start(:normal, []) ** (EXIT) an exception was raised: ** (Pleroma.ApplicationRequirements.VerifyError) Unapplied Migrations detected (pleroma 3.3.1-65-gccdf55ac-develop) lib/pleroma/application_requirements.ex:32: Pleroma.ApplicationRequirements.handle_result/1 (pleroma 3.3.1-65-gccdf55ac-develop) lib/pleroma/application.ex:55: Pleroma.Application.start/2 (kernel 8.2) application_master.erl:293: :application_master.start_it_old/4 [os_mon] memory supervisor port (memsup): Erlang has closed [os_mon] cpu supervisor port (cpu_sup): Erlang has closed {"Kernel pid terminated",application_controller,"{application_start_failure,pleroma,{bad_return,{{'Elixir.Pleroma.Application',start,[normal,[]]},{'EXIT',{#{'__exception__' => true,'__struct__' => 'Elixir.Pleroma.ApplicationRequirements.VerifyError',message => <<\"Unapplied Migrations detected\">>},[{'Elixir.Pleroma.ApplicationRequirements',handle_result,1,[{file,\"lib/pleroma/application_requirements.ex\"},{line,32}]},{'Elixir.Pleroma.Application',start,2,[{file,\"lib/pleroma/application.ex\"},{line,55}]},{application_master,start_it_old,4,[{file,\"application_master.erl\"},{line,293}]}]}}}}}"} Kernel pid terminated (application_controller) ({application_start_failure,pleroma,{bad_return,{{'Elixir.Pleroma.Application',start,[normal,[]]},{'EXIT',{#{'__exception__' => true,'__struct__' => 'Elixir.Pleroma.ApplicationRequirements.VerifyError',message => <<"Unapplied Migrations detected">>},[{'Elixir.Pleroma.ApplicationRequirements',handle_result,1,[{file,"lib/pleroma/application_requirements.ex"},{line,32}]},{'Elixir.Pleroma.Application',start,2,[{file,"lib/pleroma/application.ex"},{line,55}]},{application_master,start_it_old,4,[{file,"application_master.erl"},{line,293}]}]}}}}}) Crash dump is being written to: erl_crash.dump...done ``` not sure how to go about fixing this

floatingghost commented

2022-11-05 16:24:16 +00:00

Owner

you need to run ecto.migrate

MIX_ENV=prod mix ecto.migrate

you need to run ecto.migrate `MIX_ENV=prod mix ecto.migrate`

RedAndFoxy commented

2022-11-05 16:46:42 +00:00

Author

i did and another error has popped up

16:39:04.517 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method.
Generated pleroma app

16:39:15.091 [error] GenServer #PID<0.4535.0> terminating
** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"
    (db_connection 2.4.2) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
    (connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
    (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol

16:39:15.143 [error] GenServer #PID<0.4542.0> terminating
** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"
    (db_connection 2.4.2) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2
    (connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5
    (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3
Last message: nil
State: Postgrex.Protocol
** (Mix) The database for Pleroma.Repo couldn't be created: killed

i did and another error has popped up ``` 16:39:04.517 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 16:39:04.544 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method. Generated pleroma app 16:39:15.091 [error] GenServer #PID<0.4535.0> terminating ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" (db_connection 2.4.2) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2 (connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5 (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3 Last message: nil State: Postgrex.Protocol 16:39:15.143 [error] GenServer #PID<0.4542.0> terminating ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" (db_connection 2.4.2) lib/db_connection/connection.ex:100: DBConnection.Connection.connect/2 (connection 1.1.0) lib/connection.ex:622: Connection.enter_connect/5 (stdlib 3.17) proc_lib.erl:226: :proc_lib.init_p_do_apply/3 Last message: nil State: Postgrex.Protocol ** (Mix) The database for Pleroma.Repo couldn't be created: killed ```

floatingghost commented

2022-11-05 16:57:01 +00:00

Owner

that one should be self-explanatory

your password is incorrect

make sure you're following the install documentation

that one should be self-explanatory your password is incorrect make sure you're following the install documentation

RedAndFoxy commented

2022-11-05 17:04:01 +00:00

Author

i followed it all to the T and got to this point, how could the password be incorrect am i supposed to add a password to the migrate command

floatingghost commented

2022-11-05 17:10:59 +00:00

Owner

you remember that part where the install docs told you to copy the config you created to prod.secret.exs?

exactly 1 step before it told you to run the migration command?

check there

you remember that part where the install docs told you to copy the config you created to prod.secret.exs? exactly 1 step before it told you to run the migration command? check there

RedAndFoxy commented

2022-11-05 17:12:56 +00:00

Author

as i said before i ran all these commands...

floatingghost commented

2022-11-05 17:16:02 +00:00

Owner

then check the config file you created

check it's correct

then _check the config file you created_ check it's correct

RedAndFoxy commented

2022-11-05 17:26:43 +00:00

Author

i see no issues

floatingghost commented

2022-11-05 17:30:08 +00:00

Owner

please follow the installation instructions from hereon out

either you did not run the command to set up your database, or your credentials are incorrect

please follow the installation instructions from hereon out either you did not run the command to set up your database, or your credentials are incorrect

floatingghost closed this issue

2022-11-05 17:30:08 +00:00

RedAndFoxy commented

2022-11-05 17:39:26 +00:00

Author

both are fine and i followed everything to the T, via the guide @ https://docs.akkoma.dev/stable/installation/debian_based_en/ i'm running Ubuntu on arm so a lot of fun stuff messes up.

floatingghost commented

2022-11-05 17:41:32 +00:00

Owner

so you can connect to the database with psql -U FoxyAkkoma <dbname> and the password you provide?

that will almost certainly fail

so you can connect to the database with `psql -U FoxyAkkoma <dbname>` and the password you provide? that will almost certainly fail

RedAndFoxy commented

2022-11-05 17:45:31 +00:00

Author

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "FoxyAkkoma"

is what happens when i try, and heres my pg_hba.conf

local   all             postgres                                peer

#### TYPE  DATABASE        USER            ADDRESS                 METHOD
#### 
### "local" is for Unix domain socket connections only
local   all             all                                     peer
### IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
### IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
### Allow replication connections from localhost, by a user with the
### replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

``` psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "FoxyAkkoma" ``` is what happens when i try, and heres my pg_hba.conf ``` local all postgres peer #### TYPE DATABASE USER ADDRESS METHOD #### ### "local" is for Unix domain socket connections only local all all peer ### IPv4 local connections: host all all 127.0.0.1/32 scram-sha-256 ### IPv6 local connections: host all all ::1/128 scram-sha-256 ### Allow replication connections from localhost, by a user with the ### replication privilege. local replication all peer host replication all 127.0.0.1/32 scram-sha-256 host replication all ::1/128 scram-sha-256 ```

floatingghost commented

2022-11-05 17:48:38 +00:00

Owner

check your password

it is incorrect

update it with the superuser if you must

check your password it is incorrect update it with the superuser if you must

RedAndFoxy commented

2022-11-05 17:52:31 +00:00

Author

where would that be located to change it (it'll be where-ever the following the guide placed it on deb. But i have no clue where to look other than generated_config.exs,prod.secret.exs)

floatingghost commented

2022-11-05 17:55:18 +00:00

Owner

it's your database user

https://www.postgresqltutorial.com/postgresql-administration/postgresql-change-password/

it's your database user https://www.postgresqltutorial.com/postgresql-administration/postgresql-change-password/

RedAndFoxy commented

2022-11-05 18:03:24 +00:00

Author

after running psql \du

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

quite the predicament

after running psql \du `psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist` quite the predicament

floatingghost commented

2022-11-05 18:04:38 +00:00

Owner

use the postgres superuser

you know, postgres?

sudo -Hu postgres psql

use the postgres superuser you know, `postgres`? sudo -Hu postgres psql

floatingghost commented

2022-11-05 18:05:58 +00:00

Owner

psql*

RedAndFoxy commented

2022-11-05 18:07:18 +00:00

Author

root@gameserver:/opt/akkoma# sudo -Hu psql psw
sudo: unknown user psql
sudo: error initializing audit plugin sudoers_audit

``` root@gameserver:/opt/akkoma# sudo -Hu psql psw sudo: unknown user psql sudo: error initializing audit plugin sudoers_audit ```

floatingghost commented

2022-11-05 18:11:17 +00:00

Owner

user is postgres
command is psql

sudo -Hu postgres psql

user is postgres command is psql sudo -Hu postgres psql

RedAndFoxy commented

2022-11-05 18:17:49 +00:00

Author

interesting we're now further along

root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix ecto.migrate
Compiling 587 files (.ex)
Compiling lib/pleroma/web/gettext.ex (it's taking more than 10s)

18:16:37.282 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method.
Generated pleroma app

18:16:48.696 [info]  == Running 20210121080964 Pleroma.Repo.Migrations.AddDefaultTextSearchConfig.change/0 forward

18:16:48.696 [info]  execute "DO $$\n    BEGIN\n    execute 'ALTER DATABASE \"'||current_database()||'\" SET default_text_search_config = ''english'' ';\n    END\n    $$;"
** (Postgrex.Error) ERROR 42501 (insufficient_privilege) must be owner of database akkoma
    (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:905: Ecto.Adapters.SQL.raise_sql_call_error/1
    (elixir 1.12.2) lib/enum.ex:1582: Enum."-map/2-lists^map/1-0-"/2
    (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:997: Ecto.Adapters.SQL.execute_ddl/4
    (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:326: Ecto.Migration.Runner.log_and_execute_ddl/3
    (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:117: anonymous fn/6 in Ecto.Migration.Runner.flush/0
    (elixir 1.12.2) lib/enum.ex:2385: Enum."-reduce/3-lists^foldl/2-0-"/3
    (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:116: Ecto.Migration.Runner.flush/0
    (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:289: Ecto.Migration.Runner.perform_operation/3

interesting we're now further along ``` root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix ecto.migrate Compiling 587 files (.ex) Compiling lib/pleroma/web/gettext.ex (it's taking more than 10s) 18:16:37.282 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:16:37.307 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method. Generated pleroma app 18:16:48.696 [info] == Running 20210121080964 Pleroma.Repo.Migrations.AddDefaultTextSearchConfig.change/0 forward 18:16:48.696 [info] execute "DO $$\n BEGIN\n execute 'ALTER DATABASE \"'||current_database()||'\" SET default_text_search_config = ''english'' ';\n END\n $$;" ** (Postgrex.Error) ERROR 42501 (insufficient_privilege) must be owner of database akkoma (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:905: Ecto.Adapters.SQL.raise_sql_call_error/1 (elixir 1.12.2) lib/enum.ex:1582: Enum."-map/2-lists^map/1-0-"/2 (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:997: Ecto.Adapters.SQL.execute_ddl/4 (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:326: Ecto.Migration.Runner.log_and_execute_ddl/3 (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:117: anonymous fn/6 in Ecto.Migration.Runner.flush/0 (elixir 1.12.2) lib/enum.ex:2385: Enum."-reduce/3-lists^foldl/2-0-"/3 (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:116: Ecto.Migration.Runner.flush/0 (ecto_sql 3.9.0) lib/ecto/migration/runner.ex:289: Ecto.Migration.Runner.perform_operation/3 ```

floatingghost commented

2022-11-05 18:19:47 +00:00

Owner

that error is self-explanatory
your user does not own the database
honestly just recreate it as this point

sudo -Hu postgres psql
drop database akkoma; create database akkoma with owner FoxyAkkoma

that error is self-explanatory your user does not own the database honestly just recreate it as this point `sudo -Hu postgres psql ` `drop database akkoma; create database akkoma with owner FoxyAkkoma `

RedAndFoxy commented

2022-11-05 18:36:38 +00:00

Author

i fully uninstalled everything to try again fully removed all users and packages, reinstalled and followed the step by step, i even went and made sure on creation of the db that the main users password was done properly. and we're right back to ...

root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix ecto.migrate
Compiling 587 files (.ex)
Compiling lib/pleroma/web/gettext.ex (it's taking more than 10s)

18:33:03.717 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method.

18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method.
Generated pleroma app

18:33:14.258 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:14.258 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:15.840 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:16.406 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:18.016 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:20.058 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:20.569 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:25.216 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:25.296 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:30.024 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:34.171 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:40.399 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma"

18:33:55.154 [error] Could not create schema migrations table. This error usually happens due to the following:

  * The database does not exist
  * The "schema_migrations" table, which Ecto uses for managing
    migrations, was defined by another library
  * There is a deadlock while migrating (such as using concurrent
    indexes with a migration_lock)

To fix the first issue, run "mix ecto.create".

To address the second, you can run "mix ecto.drop" followed by
"mix ecto.create". Alternatively you may configure Ecto to use
another table and/or repository for managing migrations:

    config :pleroma, Pleroma.Repo,
      migration_source: "some_other_table_for_schema_migrations",
      migration_repo: AnotherRepoForSchemaMigrations

The full error report is shown below.

** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 40979ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

  1. Ensuring your database is available and that you can connect to it
  2. Tracking down slow queries and making sure they are running fast enough
  3. Increasing the pool_size (although this increases resource consumption)
  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval

See DBConnection.start_link/2 for more information

    (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:905: Ecto.Adapters.SQL.raise_sql_call_error/1
    (elixir 1.12.2) lib/enum.ex:1582: Enum."-map/2-lists^map/1-0-"/2
    (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:997: Ecto.Adapters.SQL.execute_ddl/4
    (ecto_sql 3.9.0) lib/ecto/migrator.ex:672: Ecto.Migrator.verbose_schema_migration/3
    (ecto_sql 3.9.0) lib/ecto/migrator.ex:486: Ecto.Migrator.lock_for_migrations/4
    (ecto_sql 3.9.0) lib/ecto/migrator.ex:398: Ecto.Migrator.run/4
    (ecto_sql 3.9.0) lib/ecto/migrator.ex:146: Ecto.Migrator.with_repo/3
    (pleroma 3.3.1-65-gccdf55ac-develop) lib/mix/tasks/pleroma/ecto/migrate.ex:63: Mix.Tasks.Pleroma.Ecto.Migrate.run/1

i fully uninstalled everything to try again fully removed all users and packages, reinstalled and followed the step by step, i even went and made sure on creation of the db that the main users password was done properly. and we're right back to ... ``` root@gameserver:/opt/akkoma# sudo -Hu akkoma MIX_ENV=prod mix ecto.migrate Compiling 587 files (.ex) Compiling lib/pleroma/web/gettext.ex (it's taking more than 10s) 18:33:03.717 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiFollowbotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoPlaceholderTextPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.ForceBotUnlistedPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoEmptyPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.UserAllowListPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.AntiLinkSpamPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.FollowBotPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.MediaProxyWarmingPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.DropPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.TagPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.NoOpPolicy is excluded from config descriptions, because does not implement `config_description/0` method. 18:33:03.740 [debug] Elixir.Pleroma.Web.ActivityPub.MRF.EnsureRePrepended is excluded from config descriptions, because does not implement `config_description/0` method. Generated pleroma app 18:33:14.258 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:14.258 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:15.840 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:16.406 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:18.016 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:20.058 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:20.569 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:25.216 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:25.296 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:30.024 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:34.171 [error] Postgrex.Protocol (#PID<0.4537.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:40.399 [error] Postgrex.Protocol (#PID<0.4536.0>) failed to connect: ** (Postgrex.Error) FATAL 28P01 (invalid_password) password authentication failed for user "FoxyAkkoma" 18:33:55.154 [error] Could not create schema migrations table. This error usually happens due to the following: * The database does not exist * The "schema_migrations" table, which Ecto uses for managing migrations, was defined by another library * There is a deadlock while migrating (such as using concurrent indexes with a migration_lock) To fix the first issue, run "mix ecto.create". To address the second, you can run "mix ecto.drop" followed by "mix ecto.create". Alternatively you may configure Ecto to use another table and/or repository for managing migrations: config :pleroma, Pleroma.Repo, migration_source: "some_other_table_for_schema_migrations", migration_repo: AnotherRepoForSchemaMigrations The full error report is shown below. ** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 40979ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by: 1. Ensuring your database is available and that you can connect to it 2. Tracking down slow queries and making sure they are running fast enough 3. Increasing the pool_size (although this increases resource consumption) 4. Allowing requests to wait longer by increasing :queue_target and :queue_interval See DBConnection.start_link/2 for more information (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:905: Ecto.Adapters.SQL.raise_sql_call_error/1 (elixir 1.12.2) lib/enum.ex:1582: Enum."-map/2-lists^map/1-0-"/2 (ecto_sql 3.9.0) lib/ecto/adapters/sql.ex:997: Ecto.Adapters.SQL.execute_ddl/4 (ecto_sql 3.9.0) lib/ecto/migrator.ex:672: Ecto.Migrator.verbose_schema_migration/3 (ecto_sql 3.9.0) lib/ecto/migrator.ex:486: Ecto.Migrator.lock_for_migrations/4 (ecto_sql 3.9.0) lib/ecto/migrator.ex:398: Ecto.Migrator.run/4 (ecto_sql 3.9.0) lib/ecto/migrator.ex:146: Ecto.Migrator.with_repo/3 (pleroma 3.3.1-65-gccdf55ac-develop) lib/mix/tasks/pleroma/ecto/migrate.ex:63: Mix.Tasks.Pleroma.Ecto.Migrate.run/1 ```

floatingghost commented

2022-11-05 19:05:10 +00:00

Owner

this message quite literally tells you the commands to need to fix it

RedAndFoxy commented

2022-11-05 19:20:16 +00:00

Author

tried that didnt work went about it a different way for whatever reason running create before migrating fixed my issues. that was the whole problem unsure if that is just an arm thing but. thanks!

Ran into a random issue on install of Akkoma #252