DataStax Gremlin Server Connection

[gourav-sg]

Describe the bug
:remote config alias g gourav.g does not work

To Reproduce
Steps to reproduce the behavior:

1. created a connection to datastax using:

%%graph_notebook_config
{
    "host": "localhost",
    "port": 8182,
    "username" : "cassandra",
    "password" : "cassandra",
    "auth_mode": "DEFAULT",
    "ssl": false,
    "database" : "dag"
}

2. Was able to run commands like system.list(), which showed the different graph databases (keyspaces in Cassandra)
3. Was not able to run Gremlin commands like :remote for generating alias for g
4. Error reported:

{'error': GremlinServerError('597: startup failed:\nScript89274.groovy: 2: unexpected token: : @ line 2, column 1.\n   :remote config alias g gourav.g\n   ^\n\n1 error\n')}

Expected behavior
should have documentation of method demonstrated to show how to create an alias g.

When I am using gremlin console in command line and connecting to Datastax cassandra everything works fine as I am able to create the remote connection properly

Screenshots
NA

Desktop (please complete the following information):

• OS: Ubuntu
• Browser chrome
• Version latest

Additional context
Not applicable

[krlawrence]

Hi @gourav-sg and thanks for taking the time to open an issue.

The :remote command is unique to the Gremlin console and the command itself is not sent to the server in that form. We're happy to consider this more as a feature request but can you please say a bit more about your use case for using an alias in the notebooks. Is it to have multiple graph traversal source objects each pointing to a different backend graph/keyspace?

[gourav-sg]

Hi @krlawrence ,
thanks a ton for your kind response.

For connecting with Datastax gremlin server this is the code that I am using in the notebook:

%%gremlin 

import org.apache.tinkerpop.gremlin.driver.remote.DriverRemoteConnection;
g = traversal().withRemote(DriverRemoteConnection.using('0.0.0.0', 8182, "database_name_oe_keyspace_name"))

g.V().outE().inV().path()

But the value of g has to be set in each and every cell of the notebook. Also is there a way that I could enter username and passwords while connecting?

Thanks and Regards,
Gourav Sengupta

[michaelnchin]

Related issues: #206, #324

[michaelnchin]

Hi @gourav-sg, thank you again for submitting this enhancement request!

These requests have implemented in #221 and #356. As of graph-notebook version 3.7.0, users can now specify a custom traversal source and username/password to use for %%gremlin queries.

These fields are configured via the new gremlin section in %%graph_notebook_config, which will look something like:

%%graph_notebook_config
{
  ...
  "gremlin": {
    "traversal_source": "g",
    "username": "user",
    "password": "pass",
    "message_serializer": "graphsonv3"
  },
  ...
}

[michaelnchin]

Closing, as the requested features have been implemented. Please feel free to re-open if you have any additional questions or concerns.

[gourav-sg]

Dear Michael, Thank you so very much. I am still in process of testing this and will surely reach out to you to seek guidance. Thanks, Gourav

…

On Fri, 3 Feb 2023, 01:13 Michael Chin, ***@***.***> wrote: Closed #189 <#189> as completed. — Reply to this email directly, view it on GitHub <#189 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJZLQYSPSVF2B3PCIRYAPLWVRLSHANCNFSM5DLJRCFA> . You are receiving this because you were mentioned.Message ID: ***@***.***>