sqlcrush icon indicating copy to clipboard operation
sqlcrush copied to clipboard

Postgresql password not passed to database from .sqlcrush/saved_databases

Open athompso opened this issue 6 years ago • 0 comments

I haven't been able to make sqlcrush connect to my Postgresql database at all using command-line arguments, so I manually created an entry in ~/.sqlcrush/saved_databases, like so:

bgpdata postgresql:///bgpdata:bgpdata/bgpdata

(No, it's not a highly secure database but Postgresql is only accessible via localhost using UNIX-domain sockets.) After editing /usr/local/bin/sqlcrush to dump the exception stack on failure, now when I run sqlcrush -o bgpdata I get the dreaded CRITICAL FAILURE message, but the root-cause exception is

psycopg2.OperationalError: fe_sendauth: no password supplied

which is clearly not the case in my saved_databases entry.

athompso avatar Feb 21 '19 23:02 athompso