Guillaume, Your emails a bit confusing, I'll assume that you mean it still didn't work.
I see this error in your logs: 1) Error injecting constructor, com.netflix.astyanax.connectionpool.exceptions.PoolTimeoutException: PoolTimeoutException: [host=127.0.0.1(127.0.0.1):9160, latency=2007(2007), attempts=1]Timed out waiting for connection Are you sure that cassandra is up and running when you're trying this? is port 9160 open? John On Mon, Apr 4, 2016 at 8:54 AM Guillaume <[email protected]> wrote: > Hi, > > I can change my arch in order to keep cassandra out of access for > security. I'll try to access without auth by keeping the followings > parameters by default in /etc/cassandra/cassandra.yml : > > > authenticator: AllowAllAuthenticator > authorizer: AllowAllAuthorizer > > instead of : > > authenticator: PasswordAuthenticator > authorizer: CassandraAuthorizer > > And I changed this keys to empty values > in /usr/share/tomcat7/lib/usergrid-deployment.properties : > > # Set the credentials used for Cassandra, if any. > # > cassandra.username= > cassandra.password= > > I also moved to cassandra 2.2.5 and changed the version in > the /usr/share/tomcat7/lib/usergrid-deployment.properties file. > > # Set a property to tell Usergrid which version of cassandra is being used. > # > cassandra.version=2.2.5 > > LOGS : > #### > > # curl -v 127.0.0.1:9200 > * Rebuilt URL to: 127.0.0.1:9200/ > * Hostname was NOT found in DNS cache > * Trying 127.0.0.1... > * Connected to 127.0.0.1 (127.0.0.1) port 9200 (#0) > > GET / HTTP/1.1 > > User-Agent: curl/7.38.0 > > Host: 127.0.0.1:9200 > > Accept: */* > > > < HTTP/1.1 200 OK > < Content-Type: application/json; charset=UTF-8 > < Content-Length: 332 > < > { > "status" : 200, > "name" : "ES-1", > "cluster_name" : "elasticsearch", > "version" : { > "number" : "1.4.5", > "build_hash" : "2aaf797f2a571dcb779a3b61180afe8390ab61f9", > "build_timestamp" : "2015-04-27T08:06:06Z", > "build_snapshot" : false, > "lucene_version" : "4.10.4" > }, > "tagline" : "You Know, for Search" > } > * Connection #0 to host 127.0.0.1 left intact > > > # nodetool status > Datacenter: datacenter1 > ======================= > Status=Up/Down > |/ State=Normal/Leaving/Joining/Moving > -- Address Load Tokens Owns Host ID > Rack > UN 127.0.0.1 131.37 KB 256 ? > 273f3db2-822a-4ad8-bed7-2176a1fec1b4 rack1 > > Note: Non-system keyspaces don't have the same replication settings, > effective ownership information is meaningless > > > > See attached logs & configs to this email please, > > Regards, > Guillaume > > 2016-04-04 0:34 GMT+01:00 John D. Ament <[email protected]>: > >> Hi Guillaume, >> >> Just wondering, do you require auth to access your cassandra instance? >> >> John >> >> >> On Sun, Apr 3, 2016 at 7:12 PM Guillaume <[email protected]> wrote: >> >>> hi, >>> >>> I tried to init the database with the command : >>> >>> # curl -v -u tron:g1psy -X PUT >>> http://localhost:8080/system/database/setup >>> * Hostname was NOT found in DNS cache >>> * Trying 127.0.0.1... >>> * Connected to localhost (127.0.0.1) port 8080 (#0) >>> * Server auth using Basic with user 'tron' >>> > PUT /system/database/setup HTTP/1.1 >>> > Authorization: Basic dHJvbjpnMXBzeQ== >>> > User-Agent: curl/7.38.0 >>> > Host: localhost:8080 >>> > Accept: */* >>> > >>> < HTTP/1.1 500 Internal Server Error >>> * Server Apache-Coyote/1.1 is not blacklisted >>> < Server: Apache-Coyote/1.1 >>> < Access-Control-Allow-Origin: * >>> < Content-Type: application/json >>> < Content-Length: 218 >>> < Date: Sun, 03 Apr 2016 22:02:13 GMT >>> < Connection: close >>> < >>> * Closing connection 0 >>> {"error":"h_invalid_request","timestamp":1459720933979,"duration":1,"error_description":"InvalidRequestException(why:You >>> have not logged >>> in)","exception":"me.prettyprint.hector.api.exceptions.HInvalidRequestException"}# >>> >>> >>> and from catalina.out error log I get : >>> >>> 2016-04-04 00:02:13,895 INFO (http-bio-8080-exec-8) >>> [org.apache.usergrid.rest.system.DatabaseResource] - DatabaseResource >>> initialized >>> 2016-04-04 00:02:13,897 INFO (http-bio-8080-exec-8) >>> [org.apache.usergrid.rest.system.DatabaseResource] - Setting up Cassandra >>> (runDatabaseSetup) >>> 2016-04-04 00:02:13,977 INFO (http-bio-8080-exec-8) >>> [org.apache.usergrid.corepersistence.CpSetup] - Creating static application >>> keyspace Usergrid_Applications >>> 2016-04-04 00:02:13,978 ERROR (http-bio-8080-exec-8) >>> [org.apache.usergrid.rest.exceptions.ThrowableMapper] - An uncaught >>> exception occurred during HTTP invocation >>> me.prettyprint.hector.api.exceptions.HInvalidRequestException: >>> InvalidRequestException(why:You have not logged in) >>> at >>> me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:52) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:195) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:185) >>> at >>> me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.java:104) >>> at >>> me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:253) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster.describeKeyspace(AbstractCluster.java:199) >>> at >>> org.apache.usergrid.persistence.cassandra.CassandraService.keySpaceExists(CassandraService.java:299) >>> at >>> org.apache.usergrid.persistence.cassandra.CassandraService.createColumnFamily(CassandraService.java:269) >>> at >>> org.apache.usergrid.corepersistence.CpSetup.setupStaticKeyspace(CpSetup.java:176) >>> at >>> org.apache.usergrid.corepersistence.CpSetup.initSubsystems(CpSetup.java:86) >>> at >>> org.apache.usergrid.corepersistence.CpEntityManagerFactory.setup(CpEntityManagerFactory.java:520) >>> at >>> org.apache.usergrid.rest.system.DatabaseResource.runDatabaseSetup(DatabaseResource.java:72) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at >>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>> at >>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) >>> at >>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267) >>> at >>> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) >>> at >>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292) >>> at >>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1139) >>> at >>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:548) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:489) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:426) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) >>> at >>> org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) >>> at >>> org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) >>> at >>> org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) >>> at >>> org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) >>> at >>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) >>> at >>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.usergrid.rest.filters.ContentTypeFilter.doFilter(ContentTypeFilter.java:94) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >>> at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >>> at >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) >>> at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >>> at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >>> at >>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >>> at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >>> at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >>> at >>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) >>> at >>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >>> at >>> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) >>> at >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >>> at >>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: InvalidRequestException(why:You have not logged in) >>> at >>> org.apache.cassandra.thrift.Cassandra$describe_keyspace_result.read(Cassandra.java:29013) >>> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) >>> at >>> org.apache.cassandra.thrift.Cassandra$Client.recv_describe_keyspace(Cassandra.java:1276) >>> at >>> org.apache.cassandra.thrift.Cassandra$Client.describe_keyspace(Cassandra.java:1263) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:190) >>> ... 67 more >>> 2016-04-04 00:02:13,979 ERROR (http-bio-8080-exec-8) >>> [org.apache.usergrid.rest.exceptions.AbstractExceptionMapper] - >>> me.prettyprint.hector.api.exceptions.HInvalidRequestException 5XX Uncaught >>> Exception (500) >>> me.prettyprint.hector.api.exceptions.HInvalidRequestException: >>> InvalidRequestException(why:You have not logged in) >>> at >>> me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(ExceptionsTranslatorImpl.java:52) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:195) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:185) >>> at >>> me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.java:104) >>> at >>> me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover(HConnectionManager.java:253) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster.describeKeyspace(AbstractCluster.java:199) >>> at >>> org.apache.usergrid.persistence.cassandra.CassandraService.keySpaceExists(CassandraService.java:299) >>> at >>> org.apache.usergrid.persistence.cassandra.CassandraService.createColumnFamily(CassandraService.java:269) >>> at >>> org.apache.usergrid.corepersistence.CpSetup.setupStaticKeyspace(CpSetup.java:176) >>> at >>> org.apache.usergrid.corepersistence.CpSetup.initSubsystems(CpSetup.java:86) >>> at >>> org.apache.usergrid.corepersistence.CpEntityManagerFactory.setup(CpEntityManagerFactory.java:520) >>> at >>> org.apache.usergrid.rest.system.DatabaseResource.runDatabaseSetup(DatabaseResource.java:72) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at >>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>> at >>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) >>> at >>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267) >>> at >>> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) >>> at >>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292) >>> at >>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1139) >>> at >>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:548) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:489) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:426) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) >>> at >>> org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) >>> at >>> org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) >>> at >>> org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) >>> at >>> org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) >>> at >>> org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) >>> at >>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) >>> at >>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.usergrid.rest.filters.ContentTypeFilter.doFilter(ContentTypeFilter.java:94) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >>> at >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >>> at >>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >>> at >>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >>> at >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) >>> at >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >>> at >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >>> at >>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >>> at >>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >>> at >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) >>> at >>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) >>> at >>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) >>> at >>> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) >>> at >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >>> at >>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: InvalidRequestException(why:You have not logged in) >>> at >>> org.apache.cassandra.thrift.Cassandra$describe_keyspace_result.read(Cassandra.java:29013) >>> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) >>> at >>> org.apache.cassandra.thrift.Cassandra$Client.recv_describe_keyspace(Cassandra.java:1276) >>> at >>> org.apache.cassandra.thrift.Cassandra$Client.describe_keyspace(Cassandra.java:1263) >>> at >>> me.prettyprint.cassandra.service.AbstractCluster$4.execute(AbstractCluster.java:190) >>> ... 67 more >>> 2016-04-04 00:02:13,980 ERROR (http-bio-8080-exec-8) >>> [org.apache.usergrid.rest.exceptions.AbstractExceptionMapper] - Server >>> Error (500): >>> {"error":"h_invalid_request","timestamp":1459720933979,"duration":1,"error_description":"InvalidRequestException(why:You >>> have not logged >>> in)","exception":"me.prettyprint.hector.api.exceptions.HInvalidRequestException"} >>> >>> What's wrong here please ? >>> >>> >
