Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Issue while creating repository in production server.

  1. #1
    Join Date
    Mar 2010

    Default Issue while creating repository in production server.

    Hello Everyone.

    We are migrating to a production server in a datacenter.
    Having said this, it is on a completely different network.
    It is a Linux server, which doesn't have xmode. As such, no graphics leads to unusability of GUI tools like spoon.
    The database on the server is mysql.

    I have installed enterprise pentaho package on the prod server using the text only mode.

    Now I need to create a repository on the prod server.
    The issue is that, I cannot connect to the database on the server from the spoon on my client machine, thus rendering spoon useless for creation of a repository on the prod server.
    (The reason I cannot connect is because I cannot define a database connection from my machine to the production database, as I am a developer, and connecting to the production database from my machine is prohibited). One can only connect to the prod-database using remote access). However, the pentaho server's enterprise console is on the production server, and can connect to the database.

    Is there some other way to create a repository on a prod server which doesn't have graphical interface?

    (PS. If I create a repository on my local database, take a mysql dump of it, and use that to make a repository on the prod server, will it work?)

    Thank you.

    Last edited by aghuge; 07-21-2010 at 11:37 AM.

  2. #2


    Ops, I have done a cross posting... (
    I'm in the same situation, how do you have solved this problem (If you had)?

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.