[Spacewalk-list] Search feature not working - Unknown host specified

Tue Nov 2 15:47:35 UTC 2010

I wiped out the database entirely (ran spacewalk-setup --disconnected which seems to discover there's an existing populated database, and asks you if you'd like to clear it out).
This caused me to have to setup all my channels and populate them all over again, recreate keys, and re-register clients with Spacewalk. And I'm STILL having the same error on our Spacewalk 1.1 server. Searching for packages doesn't work. Does ANYONE have any idea how this search feature works and where it might be getting the hostname that it's looking for in the process of searching for packages in Spacewalk 1.1?

/var/log/rhn/search/rhn_search.log shows:

[2010-11-02 11:34:43,175] ERROR - Caught exception: java.sql.SQLException: Io exception: Unknown host specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(DriverManager.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:200) at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580) at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222) at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48) at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at com.redhat.satellite.search.db.Query.loadList(Query.java:66) at com.redhat.satellite.search.rpc.handlers.IndexHandler.screenHits(IndexHandler.java:203) at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:150) at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:101) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.execute(ReflectiveInvocationHandler.java:217) at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.invoke(ReflectiveInvocationHandler.java:133) at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123) at redstone.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:83) at com.redhat.satellite.search.rpc.XmlRpcInvoker.handle(XmlRpcInvoker.java:73) at simple.http.Dispatcher.run(Unknown Source) at simple.util.process.Daemon.execute(Unknown Source) at simple.util.process.Daemon.run(Unknown Source)

/var/log/rhn/search/rhn_search_daemon.log shows:

INFO | jvm 1 | 2010/11/02 11:34:43 | 2010-11-02 11:34:43,175 [Thread-19] ERROR com.redhat.satellite.search.rpc.handlers.IndexHandler - Caught exception: INFO | jvm 1 | 2010/11/02 11:34:43 | java.sql.SQLException: Io exception: Unknown host specified
INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) INFO | jvm 1 | 2010/11/02 11:34:43 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) INFO | jvm 1 | 2010/11/02 11:34:43 | at java.sql.DriverManager.getConnection(DriverManager.java:620) INFO | jvm 1 | 2010/11/02 11:34:43 | at java.sql.DriverManager.getConnection(DriverManager.java:200) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.redhat.satellite.search.db.Query.loadList(Query.java:66) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.screenHits(IndexHandler.java:203) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:150) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.redhat.satellite.search.rpc.handlers.IndexHandler.search(IndexHandler.java:101) INFO | jvm 1 | 2010/11/02 11:34:43 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | 2010/11/02 11:34:43 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) INFO | jvm 1 | 2010/11/02 11:34:43 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) INFO | jvm 1 | 2010/11/02 11:34:43 | at java.lang.reflect.Method.invoke(Method.java:616) INFO | jvm 1 | 2010/11/02 11:34:43 | at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.execute(ReflectiveInvocationHandler.java:217) INFO | jvm 1 | 2010/11/02 11:34:43 | at redstone.xmlrpc.handlers.ReflectiveInvocationHandler.invoke(ReflectiveInvocationHandler.java:133) INFO | jvm 1 | 2010/11/02 11:34:43 | at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123) INFO | jvm 1 | 2010/11/02 11:34:43 | at redstone.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:83) INFO | jvm 1 | 2010/11/02 11:34:43 | at com.redhat.satellite.search.rpc.XmlRpcInvoker.handle(XmlRpcInvoker.java:73) INFO | jvm 1 | 2010/11/02 11:34:43 | at simple.http.Dispatcher.run(Unknown Source) INFO | jvm 1 | 2010/11/02 11:34:43 | at simple.util.process.Daemon.execute(Unknown Source) INFO | jvm 1 | 2010/11/02 11:34:43 | at simple.util.process.Daemon.run(Unknown Source) INFO | jvm 1 | 2010/11/02 11:34:43 | Nov 2, 2010 11:34:43 AM redstone.xmlrpc.XmlRpcDispatcher writeError INFO | jvm 1 | 2010/11/02 11:34:43 | WARNING: redstone.xmlrpc.XmlRpcFault: Io exception: Unknown host specified

> I just ran the "spacewalk-hostname-rename" script from the utils package.
> Doesn't appear to have fixed the error I was seeing below.  Still have a broken
> package search feature.  So, no change after running the script.

> Chris

On Oct 4, 2010, at 2:31 PM, Miller, Chris wrote:

> I just discovered the script in spacewalk-utils package that would've done
> all of this for me.  Is it possible to still run this and fix anything I
> might've not corrected on my own?
>
> On Oct 4, 2010, at 2:10 PM, Miller, Chris wrote:
>
>> Hello, we recently installed a new spacewalk server from scratch with
>> version 1.1.  In the middle of working on it, it was decided to move the
>> server (it's a virtual machine) to another location which required a server
>> name change.  This created quite a headache with all of the configuration
>> files, certificates and other misc stuff in Spacewalk already being setup
>> for the first name.  I think I cleaned up all of the references to the old
>> name, but still have one lingering issue that I can't seem to fix.
>>
>> The package search is broken on our server because it appears to be querying
>> using the wrong server name.  When a package search is performed, we get a
>> red banner with the error message:
>>
>> Could not execute query 'kernel'.
>>
>> Taking a quick look at /var/log/rhn/search/rhn_search_daemon.log reveals a
>> few error messages that lead me to believe I need to change the servername
>> somewhere in a config or database table:
>>
>> INFO   | jvm 1    | 2010/10/04 14:07:02 | 2010-10-04 14:07:02,366 [Thread-9]
>> ERROR com.redhat.satellite.search.rpc.handlers.IndexHandler - Caught
>> exception:
>> INFO   | jvm 1    | 2010/10/04 14:07:02 | java.sql.SQLException: Io
>> exception: Unknown host specified
>>
>> INFO   | jvm 1    | 2010/10/04 14:07:02 | WARNING:
>> redstone.xmlrpc.XmlRpcFault: Io exception: Unknown host specified
>>
>> Does anyone know where I might find the configuration file or database entry
>> that holds the server name causing package search to fail on our server?
>>
>> Chris Miller
>> Unix Systems Engineer
>> QuickenLoans.com<http://QuickenLoans.com>
>>
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
> https://www.redhat.com/mailman/listinfo/spacewalk-list

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list