access CDSW database without CM

[#1]

Hi, 

our CDH CM is down (difficult issue, related to certificates renewal), so we would like to access everything related to the workbench (sessions, projects, ...) from terminal

(I guess there is a database on the CDSW host related to that...)

thanks for help

[#2]

Hi @grlzz ,

CDSW is typically installed/runs on edge nodes, so CM going down does not necessarily preclude you from accessing CDSW. However, if certs expired across the cluster then all services may be inaccessible.

Regarding your question for command line access to CDSW. There is a CLI you can use for that: https://docs.cloudera.com/cdsw/1.9.2/cli-reference/topics/cdsw-cli-reference.html 

The first thing you'll need to do to use the CLI is to generate some access keys from CDSW UI, so if you can't access CDSW UI, then you may be stuck until that is resolved. 

Have you opened a support case for this?

Kind regards,

Alex Akulov

[#3]

Hi @aakulov, 

thanks for your reply.

Yes, here is the case https://my.cloudera.com/cases/834870/comments

Regarding the CLI / UI:

no, we cannot use the UI unfortunately... 😕 We got pretty nasty issues with certs , freeIPA, kerberos... we put a lot of effort last month, but we couldn't sort it out

https://my.cloudera.com/cases/816909/comments

https://my.cloudera.com/cases/818773/comments

https://my.cloudera.com/cases/824026/comments

Therefore , I was wondering whether there is a way to access CDSW database (there should be one, somewhere), without the UI , like we can access hue, oozie, etc... databases , via mysql (without having those services running)

Thanks again 

[#4]

in case, on the cdsw host , `sudo cdsw status` returns

```
Sending detailed logs to [/tmp/cdsw_status_TJ0DRz.log] ...
CDSW Version: [1.7.2.2066404:fc261c3]
Installed into namespace 'default'
OK: Application running as root check
OK: NFS service check
Processes are not running: [dockerd, kubelet]. Check the CDSW role logs in Cloudera Manager for more details.
OK: Sysctl params check
OK: Kernel memory slabs check
Failed to connect to Kubernetes Master api.
Checking web at url
Web is not yet up.
Cloudera Data Science Workbench is not ready yet
```

[#5 · Accepted solution]

Hi, 

just for future readers:

I found what I need to restore the work before CDH crashed in:

/var/lib/cdsw/current/projects/projects

thanks anyways

[#6]

better than nothing, although the whole information (with metadata) would be reconstructed using the associated postgreSQL 

(not possible in our case as CDSW and kubeclt are down)