Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kettle 3.0.0 RC1 unable to connect to MySQL DB

  1. #1
    Join Date
    Oct 2007
    Posts
    1

    Unhappy Kettle 3.0.0 RC1 unable to connect to MySQL DB

    I'm interested in the possibilities of Kettle for generating test data so I have installed this on my Windows workstation, which is also running MySQL5 with a few test databases.
    When Spoon starts, it presents me with a screen for creating a new database connection (Image 1). I choose "New", and enter all the things you would expect for a MySQL database (Image 2) and this works fine - as I can see by using the "Explorer" (Image 3). I can see the tables and the data in them.
    However, when I return to the original window (Image 1) and try to accept the new connexion, I get the message below... and there seems no way around it (I have tried the standard user "root", "root@localhost", adding the new user "pentaho" with full privileges, changing the server from "localhost" to "127.0.0.1", but nothing works):

    org.pentaho.di.core.exception.KettleException:
    L'utilisateur [pentaho] ne peut être chargé depuis le référentiel: []

    L'utilisateur [pentaho] n'a pas été trouvé.


    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:100)
    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:109)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.ok(RepositoriesDialog.java:514)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.access$900(RepositoriesDialog.java:77)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$7.handleEvent(RepositoriesDialog.java:369)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:422)
    at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:5173)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5364)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5457)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:359)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    L'utilisateur [pentaho] n'a pas été trouvé.

    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:94)
    ... 13 more
    Attached Images Attached Images    

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    admin/admin if you create a new repository ... but you can use Kettle without repository as well.

    Regards,
    Sven

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.