FAQ
Hi,

I initially setup CM4 entreprise using the embedded Postgresql DB on the
SCM hosts without the management services and now have a cluster of 22
nodes running. We are planning to grow the number of nodes and I'd like to
"add cloudera management services" using an external Mysql DB. Can the
initial scm postgresql config live still use the embedded Postgresql SCM DB
and have the cloudera management services databases (activity monitor,
service monitor, report manager, host monitor) on an external MySQL DB?

If not how can I migrate from Postgresql to mysql DB to hosts the SCM and
the service databases?


Thank you

Search Discussions

  • Wongster80 at Jan 28, 2013 at 5:01 pm
    I also attempted to "add the cloudera management services" to a added host
    with Mysql. I created the DB (activity monitor, service monitor, report
    manager, host monitor) on the external Mysql instance and I'm able to
    connect from the currently running SCM server to the MySQL DBs
    remotely using MySQL client. I also added the mysql-java-connector. When
    I run the "test connections" I get:

    "*Logon denied for user/password. Able to find the database server and
    database, but logon request was rejected."*
    *
    *
    in /var/log/cloudera-scm-server/cloudera-scm-server.log, I see:*
    *

    + exec /usr/java/jdk1.6.0_33/bin/java -cp
    '/var/run/cloudera-scm-agent/process/1251-HOSTMONITOR-test-db-connection:/usr/share/java/mysql-connector-java.jar:/usr/share/cmf/lib/*'
    com.cloudera.enterprise.db
    util.DbCommandExecutor db.properties

    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractOneOffHostCommand@133] Unsuccessful
    'RepMgrTestDatabaseConnection'
    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractDbConnectionTestCommand@233] Command exited
    with code: 8
    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractDbConnectionTestCommand@235] + '[' -e
    /usr/lib/jvm/j2sdk1.6-oracle/bin/java ']'


    I cannot continue with the installation of the management services. Can
    someone help?


    Thanks

    On Monday, January 28, 2013 8:51:11 AM UTC-8, wongster80 wrote:

    Hi,

    I initially setup CM4 entreprise using the embedded Postgresql DB on the
    SCM hosts without the management services and now have a cluster of 22
    nodes running. We are planning to grow the number of nodes and I'd like to
    "add cloudera management services" using an external Mysql DB. Can the
    initial scm postgresql config live still use the embedded Postgresql SCM DB
    and have the cloudera management services databases (activity monitor,
    service monitor, report manager, host monitor) on an external MySQL DB?

    If not how can I migrate from Postgresql to mysql DB to hosts the SCM and
    the service databases?


    Thank you
  • Vikas Singh at Jan 28, 2013 at 6:51 pm
    Hi Wong,

    You should be able to connect to MySQL from the hosts where Mgmt Services
    are going to be run (and *not* from where *SCM Server* is running). Do you
    get connection denied for any one service or for all services?

    Try connecting using mysql client from those hosts and see if that works.
    The Database connection test logs with more information can be found in
    /var/run/cloudera-scm-agent/process/*DbTestConnection* directory.

    On Mon, Jan 28, 2013 at 9:00 AM, wongster80 wrote:

    I also attempted to "add the cloudera management services" to a added host
    with Mysql. I created the DB (activity monitor, service monitor, report
    manager, host monitor) on the external Mysql instance and I'm able to
    connect from the currently running SCM server to the MySQL DBs
    remotely using MySQL client. I also added the mysql-java-connector. When
    I run the "test connections" I get:

    "*Logon denied for user/password. Able to find the database server and
    database, but logon request was rejected."*
    *
    *
    in /var/log/cloudera-scm-server/cloudera-scm-server.log, I see:*
    *

    + exec /usr/java/jdk1.6.0_33/bin/java -cp
    '/var/run/cloudera-scm-agent/process/1251-HOSTMONITOR-test-db-connection:/usr/share/java/mysql-connector-java.jar:/usr/share/cmf/lib/*'
    com.cloudera.enterprise.db
    util.DbCommandExecutor db.properties

    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractOneOffHostCommand@133] Unsuccessful
    'RepMgrTestDatabaseConnection'
    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractDbConnectionTestCommand@233] Command
    exited with code: 8
    2013-01-28 16:24:02,359 INFO
    [CommandPusher:service.AbstractDbConnectionTestCommand@235] + '[' -e
    /usr/lib/jvm/j2sdk1.6-oracle/bin/java ']'


    I cannot continue with the installation of the management services. Can
    someone help?


    Thanks

    On Monday, January 28, 2013 8:51:11 AM UTC-8, wongster80 wrote:

    Hi,

    I initially setup CM4 entreprise using the embedded Postgresql DB on the
    SCM hosts without the management services and now have a cluster of 22
    nodes running. We are planning to grow the number of nodes and I'd like to
    "add cloudera management services" using an external Mysql DB. Can the
    initial scm postgresql config live still use the embedded Postgresql SCM DB
    and have the cloudera management services databases (activity monitor,
    service monitor, report manager, host monitor) on an external MySQL DB?

    If not how can I migrate from Postgresql to mysql DB to hosts the SCM and
    the service databases?


    Thank you

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedJan 28, '13 at 4:51p
activeJan 28, '13 at 6:51p
posts3
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Wongster80: 2 posts Vikas Singh: 1 post

People

Translate

site design / logo © 2022 Grokbase