Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

PostgreSQL administration through Webmin

Posted on 2004-08-16
3
Medium Priority
?
922 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

618 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