PostgreSQL administration through Webmin

I currently have Webmin 1.150 and Postgres 7.3.2 installed on an OpenBSD 3.5 machine.  The problem I am having is when trying to setup the admin section for Postgres.

I am initially presented with a PostreSQL login prompt in Webmin.  After entering the database admin account I receive the followng error "Login failed : Incorrect administration username or password."  The correct user and pasword are being used.  I have checked the logs and it is being reported as an invalid login for the user.  I can however login with the same user and password through the terminal.

I have searched around and found users with similar problems, but there doesn't seem to be any definite answer on how to correct this.  Or perhaps I am just having a laps in intelligence :/.  Any help would be appreciated.  Thanks.
Who is Participating?
rjkimbleConnect With a Mentor Commented:
You may have a problem with how you have set up authentication. Could you post the relevant lines of pg_hba.conf?

A simple test you could try might be to log in as the webmin user account and then run psql, passing whatever user ID and password you use when using webmin.

I have no problems using the webmin PostgreSQL administration module.
jedannerAuthor Commented:
Seems like it was a problem the user.  I deleted and recreated the psql user and all seems happy now.  Must be a Monday.  Thanks for your help.
It might have been whether or not the original user had the permissions to create databases and/or other users. I'm glad it's working now.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.