Solved

PostgreSQL administration through Webmin

Posted on 2004-08-16
3
897 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
python - read lines from text file into sql query 6 903
pgpool-II on Ubuntu 14.04... ARGH! 5 873
How to grab this with SQL in PostgreSQL 4 117
replicating postgresql database 4 64
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

777 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