Solved

Problem to login

Posted on 2014-07-20
7
342 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 34

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 34

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 37

Expert Comment

by:Gerwin Jansen
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

912 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now