CentOS vs pgadmin

If it doesn't fit in another category, ask it here.
Post Reply
fgoncalo
Posts: 16
Joined: 2011/05/15 22:31:20

CentOS vs pgadmin

Post by fgoncalo » 2011/05/20 01:11:42

Hi,

So i am trying to work with pg admin 3 on a CentOS virtual machine (i "built it vmware workstation"). I am quite new to centOS, and so far so good i believe, i am working hard to learn how to deal with it. Hopefully i will get rid off Windows soon :)
I've installed pg admin3 with no problems, and everything was going ok, at least i was hopping for that, until i got into a dead end, when i tried to add a new server, i left, as default, the "Maintenance DB : postgres" and the "username: myusername" and running "localhost". I tried to start the proccess, but i got this error (check the img)
I already googled it, but still, it hasn't been easy to reach a solution.
For sure this seems like a silly question, but as i said, i'm quite new to this, and i really want to learn it


Thanks in advance,
Filipe

fgoncalo
Posts: 16
Joined: 2011/05/15 22:31:20

Re: CentOS vs pgadmin

Post by fgoncalo » 2011/05/20 01:18:52

Sorry the img is here

fgoncalo
Posts: 16
Joined: 2011/05/15 22:31:20

Re: CentOS vs pgadmin

Post by fgoncalo » 2011/05/20 01:21:56

Img

fgoncalo
Posts: 16
Joined: 2011/05/15 22:31:20

Re: CentOS vs pgadmin

Post by fgoncalo » 2011/05/20 01:30:13

Sorry, but i couldt upload a .gif file with the snapshot

this is the error i've mentioned

Ident authentication failed
The server doesn't accept the current user: The server reports
FATAL: Ident authentication failed for user "myusername"
If this message appears, the pg_hba.conf entry found for your client / user / database combination is set to "ident" authentication. Some distributions, e.g. Debian, have this by default. To perform ident based authentication successfully, you need additional setup; see the PostgreSQL help for this. For a beginner, it might be more appropriate to use a different authentication method; MD5 encrypted passwords are a good choice, which can be configured by an entry in pg_hba.conf like this:
host all all 192.168.0.0/24 md5
This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24.
You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process.

mbaudier
Posts: 8
Joined: 2011/05/11 18:40:56
Contact:

Re: CentOS vs pgadmin

Post by mbaudier » 2011/05/20 06:37:20

This is a postgresql issue, not a centos issue.
Please rather ask postgresql mailing-lists or forums.

If this is just a test environment, try replacing the last lines of /var/lib/pgsql/data/pg_hba.conf by:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust
host all all 192.168.1.0/24 trust
host all all 127.0.0.1/32 trust

(extremely unsecure)

and restart

fgoncalo
Posts: 16
Joined: 2011/05/15 22:31:20

Re: CentOS vs pgadmin

Post by fgoncalo » 2011/05/20 08:28:12

Thanks for your attention :)
Good to know that in this mad world, we can still find people wanting to help.

Have a nice day,
Filipe

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

CentOS vs pgadmin

Post by pschaff » 2011/05/20 21:01:58

[quote]
fgoncalo wrote:
Sorry the img is here[/quote]
For future reference please note that the forum attachment function is permanently broken. Posting text is generally preferred anyway, but if an image is required it can be posted somewhere public and a link provided.

Looks like you never got an official welcome, so: Welcome to the CentOS fora.

Post Reply

Return to “CentOS 5 - Miscellaneous Questions”