US and Worldwide: +1 (866) 660-7555
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Problem with pgsql driver in admin console

  1. #1
    Join Date
    Jun 2008
    Posts
    27

    Unhappy Problem with pgsql driver in admin console

    Hi,

    I installed Pentaho on a server. When I start it, everything works fine. But I've got problems with the admin-console.
    I installed database and inserted everything like said in:
    http://wiki.pentaho.com/display/Serv...for+PostgreSQL

    Now I want to use admin-console but when I open 192.168.11.148:8099 in a Browser admin-console throws an error:
    "Connection refused"
    Maybe it's because of the data sources?
    I added Hibernate, but Pentaho cannot connect:
    Code:
    Driver class: postgresql
    User name: pentaho
    Password: mypass
    URL: jdbc:postgresql://192.168.11.148:5432/Hibernate
    After pressing on Test I get:
    Connection attempt failed, driver class postgresql not in classpath.
    But I uploaded the file: postgresql-8.4dev-700.jdbc4.jar into ALL lib files within my Pentaho installation.
    Did I make a mistake while configuring something?
    Can someone help me with this problem?

    Thank you in advance.
    Bye, Chris

  2. #2

    Default

    Did you add it to the administration-console/ jdbc driver folder(can't remember quite where it is off hand). Anyway the test button isn't actually required ie: if the connection is right and the jar is in common/lib/ then even with a test fail pentaho will still load the jdbc driver and the connection will work as admin console is on the jetty server and pentaho is on the tomcat.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)


  3. #3
    Join Date
    Jun 2008
    Posts
    27

    Default

    What do I have to insert in Driver class field?
    Driver Class: postgresql?
    And what is the appropriate name for Postgre jar driver?

    But on the top of the page I see server status ist "NOT available". Is it because of my data source?
    Or may I have another problem?

    Even on Refresh BI Server -> System settings, ... I just get "Connection refused".
    Is that all because of the incorrect datasource?

  4. #4

    Default

    org.postgresql.Driver

    the jar can be called anything, its just loaded at boot time
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)


  5. #5
    Join Date
    Jun 2008
    Posts
    27

    Question

    Great, it works
    Test passes.

    But now I've got another problem - Connection Refused is still remaining.
    Did you experience this problem before?
    Attached Images Attached Images

  6. #6
    Join Date
    Oct 2007
    Posts
    235

    Default

    Hello

    Is your postgres db set-up to accept connections from the other machine. I think in pg_hba.conf in your postgres data directory there is a list of places that are allowed to connect to the server.

    Wil

  7. #7

    Default

    that screen dump isn't a postgres problem thants a not able to talk with tomcat problem. But we need some sort of error
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)


  8. #8
    Join Date
    Jun 2008
    Posts
    27

    Question

    Hi,

    yes, postgre accepts request from other machines.
    Tomcat sounds like the right direction.
    I've got errors on the bash after starting admin console:

    Code:
    Dec 15, 2008 5:51:53 PM org.pentaho.pac.server.JettyServer startServer
    INFO: Console Starting
    2008-12-15 17:51:53.768::INFO:  jetty-6.1.2
    org.dom4j.DocumentException: No route to host Nested exception: No route to host
            at org.dom4j.io.SAXReader.read(SAXReader.java:484)
            at org.dom4j.io.SAXReader.read(SAXReader.java:343)
            at org.pentaho.platform.util.xml.dom4j.XmlDom4JHelper.getDocFromStream(XmlDom4JHelper.java:217)
            at org.pentaho.platform.util.xml.dom4j.XmlDom4JHelper.getDocFromString(XmlDom4JHelper.java:103)
            at org.pentaho.platform.util.xml.dom4j.XmlDom4JHelper.getDocFromString(XmlDom4JHelper.java:131)
            at org.pentaho.pac.server.common.AppConfigProperties.getPasswordServiceClass(AppConfigProperties.java:267)
            at org.pentaho.pac.server.common.AppConfigProperties.initPasswordService(AppConfigProperties.java:130)
            at org.pentaho.pac.server.common.AppConfigProperties.<init>(AppConfigProperties.java:120)
            at org.pentaho.pac.server.common.AppConfigProperties.<clinit>(AppConfigProperties.java:115)
            at org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl.initFromConfiguration(JdbcDriverDiscoveryServiceImpl.java:47)
            at org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl.initialize(JdbcDriverDiscoveryServiceImpl.java:44)
            at org.pentaho.pac.server.common.JdbcDriverDiscoveryServiceImpl.init(JdbcDriverDiscoveryServiceImpl.java:41)
            at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:433)
            at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:256)
            at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
            at org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:617)
            at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
            at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:500)
            at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
            at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
            at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
            at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
            at org.mortbay.jetty.Server.doStart(Server.java:210)
            at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39)
            at org.pentaho.pac.server.JettyServer.startServer(JettyServer.java:139)
            at org.pentaho.pac.server.JettyServer.<init>(JettyServer.java:72)
            at org.pentaho.pac.server.JettyServer.main(JettyServer.java:270)
    
    And:
    
    Dec 15, 2008 5:58:52 PM org.pentaho.pac.server.common.AppConfigProperties getBiServerBaseUrl
    SEVERE: Unable to read file : ../tomcat/webapps/pentaho/WEB-INF/web.xml
    Dec 15, 2008 5:58:52 PM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
    INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection refused
    Dec 15, 2008 5:58:52 PM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
    INFO: Retrying request

    No route to host .. but it's on the same machine.
    Hmm .. how can I find out where my mistake is?

    And web.xml ist chmod 777 for testing purposes.
    Maybe admin console can't read something within the web.xml file?

  9. #9

    Default

    I've seen the web.xml error thats normally not terminal. Are you sure the BI server is up and running ie: http://localhost:8080/pentaho
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)


  10. #10
    Join Date
    Jun 2008
    Posts
    27

    Default

    You're right - first I forgot to set the JAVA_HOME. Now I got an error like described here:
    http://forums.pentaho.org/showthread.php?p=202878
    But how do I have to configure my content.xml to work with Postgresql?

    Code:
    <Context     path="/pentaho"
                   docBase="${catalina.home}/webapps/pentaho"
                   debug="5"
                   reloadable="true"
                   crossContext="true">
        <Resource   name="jdbc/Quartz"
                    auth="Container"
                    type="javax.sql.DataSource"
                    maxActive="100"
                    maxIdle="30"
                    maxWait="10000"
                    username="pentaho"
                    password="******"
                    driverClassName="org.postgresql.Driver"
                    url="jdbc:postgresql://localhost:5432/Quartz"/>
    
        <Resource   name="jdbc/Hibernate"
                    auth="Container"
                    type="javax.sql.DataSource"
                    maxActive="100"
                    maxIdle="30"
                    maxWait="10000"
                    username="pentaho"
                    password="******"
                    driverClassName="org.postgresql.Driver"
                    url="jdbc:postgresql://localhost:5432/Hibernate"/>
    
        <Resource   name="jdbc/Shark"
                    auth="Container"
                    type="javax.sql.DataSource"
                    maxActive="100"
                    maxIdle="30"
                    maxWait="10000"
                    username="pentaho"
                    password="******"
                    driverClassName="org.postgresql.Driver"
                    url="jdbc:postgresql://localhost:5432/Shark"/>
    </Context>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •