[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

PostgreSQL administration through Webmin

Posted on 2004-08-16
3
Medium Priority
?
929 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 1000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
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.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month18 days, 16 hours left to enroll

834 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