Can't migrate data from MySQL to Couchbase

[Anonymous]

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? 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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