Re: [pentaho-id] [ASK] Koneksi ke Hosting luar(bukan localhost)

[Faqih Zulfikar]

ada tampilan printscreennya?

Pada tanggal 10/10/12, yasir <fan...@gmail.com> menulis:
> dear all pentaho user,
>
> Kenapa terjadi error ketika koneksi databasenya memakai hosting luar(bukan
> localhost)?
>
> saya berencana output ETL dari spoon langsung masuk ke database pada
> hosting luar,, databasenya menggunakan mysql.
>
> mohon pencerahanya ^ ^
> trims.
>
> --
> Anda menerima pesan ini karena Anda telah terdaftar di Google
> Groups "Pentaho User Group - Indonesia".
> Untuk mengirim pesan ke grup ini, kirimkan email ke
> penta...@googlegroups.com
> Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
> pentaho-id+...@googlegroups.com
> Untuk opsi lainnya, silahkan kunjungi
> http://groups.google.com/group/pentaho-id?hl=id.
> Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi
> http://pentaho.phi-integration.com.
> http://pentaho-en.phi-integration.com.
> Milis terkait : http://groups.google.com/group/indo-bi
> Link knowledge base lainnya : http://www.belajarsql.com.
>


--


Faqih Zulfikar


PT LAPI Divusi >> Creating Value With Integrity
Jalan Kyai Gede Utama 12, Bandung 40132
Phone: +62.22.2501925
Fax: +62.22.2516752
Website: http://www.divusi.com

Penulis dan PT LAPI Divusi, baik sendiri ataupun bersama-sama, tidak
bertanggung jawab atas setiap salinan, modifikasi, dan/atau reproduksi dari
email ini dalam bentuk apapun. Jika anda telah menerima email ini dalam
kesalahan dan/atau menemukan email ini mengandung virus, harap menghapusnya
dan memberitahu penulis. Penulis dan PT LAPI Divusi, baik sendiri ataupun
bersama-sama, tidak bertanggung jawab atas kerusakan yang disebabkan oleh
email ini. Harap dicatat bahwa setiap pandangan dan/atau pendapat yang
disajikan dalam email ini adalah semata-mata dari penulis dan tidak selalu
mewakili PT LAPI Divusi.

[Rio Bastian]

Halo Pak Yasir, salam kenal,.. ^^

Pesan errornya apa pak?

2012/10/10 Faqih Zulfikar <fa...@divusi.com>

--
.: Rio Bastian :.

[Adjie]

Hmm, sepertinya server mysql yg dihosting tidak diset untuk bisa di-remote jd hanya bisa diakses dari local.

Salam,

-Adjie-

[Ludvianto Ovandi]

kalo menurut saya, tidak baik jika langsung ke database hosting through internet.

karena memungkinkan terputusnya koneksi secara tiba2. atau mungkin akab membuat database hosting down jika terlalu banyak hit antara pentaho dengan penggunaan laen. dan laen sebagainya.

mungkin lebih baik, dilakukan secara bertahap untuk memasukkan data ke database hosting.

tapi ini pemikiran saya saja. kalo salah atau ada yg tidak setuju, saya cuma berpendapat.

terima kasih

[santenkelapa isanasin]

sepertinya biasanya hosting pas kita buat database ada embel2 dari
dianya misalnya c11blabla.com , nampaknya salahnya di penamaan nama
hostnamenya

On 10/11/12, yasir <fan...@gmail.com> wrote:
> terimakasih semuanya atas tanggapan yang diberikan,,,
> setelah saya pikir2 memang benar apa kata pak ludvianto, tidak baik jika
> ETL dilakukan secara langsung ke db yang ada di host, apalagi jika datanya
> cukup banyak,,
>
> tetapi mungkin tidak ada salahnya untuk mencoba ETL langsung ke db host,
> mungkin untuk data yang kecil
> apa ada kemungkinan bisa koneksinya ke db hosting luar,? caranya
> di bawah ini capture-ran dari errornya :
>
> Error connecting to database [tes] :
> 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: Connection timed out: connect
>
> STACKTRACE:
>
> java.net.SocketException: java.net.ConnectException: Connection timed out:
> connect
> 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(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at
> org.pentaho.di.core.database.Database.connectUsingClass(Database.java:470)
> at
> org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
> at org.pentaho.di.core.database.Database.connect(Database.java:315)
> at org.pentaho.di.core.database.Database.connect(Database.java:277)
> at org.pentaho.di.core.database.Database.connect(Database.java:267)
> at
> org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
> at
> org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
> at
> org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
> at
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
> at
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
> at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
> at
> org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
> 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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
> at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
> at
> org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:98)
> at
> org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
> at
> org.pentaho.di.ui.trans.step.BaseStepDialog$3.widgetSelected(BaseStepDialog.java:480)
> 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.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:915)
> at
> org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
> at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7487)
> at
> org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2728)
> at
> org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693)
> 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:1161)
> at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
> at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 63 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: Connection timed out: connect
>
> STACKTRACE:
>
> java.net.SocketException: java.net.ConnectException: Connection timed out:
> connect
> 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(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at
> org.pentaho.di.core.database.Database.connectUsingClass(Database.java:470)
> at
> org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
> at org.pentaho.di.core.database.Database.connect(Database.java:315)
> at org.pentaho.di.core.database.Database.connect(Database.java:277)
> at org.pentaho.di.core.database.Database.connect(Database.java:267)
> at
> org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
> at
> org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
> at
> org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
> at
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
> at
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
> at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
> at
> org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
> 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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
> at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
> at
> org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:98)
> at
> org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
> at
> org.pentaho.di.ui.trans.step.BaseStepDialog$3.widgetSelected(BaseStepDialog.java:480)
> 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.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:915)
> at
> org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
> at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7487)
> at
> org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2728)
> at
> org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693)
> 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:1161)
> at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
> at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
>
>
> ** END NESTED EXCEPTION **
>
>
>
> Last packet sent to the server was 63 ms ago.
>
> org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
> org.pentaho.di.core.database.Database.connect(Database.java:315)
> org.pentaho.di.core.database.Database.connect(Database.java:277)
> org.pentaho.di.core.database.Database.connect(Database.java:267)
> org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
> org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
> org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
> org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
> org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
> org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
> 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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
> org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
> org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:98)
> org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
> org.pentaho.di.ui.trans.step.BaseStepDialog$3.widgetSelected(BaseStepDialog.java:480)
> 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.trans.steps.tableoutput.TableOutputDialog.open(TableOutputDialog.java:915)
> org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
> org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7487)
> org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2728)
> org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:693)
> 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:1161)
> org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
> org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
>
> Hostname : blablabla.com
> Port : 3306
> Database name : blablabla
>
> ===============================

>
>
> On Wednesday, October 10, 2012 4:51:16 PM UTC+7, yasir wrote:
>>
>> dear all pentaho user,
>>
>> Kenapa terjadi error ketika koneksi databasenya memakai hosting luar(bukan
>>
>> localhost)?
>>
>> saya berencana output ETL dari spoon langsung masuk ke database pada
>> hosting luar,, databasenya menggunakan mysql.
>>
>> mohon pencerahanya ^ ^
>> trims.
>>
>
> --
> Anda menerima pesan ini karena Anda telah terdaftar di Google
> Groups "Pentaho User Group - Indonesia".
> Untuk mengirim pesan ke grup ini, kirimkan email ke
> penta...@googlegroups.com
> Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
> pentaho-id+...@googlegroups.com
> Untuk opsi lainnya, silahkan kunjungi
> http://groups.google.com/group/pentaho-id?hl=id.
> Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi
> http://pentaho.phi-integration.com.
> http://pentaho-en.phi-integration.com.
> Milis terkait : http://groups.google.com/group/indo-bi
> Link knowledge base lainnya : http://www.belajarsql.com.
>

--
Best Regard,
Muhamad Ikhsan
085883552866
http://santenkelapa.com

[Rio Bastian]

Ga masalah ko Pak Yasir klo integrasi dari dbase yang berbeda domain,

sejauh kita punya otorisasi ke dbase itu. ^^

masalah yang paling umum dari integrasi dengan menggunkan dbase yang berbeda domain adalah koneksi, 

dari error code yang bapak berikan :

java.net.SocketException: java.net.ConnectException: Connection timed out: connect 

saya kira ini masalahnya lebih ke koneksi-nya (mungkin portnya di blok firewall, request time out, atau mungkin saat integrasi traffic ke domain dbase tersebut sedang ramai, atau masalah koneksi lain).

regards

2012/10/11 santenkelapa isanasin <santen...@gmail.com>

--
.: Rio Bastian :.