PSQL running in Docker

[76creates]

Hey all, just started using sqlboiler and run uppon an issue.
OS: MacOS
PSQL: 13.1

I run PSQL in Docker and publish 5432 port, I am able to connect to it with psql --user=foo --password --host=127.0.0.1 --db=foo from the host machine, same config is within sqlboiler.toml. When I turn on the debug mode I can see that variables loaded up correctly.
When I run sqlboiler psql -d from the host machine I get following output:

using driver: /Users/gliga/go/bin/sqlboiler-psql
unable to get table names: pq: password authentication failed for user "foo"
{"config":{"driver_name":"psql","driver_config":{"blacklist":["schema_migrations"],"dbname":"foo","host":"127.0.0.1","password":"foo","port":5432,"schema":"public","sslmode":"disable","user":"foo","whitelist":null},"pkg_name":"models","out_folder":"my_models","debug":true,"no_tests":true,"struct_tag_casing":"snake","relation_tag":"-","imports":{"all":{"Standard":["\"database/sql\"","\"fmt\"","\"reflect\"","\"strings\"","\"sync\"","\"time\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/sqlboiler/v4/queries/qm\"","\"github.com/volatiletech/sqlboiler/v4/queries/qmhelper\"","\"github.com/volatiletech/strmangle\""]},"test":{"Standard":["\"bytes\"","\"reflect\"","\"testing\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/randomize\"","\"github.com/volatiletech/strmangle\""]},"singleton":{"boil_queries":{"Standard":null,"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/drivers\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/sqlboiler/v4/queries/qm\""]},"boil_types":{"Standard":["\"strconv\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/strmangle\""]}},"test_singleton":{"boil_main_test":{"Standard":["\"database/sql\"","\"flag\"","\"fmt\"","\"math/rand\"","\"os\"","\"path/filepath\"","\"strings\"","\"testing\"","\"time\""],"ThirdParty":["\"github.com/spf13/viper\"","\"github.com/volatiletech/sqlboiler/v4/boil\""]},"boil_queries_test":{"Standard":["\"bytes\"","\"fmt\"","\"io\"","\"io/ioutil\"","\"math/rand\"","\"regexp\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/boil\""]},"boil_suites_test":{"Standard":["\"testing\""],"ThirdParty":null}}},"aliases":{},"version":"4.4.0"},"driver_config":{"blacklist":["schema_migrations"],"dbname":"foo","host":"127.0.0.1","password":"foo","port":5432,"schema":"public","sslmode":"disable","user":"foo","whitelist":null},"schema":"","dialect":{"lq":0,"rq":0,"use_index_placeholders":false,"use_last_insert_id":false,"use_schema":false,"use_default_keyword":false,"use_auto_columns":false,"use_top_clause":false,"use_output_clause":false,"use_case_when_exists_clause":false},"tables":null,"templates":null}
Error: exit status 1
driver (/Users/gliga/go/bin/sqlboiler-psql) exited non-zero
github.com/volatiletech/sqlboiler/v4/drivers.execute
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/drivers/binary_driver.go:73
github.com/volatiletech/sqlboiler/v4/drivers.binaryDriver.Assemble
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/drivers/binary_driver.go:21
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).initDBInfo
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/boilingcore/boilingcore.go:382
github.com/volatiletech/sqlboiler/v4/boilingcore.New
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/boilingcore/boilingcore.go:93
main.preRun
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:215
github.com/spf13/cobra.(*Command).execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:839
github.com/spf13/cobra.(*Command).ExecuteC
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:958
github.com/spf13/cobra.(*Command).Execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:895
main.main
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:122
runtime.main
	/Users/gliga/sdk/go1.14.14/src/runtime/proc.go:203
runtime.goexit
	/Users/gliga/sdk/go1.14.14/src/runtime/asm_amd64.s:1373
unable to fetch table data
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).initDBInfo
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/boilingcore/boilingcore.go:384
github.com/volatiletech/sqlboiler/v4/boilingcore.New
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/boilingcore/boilingcore.go:93
main.preRun
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:215
github.com/spf13/cobra.(*Command).execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:839
github.com/spf13/cobra.(*Command).ExecuteC
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:958
github.com/spf13/cobra.(*Command).Execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:895
main.main
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:122
runtime.main
	/Users/gliga/sdk/go1.14.14/src/runtime/proc.go:203
runtime.goexit
	/Users/gliga/sdk/go1.14.14/src/runtime/asm_amd64.s:1373
unable to initialize tables
github.com/volatiletech/sqlboiler/v4/boilingcore.New
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/boilingcore/boilingcore.go:95
main.preRun
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:215
github.com/spf13/cobra.(*Command).execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:839
github.com/spf13/cobra.(*Command).ExecuteC
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:958
github.com/spf13/cobra.(*Command).Execute
	/Users/gliga/go/pkg/mod/github.com/spf13/cobra@v1.1.1/command.go:895
main.main
	/Users/gliga/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.4.0/main.go:122
runtime.main
	/Users/gliga/sdk/go1.14.14/src/runtime/proc.go:203
runtime.goexit
	/Users/gliga/sdk/go1.14.14/src/runtime/asm_amd64.s:1373

There are some demo tables in the DB, all is accessable, any assistance would be appreciated! ty :)

[aarondl]

Not sure what's going on here and without access to the machine itself etc not sure how to go about dealing with it. You could output some details about what's given to the STDIN of the sqlboiler-psql driver yourself.

Definitely ensure everything's the right version (master branch v4). Downloading and installing Go binaries has become... complicated. Go 1.16 will finally clean this up.

[76creates]

Ok, pasting full info/test here, hope it can be reproduced, Im on a Mac, just a remark due to how Docker works on it.

[ gliga@7six > /Users/gliga/go/src/<redacted> ][ 2.05 | 2.14 | 2.21 ]
 > docker run -d -p 5432:5432 -e "POSTGRES_PASSWORD=foo" -e "POSTGRES_USER=foo" -e "POSTGRES_DB=foo"  postgres:13.1
81d5f1b82f37a1a75e783508db148a8f0f4318207f876a68bffe4b9c402a0ea5

[ gliga@7six > /Users/gliga/go/src/<redacted> ][ 1.97 | 2.11 | 2.20 ]
 > psql --host=127.0.0.1 --user=foo --password foo # will enter foo as a password as well
Password:
psql (13.1)
Type "help" for help.

foo=# create table bar(id int);
CREATE TABLE
foo=# \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | bar  | table | foo
(1 row)

foo=#
\q

[ gliga@7six > /Users/gliga/go/src/<redacted> ][ 1.53 | 1.95 | 2.13 ]
 > cat sqlboiler.toml
[psql]
dbname = "foo"
host = "127.0.0.1"
port = 5432
user = "foo"
password = "foo"
sslmode = "disable"
schema = "public"

[ gliga@7six > /Users/gliga/go/src/<redacted> ][ 2.03 | 2.01 | 2.14 ]
 > sqlboiler psql -c sqlboiler.toml
unable to get table names: pq: password authentication failed for user "foo"
Error: unable to initialize tables: unable to fetch table data: driver (/Users/gliga/go/bin/sqlboiler-psql) exited non-zero: exit status 1

[ gliga@7six > /Users/gliga/go/src/<redacted> ][ 2.05 | 2.01 | 2.14 ]
 > sqlboiler psql --version
SQLBoiler v4.4.0

excluded -d flag to save some space, it produces same output as pasted above

[aarondl]

The key is pass not password. Make sure you're reading the documentation, that's right in README.md

[76creates]

damn this is outright embarrassing, checked everything multiple times, missed id somehow 🤦
ty for the sanity check 🙇