topic Re: Can't migrate data from MySQL to Couchbase in Talend Studio

Can't migrate data from MySQL to Couchbase

Anonymous — Mon, 11 Dec 2017 10:11:05 GMT

I am trying to move data from a table in MySQL to Couchbase and I get the following error:

com.couchbase.client.vbucket.ConfigurationProviderHTTP: Connection problems with URI http://localhost:8091/pools ...skipping
java.io.IOException: Server returned HTTP response code: 401 for URL: http://localhost:8091/pools

(more in the image attached).

Here are the steps I have taken so far:

Drag tMysqlInput to the workspace, navigate to component with it selected, added in the connection settings, the username (root) and password is blank then table name and guess schema. I have also setup the schema and the query to user for Mysql
Drag tCouchbaseOutput to the workspace and drag a row from the myqlinput to couchbaseoutput and with tCouchbaseOutput selected, i have set the butcket name, the username and password (the admin password for the gui) and for the URI i have set "http://localhost:8091/pools"

When I run this job, I get that error about a 401 for the url. Do I have the correct url? What username and password am I supposed to use for the Couchbase connection?

Re: Can't migrate data from MySQL to Couchbase

Anonymous — Thu, 14 Dec 2017 07:39:21 GMT

Hello,

@a_ikiugu wrote:

com.couchbase.client.vbucket.ConfigurationProviderHTTP: Connection problems with URI http://localhost:8091/pools ...skipping

Could you please try to use ip server instead of localhost to see if it works?

Best regards

Sabrina

Re: Can't migrate data from MySQL to Couchbase

Anonymous — Thu, 14 Dec 2017 07:57:11 GMT

Hi, I already tried with the two variations...(localhost and 127.0.0.1)

Re: Can't migrate data from MySQL to Couchbase

Anonymous — Mon, 15 Jan 2018 16:49:38 GMT

Was there any resolution to this issue? I am running into this exact error with 6.4.1. Localhost, 127.0.0.1 and even the assigned IP of the machine from DHCP 192.168.xx.xx throw exactly the same error message. The couchbase logs show

192.168.99.121 - accessions [15/Jan/2018:09:43:17 -0700] "GET /pools HTTP/1.1" 401 0 - Couchbase Java Client

Re: Can't migrate data from MySQL to Couchbase

Anonymous — Mon, 15 Jan 2018 19:17:15 GMT

I'm sorry but this was never responded to. I gave up on using Talend with Couchbase and resolved to write code to move data to and from Sql/MySql