Trying to install Wildfire in my test lab, am at the screen for the Administrator account.
I’'ve tried to set it up using the Administrator account, the DB2 account and an account named ‘‘admin’’, and it does not seem to be working.
Any suggestions on how to complete the setup wizard?
Thanx.
Hi Mikemillion,
Welcome to Jive community
At that stage of installation, you should be able to see some hints in logs/error.log file of Wildfire installation directory. Post the listing here if you can’'t figure out the error.
Hello, here is the info from error.log:
2006.10.14 13:18:29 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:108)
] Failed to create new connections on startup. Attempt 0 of 3
COM.ibm.db2.jdbc.DB2Exception: [CLI Driver] SQL1001N “[JIVE]” is not a valid database name. SQLSTATE=2E000
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.(ConnectionPool.java:108)
] Failed to create new connections on startup. Attempt 1 of 3
COM.ibm.db2.jdbc.DB2Exception: [CLI Driver] SQL1001N “[JIVE]” is not a valid database name. SQLSTATE=2E000
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.(ConnectionPool.java:108)
] Failed to create new connections on startup. Attempt 2 of 3
COM.ibm.db2.jdbc.DB2Exception: [CLI Driver] SQL1001N “[JIVE]” is not a valid database name. SQLSTATE=2E000
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.(Unknown Source)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocke t(DefaultProtocolSocketFactory.java:79)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocke t(DefaultProtocolSocketFactory.java:121)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDir ector.java:386)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirect or.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at org.jivesoftware.wildfire.update.UpdateManager.checkForServerUpdate(UpdateManag er.java:192)
at org.jivesoftware.wildfire.update.UpdateManager$1.run(UpdateManager.java:109)
Hi,
it seems that you did read http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/database.h tml#db2 and did specify the [ and ] characters around your database name, but these where just meant to show that a random database name can be used and must be specified there.
jdbc:db2:JIVE should work fine for you if you did name your database JIVE.
LG
Yes,
I would have figured that it would work, that’'s what has me perplexed.
Any suggestions?
Try it with the “net” COM.ibm.db2.jdbc.net.DB2Driver driver.
Or for your first installation just to get it up and running until you get a much better answer use the embedded database. I don’'t use DB2 so I have no idea what one could do wrong there.
LG
Ok, finally got it going. I reran the setup wizard, and although I got an error 500 after trying to setup the initial admin account, I was able to login to the secure admin console on port 9091 and all seems to be working ok.
Thanx for the help.
Mikemillion