大叔经验分享（50）hue访问mysql（librdbms）

 cloudera manager安装hue后想开启访问mysql（librdbms）需要在这里配置（hue_safety_valve.ini）

添加配置如下

[librdbms]
  # The RDBMS app can have any number of databases configured in the databases
  # section. A database is known by its section name
  # (IE sqlite, mysql, psql, and oracle in the list below).
  [[databases]]
    # mysql, oracle, or postgresql configuration.
    [[[mysql]]]
      # Name to show in the UI.
      nice_name="db_dataone"

      # For MySQL and PostgreSQL, name is the name of the database.
      # For Oracle, Name is instance of the Oracle server. For express edition
      # this is 'xe' by default.
      name=db_dataone

      # Database backend to use. This can be:
      # 1. mysql
      # 2. postgresql
      # 3. oracle
      engine=mysql

      # IP or hostname of the database to connect to.
      host=192.168.0.1

      # Port the database server is listening to. Defaults are:
      # 1. MySQL: 3306
      # 2. PostgreSQL: 5432
      # 3. Oracle Express Edition: 1521
      port=3306

      # Username to authenticate with when connecting to the database.
      user=root

      # Password matching the username to authenticate with when
      # connecting to the database.
      password=123456

      # Database options to send to the server when connecting.
      # https://docs.djangoproject.com/en/1.4/ref/databases/
      ## options={}

注意：[[databases]]下可添加多个[[[mysql]]]或其他数据库，如果有多个mysql，分别命名为[[[mysql1]]],[[[mysql2]]]或其他名字区分

 

除此之外，还要添加notebook

[notebook]
[[interpreters]]
[[[impala]]]
name=Impala
[[[hive]]]
name=Hive
[[[mysql]]]
name=Mysql
interface=rdbms
[[[java]]]
name=Java
interface=oozie
[[[spark2]]]
name=Spark
interface=oozie
[[[shell]]]
name=Shell
interface=oozie
[[[sqoop1]]]
name=Sqoop1
interface=oozie
[[[distcp]]]
name=Distcp
interface=oozie

此处略去了不需要的Pig和MapReduce等；

 

然后重启hue

 

 

 

如果要添加多个mysql，如下配置：

[librdbms]
[[databases]]
[[[mysql1]]]
...
[[[mysql2]]]
...
[notebook]
[[interpreters]]
[[[mysql1]]]
...
[[[mysql2]]]
...

 

参考：
https://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Hue-db-editor-permissions/td-p/78298
http://cloudera.github.io/hue/docs-4.4.0/user/editor/
http://cloudera.github.io/hue/latest/administrator/configuration/editor/