Hi @stevenmatison when i change the default data base to oracle .HUE UI dose not come up .it give me below error .   Request Method:Request URL:Django Version:Exception Type:Exception Value: GET http://xxxxxxx:8888/ 1.11.22 DatabaseError ORA-00942: table or view does not exist ... View more

Hi @stevenmatison  i am trying to get the backup of sqllite database to import into oracle database as i dont have database dump from ambari .   Regards Bharad ... View more

Hi @stevenmatison ,   I was able to run the same query from hive ,but from hue i see database lock . When i did some research i got to know that  hue stores the user requests in metadata database . so when i checked repository data base i dont see any tables created . so i tried configuring metadata repository by configuring to oracle database and i am running into issues (in the above post ) .   Regards Bharad ... View more

Hi @lwang    I was able to get the details . But when i configure my oracle database i am seeing below error .I dont see any tables were also create in oracle metadata db .   [29/Apr/2020 12:36:36 +0000] exception ERROR Internal Server Error: / Traceback (most recent call last): File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/exception.py", line 41, in inner response = get_response(request) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/core/handlers/base.py", line 244, in _legacy_get_response response = middleware_method(request) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/middleware/locale.py", line 25, in process_request language = translation.get_language_from_request(request, check_path=i18n_patterns_used) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/utils/translation/__init__.py", line 211, in get_language_from_request return _trans.get_language_from_request(request, check_path) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/utils/translation/trans_real.py", line 519, in get_language_from_request lang_code = request.session.get(LANGUAGE_SESSION_KEY) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/base.py", line 68, in get return self._session.get(key, default) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/base.py", line 207, in _get_session self._session_cache = self.load() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/contrib/sessions/backends/db.py", line 35, in load expire_date__gt=timezone.now() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 374, in get num = len(clone) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 232, in __len__ self._fetch_all() File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 1121, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/query.py", line 53, in __iter__ results = compiler.execute_sql(chunked_fetch=self.chunked_fetch) File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.11.22-py2.7.egg/django/db/models/sql/compiler.py", line 899, in execute_sql raise original_exception DatabaseError: ORA-00942: table or view does not exist       Below are my databse detaisl i put in hue.ini   [[database]] # Database engine is typically one of: # postgresql_psycopg2, mysql, sqlite3 or oracle. # # Note that for sqlite3, 'name', below is a path to the filename. For other backends, it is the database name # Note for Oracle, options={"threaded":true} must be set in order to avoid crashes. # Note for Oracle, you can use the Oracle Service Name by setting "host=" and "port=" and then "name=(host):(port)/(service_name)". # Note for MariaDB use the 'mysql' engine. engine=oracle host= port=0 user=hue password=xxxxx # conn_max_age option to make database connection persistent value in seconds # https://docs.djangoproject.com/en/1.11/ref/databases/#persistent-connections ## conn_max_age=0 # Execute this script to produce the database password. This will be used when 'password' is not set. ## password_script=/path/script name= options={"threaded":true} # Database schema, to be used only when public schema is revoked in postgres ## schema=public   and i see the below coming up when i open hue UI with error page .         DATABASES ... View more

Hi @lwang ,   I have installed HUE through Ambari by following below document with the help of @stevenmatison     https://github.com/steven-dfheinz/HDP2-Hue4-Service   I was able to successfully  install  and bring up the services . I chose my metadata database as oracle as attached . But when i look into oracle database i don't see and metadata tables created . How do i check where Hue desktop is having its repository .   Regards Bharad   ... View more

thanks @GangWar i thought users in community might be having up to date details on CDP so was checking . ... View more

@stevenmatison  Sure .Let me reinstall and see how it goes .Will reach out to you if i need any further help . Appreciate all your support .   Regards Bharad ... View more

@stevenmatison  Thank you Sir . ... View more

@stevenmatison   i have changed the password  - it did not work I have updated lines 92-94 in common.py - it did not work i made changes to params.py - it gave the below error .   Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 76, in <module> HueServer().execute() File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 375, in execute method(env) File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 26, in start import params File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/params.py", line 194, in <module> webhdfs_url = format('http://' + dfs_namenode_http_address + '/webhdfs/v1') File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/config_dictionary.py", line 73, in __getattr__ raise Fail("Configuration parameter '" + self.name + "' was not found in configurations dictionary!") resource_management.core.exceptions.Fail: Configuration parameter 'dfs.namenode.http-address' was not found in configurations dictionary! and i see these (dfs.namenode.http-address are configured under HDFS configuration . Do i have to do anything separately for HUE  .   Regards Bharad Regards Bharad ... View more

@stevenmatison    Finally i was able to install using mpack (all thanks to you )  . But hue server wont start . below is the error i am getting   Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 76, in <module> HueServer().execute() File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 375, in execute method(env) File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 28, in start self.configure(env) File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 120, in locking_configure original_configure(obj, *args, **kw) File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/hue_server.py", line 23, in configure setup_hue() File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/setup_hue.py", line 52, in setup_hue add_hdfs_configuration(params.has_ranger_admin, params.security_enabled) File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/common.py", line 99, in add_hdfs_configuration add_configurations(services_configurations) File "/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/scripts/common.py", line 161, in add_configurations Execute(cmd) File "/usr/lib/ambari-agent/lib/resource_management/core/base.py", line 166, in __init__ self.env.run() File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 160, in run self.run_action(resource, action) File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 124, in run_action provider_action() File "/usr/lib/ambari-agent/lib/resource_management/core/providers/system.py", line 262, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 72, in inner result = function(command, **kwargs) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 102, in checked_call tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 150, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 303, in _call raise ExecutionFailed(err_msg, code, out, err) resource_management.core.exceptions.ExecutionFailed: Execution of '/var/lib/ambari-agent/cache/common-services/HUE/4.6.0/package/files/configs.sh set catl0dlbd00028.corp.cox.com HDP_ANALYTICS_DEV httpfs-site 'httpfs.proxyuser.hue.groups' '*'' returned 1. [ERROR] "httpfs-site" not found in server response. [ERROR] Output of `curl -k -s -u admin:admin "http://catl0dlbd00028.corp.cox.com:8080/api/v1/clusters/HDP_ANALYTICS_DEV?fields=Clusters/desired_configs"` is: [ERROR]   ... View more

@stevenmatisonI was able to resolve the dependency issue . when i run the install through Ambari its failing with the below error   Statement":947,"ShowDatabasesStatement":948,"ShowFunctionsStatement":949,"ShowGrantStatement":950,"ShowIndexStatement":951,"ShowLocksStatement":952,"ShowPartitionsStatement":953,"ShowRolesStatement":954,"ShowRoleStatement":955,"ShowTablesStatement":956,"ShowTableStatement":957,"ShowTblPropertiesStatement":958,"ShowTransactionsStatement":959,"ShowViewsStatement":960,"ShowColumnsStatement_EDIT":961,"ShowCreateTableStatement_EDIT":962,"ShowCurrentRolesStatement_EDIT":963,"ShowDatabasesStatement_EDIT":964,"ShowGrantStatement_EDIT":965,"ShowIndexStatement_EDIT":966,"ShowLocksStatement_EDIT":967,"ShowPartitionsStatement_EDIT":968,"ShowRoleStatement_EDIT":969,"ShowTablesStatement_EDIT":970,"ShowTableStatement_EDIT":971,"ShowTblPropertiesStatement_EDIT":972,"ShowViewsStatement_EDIT":973,"TableOrView":974,"OptionalPrincipalName":975,"OptionalPrincipalName_EDIT":976,"OptionalInOrFromDatabase":977,"OptionalLike":978,"InOrFromDatabase_EDIT":979,"Like_EDIT":980,"TargetTable":981,"OptionalFromJoinedTable":982,"TargetTable_EDIT":983,"FromJoinedTable_EDIT":984,"TableName":985,"TableName_EDIT":986,"SetClause":987,"SetClause_EDIT":988,"SetTarget":989,"UpdateSource":990,"UpdateSource_EDIT":991,"CaseWhenThenList":992,"CaseWhenThenList_EDIT":993,"CaseWhenThenListPartTwo":994,"CaseWhenThenListPartTwo_EDIT":995,"$accept":0,"$end":1}, at Parser._raise (/usr/local/hue/node_modules/@babel/parser/lib/index.js:742:17) at Parser.raiseWithData (/usr/local/hue/node_modules/@babel/parser/lib/index.js:735:17) at Parser.raise (/usr/local/hue/node_modules/@babel/parser/lib/index.js:729:17) at Parser.unexpected (/usr/local/hue/node_modules/@babel/parser/lib/index.js:8757:16) at Parser.parseExprAtom (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10052:20) at Parser.parseExprSubscripts (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9602:23) at Parser.parseMaybeUnary (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9582:21) at Parser.parseExprOps (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9452:23) at Parser.parseMaybeConditional (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9425:23) at Parser.parseMaybeAssign (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9380:21) at Parser.parseExpression (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9332:23) at Parser.parseStatementContent (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11210:23) at Parser.parseStatement (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11081:17) at node.body.withTopicForbiddingContext (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11699:60) at Parser.withTopicForbiddingContext (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10956:14) at Parser.parseFor (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11699:22) at Parser.parseForStatement (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11422:17) at Parser.parseStatementContent (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11106:21) at Parser.parseStatement (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11081:17) at Parser.parseBlockOrModuleBlockBody (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11656:25) at Parser.parseBlockBody (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11642:10) at Parser.parseBlock (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11626:10) at Parser.parseFunctionBody (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10634:24) at Parser.parseFunctionBodyAndFinish (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10617:10) at withTopicForbiddingContext (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11796:12) at Parser.withTopicForbiddingContext (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10956:14) at Parser.parseFunction (/usr/local/hue/node_modules/@babel/parser/lib/index.js:11795:10) at Parser.parseFunctionExpression (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10093:17) at Parser.parseExprAtom (/usr/local/hue/node_modules/@babel/parser/lib/index.js:10001:21) at Parser.parseExprSubscripts (/usr/local/hue/node_modules/@babel/parser/lib/index.js:9602:23) @ ./desktop/core/src/desktop/js/parse/sql/sqlParserRepository.js 117:11-119:34 @ ./desktop/core/src/desktop/js/sql/sqlLocationWebWorker.js @ multi ./desktop/core/src/desktop/js/sql/sqlLocationWebWorker.js npm ERR! Linux 3.10.0-514.16.1.el7.x86_64 npm ERR! argv "/usr/bin/node" "/bin/npm" "run" "webpack-workers" npm ERR! node v6.14.0 npm ERR! npm v3.10.10 npm ERR! code ELIFECYCLE npm ERR! hue@4.6.0 webpack-workers: `webpack --config webpack.config.workers.js` npm ERR! Exit status 2 npm ERR! npm ERR! Failed at the hue@4.6.0 webpack-workers script 'webpack --config webpack.config.workers.js'. npm ERR! Make sure you have the latest version of node.js and npm installed. npm ERR! If you do, this is most likely a problem with the hue package, npm ERR! not with npm itself. npm ERR! Tell the author that this fails on your system: npm ERR! webpack --config webpack.config.workers.js npm ERR! You can get information on how to open an issue for this project with: npm ERR! npm bugs hue npm ERR! Or if that isn't available, you can get their info via: npm ERR! npm owner ls hue npm ERR! There is likely additional logging output above. npm ERR! Please include the following file with any support request: npm ERR! /usr/local/hue/npm-debug.log make[1]: *** [npm-install] Error 1 make[1]: Leaving directory `/usr/local/hue' make: *** [install-env] Error 2   When i run manual install it suceeds .please find last few lines on manual install where it suceeded .   Post-processed 'jobsub/css/jobsub.css' as 'jobsub/css/jobsub.4dd97953214b.css' Post-processed 'desktop/css/roboto.css' as 'desktop/css/roboto.895233d7bf84.css' Post-processed 'metastore/css/metastore.css' as 'metastore/css/metastore.0bd1490fe916.css' Post-processed 'desktop/css/bootstrap-medium-editor.css' as 'desktop/css/bootstrap-medium-editor.307d202ce21d.css' Post-processed 'admin/css/login.css' as 'admin/css/login.a846c0e2ef65.css' Post-processed 'admin/css/rtl.css' as 'admin/css/rtl.4c867197b256.css' Post-processed 'oozie/css/workflow.css' as 'oozie/css/workflow.5bf771c653dc.css' Post-processed 'debug_toolbar/css/toolbar.css' as 'debug_toolbar/css/toolbar.b35523ea26ab.css' Post-processed 'impala/css/impala-dashboard.css' as 'impala/css/impala-dashboard.60e7988b5afe.css' Post-processed 'desktop/css/bootstrap-daterangepicker.css' as 'desktop/css/bootstrap-daterangepicker.3b118749763b.css' Post-processed 'desktop/css/jqCron.css' as 'desktop/css/jqCron.ad6fb9a1edc5.css' Post-processed 'pig/css/pig.css' as 'pig/css/pig.971ef685eb43.css' Post-processed 'oozie/css/workflow-editor.css' as 'oozie/css/workflow-editor.fb64c90799c5.css' Post-processed 'desktop/css/bootstrap-spinedit.css' as 'desktop/css/bootstrap-spinedit.983726642cbb.css' 66 static files copied to '/usr/local/hue/build/static', 1518 unmodified, 318 post-processed. make[1]: Leaving directory `/usr/local/hue'       ... View more

@stevenmatison    Appreciate your support sir .     For the above ( Hue 4.6.0 install in HDP 2.x ) i tried multiple times but i was not able to get past the above steps . even though i have all the dependent packages avilable on the server i am getting below error . copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants copying MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants copying MySQLdb/constants/REFRESH.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants copying MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants running build_ext building '_mysql' extension creating build/temp.linux-x86_64-2.7 gcc -pthread -fno-strict-aliasing -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o -m64 _mysql.c:44:23: fatal error: my_config.h: No such file or directory #include "my_config.h" ^ compilation terminated. error: command 'gcc' failed with exit status 1 make[2]: *** [/usr/local/hue-4.6.0/desktop/core/build/MySQL-python-1.2.5/egg.stamp] Error 1 make[2]: Leaving directory `/usr/local/hue-4.6.0/desktop/core' make[1]: *** [.recursive-install-bdist/core] Error 2 make[1]: Leaving directory `/usr/local/hue-4.6.0/desktop' make: *** [install-desktop] Error 2   I have all the dependencies available on the server   sudo yum install ant asciidoc cyrus-sasl-devel cyrus-sasl-gssapi cyrus-sasl-plain gcc gcc-c++ krb5-devel libffi-devel libxml2-devel libxslt-devel make mysql mysql-devel openldap-devel python-devel sqlite-devel gmp-devel Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager IDS_EPEL_EPEL_7_Server | 2.4 kB 00:00:00 IDS_NewRelic_RHEL7 | 2.1 kB 00:00:00 IDS_UIMS_RHEL7 | 2.1 kB 00:00:00 rhel-7-server-optional-rpms | 2.0 kB 00:00:00 rhel-7-server-rpms | 2.0 kB 00:00:00 rhel-7-server-satellite-tools-6.6-rpms | 2.1 kB 00:00:00 rhel-7-server-supplementary-rpms | 2.0 kB 00:00:00 Package ant-1.9.4-2.el7.noarch already installed and latest version Package asciidoc-8.6.8-5.el7.noarch already installed and latest version Package cyrus-sasl-devel-2.1.26-23.el7.x86_64 already installed and latest version Package cyrus-sasl-gssapi-2.1.26-23.el7.x86_64 already installed and latest version Package cyrus-sasl-plain-2.1.26-23.el7.x86_64 already installed and latest version Package gcc-4.8.5-39.el7.x86_64 already installed and latest version Package gcc-c++-4.8.5-39.el7.x86_64 already installed and latest version Package krb5-devel-1.15.1-37.el7_7.2.x86_64 already installed and latest version Package libffi-devel-3.0.13-18.el7.x86_64 already installed and latest version Package libxml2-devel-2.9.1-6.el7_2.3.x86_64 already installed and latest version Package libxslt-devel-1.1.28-5.el7.x86_64 already installed and latest version Package 1:make-3.82-24.el7.x86_64 already installed and latest version Package mysql-community-client-8.0.17-1.el7.x86_64 already installed and latest version Package mysql-community-devel-8.0.17-1.el7.x86_64 already installed and latest version Package openldap-devel-2.4.44-21.el7_6.x86_64 already installed and latest version Package python-devel-2.7.5-86.el7.x86_64 already installed and latest version Package sqlite-devel-3.7.17-8.el7_7.1.x86_64 already installed and latest version Package 1:gmp-devel-6.0.0-15.el7.x86_64 already installed and latest version Nothing to do Uploading Enabled Repositories Report Loaded plugins: product-id, subscription-manager   its weird behavior from ambari server and agent .. I am out of ideas and energy for now 🙂   .I will wait for Mpack and try that . Thanks for all your efforts .   Regards Bharad                                                                                                     ... View more

@stevenmatison  I have installed all the dependencies .   and now getting into different error  .   File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 102, in checked_call tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 150, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 303, in _call raise ExecutionFailed(err_msg, code, out, err) resource_management.core.exceptions.ExecutionFailed: Execution of 'cd /usr/local/hue-4.6.0 && PREFIX=/usr/local make install' returned 2. "PYTHON_VER is python2.7" ERROR: /usr/local/hue not empty. Cowardly refusing to continue. make: *** [install-check] Error 1 Trying to get in touch with my system admin to check on this  . if you have any thoughts please let me know .   Regards Bharad   ... View more

Hi ,   I am working with Red Hat Enterprise Linux Server release 7.6 (Maipo) . Let me check the dependencies once again . ... View more