Skip to main content
grlzz
grlzz
Gold ⭐️
January 13, 2022
Solved

access CDSW database without CM

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

grlzz
grlzzAnswer
Gold ⭐️
January 21, 2022

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 in thread

5 replies

aakulov
Platinum ⭐️
aakulov
Platinum ⭐️
January 13, 2022

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

Translate
grlzz
grlzzAuthor
Gold ⭐️
January 13, 2022

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 

 

 

Translate
grlzz
grlzzAuthor
Gold ⭐️
January 13, 2022

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

Translate
grlzz
grlzzAuthorAnswer
Gold ⭐️
January 21, 2022

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

Translate
grlzz
grlzzAuthor
Gold ⭐️
January 21, 2022

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)

Translate
Terms & ConditionsAccessibility statement