Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

scm_prepare_database.sh

Highlighted

scm_prepare_database.sh

I have been trying to follow the installation procedure as closely as possible for CDH 5.3

 

I got to this page:

 

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cm_ig_installing_config...

 

I got to the section titled "Preparing an Cloudera Manager Server External Database" and then it instructs me to run the scm_prepare_database.sh script.

 

I was not planning to install from a tarball, and prior to that point the instructions have not told me to download the installer or package install.  The path it tells me the script will be in does not exist.

 

Should I download the tarball and run it from there?  Should I have already downloaded and ran the installer by this point?  because the instructions told me to run that first.

 

Somebody please explain how I was supposed to do this.

10 REPLIES 10
Highlighted

Re: scm_prepare_database.sh

Explorer
Highlighted

Re: scm_prepare_database.sh

It actually does not matter if you choose installation path A or B, either way the first thing it tells you to do is to set up your database.  They both take you to this page:

 

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cm_ig_installing_config...

 

From the table of contents at the top of the page, there are four links, I was clicking the second one "Setting up the Cloudera Manager Server Database"

 

There were two bold sections beneath that:  "Installing and Starting the Cloudera Manager Server Embedded Database" and "Preparing an Cloudera Manager Server External Database".  Since I was trying to set up an external database I skipped the first of those two sections and went straight to the second.  That's when I realized it wanted me to execute a script that I don't have.

 

After re-reading the instructions carefully for a couple more hours, I figured out that I did NOT miss a step, and in fact that your instructions are just misguiding me.  I figured out that I was not supposed to do either of those sections, I was supposed to skip them and move to the bottom of the page:

 

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cm_ig_installing_config...

 

I think the reason these instructions are so unclear is that you put all of them in order and tell people to jump around from section to section, page to page, and it's not clear where you are supposed to resume. 

 

Quite honestly these are some of the most confusing installation instructions I have ever seen.

Re: scm_prepare_database.sh

I would like to add that I just realized those two links both go straight to the top of the same page, not to the anchor for the sub-section on the page.  So copying the link over twice accomplished nothing.

 

I tried to fix it but apparently when I click the "options" button next to my post, it just scrolls to the top of the page instead of presenting me with any options.  Seems like the options button is broken.

Highlighted

Re: scm_prepare_database.sh

Cloudera Employee

I agree the links are confusing and I will address that in the next doc update. 

 

The prepare script is not installed until after you install the Cloudera Manager packages. You install and configure the external database as described in MySQL Database, Oracle Database, or External PostgreSQL Database.

 

After you install the Cloudera Manager packages (Install the Cloudera Manager Server Packages), you run the database setup script as described here: Preparing a Cloudera Manager Server External Database.

Highlighted

Re: scm_prepare_database.sh

New Contributor

Hello. I have a doubt about Cloudera’s installation doc, on cloudera manager and CDH (path B). I think the instructions aren´t clear.

 

I am consulting this link https://www.cloudera.com/documentation/enterprise/5-8-x/topics/cm_ig_install_path_b.html and on the topic “before you begin”, there is a point “install and configure external databases”.

 

Into the last topic, your documentation says that I need prepare cloudera Manager External Database, in my case MySQL, and for this propose, I will be run  “scm_prepare_database.sh”, but I can’t access to the resource, because this link (https://www.cloudera.com/documentation/enterprise/5-8-x/topics/cm_ig_installing_configuring_dbs.html... ) redirect me to the same page, At the section “scm_prepare_database.sh Syntax”, and isn´t clear how to get the “scm_prepare_database.sh” file.

I have checked the post https://community.cloudera.com/t5/Cloudera-Manager-Installation/scm-prepare-database-sh/td-p/23423 but I think it has redundancy because the scm_prepare_database.sh  is required to continue with the installation.

 

I have downloaded the “cloudera quisckstart MV 5.8 and search into ‘/usr/share/cmf/schema’ and I found the “scm_prepare_database.sh” file, but I don’t know if   is the correct to run this file on my installation.

 

Can you please clarified this issue or provide a more clear documentation?

Thanks for your help

Highlighted

Re: scm_prepare_database.sh

New Contributor

I am unable to find scm_prepare_database.sh file. Where can i get this from?

I am following the steps in this doc:

https://www.cloudera.com/documentation/enterprise/5-6-x/topics/cm_ig_oracle.html

Highlighted

Re: scm_prepare_database.sh

Expert Contributor

Hello,

The procedure for installing Cloudera Manager would typically look something like what is shown below.

 

1.) Install the JDK.

2.) Setup an RDB system such as MySQL, Oracle, PostgreSQL if you are using an external database system.

3.) Obtain and deploy the RDB JDBC driver/connector for your selected database type. (Typically placed in /usr/share/java)

4.) Install the Cloudera Manager software packages.

5.) Prepare the Cloudera Manager database using scm_prepare_database.sh.

6.) Configure Cloudera Manager so that it connects to your database. (/etc/cloudera-scm-server/db.properties)

7.) Start Cloudera Manager.

 

The intallation phases in the top level document may help make this a little more visible.

https://www.cloudera.com/documentation/enterprise/latest/topics/installation_installation.html#insta...

 

Note: The tool scm_prepare_database.sh is part of the package you used to install the Cloudera Manager software suite. It will not be available on your host operating system until that software is installed.

https://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_installing_configuring_dbs.htm...

---
Customer Operations Engineer | Security SME | Cloudera, Inc.
Highlighted

Re: scm_prepare_database.sh

Expert Contributor

Thanks for the install steps. However when following the latest Cloudera 5.15 install doc for Ubuntu, when we reach Step 5: Set up the Cloudera Manager Database, the script is not found in the location /opt/cloudera/cm/schema/scm_prepare_database.sh in Ubuntu. However I found a similar named script in /usr/share/cmf/schema/scm_prepare_database.sh . Is it ok to run the script from this different location? Also does the Cloudera install document need to be corrected ? Thanks!

Highlighted

Re: scm_prepare_database.sh

Expert Contributor

Hello,

 

I'm not certain where you are obtaining the path located in /opt. Can you please link to the page in our documentation which points to a different location than the one you are trying to use?

 

The correct path is /usr/share/cmf/schema/scm_prepare_database.sh

 

https://www.cloudera.com/documentation/enterprise/latest/topics/prepare_cm_database.html

https://www.cloudera.com/documentation/enterprise/latest/topics/prepare_cm_database.html#scm_prepare...

---
Customer Operations Engineer | Security SME | Cloudera, Inc.
Don't have an account?
Coming from Hortonworks? Activate your account here