No options to set SSL on JDBC driver during ambari-server setup

apiwoni1 · ‎12-04-2018

I'm looking at options for ambari-server setup and I don't see anything to enable SSL connectivity. I have automated Chef script that does install so going back to Ambari UI and adjusting JDBC url is not an option even if possible.

I'm going to test a little hack like --databasename=ambari?ssl=true

Usage: ambari-server.py action [options]
  Database options (command need to include all options):
    --database=DBMS     Database to use
                        embedded|oracle|mysql|mssql|postgres|sqlanywhere
    --databasehost=DATABASE_HOST
                        Hostname of database server
    --databaseport=DATABASE_PORT
                        Database port
    --databasename=DATABASE_NAME
                        Database/Service name or ServiceID
    --databaseusername=DATABASE_USERNAME
                        Database user login
    --databasepassword=DATABASE_PASSWORD
                        Database user password


  JDBC options (command need to include all options):
    --jdbc-driver=JDBC_DRIVER
                        Specifies the path to the JDBC driver JAR file or
                        archive with all required files(jdbc jar, libraries
                        and etc), for the database type specified with the
                        --jdbc-db option. Used only with --jdbc-db option.
                        Archive is supported only for sqlanywhere database.
    --jdbc-db=JDBC_DB   Specifies the database type
                        [postgres|mysql|mssql|oracle|hsqldb|sqlanywhere] for
                        the JDBC driver specified with the --jdbc-driver
                        option. Used only with --jdbc-driver option.

aquilodran · ‎12-05-2018

Hi @Andre Piwoni,

As you said, there isn't an option for that, but after the setup you can check the ambari.properties about jdbc related properties maybe you can edit an url there which is generated by the jdbc setup.

Regards,

AQ