ledgersmb-admin does not recognize $HOME/.ledgersmb-admin.conf when doing the 1.12 template upgrade

[neilt]

When trying the following to upgrade 1.12 templates:

echo "connect_data:" > $HOME/.ledgersmb-admin.conf
echo "    username: postgres" >> $HOME/.ledgersmb-admin.conf
echo "    password: abc" >> $HOME/.ledgersmb-admin.conf
echo "    company: example_inc" >> $HOME/.ledgersmb-admin.conf

cat templates/demo/display_report.html | bin/ledgersmb-admin template load postgres:5432/example_inc display_report html

ledgersmb-admin fails to use $HOME/.ledgersmb-admin.conf for the connection parameters and tries to connect using the user as root.

This is in the LSMB docker install. Not dev-docker.

The error is:

root@5d2a327db6cd:/srv/ledgersmb# cat $HOME/.ledgersmb-admin.conf
connect_data:
    username: postgres
    password: abc
    company: example_inc
root@5d2a327db6cd:/srv/ledgersmb# cat templates/demo/display_report.html | bin/ledgersmb-admin template load postgres:5432/example_inc display_report html
2025/01/17 20:59:54 Could not connect to database: connection to server at "postgres" (172.18.0.2), port 5432 failed: FATAL:  password authentication failed for user "root"
Could not connect to database: connection to server at "postgres" (172.18.0.2), port 5432 failed: FATAL:  password authentication failed for user "root" at lib/LedgerSMB/Admin/Command/template.pm line 205.