Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Orientdb etl Login failure to a remote database #4175

Closed
KarimOurrai opened this issue May 18, 2015 · 2 comments
Closed

Orientdb etl Login failure to a remote database #4175

KarimOurrai opened this issue May 18, 2015 · 2 comments
Assignees

Comments

@KarimOurrai
Copy link

{
  "source": { "file": { "path": "./region.csv" } },
  "extractor": { "row": {} },
  "transformers": [
    { "csv": {} },
    { "vertex": { "class": "Region" } }
  ],
  "loader": {
    "orientdb": {
       "dbURL": "remote:URL_to_Database/data-ma",
       "dbUser": "User",
       "dbPassword": "Password",
       "dbAutoCreate": true,
       "standardElementConstraints": false,
       "tx": false,
       "wal": false,
       "batchCommit": 1000,
       "dbType": "graph",
       "classes": [
         {"name": "Region", "extends": "V"},
         {"name": "Country", "extends": "V"},
       ], "indexes": [
         {"class":"Region", "fields":["id:integer"], "type":"UNIQUE" }
       ]
    }
  }
}

Hey I have this json file I want to fill a remote database with 'orientdb etl' but it gives login failure although I can connect to it using the Console.sh (Same password and username).

error:

 /opt/orientdb-community-2.1-rc2/bin/oetl.sh /path_to/region.json
OrientDB etl v.2.1-rc2 (build @BUILD@) www.orientechnologies.com
Exception in thread "main" com.orientechnologies.orient.core.exception.OConfigurationException: Error on creating ETL processor
    at com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:275)
    at com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:185)
    at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:160)
Caused by: com.orientechnologies.orient.core.exception.OSecurityAccessException: User or password not valid for database: 'data-ma'
    at com.orientechnologies.orient.core.metadata.security.OSecurityShared.authenticate(OSecurityShared.java:186)
    at com.orientechnologies.orient.core.metadata.security.OSecurityProxy.authenticate(OSecurityProxy.java:87)
    at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:239)
    at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:631)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.openDatabase(ONetworkProtocolBinary.java:638)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:269)
    at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:221)
    at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:71)
@lvca
Copy link
Member

lvca commented Aug 24, 2015

Could you send us the database so we can try it?

@lvca lvca self-assigned this Aug 24, 2015
@prjhub prjhub closed this as completed Oct 7, 2015
@prjhub
Copy link

prjhub commented Oct 7, 2015

The issue has been closed because no response has been received after a while. In case the issue is still valid, please reopen it or write a comment that explains why it's still valid and a way to reproduce it. Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

3 participants