Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

access CDSW database without CM

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Explorer

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

View solution in original post

5 REPLIES 5

avatar
Master Collaborator

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

avatar
Explorer

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 

 

 

avatar
Explorer

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
```

avatar
Explorer

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

avatar
Explorer

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)