[jira] [Commented] (CASSANDRA-12642) cqlsh NoHostsAvailable/AuthenticationFailure when sourcing a file with COPY commands

["Adam Holmberg (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-12642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15491510#comment-15491510 ] 

Adam Holmberg commented on CASSANDRA-12642:
-------------------------------------------

[3.9|https://github.com/apache/cassandra/compare/cassandra-3.9...aholmberg:12642-3.9]
[2.2|https://github.com/apache/cassandra/compare/cassandra-2.2...aholmberg:12642-2.2] / [3.0|https://github.com/apache/cassandra/compare/cassandra-3.0...aholmberg:12642-3.0]

2.2/3.0 are the same; 3.9 had one additional parameter.

> cqlsh NoHostsAvailable/AuthenticationFailure when sourcing a file with COPY commands
> ------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-12642
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12642
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Adam Holmberg
>            Priority: Minor
>
> In {{cqlsh}}, with authentication enabled, when sourcing a file with {{COPY}} commands in it:
> {noformat}
> test.cql:2:Error for (None, None): Failed to connect to all replicas ['127.0.0.1'] for (None, None), errors: ["NoHostAvailable - ('Unable to connect to any servers', {'127.0.0.1': AuthenticationFailed('Remote end requires authentication.',)})"] (permanently given up after 0 rows and 5 attempts)
> {noformat}
> {{cqlsh}} creates a new {{Shell}} without passing all pertinent arguments. When {{copyutil}} creates new cluster connections, they are not initialized correctly.
> This is only for the {{source}} command. As a workaround,  {{cqlsh -f <script>}}  works, since it does not create a new {{Shell}} instance.
> Repro:
> {code}
> ccm create -v 3.7 -n 1 test
> ccm updateconf "authenticator: PasswordAuthenticator" "authorizer: CassandraAuthorizer"
> ccm start
> echo "copy system.local to 'something';" > test.cql
> echo "source 'test.cql'" | ccm node1 cqlsh
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)