Solved

PostgreSQL administration through Webmin

Posted on 2004-08-16
3
893 Views
Last Modified: 2006-11-17
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.
0
Comment
Question by:jedanner
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
rjkimble earned 250 total points
ID: 11815121
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.
0
 

Author Comment

by:jedanner
ID: 11817399
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.
0
 
LVL 9

Expert Comment

by:rjkimble
ID: 11817654
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.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now