Solved

Problem to login

Posted on 2014-07-20
7
354 Views
Last Modified: 2014-07-23
Hi,
I now login as "postgres" user to the Cent OS 6.5 server but I've got the attached problem

why?
0
Comment
Question by:HuaMinChen
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 35

Expert Comment

by:Gary Patterson
ID: 40207378
Nothing attached.
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40207388
Please see this
t763.png
0
 
LVL 35

Expert Comment

by:Gary Patterson
ID: 40207400
Looks like a common problem.  

Several troubleshooting options for this popped up with a quick search.  Did you try just doing a Google search on the error message?  

That's often a great first troubleshooting step.

The issue seems to be related to security, but there seem to be a variety of different fixes.  These threads have a lot of narrative on the problem and possible resolutions - too much to reproduce here.  I suggest you review them, try the most common, and let us know what you've tried.  I combed through the top search responses and selected these, which seem to contain the most valuable troubleshooting information.  I hope you find it useful.

http://mindref.blogspot.com/2011/06/troubleshooting-iceauthority-update.html

http://askubuntu.com/questions/55568/could-not-update-iceauthority-file-after-login-independent-of-gnome

- Gary
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40207405
Try deleting that file as root or move it as root to something else:

#mv /var/lib/pgsql/.ICEauthority /var/tmp

The relogin as postgres
0
 
LVL 11

Expert Comment

by:Joseph O'Loughlin
ID: 40207746
You should not normally be logging into a service account
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40208083
Thanks all.
Joseph,
does it mean it is of no meaning to login as user "postgres"?
0
 
LVL 11

Accepted Solution

by:
Joseph O'Loughlin earned 190 total points
ID: 40208103
You will have administrative/root rights to the postgres database
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
#Citrix #POC #XenDesktop #vCenter #VMware #ESX
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

808 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