Hi all, I have a problem with rhn-search on my fresh spacewalk v1.1 installation. In particular the /etc/init.d/rhn-search cleanindex command fails with the following error:
[r...@spacewalk ~]# /etc/init.d/rhn-search cleanindex Stopping rhn-search... Stopped rhn-search. 2010-09-09 16:34:47,149 [main] ERROR com.redhat.satellite.search.DeleteIndexes - Caught Exception: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/redhat/satellite/search/db/errata.xml. --- The error occurred while executing mapped statement. --- Check the deleteLastErrata. --- Check the statement or the result map. --- Cause: java.sql.SQLException: Eccezione IO: The Network Adapter could not establish the connection at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98) at com.redhat.satellite.search.db.WriteQuery.delete(WriteQuery.java:72) at com.redhat.satellite.search.DeleteIndexes.deleteQuery(DeleteIndexes.java:87) at com.redhat.satellite.search.DeleteIndexes.main(DeleteIndexes.java:118) Caused by: java.sql.SQLException: Eccezione IO: The Network Adapter could not establish the connection 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.executeUpdate(GeneralStatement.java:78) ... 6 more 2010-09-09 16:34:47,156 [main] ERROR com.redhat.satellite.search.DeleteIndexes - Unable to establish database connection. 2010-09-09 16:34:47,156 [main] ERROR com.redhat.satellite.search.DeleteIndexes - Ensure database is available and connection details are correct, then retry Starting rhn-search... and I can't search for any package in my spacewalk. I have a separate oracle server and modified the /usr/share/rhn/search/classes/com/redhat/satellite/search/db/config.xml file as suggested i this list in the following mode: <transactionManager type="JDBC" > <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="${search.connection.driver_class}"/> <!-- <property name="JDBC.ConnectionURL" value="${search.connection.driver_proto}:@${db_name}"/> --> <!-- <property name="JDBC.ConnectionURL" value="${search.connection.driver_proto}:@${db_host}:${db_port}:${db_name}"/> --> <property name="JDBC.ConnectionURL" value="${search.connection.driver_proto}:@oracle-server:1521:spacewalk"/> <property name="JDBC.Username" value="${db_user}"/> <property name="JDBC.Password" value="${db_password}"/> </dataSource> </transactionManager> but even if I restore it to the original values it doesn't work. Any suggestion? Thank you. -- -- Benedetto Vassallo Sistema Informativo di Ateneo Settore Gestione Reti Hardware e Software U.O.B. Sviluppo e manutenzione dei sistemi Università degli Studi di Palermo Red Hat Certified Engineer Certificate Number: 804007793324656 Phone.: +3909123860056 Fax: +390916529124
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list