Ran into a random issue on install of Akkoma #252
Labels
No labels
approved, awaiting change
bug
configuration
documentation
duplicate
enhancement
extremely low priority
feature request
Fix it yourself
help wanted
invalid
mastodon_api
needs docs
needs tests
not a bug
planned
pleroma_api
privacy
question
static_fe
triage
wontfix
No milestone
No project
No assignees
2 participants
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference: AkkomaGang/akkoma#252
Loading…
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
not sure how to go about fixing this
you need to run ecto.migrate
MIX_ENV=prod mix ecto.migrate
i did and another error has popped up
that one should be self-explanatory
your password is incorrect
make sure you're following the install documentation
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
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
as i said before i ran all these commands...
then check the config file you created
check it's correct
i see no issues
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
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.
so you can connect to the database with
psql -U FoxyAkkoma <dbname>
and the password you provide?that will almost certainly fail
is what happens when i try, and heres my pg_hba.conf
check your password
it is incorrect
update it with the superuser if you must
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)
it's your database user
https://www.postgresqltutorial.com/postgresql-administration/postgresql-change-password/
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
use the postgres superuser
you know,
postgres
?sudo -Hu postgres psql
psql*
user is postgres
command is psql
sudo -Hu postgres psql
interesting we're now further along
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
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 ...
this message quite literally tells you the commands to need to fix it
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!