If you’re trying to setup bandwidthd with PostgreSQL, you may run into the following error: bandwidthd: Connection to database ‘user = USER dbname = bandwidthd host = localhost password = PASSWORD’ failed: FATAL: Ident authentication failed for user “USER”. This is most likely a problem with PostgreSQL and not bandwidthd itself.
Here’s how to fix it (on CentOS/RHEL):
Find the line:
host all all 127.0.0.1/32 ident sameuser
Change the last part to md5. Your line should look like this:
host all all 127.0.0.1/32 md5
Et voila! You should now be logging to PostgreSQL 🙂