Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problemas con conexion de bases de datos

  1. #1
    Join Date
    Feb 2010
    Posts
    21

    Default Problemas con conexion de bases de datos

    Hola buenas...

    He intentado conectarme con la base de datos mysql siguiendo los pasos de crear nueva conexion y el asistente. En ambos casos me da error y no se porque...

    Utilizo linux ( opensuse 11.2), me da error tanto en la version 3.2 como en la nueva 4.0.
    La base de datos se llama Proyecto y me conecto como usuario eduardo y contraseña ****, puerto 3306, el servidor es localhost.

    Me da el siguiente error: Si alguien me puede dar alguna pista...

    Y otra cosa: en /usr/share/java tengo instaldo el mysql connector java 5.1.6 ( el que viene con opensuse). Kettle cual utiliza el que esta en su directorio ( /data-integration/libext/JDBC que es el 3.1.14) o el "general de linux". Que pasa si copio el archivo mysqlconnectorjava5.1.6 en el directorio local de kettle ? que driver elegiria ? o podria elegirlo yo ? y como ?

    Gracias por la ayuda

    Error connecting to database [ConexionProyecto] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException
    MESSAGE: java.net.ConnectException: Conexión rehusada

    STACKTRACE:

    java.net.SocketException: java.net.ConnectException: Conexión rehusada
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:467)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:347)
    at org.pentaho.di.core.database.Database.connect(Database.java:312)
    at org.pentaho.di.core.database.Database.connect(Database.java:274)
    at org.pentaho.di.core.database.Database.connect(Database.java:264)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2431)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6254)
    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 org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.spoon.Spoon.readAndDispatch(Spoon.java:1147)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6586)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 7 ms ago.


    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Communications link failure due to underlying exception:

    ** BEGIN NESTED EXCEPTION **

    java.net.SocketException
    MESSAGE: java.net.ConnectException: Conexión rehusada

    STACKTRACE:

    java.net.SocketException: java.net.ConnectException: Conexión rehusada
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:467)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:347)
    at org.pentaho.di.core.database.Database.connect(Database.java:312)
    at org.pentaho.di.core.database.Database.connect(Database.java:274)
    at org.pentaho.di.core.database.Database.connect(Database.java:264)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2431)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6254)
    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 org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.spoon.Spoon.readAndDispatch(Spoon.java:1147)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6586)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 7 ms ago.

    org.pentaho.di.core.database.Database.normalConnect(Database.java:363)
    org.pentaho.di.core.database.Database.connect(Database.java:312)
    org.pentaho.di.core.database.Database.connect(Database.java:274)
    org.pentaho.di.core.database.Database.connect(Database.java:264)
    org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2431)
    org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:146)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    org.eclipse.jface.window.Window.open(Window.java:796)
    org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:113)
    org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6254)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119)
    org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
    org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147)
    org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6586)
    org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544)

    Hostname : localhost
    Port : 3306
    Database name : Proyecto

  2. #2
    Join Date
    Jun 2010
    Posts
    14

    Default

    Hola Eduardo
    ¿Cuando has definido la conexión la has probado con el botón 'Probar'?
    ¿El usuario que estás usando es administrador en la base de datos?
    Yo estoy usando Windows y con lo anterior lo conseguí a la primera.

  3. #3
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    Al dar de alta usuarios en mysql se indica desde dónde pueden conectarse. ¿El usuario con el que te estás conectando tiene permisos para conectarse a "localhost"?
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

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.