Connect Hue to MySQL or MariaDB

mysql -u root -p
Enter password: <root password>

MariaDB [(none)]> CREATE DATABASE hue DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> GRANT ALL ON hue.* TO 'hue'@'%' IDENTIFIED BY '<password>';
Query OK, 0 rows affected (0.00 sec)

mysql -u hue -p
Enter password: <password>
quit

1. In Cloudera Manager, navigate to Cluster > Hue.
2. Select Actions > Stop.

1. Select Actions > Dump Database.
2. Click Dump Database. The file is written to /tmp/hue_database_dump.json on the host of the Hue server.
3. Log on to the host of the Hue server in a command-line terminal.
4. Edit /tmp/hue_database_dump.json by removing all objects with useradmin.userprofile in the model field. For example:

   # Count number of objects
   grep -c useradmin.userprofile /tmp/hue_database_dump.json

   vi /tmp/hue_database_dump.json

   {
     "pk": 1,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:06:13",
       "creation_method": "HUE",
       "first_login": false,
       "user": 1,
       "home_directory": "/user/admin"
     }
   },
   {
     "pk": 2,
     "model": "useradmin.userprofile",
     "fields": {
       "last_activity": "2016-10-03T10:27:10",
       "creation_method": "HUE",
       "first_login": false,
       "user": 2,
       "home_directory": "/user/alice"
     }
   },

1. Go to Hue > Configuration.
2. Filter by category, Database.
3. Set the following database parameters:
   • Hue Database Type: MySQL
   • Hue Database Hostname: FQDN of host running MySQL server
   • Hue Database Port: 3306,5432, or 1521
   • Hue Database Username: username
   • Hue Database Password: password
   • Hue Database Name: Hue database name or SID
4. Click Save Changes.

1. Select Actions > Synchronize Database
2. Click Synchronize Database.

1. Log on to the host of the MySQL server in a command-line terminal.

   mysql -u root -p
   Enter password: <root password>

2. Drop the foreign key constraint from the auth_permission table in the hue database.

   SHOW CREATE table hue.auth_permission;
   ALTER TABLE hue.auth_permission DROP FOREIGN KEY content_type_id_refs_id_id value;

3. Clean the table, django_content_type.

   DELETE FROM hue.django_content_type;

   
   
   
   
   
4. In Cloudera Manager, load the JSON file: select Actions > Load Database and click Load Database.
5. Add the foreign key back:

   ALTER TABLE hue.auth_permission ADD FOREIGN KEY (content_type_id) REFERENCES django_content_type (id);

1. Navigate to Cluster > Hue, if not already there.
2. Select Actions > Start.
3. Click Start.
4. Click Hue Web UI to log on to Hue with a custom MySQL database.