Requisites are:
OS-CentOS-6.6/Redhat-6.7
MapR-5.1
Hue-3.9
MySql
Steps:
Here Hue and MySql is installed
on different nodes.
MySql Host:Host1
MapR-Hue Host:Host2
On Host1 Host, do below steps:
Confirm before going to install it using rpm -qa command.
Step 1:
>rpm -qa | grep mysql-devel
If not installed , do below
execution.
>yum install mysql-devel
Step 2:
rpm -qa | grep
mysql-connector-java
If not installed , do below
execution.
>yum install
mysql-connector-java
Step 3:
> rpm -qa | grep mysql-server
If not installed , do below
execution
>yum install mysql-server
Step 4:Change the /etc/my.cnf
file as follows:
>vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
bind-address=Host1
#This IP is MySql installed
Host.
default-storage-engine=InnoDB
sql_mode=STRICT_ALL_TABLES
Step 5:
Start the mysql daemon.
$ sudo service mysqld start
Step 6:
Configure the Mysql with
password, initially MySql pwd could be not set, please set here with
pwd.
>/usr/bin/mysql_secure_installation
Enter current password for root (enter for none):
OK, successfully used password, moving on...
[...]
Set root password? [Y/n] y
New password:x
Re-enter new password:x
Remove anonymous users? [Y/n] Y
[...]
Disallow root login remotely? [Y/n] N
[...]
Remove test database and access to it [Y/n] Y
[...]
Reload privilege tables now? [Y/n] Y
All done!
(#Here I have provided password
as “ x ”)
Step 7:
>mysql> drop database hue;
Create a database for Hue with
name “hue” in mysql by using below command.
mysql> create database hue;
Query OK, 1 row affected (0.00
sec)
Here the Host Host2 is the HUE
installation HostName.
mysql> grant all on hue.* to
'hue'@Host2 identified by 'x';
Query OK, 0 rows affected (0.00
sec)
# here 'x' is the mysql password
mysql> flush privileges;
Query OK, 0 rows affected (0.00
sec)
Step 8:
In Hue installed Host Host2,
Edit the hue.ini file with this information.
> vi
/opt/mapr/hue/hue-3.9.0/desktop/conf/hue.ini
[[database]]
host=Host1
port=3306
engine=mysql
user=hue
password=x
name=hue
Add the below details under “#
Settings for the RDBMS application “
> vi
/opt/mapr/hue/hue-3.9.0/desktop/conf/hue.ini
[librdbms]
[[databases]]
#Add
at MySql settings area.
host=Host1
port=3306
engine=mysql
user=hue
password=x
name=hue
Step 9:
Do these steps in Hue
installation Host i.e. Host2
>/opt/mapr/hue/hue-3.9.0/build/env/bin/hue
dumpdata > bkpHueData.json
Delete the data in the file in
“model “ field if any thing with "useradmin.userprofile"
, remove that json file and save it.
Check if any words are
presenting with "useradmin.userprofile" string in backup
file.
>cat bkpHueData.json | grep
useradmin.userprofile
Step 10:
Restart the Hue serverice
> maprcli node services
-name hue -action restart -nodes `hostname`
Syncdb operation:
/opt/mapr/hue/hue-3.9.0/build/env/bin/hue
syncdb --noinput
Migrating the hue.
/opt/mapr/hue/hue-3.9.0/build/env/bin/hue
migrate
From Host1 Mysql Installed
Host execute this command.
Step 11:
From MySql Host do the below
operation:
mysql> DELETE FROM
hue.django_content_type;
Step 12:
From Host2, Hue installed host
do this command.
>
/opt/mapr/hue/hue-3.9.0/build/env/bin/hue loaddata bkpHueData.json
Start the Hue UI using the Url.
“ :8888 ” at url browser.
Try to add a user to “ AddUser
“ are at mapr user and add it and check the updated table info at
mysql using below command/.
mysql> select *from
auth_user;
(It ll display the recently
added user info in this table.)
