Four Stars

Can't migrate data from MySQL to Couchbase

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:

  1. 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
  2. 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? 

 

4 REPLIES
Moderator

Re: Can't migrate data from MySQL to Couchbase

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Can't migrate data from MySQL to Couchbase

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

One Star

Re: Can't migrate data from MySQL to Couchbase

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

Four Stars

Re: Can't migrate data from MySQL to Couchbase

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