Hi,
I try to install management console as like as the same version of the vertica. But my browser shows me that wep page is not available error. Here below I provied my output.
=================
starting monitor thread
2014-09-18 04:49:51.402:INFO:oejs.Server:jetty-7.x.y-SNAPSHOT
2014-09-18 04:49:51.485:INFO:oejw.WebInfConfiguration:Extract jar:file:/opt/vconsole/lib/webui.war!/ to /opt/vconsole/temp/webapp
2014-09-18 04:50:01.902:INFO:/webui:Initializing Spring root WebApplicationContext
log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).
log4j:WARN Please initialize the log4j system properly.
java.sql.SQLSyntaxErrorException: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.getLatestSchemaVer(RepositoryDataCleanupTask.java:164)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.canStartCleanUp(RepositoryDataCleanupTask.java:126)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupTask.launchTask(RepositoryDataCleanupTask.java:93)
at com.vertica.admin.tools.webui.jobs.RepositoryDataCleanupJob.execute(RepositoryDataCleanupJob.java:32)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.SQLException: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR 42X05: Table/View 'CONFIGURATION.SCHEMA_VERSION' does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 10 more
---- Upgrading /opt/vconsole/config/console.properties ----
************************************************************************************************************
Please open the Vertica Management Console at https://ip-myipdetails.ec2.internal:5450/webui
************************************************************************************************************
2014-09-18 04:50:54.719:INFO:/webui:Set web app root system property: 'webapp.root' = [/opt/vconsole/temp/webapp]
2014-09-18 04:50:54.723:INFO:/webui:Initializing log4j from [/opt/vconsole/temp/webapp/WEB-INF/log4j-mc.xml]
2014-09-18 04:50:54.831:INFO:oejsh.ContextHandler:started o.e.j.w.WebAppContext{/webui,file:/opt/vconsole/temp/webapp/},file:/opt/vconsole/lib/webui.war
2014-09-18 04:50:55.199:INFO:/webui:Initializing Spring FrameworkServlet 'appServlet'
2014-09-18 04:51:02.749:INFO:oejhs.SslContextFactory:Enabled Protocols [SSLv2Hello, TLSv1, SSLv3] of [SSLv2Hello, SSLv3, TLSv1]
2014-09-18 04:51:02.792:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:5450 STARTING
Any one can share your ideas for resolve this and make MC installation succssfully happen.
Thanks
raj
Problem in MC installation
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Problem in MC installation
Well, MC appears to be running. What's the name of the host or IP of the node MC is installed on and what is the URL you're using to try to access MC through the browser?
Checkout vertica.tips for more Vertica resources.