Glad I could help <div class="gmail_quote">On Apr 2, 2012 2:44 PM, "Glennie, Jonathan - 0443 - MITLL" <<a href="mailto:jrglenni@ll.mit.edu">jrglenni@ll.mit.edu</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div lang="EN-US" link="blue" vlink="purple"><div>Changing the auth method in pg_hba.conf to md5 and then restarting postgres worked. Thank you very much! <div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in"> From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>] On Behalf Of Paul Robert Marino Sent: Thursday, March 29, 2012 5:45 PM To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Package Search Failing, Ident Authentication Failed </div> You shouldn't be using ident auth in postgresql. Instead you should be using md5 auth. Or simmilar mechanisim. Ident auth is really only avalible because it makes the initial configuration easier, and some times its used for scripts so they don't need to contain passwords, however that's a bad security practice. If it worked before and stopped working now it probably because it can't do remote ident verification which is handeled by xinetd. To really fix the problem you need to edit the /var/lib/pgsql/data/gp_hba.conf file and change the auth mechanisim to md5. Not if both are configured postgresql will honor the first entry from the top that matches the user and database.<div>On Mar 28, 2012 11:54 AM, "Glennie, Jonathan - 0443 - MITLL" <<a href="mailto:jrglenni@ll.mit.edu" target="_blank">jrglenni@ll.mit.edu</a>> wrote: <div><div>Hello- On spacewalk 1.6, running a package search in the GUI displays a red banner that reads “Could not execute query package_name”. /var/log/rhn/search/rhn_search_daemon.log shows the following: INFO | jvm 1 | 2012/03/28 11:25:41 | 2012-03-28 11:25:41,792 [Thread-8] ERROR com.redhat.satellite.search.rpc.handlers.IndexHandler - Caught exception: INFO | jvm 1 | 2012/03/28 11:25:41 | org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "spaceuser"INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291) INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.jdbc3g.Jdbc3gConnection.<init>(Jdbc3gConnection.java:24) INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.Driver.makeConnection(Driver.java:393)INFO | jvm 1 | 2012/03/28 11:25:41 | at org.postgresql.Driver.connect(Driver.java:267) INFO | jvm 1 | 2012/03/28 11:25:41 | at java.sql.DriverManager.getConnection(DriverManager.java:620)INFO | jvm 1 | 2012/03/28 11:25:41 | at java.sql.DriverManager.getConnection(DriverManager.java:200) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.redhat.satellite.search.db.Query.loadList(Query.java:66)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.screenHits(IndexHandler.java:203) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:150)INFO | jvm 1 | 2012/03/28 11:25:41 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:101) INFO | jvm 1 | 2012/03/28 11:25:41 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)INFO | jvm 1 | 2012/03/28 11:25:41 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) INFO | jvm 1 | 2012/03/28 11:25:41 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)INFO | jvm 1 | 2012/03/28 11:25:41 | at java.lang.reflect.Method.invoke(Method.java:616) INFO | jvm 1 | 2012/03/28 11:25:41 | at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.execute(ReflectiveInvocationHandler.java:217)INFO | jvm 1 | 2012/03/28 11:25:41 | at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.invoke(ReflectiveInvocationHandler.java:133) INFO | jvm 1 | 2012/03/28 11:25:41 | at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)INFO | jvm 1 | 2012/03/28 11:25:41 | at redstone.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:83) INFO | jvm 1 | 2012/03/28 11:25:41 | at com.redhat.satellite.search.rpc.XmlRpcInvoker.handle(XmlRpcInvoker.java:73)INFO | jvm 1 | 2012/03/28 11:25:41 | at simple.http.Dispatcher.run(Dispatcher.java:83) INFO | jvm 1 | 2012/03/28 11:25:41 | at simple.util.process.Daemon.execute(Daemon.java:121)INFO | jvm 1 | 2012/03/28 11:25:41 | at simple.util.process.Daemon.run(Daemon.java:106) INFO | jvm 1 | 2012/03/28 11:25:41 | Mar 28, 2012 11:25:41 AM redstone.xmlrpc.XmlRpcDispatcher writeErrorINFO | jvm 1 | 2012/03/28 11:25:41 | WARNING: redstone.xmlrpc.XmlRpcFault: FATAL: Ident authentication failed for user "spaceuser" Is there a config file that I can check to see what credentials it is using? The account and password that is using has been the same since day 1 although we re-ran the setup to use the FQDN of the server instead of the CN, not sure if that would have any impact on this or not. -Jon</div></div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </div></div></div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote></div>