search

Stratio / cassandra-lucene-index

Lucene based secondary indexes for Cassandra
Apache License 2.0
600 stars 170 forks source link

Thingsboard cassandra cql schema Installing getting error #386

Open srimathselva opened 6 years ago

srimathselva commented 6 years ago

hi, Trying to connect cqlsh on Linux 16.0.4 for thingsboard database . but its not connecting throwing the following error .

Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error: Connection refused")}) .

So that i up-down the cassandra version from 3.11.2 to 2.2.11. now able to connect cqlsh . but not able to install cassandra database getting following error.

GETTING ERROR : Starting ThingsBoard Installation... Installing DataBase schema... Installing Cassandra DataBase schema... Unexpected error during ThingsBoard installation! com.datastax.driver.core.exceptions.SyntaxError: line 1:7 no viable alternative at input 'MATERIALIZED' ([CREATE] MATERIALIZED...) at com.datastax.driver.core.exceptions.SyntaxError.copy(SyntaxError.java:58) at com.datastax.driver.core.exceptions.SyntaxError.copy(SyntaxError.java:24) at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37) at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:63) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) at org.thingsboard.server.service.install.CassandraDatabaseSchemaService.lambda$loadCql$0(CassandraDatabaseSchemaService.java:58)

thanks,