fe_sendauth: no password supplied

[tjwebb]

Get this when trying to load tiles...

error: "Postgis Plugin: fe_sendauth: no password supplied host=localhost dbname=cartodb_dev_user_2_db user=development_cartodb_user_2 connect_timeout=4 encountered during parsing of layer 'nbt_offices' in Layer at line 22"

[strk]

Try adding a password:xxx line to your config/environments/development.js,
under the postgres section.

Those params should be passed verbatim to the mapnik XML generator.
See here for more info:
https://github.com/mapnik/mapnik/wiki/PostGIS

[tjwebb]

But isn't the password that of the user, and therefore changes? The username could change too.

Also, the properties in the postgres section don't at all match what's being used for authentication here, or what's in the show_styles output...

On Fri, Dec 7, 2012 at 12:49 PM, strk notifications@github.com wrote:

Try adding a password:xxx line to your config/environments/development.js,
under the postgres section.

Those params should be passed verbatim to the mapnik XML generator.
See here for more info:
https://github.com/mapnik/mapnik/wiki/PostGIS

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/61#issuecomment-11139411.

[tjwebb]

It works if I change my pg_hba.conf auth METHOD to allow "trust" connections, and it seems to work. Though now I'm having other database issues: CartoDB/cartodb#49

If I switch "trust" back to "md5", I still have the new problem. So I think this issue is resolved.

[strk]

@tjwebb good point, now I remember why there's no password we're using :)
Yep, we all trust (scary but true)