orzhaha/cassandra-web

cassandra web ui

cassandra-web's Issues

This Docker build is not compatible with ARM platform

I have tried to build the project on ARM platform and its failing with below error

xec /bin/sh: exec format error

It seems the source is not compatible with ARM. Could you please make this ARM platform compatible also.

Unable to connect to cassandra: unable to create session: unable to discover protocol version: authentication required

Hi,

I have tried deploying cassandra-web to kubernetes and hook it up with bitnami-cassandra, but the app fails with the following error:

{"time":"2020-08-20T09:08:51.771615881Z","level":"INFO","prefix":"-","file":"main.go","line":"131","message":"Cofing 設定成功"}
{"time":"2020-08-20T09:08:51.819951735Z","level":"FATAL","prefix":"-","file":"main.go","line":"154","message":"gocql: unable to create session: unable to discover protocol version: authentication required (using \"org.apache.cassandra.auth.PasswordAuthenticator\")"}

My deployment manifest looks like:

apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app: cassandra-web
  name: cassandra-web
  namespace: pipeline
spec:
  replicas: 1
  selector:
    matchLabels:
      app: cassandra-web
  strategy:
    rollingUpdate:
      maxSurge: 25%
      maxUnavailable: 25%
    type: RollingUpdate
  template:
    metadata:
      labels:
        app: cassandra-web
    spec:
      containers:
      - name: cassandra-web
        image: ipushc/cassandra-web:latest
        imagePullPolicy: IfNotPresent
        env:
        - name: HOST_PORT
          value: ":80"
        - name: CASSANDRA_HOST
          value: cassandra.pipeline.svc.cluster.local # <- tried with cassandra-headless too
        - name: CASSANDRA_PORT
          value: "9042"
        - name: CASSANDRA_USERNAME
          value: cassandra
        - name: CASSANDRA_PASSWORD
          valueFrom:
            secretKeyRef:
              key: cassandra-password
              name: cassandra
        ports:
        - containerPort: 80
          name: http
          protocol: TCP
        resources: {}

跪求新增清空table功能 在瀏覽tables的畫面

語法如下：
https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlTruncate.html

add table Columns

table page add table columns

api reference https://github.com/orzhaha/cassandra-web#columns-get-table-columns

Questions about enable_materialized_views and enable_transient_replication

Thanks for providing this useful container.

I have a question about two cassandra configs: enable_materialized_views and enable_transient_replication. It seems the official document says "Materialized views are considered experimental and are not recommended for production use." And the default value for these two parameters are False in the document. They say they will disable them in Cassandra 4.

However, in the latest version of Cassandra (3.11.4), the default value for them are still True, as is the setting in your container's cassandra.yaml.

Shall we disable them manually for now?
Thanks!

add Describe

table page add table Describe info

api reference https://github.com/orzhaha/cassandra-web#describe-cqlsh-describe

Security of the app

Hello,

1. This app requires that both CASSANDRA_USERNAME and CASSANDRA_PASSWORD are defined.
   This means that anyone accessing the URL of the webapp automatically has full access to the database.
   Not only that, it also means that the superuser's password is hardcoded in a file.

Would it be possible to not have to provide these environment variables, and instead have a Log In front page, where we can just enter the username and password?

2. The HTML assets are using absolute paths:

        <link href=/static/css/chunk-vendors.62e245e7.css rel=preload as=style>
        <link href=/static/css/index.9c79d7e1.css rel=preload as=style>
        <link href=/static/js/chunk-vendors.f1428dfc.js rel=preload as=script>
        <link href=/static/js/index.ab7d7262.js rel=preload as=script>
        <link href=/static/css/chunk-vendors.62e245e7.css rel=stylesheet>
        <link href=/static/css/index.9c79d7e1.css rel=stylesheet>

        <script src=/static/js/chunk-vendors.f1428dfc.js></script>
        <script src=/static/js/index.ab7d7262.js></script>

Is it possible to either make these "relative" paths (instead of absolute), or allow us to provide an environment variable that says what the "prefix" should be?

That way, we'd be able to set this webapp inside a subpath, e.g. admin.mydomain.com/cassandra-web/

Thank you very much

Update the text field Error when use json data

unable to cast map[string]interface {}

Helm Chart Ingress Labels are broken

There's no cassandra-web.labels defined in the helper template

Publish Helm chart

Do you consider to publish the helm chart as a public repository, so the user just have execute "helm install" without cloning your repo?

Need to be able to configure service port and targetPort separately in helm chart.

Running as non-root can cause problems if you're using port 80 as the default container target port, resulting in sporadic downtime for the UI deployment. Target port should be configured through its own value, distinct from service port.

Helm 3 chart usage

is helm chart still supported? any special repo i should add to make it work?
when trying to deploy the chart as described

helm install cassandra-web cassandra-web --namespace default -f cass-web.yml 

i am getting

Error: failed to download "cassandra-web" 

Helm version

version.BuildInfo{Version:"v3.3.2", GitCommit:"e5077257b6ca106d1f65652b4ca994736d221ab1", GitTreeState:"clean", GoVersion:"go1.14.9"}

Questions about enable_materialized_views and enable_transient_replication

Thanks for providing this useful container! I have a question about two cassandra configs: enable_materialized_views and enable_transient_replication. It seems the official document
does not recommend to enable them in production but you set that to be enabled in /etc/cassandra/cassandra.yaml:

Shall we disable them?
Thanks!

Two Remote Code Execution vulnerabilities in this project...

Hello. Found two remote code execution vulnerables in this project. Both trivially exploitable.
Sent you a patch via email 10 days ago as i don't want to post this here. Email went to k*****[email protected] ..

Security and compliance updates for goland and alpine

To allow use in environments with rigorous CVE requirements, it would be useful to update the dockerfile with updated base images, to at least golang:1.18-alpine for the build server stage and alpine 3.13.8 for the final stage.

It would also make this easier to square with enterprise infosec if the container did not run as root.

[QUESTION]: Cassandra SSL connection

Is it possible to use cassandra-web with encrypted cassandra connection (SSL)? If yes, how?

Can't get data

Cannot get data from a table. Constantly get a "No data" error msg.

Cassandra version: v3.11.9
Running cassandra-web docker image: ipushc/cassandra-web:v1.0.14

• I can see the cables
• The table contains data but no data is returned to the UI.

If you need any other data just let me know.

Fail to build on v1.0.4 because of filure to make client.go

as title.

I can build it on v1.0.3 but not v1.0.4 as client.go cannot be built.

~/go/bin/go-bindata -o=client/client.go -pkg=client client/dist/...
bindata: Failed to stat input path 'client/dist': lstat client/dist: no such file or directory

missing ingress.yaml in helm chart

Hey,

first, thank you for your work, really cool project. I think, the ingress.yaml is missing under "kubernetes/helm/cassandra-web/templates", since there is a configuration for this in values.yaml

跪求資料查詢功能

cassandra-web 在 scylla升級後無法使用 export

cassandra-web 在 scylla升級後無法使用 export

Getting An error

Maybe it's me, not sure!

Read Only View And Read Write view

At present, it only shows a read-write view. Can we have a user interface with read-only option?

Edit/Delete has problem with strings containing numbers containing leading zeros

Hi, there is an issue while editing/deleting rows where the part of the id is a string containing a number with leading zero(s).

We have a following table

create table dps_usage_consumption.evs_to_acc
(
    event_source   text,
    account_num    text,
    bill_event_seq int,
    last_bill_date date,
    next_bill_date date,
    primary key (event_source, account_num)
)

event_source may contain msisdns in international format, like 00421xxxxxxxxx
Unfortunately, when you edit/delete such a row it sends request where the event_source is without leading zeros, like:

{"item":"{\"event_source\":421949323548,\"account_num\":3107413306,\"bill_event_seq\":43,\"last_bill_date\":\"2023-02-01\",\"next_bill_date\":\"2023-02-01\"}","table":"dps_usage_consumption.evs_to_acc"}

I assume it's the problem in method

jsonParams(jsonString) {
      try {
        return JSONbig.parse(jsonString)
      } catch (e) {
        return jsonString
      }
    }

I assume if you send there 00421949323548, the leading zeros are ommited and you get 421949323548.

Can you please look into this? Maybe you should take into account the cassandra types. It's text here, so it shpould be treated as string instead of trying to make it into a bigint.

Thank You

Support Cassandra 4.0

Got this on scylladb 5.0

docker run -p 8080:9090  -e CASSANDRA_HOST=10.71.0.110 -e CASSANDRA_PORT=9042 -e CASSANDRA_USERNAME=cassandra -e CASSANDRA_PASSWORD=cassandra -e HOST_PORT=":9090" ipushc/cassandra-web
{"time":"2022-07-13T05:07:52.167592392Z","level":"INFO","prefix":"-","file":"main.go","line":"131","message":"Cofing 設定成功"}
{"time":"2022-07-13T05:07:52.731531951Z","level":"FATAL","prefix":"-","file":"main.go","line":"154","message":"gocql: unable to create session: unable to discover protocol version: Username and/or password are incorrect"}

Feature request: Support multiple Cassandra nodes

In order to support the non-single point of failure feature of Cassandra, it would be great if we could pass a list of host (perhaps a string comma-separated?). I can see that NewCluster is a variadic function so I believe this shouldn't be too complicated. If you wish, I'm happy to submit a PR although my experience with Golang is close to null ;)

cassandra-web/service/main.go

Line 123 in cb49579

cluster := gocql.NewCluster(env.CassandraHost)

The describe function not work in provided helm app

The /describe

function always get 500.

{ "body": { "message": "exit status 1" }, "debug": { "original": null, "response": { "req": { "method": "GET", "url": "http:///describe?table=system.built_views", "headers": {} }, "xhr": {}, "text": "{"message":"exit status 1"}", "statusText": "Internal Server Error", "statusCode": 500, "status": 500, "statusType": 5, "info": false, "ok": false, "redirect": false, "clientError": false, "serverError": true, "error": { "status": 500, "method": "GET", "url": "http:///describe?table=system.built_views" }, "accepted": false, "noContent": false, "badRequest": false, "unauthorized": false, "notAcceptable": false, "forbidden": false, "notFound": false, "headers": { "connection": "keep-alive", "content-length": "27", "content-type": "application/json; charset=UTF-8", "date": "Fri, 20 Aug 2021 02:32:03 GMT" }, "header": { "connection": "keep-alive", "content-length": "27", "content-type": "application/json; charset=UTF-8", "date": "Fri, 20 Aug 2021 02:32:03 GMT" }, "type": "application/json", "charset": "UTF-8", "links": {}, "body": { "message": "exit status 1" } }, "status": 500 }, "status": 500, "statusText": "Internal Server Error", "text": "{"message":"exit status 1"}", "error": {} }

I also tried tried to use curl it, but it still 500 and without error message in k8s pods log.

my cassandra version is 3.11.11

跪求新增語法匯出/入