Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Pentaho Admin Console Errors

  1. #1

    Default Pentaho Admin Console Errors

    Hello Everyone,

    I am not able to use the pentaho admin console. Please help me here.


    I had to go to console.properties and change the port of pac to 8080 (because this is the only port available).

    Now when I run PAC, I get the following two errors





    The stack trace says

    INFO: No credentials available for BASIC 'Pentaho'@204.232.210.138:8080
    Jun 6, 2010 7:38:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    WARNING: SQL Error: -80, SQLState: 08000
    Jun 6, 2010 7:38:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    SEVERE: socket creation error
    Jun 6, 2010 7:38:05 PM org.pentaho.pac.server.common.DAOFactory getUserRoleDAO
    WARNING: Unable to initialize
    org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:125)
    at org.pentaho.platform.engine.security.userroledao.hibernate.UserRoleDaoTransactionDecorator.getUsers(UserRoleDaoTransactionDecorator.java:117)
    at org.pentaho.platform.engine.security.userroledao.hibernate.sample.SampleUsersAndRolesInitHandler.handleInit(SampleUsersAndRolesInitHandler.java:58)
    at org.pentaho.platform.engine.security.userroledao.hibernate.HibernateUserRoleDao.init(HibernateUserRoleDao.java:77)
    at org.pentaho.pac.server.common.DAOFactory.getUserRoleDAO(DAOFactory.java:58)
    at org.pentaho.pac.server.UserRoleMgmtService.<init>(UserRoleMgmtService.java:40)
    at org.pentaho.pac.server.PacServiceImpl.refreshHibernateConfig(PacServiceImpl.java:878)
    at org.pentaho.pac.server.PacServiceImpl.getUserRoleMgmtService(PacServiceImpl.java:857)
    at org.pentaho.pac.server.PacServiceImpl.getUserRoleSecurityInfo(PacServiceImpl.java:124)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)

  2. #2

    Default

    bump! Please help me here.
    What can be causing this error?

  3. #3

    Default

    For the first error:

    http://forums.pentaho.org/showthread.php?t=73113

    Don't know about second error, although maybe is caused because of the first one.

  4. #4
    Join Date
    Jun 2013
    Posts
    8

    Smile Start ur BI server

    guyz pls start ur BI server n then try to log in thr Admin console.. I hope, i'll resole the issue..

  5. #5

    Default Unable to connect o BI Server.

    Quote Originally Posted by abhishes View Post
    Hello Everyone,

    I am not able to use the pentaho admin console. Please help me here.


    I had to go to console.properties and change the port of pac to 8080 (because this is the only port available).

    Now when I run PAC, I get the following two errors





    The stack trace says

    INFO: No credentials available for BASIC 'Pentaho'@204.232.210.138:8080
    Jun 6, 2010 7:38:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    WARNING: SQL Error: -80, SQLState: 08000
    Jun 6, 2010 7:38:05 PM org.hibernate.util.JDBCExceptionReporter logExceptions
    SEVERE: socket creation error
    Jun 6, 2010 7:38:05 PM org.pentaho.pac.server.common.DAOFactory getUserRoleDAO
    WARNING: Unable to initialize
    org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:599)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:125)
    at org.pentaho.platform.engine.security.userroledao.hibernate.UserRoleDaoTransactionDecorator.getUsers(UserRoleDaoTransactionDecorator.java:117)
    at org.pentaho.platform.engine.security.userroledao.hibernate.sample.SampleUsersAndRolesInitHandler.handleInit(SampleUsersAndRolesInitHandler.java:58)
    at org.pentaho.platform.engine.security.userroledao.hibernate.HibernateUserRoleDao.init(HibernateUserRoleDao.java:77)
    at org.pentaho.pac.server.common.DAOFactory.getUserRoleDAO(DAOFactory.java:58)
    at org.pentaho.pac.server.UserRoleMgmtService.<init>(UserRoleMgmtService.java:40)
    at org.pentaho.pac.server.PacServiceImpl.refreshHibernateConfig(PacServiceImpl.java:878)
    at org.pentaho.pac.server.PacServiceImpl.getUserRoleMgmtService(PacServiceImpl.java:857)
    at org.pentaho.pac.server.PacServiceImpl.getUserRoleSecurityInfo(PacServiceImpl.java:124)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)

    Hi Experts,

    I am also facing the same problem and i have tried to add trustedips. But still i couldnt get rid of the error..
    Can someone help on this.

    Please find the log as below

    2013-09-12 11:48:45,647 INFO [org.pentaho.pac.server.JettyServer] Console is starting
    2013-09-12 11:48:45,672 INFO [/] org.pentaho.pac.server.BrowserLocaleServlet-654694538: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.DefaultConsoleServlet-444914211: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.PacServiceImpl-241230120: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.SchedulerServiceImpl-968414967: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.SolutionRepositoryServiceImpl-381221099: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.SubscriptionServiceImpl-948074059: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.common.HibernateConfigurationServiceImpl-1473444918: init
    2013-09-12 11:48:45,673 INFO [/] org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl-1021925974: init
    2013-09-12 11:48:45,684 INFO [org.pentaho.pac.server.JettyServer] Console is now started. It can be accessed using http://testbed:8099 or http://127.0.0.1:8099
    2013-09-12 11:48:56,004 DEBUG [httpclient.wire.header] >> "GET /pentaho/ping/alive.gif?requestedMimeType=text%2Fxml HTTP/1.1[\r][\n]"
    2013-09-12 11:48:56,021 DEBUG [httpclient.wire.header] >> "User-Agent: org.pentaho.pac.server.common.ThreadSafeHttpClient[\r][\n]"
    2013-09-12 11:48:56,021 DEBUG [httpclient.wire.header] >> "Host: localhost:8099[\r][\n]"
    2013-09-12 11:48:56,021 DEBUG [httpclient.wire.header] >> "[\r][\n]"
    2013-09-12 11:48:56,032 DEBUG [httpclient.wire.header] << "HTTP/1.1 401 Unauthorized[\r][\n]"
    2013-09-12 11:48:56,033 DEBUG [httpclient.wire.header] << "WWW-Authenticate: basic realm="Pentaho"[\r][\n]"
    2013-09-12 11:48:56,033 DEBUG [httpclient.wire.header] << "Content-Type: text/html; charset=iso-8859-1[\r][\n]"
    2013-09-12 11:48:56,033 DEBUG [httpclient.wire.header] << "Content-Length: 1315[\r][\n]"
    2013-09-12 11:48:56,034 DEBUG [httpclient.wire.header] << "Server: Jetty(6.1.2)[\r][\n]"
    2013-09-12 11:48:56,047 INFO [org.apache.commons.httpclient.auth.AuthChallengeProcessor] basic authentication scheme selected
    2013-09-12 11:48:56,054 INFO [org.apache.commons.httpclient.HttpMethodDirector] No credentials available for BASIC 'Pentaho'@localhost:8099
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<html>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<head>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<title>Error 401 UNAUTHORIZED</title>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "</head>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<body>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<h2>HTTP ERROR: 401</h2><pre>UNAUTHORIZED</pre>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<p>RequestURI=/pentaho/ping/alive.gif</p>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << "<p><i><small><a href="http://jetty.mortbay.org">Powered by jetty://</a></small></i></p>[\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,055 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " "
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << " [\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << "</body>[\n]"
    2013-09-12 11:48:56,056 DEBUG [httpclient.wire.content] << "</html>[\n]"



    Thanks,
    Arun
    Last edited by arun@valorise; 09-12-2013 at 03:50 AM. Reason: added log

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.