Opalis Operator Console Database Connection Issue

opalis error transaction failed

Problem:

I am having some trouble logging into my Opalis Operator Console after running through the installation script. After trying to login I am getting the error message “The username or password you have entered is not correct. Transaction failed”.

At first I thought it was an Active Directory or LDAP issue but in the error logs I’m seeing thing related to SQL rather than AD.  I don’t think the tables were properly created, because when I look at the Tables in the OpalisDevOpsPanel database I don’t see any of these tables.

My opalis-ds.xml looks correct, and I can ping the SQL server and telnet to port 1433.  The AD user running the JBoss server has dbo access to the database…

My opalis-ds.xml:

<datasources>
 <local-tx-datasource>
 <jndi-name>OpConsoleDS</jndi-name>
 <connection-url>jdbc:sqlserver://usdevserver.usdev.domain.com;database=OpalisDevOpsPanel;IntegratedSecurity=true;</connection-url>
 <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>25</max-pool-size>
 <track-statements>nowarn</track-statements>
 <connection-property name="autoReconnect">true</connection-property>
 <idle-timeout-minutes>3</idle-timeout-minutes>
 <background-validation>true</background-validation>
 <background-validation-minutes>2</background-validation-minutes>
 <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
 <prepared-statement-cache-size>30</prepared-statement-cache-size>
 </local-tx-datasource>
</datasources>

From the system.log:

2011-02-09 08:59:29,338 INFO [com.opalis.opconsole.jmx.account.AccountServicesActiveDirectory] Got com.opalis.opconsole.jmx.account.SearchResult@120e76d
2011-02-09 08:59:29,526 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 208, SQLState: S0002
2011-02-09 08:59:29,526 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid object name 'dbo.USER_INFO'
2011-02-09 08:59:29,526 ERROR [org.jboss.seam.security.jaas.SeamLoginModule] Error invoking login method
javax.el.ELException: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:333)
	at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
	at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
	at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
...

Resolution:

Turns out I can’t read properly.  Either that, or the instructions here were not clear enough to me.

When the install script asks for the “database” apparently it wants the name of your existing Opalis database, so in my case “OpalisDev”. I was erroneously creating a brand NEW database for the Operator Console, called OpalisDevOpsPanel.  Oops.

I ran the installer script again and specified the correct database, everything is working now.  I probably could have just modified the opalis-ds.xml but was already midway running the script again when I realized my error.  Well, I hope that helps someone!

- Rezilient

This entry was posted in System Center Opalis. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>