Native deployment: where to find postgres' password?

[Sakrecoer]

The latest release v3.4.0 suggest an operation on the postgres and offers a nice bash string to proceed with it. However, the string requires one to know the postgres password. Since the native deployment instruction do not give the opportunity to set it, i am wondering where i can find it. I'm unable to locate to configuration file for AudioMuse-Ai in my system.

[NeptuneHub]

You don't need to search for a config file. When you install natively without setting anything, AudioMuse-AI falls back to hardcoded defaults in config.py:

User: audiomuse
Password: audiomusepassword
Database: audiomusedb
Host: localhost

So if you never changed it, the password is simply audiomusepassword. Just paste that into the bash command from the release notes.

[Sakrecoer]

wonderful! Thank you for your prompt and efficient answer!

[github-actions[bot]]

Your discussion has its answer now - thanks for having starred AudioMuse-AI and supporting self-hosted music here on GitHub! It really helps the project grow!

[Sakrecoer]

@NeptuneHub i was probably a bit quick on closing this, that did not work. And i'm pretty sure i haven't changed the passwoed

~$ PGPASSWORD=audiomusepassword psql -h 127.0.0.1 -p 5432 -U audiomuse -d audiomusedb -c "UPDATE score SET tempo = NULL, energy = NULL, key = NULL, scale = NULL;"
psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL:  password authentication failed for user "audiomuse"
connection to server at "127.0.0.1", port 5432 failed: FATAL:  password authentication failed for user "audiomuse"

``

[NeptuneHub]

Have you the container version or one of the native one? if native, which one?

[Sakrecoer]

Native, the debian one for x86

[NeptuneHub]

Thanks for the details, this change the things, the before procedure is mainly for container. Native app have all embedded and are not designed for an user to have direcy access to the database.

Say that for Linux Claude suggest to run the below command (that should work only on linux) meanwhile the AudioMuse-AI is up:

psql -h ~/.local/share/AudioMuse-AI/pgdata -U postgres -d postgres \
  -c "UPDATE score SET tempo = NULL, energy = NULL, key = NULL, scale = NULL;"

Basically you're connecting to a folder, and there shouldn't be a password. But I don't have any way to test at the moment and confirm that is correct or not. If it doesnt work, the only other alternative is to cancell all the app data from this folder:

~/.local/share/AudioMuse-AI

And then do a fresh analysis from scratch.

EDIT: if someone else read this should be the qeuivalent command for MacOS:

psql -h ~/Library/AudioMuse-AI/pgdata -U postgres -d postgres \
  -c "UPDATE score SET tempo = NULL, energy = NULL, key = NULL, scale = NULL;"

and this for Windows

$env:PGPASSWORD = Get-Content "$env:LOCALAPPDATA\AudioMuse-AI\secrets\pg_password"
psql -h 127.0.0.1 -p 5432 -U postgres -d postgres `
  -c "UPDATE score SET tempo = NULL, energy = NULL, key = NULL, scale = NULL;"

[Sakrecoer]

psql -h ~/.local/share/AudioMuse-AI/pgdata -U postgres -d postgres   -c "UPDATE score SET tempo = NULL, energy = NULL, key = NULL, scale = NULL;"
UPDATE 58155

It seems to run, but at the end of the command, the dashboard is still showing moods and tempo... i'll run a new analysis and see what happens :) Many thanks for your help!

[NeptuneHub]

Dashboard don’t generate data “online” but batched. So it’s not a problem at all.
If the command worked, now just run a new analysis and you will see reworking all the song to get the missing data.

[Sakrecoer]

@NeptuneHub

AudioMuse-AI falls back to hardcoded defaults in config.py:

User: audiomuse
Password: audiomusepassword
Database: audiomusedb
Host: localhost

I find one config.py file on my system related to AudioMuse-AI but it contains none of those values...

[github-actions[bot]]

Your discussion has its answer now - thanks for having starred AudioMuse-AI and supporting self-hosted music here on GitHub! It really helps the project grow!