Issue:
Whenever you face an issue while launching HUE web UI as specified below in CentOS7/RHEL7 in MapR-.2 platform, please follow below steps.
raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'hue.auth_user' doesn't exist")
To over come this issue, please use below steps:
Environment:
[root@VM206 mapr]# rpm -qa| grep mapr
mapr-core-internal-5.2
mapr-core-5.2
mapr-hue-base-3.9.0
Steps:
Step 1:
Run the following commands to install MariaDB and the Redhat 6 compatibility library:
#yum install mariadb
#ver=$(rpm -qa mariadb|cut -d- -f2)
#rpm -ivh --nodeps http://yum.mariadb.org/$ver/rhel7-amd64/rpms/MariaDB-$ver-centos7-x86_64-compat.rpm
Logging into MariaDB
[root@VM206 mapr]# mysql -u root -p
Enter password:<pwd> (= <puli> )
MariaDB [(none)]> create database hue;
MariaDB [(none)]> grant all on hue.* to 'hue'@10.10.72.206 identified by 'puli';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> use hue;
MariaDB [hue]> show tables;
Empty set (0.00 sec)
step 2:
Run the following command to create a symlink for the Cyrus SASL library:
#ln -s /lib64/libsasl2.so.3.0.0 /lib64/libsasl2.so.2
Step 3:
Run the following command to reconfigure Hue:
#bash -c "source /opt/mapr/hue/hue-3.9.0/build/env/bin/activate;
/opt/mapr/hue/hue-3.9.0/build/env/bin/hue syncdb --noinput;
/opt/mapr/hue/hue-3.9.0/build/env/bin/hue migrate"
Step 4:
Run the following command to restart Hue:
# maprcli node services -name hue -action restart -nodes `hostname`
Verification:
Log in to Hue host:
http://10.10.72.206:8888/
You will be able to see launching the HUE web UI without any issues.
Check in MariaDB:
[root@VM206 mapr]# mysql -u root -p
Enter password:<pwd>
MariaDB [(none)]> use hue;
MariaDB [hue]> show tables;
+--------------------------------+
| Tables_in_hue |
auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups
.......
......
(You will see here lot of tables . Around 74 tables.
No comments:
Post a Comment