Hi @Nesh,

You've reused the same volume mount for the new "fresh installation." By default, Docker containers don't persist data to your drive. To ensure data persistence, such as for the database, you need to define volumes to share a disk location from your host system with the Docker container. You can find many explanations on how this works by searching for Docker volumes (Official Docs: https://docs.docker.com/storage/volumes/).

 

The issue here is that you're not actually performing a fresh installation because the path remains the same, and there's already a PostgreSQL installation with an existing database in that host path. Your logs clearly indicate this with the message "Your PostgreSQL Database Directory appears to contain a database."

You have two options: either delete the old installation or define a different path to create a new directory for persisting your database files.

If you want to reuse the old data, migrating your database from version 12 to 14 may not be straightforward.

 

@BryanSeah, Ghostfolio supports multiple users. By default it creates a demo user and your main user. However, I'm not sure if you can add users via the GUI. If you have questions about Ghostfolio as an application (not related to the Unraid installation), the best place to ask questions or report bugs is on Github: https://github.com/ghostfolio/ghostfolio/discussions.

It should be possible to add users via the database, but be cautious and only attempt this if you are comfortable executing SQL commands on your database and understand what you are doing.

Edited September 3, 20232 yr by LeonStoldt

Hi @LeonStoldt, Thank you for getting back to me. 

 

I'm not sure if deleted my previous installations correctly. Before each reinstallation, i uninstalled, the dockers and used krusader to delete the folders for postgres, redis and ghostfolio. 

 

Can you advise if this is correct, if it is then i might have missed something out the last few times. 

Hello, after some tinkering, i seem to have everything running without any issues. 
[edit] just checked the instances today, and found that both Postgres and Ghostfolio has stopped. I started both but now my security key is no longer working (incorrect key error). 100% certain the key is correct because i tried it a few times on the day of the installation. 

 

I am now looking at backing up my Appdata in general. I have checked all the folders manually but i am unable to find a folder for Gostfolio in the appdata folder. 

 

How can i backup Ghostfolio? The app itself has an option to export the data as JSON but i do not see any option to restore. 

currently i am using Duplicati to directly backup my ebook library.
I also downloaded CA Backup with the intention of backing up my appdata and then backing that up again via Duplicati to the cloud. 

Edited November 14, 20232 yr by Nesh

For some reason, no matter the currency ticker that I put into BASE_CURRENCY (default is USD), I'm not able to have it displayed on the WebUI as it always shows USD (and not any other currency).

Has anyone faced this as well?

On 12/27/2023 at 5:03 AM, Tarnished said:

For some reason, no matter the currency ticker that I put into BASE_CURRENCY (default is USD), I'm not able to have it displayed on the WebUI as it always shows USD (and not any other currency).

Has anyone faced this as well?

 

Yeh same issue. If you go into the Admin section you can add a currency there, it'll find the exchange rate and then update it. Then you will find the added currency to all the dropdown menus.

 

 

On 1/9/2024 at 1:11 AM, Mooks said:

 

Yeh same issue. If you go into the Admin section you can add a currency there, it'll find the exchange rate and then update it. Then you will find the added currency to all the dropdown menus.

 

 

 

Thank you for the help! Sadly the Admin Control panel doesn't appear in my WebUI. How did you managed to get it?

On 1/8/2024 at 8:11 PM, Mooks said:

 

Yeh same issue. If you go into the Admin section you can add a currency there, it'll find the exchange rate and then update it. Then you will find the added currency to all the dropdown menus.

 

 

Don't know why, when I put CAD, it's says 1 USD = 1 CAD. I wish that was true...

 

edit: nevermind, had redis bug

Edited January 16, 20242 yr by Nodiaque

I am having a similar issue to what was previously discussed, my home page holdings show as $0, and market prices aren't loading for any assets. I have my base currency as CAD.  I have loaded all historical market data, and have all CAD rates. I have tried adding the TZ variable as null and it still did not correct it. Anyone have any ideas?

 

I managed to get some time to look into the issues i had earlier. 

I reinstalled everything with a new database , following your video instructions @LeonStoldt
Ok so i'm back with the same postgres error, 


I think i have the backup part sorted out now. 

Edited March 6, 20242 yr by Nesh

I keep getting errors in trying Fetching crumb and cookies from https://finance.yahoo.com/quote/AAPL?guccounter=1 when starting the container. Makes all other queries to Yahoo fail. 

Tried to insert an empty TZ variable but a "static" TZ variable is already present, so there are 2 TZ variables. Any way to prevent unraid inserting a TZ variable automatically?

On 2/13/2024 at 12:43 PM, yoshii-unraid said:

I am having a similar issue to what was previously discussed, my home page holdings show as $0, and market prices aren't loading for any assets. I have my base currency as CAD.  I have loaded all historical market data, and have all CAD rates. I have tried adding the TZ variable as null and it still did not correct it. Anyone have any ideas?

 

Someone over on github said setting the TZ variable to UTC worked for them when a blank TZ variable didn't.

Has anyone got the "Markets" tab working? Anything I add as benchmark shows up on the tab, but ghostfolio can't grab any historical data for it. Everything else seems to be working fine.

 

EDIT: I had to go into the admin panel and force "Gather Historical Data". I still don't have the current market mood or chart though.

Edited March 8, 20242 yr by JPDVM2014

i am already running a redis container for paperless-ngx , is there any issue if this container uses the same instance?

I still can't get it to work with REDIS_PASSWORD

 

[Nest] 125  - 05/05/2024, 5:41:18 PM   ERROR [RedisCacheService] ReplyError: WRONGPASS invalid username-password pair or user is disabled.
[Nest] 125  - 05/05/2024, 5:41:18 PM   ERROR [RedisCacheService] ReplyError: Ready check failed: NOAUTH Authentication required.
[Nest] 125  - 05/05/2024, 5:41:18 PM   ERROR [RedisCacheService] ReplyError: WRONGPASS invalid username-password pair or user is disabled.
[Nest] 125  - 05/05/2024, 5:41:18 PM   ERROR [RedisCacheService] ReplyError: Ready check failed: NOAUTH Authentication required.
/ghostfolio/apps/api/node_modules/redis-parser/lib/parser.js:179
    return new ReplyError(string)
           ^

ReplyError: NOAUTH Authentication required.
    at parseError (/ghostfolio/apps/api/node_modules/redis-parser/lib/parser.js:179:12)
    at parseType (/ghostfolio/apps/api/node_modules/redis-parser/lib/parser.js:302:14) {
  command: {
    name: 'client',

 

On 3/8/2024 at 9:55 AM, JPDVM2014 said:

Has anyone got the "Markets" tab working? Anything I add as benchmark shows up on the tab, but ghostfolio can't grab any historical data for it. Everything else seems to be working fine.

 

EDIT: I had to go into the admin panel and force "Gather Historical Data". I still don't have the current market mood or chart though.

Were you able to figure this out? I'm having the same issue. 

Installed from CA template, and got everything working, but having several issues.

1. From the template, It didn't install as a directory to appdata, and I can't figure out where it did install. Since it's not in appdata, it's not being backed up by CA Appdata Backup.
2. I can't seem to import my activity from Fidelity. Fidelity seems to have changed their activity page recently, and I'm not sure if they changed anything, but the CSV appears to be a different format than what's described in the docs. When I try to import via the webUI, I get "activities.0.currency is not valid". I've tried editing the fields to match the schema described in the docs, but no luck. 

Any suggestions would be appreciated.

hi. can i get some help. after first run, i get an error and i the containers stops: 

atabase error code: 25001

Database error:
ERROR: ALTER TYPE ... ADD cannot run inside a transaction block

DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E25001), message: "ALTER TYPE ... ADD cannot run inside a transaction block", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("xact.c"), line: Some(3230), routine: Some("PreventInTransactionBlock") }

 

On 1/21/2025 at 7:54 AM, Emanuel87 said:

hi. can i get some help. after first run, i get an error and i the containers stops: 

atabase error code: 25001

Database error:
ERROR: ALTER TYPE ... ADD cannot run inside a transaction block

DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E25001), message: "ALTER TYPE ... ADD cannot run inside a transaction block", detail: None, hint: None, position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("xact.c"), line: Some(3230), routine: Some("PreventInTransactionBlock") }

 

 

I'm also getting this exact error, trying to run it in postgres 11

Hi,

I'm having a weird situation where after I updated my Redis, Postgres, and Ghostfolio docker containers, the security token that was used for my instance's admin account is now no longer working, almost as if the container is behaving like it's brand new? This has been an issue in the past where I've experienced the same situation, and I was forced to reinstall the Ghostfolio docker image after the update was ran. It's never clear as to why this happens either, so I was hoping I could receive some pointers from someone who's more experienced with this Ghostfolio instance than I am.

When I check the logs, I don't see anything noteworthy. Ghostfolio loads the databases just fine and there has been no changes to the actual data to the database as far as I'm aware. I'm unsure if this is an issue that's persistent with Ghostfolio itself or if it's the docker container that tends to misbehave. All variables set in all containers are unchanged. 🤨

Has anyone else experienced this issue and has there been a solution to this problem yet?

EDIT: This ended up happening a second time and I took a rough guess that perhaps it was a persistence or stability issue on my end. I was able to restore functionality by both dumping and restoring the Postgres database, as well as building a separate Redis instance on virtual machines I built using Proxmox instead of dockerized images. Why this fixed my issue is beyond me! But unfortunately due to a couple other experiences I've had with this app, I decided it's best for me to find another solution as Ghostfolio seems to have other issues and limitations that have also been outlined by others in their Github.

As a tiny side-quest since I had access to the tables, I also tried to see if there was a way to restore the user account via access token, the user-set access token salt value, and the associated user-generated security token as a potential hack-job recovery option for situations like these, but unfortunately it doesn't look like it's possible with my current knowledge and I don't have any extra time to dedicate to finding that out. With no additional documentation and only the source code to work with, further troubleshooting of weird issues like this moving forward is difficult. However, that's a Ghostfolio issue and not a Unraid issue.

Thanks for your work to bring this app to Unraid. Hopefully others don't run into the same issue I did! Much love.

Edited February 24, 20251 yr by Skittlesthehusky
personal solution found and additional information

On 8/11/2024 at 12:58 PM, Diesel said:

Installed from CA template, and got everything working, but having several issues.

1. From the template, It didn't install as a directory to appdata, and I can't figure out where it did install. Since it's not in appdata, it's not being backed up by CA Appdata Backup.
2. I can't seem to import my activity from Fidelity. Fidelity seems to have changed their activity page recently, and I'm not sure if they changed anything, but the CSV appears to be a different format than what's described in the docs. When I try to import via the webUI, I get "activities.0.currency is not valid". I've tried editing the fields to match the schema described in the docs, but no luck. 

Any suggestions would be appreciated.

Having the same issue, has anyone found a solution. Also tried importing Vanguard data and am having the same issue.

Hi,

I only seem to get USD and USX as currency options in my account settings. I can't find anywhere else to add GBP. Can someone help me with this?

Thanks

On 1/9/2024 at 2:11 AM, Mooks said:

 

Yeh same issue. If you go into the Admin section you can add a currency there, it'll find the exchange rate and then update it. Then you will find the added currency to all the dropdown menus.

 

 

I have the same issue where I can only choose currencies USD and USX.

So, this exchange rate could be a good workaround but I don't have an exchange rate option in the admin panel.

anyone have one of the other repos installed as well to facilitate import of data? or otherwise some other way of syncing?

wondering how to do this part now that i have the container installed