[Just a template for homechart]

 

Homechart is a productivity application to manage your household data--budgets, tasks, recipes, and more. Homechart can run in your browser or on your Android and iOS devices via an app.

 

Template: https://github.com/W3LFARe/unraid_templates/edit/main/homechart/homechart..xml

Source container: https://github.com/candiddev/homechart

Registry: https://github.com/candiddev/homechart

Trying to trial this and possibly move away from Grocy.

New docker and new Postgres docker but doesn't launch.

error performing PostgreSQL action

error migrating database

Having some major trouble with Homechart self-hosted and cannot find support anywhere.

 

My biggest issue atm is I cannot get my instance to send outbound emails .. thus I cannot invite anyone into the household. There’s no way to manually setup their account, and no verification emails are being sent. My Unraid docker settings have the SMTP variables added to them, as follows:

 

I have also tried setting port to SSL & TLS (465 and 587), neither works. The containers log screen shows no SMTP errors whatsoever, as follows:

 

Forgot to mention .. yes, I did set an app password on my gmail account for Homechart .. and have copied that password to my HOMECHART_SMTP_password docker container variable.

 

Anyone have any ideas?

Edited November 20, 20232 yr by Timski
Added gmail app password detail

7 hours ago, Timski said:

Having some major trouble with Homechart self-hosted and cannot find support anywhere.

 

My biggest issue atm is I cannot get my instance to send outbound emails .. thus I cannot invite anyone into the household. There’s no way to manually setup their account, and no verification emails are being sent. My Unraid docker settings have the SMTP variables added to them, as follows:

 

I have also tried setting port to SSL & TLS (465 and 587), neither works. The containers log screen shows no SMTP errors whatsoever, as follows:

 

Forgot to mention .. yes, I did set an app password on my gmail account for Homechart .. and have copied that password to my HOMECHART_SMTP_password docker container variable.

 

Anyone have any ideas?

 

Gotta say, @thequailman (owner of the candiddev/homechart repo) is awesome .. solved my issue straight up, a hole-in-1 on a par 4 with a blowing gale

 

The answer is ... the SMTP variables should be in camelCase format e.g. HOMECHART_smtp_fromAddress and NOT HOMECHART_SMTP_fromAddress or HOMECHART_SMTP_FROMADDRESS, as per the help. Oh and only use gmail port 587 (TLS) ... port 465 (SSL) does not work (in my experience) for Homechart notifications.

 

You're a legend Mike, thank you

I couldn't even get the dockers to start.

Seems template is abandoned?

No matter the variable for HOMECHART_POSTGRESQL_HOSTNAME, nothing changes the dial tcp ip

 

Quote

level="ERROR" function="postgresql/postgresql.go:64" status=500 success=false traceID="b4d7df1d6afe9bd61b8b2f7a1a63a959" error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="models/models.go:818" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="go/setup.go:47" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="postgresql/postgresql.go:64" status=500 success=false traceID="13901e6796b2236cc01ef064590880ec" error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="models/models.go:818" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="go/setup.go:47" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="postgresql/postgresql.go:64" status=500 success=false traceID="de8b56f8acbdc328159205623f4e7de7" error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="models/models.go:818" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"
level="ERROR" function="go/setup.go:47" status=500 success=false error="error connecting to PostgreSQL: dial tcp 127.0.0.1:5432: connect: connection refused"

 

On 4/27/2024 at 5:34 PM, TR1GGA187 said:

No matter the variable for HOMECHART_POSTGRESQL_HOSTNAME, nothing changes the dial tcp ip

 

 

Found a "fix" from github for the project. The case requirements changed so that everything after HOMECHART_ must be lower case. More details here Config | Homechart

You should have:

HOMECHART_postgresql_hostname
HOMECHART_postgresql_password
HOMECHART_postgresql_username
HOMECHART_postgresql_port
HOMECHART_postgresql_database

 

Also, I had to make a couple of commands on the database due to changes in postgresql 15 (more detail here https://stackoverflow.com/a/74111630)

GRANT ALL ON DATABASE homechart TO homechart;
ALTER DATABASE homechart OWNER TO homechart;

 

After that my instance started correctly

@boltojamthank you the lower case worked.

Also, you can't use Postgres 12.5 had to change to 15 and didn't need the commands specified.

Works with Authentik out of the box.

Should be mentioned you have to pay for 50% of the features advertised and has been abandoned. Avoid!

On 6/12/2024 at 7:39 AM, ados said:

Should be mentioned you have to pay for 50% of the features advertised and has been abandoned. Avoid!

 

Latest is here Package homechart · GitHub via ghcr.io/candiddev/homechart:main

That appears to be getting updates even 3 days ago.

 

What you get by paying is very unclear to me. I got it up and running without paying.

trying for the last few hours to get this running and keep running into 

ERROR Error performing database action: pq: password authentication failed for user "homechart"

 

double, triple checked passwords

env | grep POSTGRES
POSTGRES_PASSWORD=homechart
POSTGRES_USER=homechart
POSTGRES_DB=#########