Pentaho

 View Only

 How to configure access for Kitchen to a MySQL repository on a Ubuntu Server?

  • Pentaho
  • Pentaho
Gert Wieland's profile image
Gert Wieland posted 06-21-2020 02:17

I set up a Ubuntu Server (18.04 LTS) and I managed to get the Pentaho Server (CE 9) up and running.

 

I also installed a LAMP stack. From my developer machine, I configured a MySQL Repository, and I can connect from my local Spoon. So far so good.

 

I created a very simple job, and I tried to run it via Kitchen using this command line:

 

/home/abc/pentaho/data-integration/kitchen.sh -rep=ubuntu -user=pentaho -password=areallygoodpassword -dir=/ -job=Job1

 

However, I keep getting this error:

ERROR: Can't connect to the repository.

 

I made sure that the MySQL JDBC jar driver exists in this folder:

/home/abc/pentaho/data-integration/lib

 

My hunch is that I need to put the JDBC driver into another folder for Kitchen to find it, but I was unable to find any documentation.

 

What would I need to do so Kitchen can connect to the repository?

 

I could really need a hand here.

 

Thanks in advance :)


#Pentaho
Marvin Horst's profile image
Marvin Horst posted 07-09-2020 13:21

That is the correct directory for the mysql driver.

 

You successfully connected via spoon on the Ubuntu server?

 

Double check the contents of the .kettle/repositories.xml file in your home directory.

Gert Wieland's profile image
Gert Wieland posted 08-05-2020 18:20

Thanks Marvin, and my apologies for only getting back to you today!

You were right, my problem was with the "repositories.xml" file. I wasn't sure how to fix it, but I just transferred and edited the one that was automatically created on the server where I first created the transformations and jobs. Et voila, it worked!

 

Thanks a lot for putting me on the right track :)

Related Content