I have encountered multiple errors/warnings in Hue Browser: Checking current configuration Configuration files located in /usr/local/hue/desktop/conf Potential misconfiguration detected. Fix and restart Hue. HBase BrowserThe application won't work without a running HBase Thrift Server v1.ImpalaNo available Impalad to send queries to.SparkThe app won't work without a running Livy Spark Server I cannot install individual app examples (Impala, Solr and HBase) Could not install table: Error creating table sample_07: Could not connect to localhost:21050 (code THRIFTTRANSPORT): TTransportException('Could not connect to localhost:21050',). ×Instance directory /usr/local/hue/desktop/libs/indexer/src/indexer/../data/collections/twitter_demo already exists! Please remove it from the file system. ×Could not connect to xx9090 (code THRIFTTRANSPORT): TTransportException('Could not connect to ec2-xxx.compute-1.amazonaws.com:9090',) Please advise. thanks ... View more

@ibhatt: Many thanks. That worked! I have a questions as clarifications please. # hue syncdb gave me these results Synced: > django.contrib.auth > django_openid_auth > django.contrib.contenttypes > django.contrib.sessions > django.contrib.sites > django.contrib.staticfiles > django.contrib.admin > south > axes > about > filebrowser > help > impala > jobbrowser > metastore > proxy > rdbms > zookeeper > indexer Not synced (use migrations): - django_extensions - desktop - beeswax - hbase - jobsub - oozie - pig - search - spark - sqoop - useradmin - notebook Can I ignore the not synced please? It asked me if I wanted to create a super user for Django's auth system. It created one with a user name, which is different to "hue" as a user in mysql for the huedb. I assume this does not pose any conflict. If I need to remove this, please advise the steps to correct. The last command "hue migrate" gave me these messages. Running migrations for django_extensions: - Migrating forwards to 0001_empty. > django_extensions:0001_empty - Loading initial data for django_extensions. Installed 0 object(s) from 0 fixture(s) Running migrations for desktop: - Migrating forwards to 0022_auto__del_field_defaultconfiguration_group__del_unique_defaultconfigur. > pig:0001_initial > oozie:0001_initial > oozie:0002_auto__add_hive > oozie:0003_auto__add_sqoop > oozie:0004_auto__add_ssh > oozie:0005_auto__add_shell > oozie:0006_auto__chg_field_java_files__chg_field_java_archives__chg_field_sqoop_f > oozie:0007_auto__chg_field_sqoop_script_path > oozie:0008_auto__add_distcp > oozie:0009_auto__add_decision > oozie:0010_auto__add_fs > oozie:0011_auto__add_email > oozie:0012_auto__add_subworkflow__chg_field_email_subject__chg_field_email_body > oozie:0013_auto__add_generic > oozie:0014_auto__add_decisionend > oozie:0015_auto__add_field_dataset_advanced_start_instance__add_field_dataset_ins > oozie:0016_auto__add_field_coordinator_job_properties > oozie:0017_auto__add_bundledcoordinator__add_bundle > oozie:0018_auto__add_field_workflow_managed > oozie:0019_auto__add_field_java_capture_output > oozie:0020_chg_large_varchars_to_textfields > oozie:0021_auto__chg_field_java_args__add_field_job_is_trashed > oozie:0022_auto__chg_field_mapreduce_node_ptr__chg_field_start_node_ptr > oozie:0022_change_examples_path_format - Migration 'oozie:0022_change_examples_path_format' is marked for no-dry-run. > oozie:0023_auto__add_field_node_data__add_field_job_data > oozie:0024_auto__chg_field_subworkflow_sub_workflow > oozie:0025_change_examples_path_format - Migration 'oozie:0025_change_examples_path_format' is marked for no-dry-run. > desktop:0001_initial > desktop:0002_add_groups_and_homedirs > desktop:0003_group_permissions > desktop:0004_grouprelations > desktop:0005_settings > desktop:0006_settings_add_tour > beeswax:0001_initial > beeswax:0002_auto__add_field_queryhistory_notify > beeswax:0003_auto__add_field_queryhistory_server_name__add_field_queryhistory_serve > beeswax:0004_auto__add_session__add_field_queryhistory_server_type__add_field_query > beeswax:0005_auto__add_field_queryhistory_statement_number > beeswax:0006_auto__add_field_session_application > beeswax:0007_auto__add_field_savedquery_is_trashed > beeswax:0008_auto__add_field_queryhistory_query_type > desktop:0007_auto__add_documentpermission__add_documenttag__add_document > desktop:0008_documentpermission_m2m_tables > desktop:0009_auto__chg_field_document_name > desktop:0010_auto__add_document2__chg_field_userpreferences_key__chg_field_userpref > desktop:0011_auto__chg_field_document2_uuid > desktop:0012_auto__chg_field_documentpermission_perms > desktop:0013_auto__add_unique_documenttag_owner_tag > desktop:0014_auto__add_unique_document_content_type_object_id > desktop:0015_auto__add_unique_documentpermission_doc_perms > desktop:0016_auto__add_unique_document2_uuid_version_is_history > desktop:0017_auto__add_document2permission__add_unique_document2permission_doc_perm > desktop:0018_auto__add_field_document2_parent_directory > desktop:0019_auto > desktop:0020_auto__del_field_document2permission_all > desktop:0021_auto__add_defaultconfiguration__add_unique_defaultconfiguration_app_is > desktop:0022_auto__del_field_defaultconfiguration_group__del_unique_defaultconfigur - Loading initial data for desktop. Installed 0 object(s) from 0 fixture(s) Running migrations for beeswax: - Migrating forwards to 0014_auto__add_field_queryhistory_is_cleared. > beeswax:0009_auto__add_field_savedquery_is_redacted__add_field_queryhistory_is_reda > beeswax:0009_auto__chg_field_queryhistory_server_port > beeswax:0010_merge_database_state > beeswax:0011_auto__chg_field_savedquery_name > beeswax:0012_auto__add_field_queryhistory_extra > beeswax:0013_auto__add_field_session_properties > beeswax:0014_auto__add_field_queryhistory_is_cleared - Loading initial data for beeswax. Installed 0 object(s) from 0 fixture(s) Running migrations for hbase: - Migrating forwards to 0001_initial. > hbase:0001_initial - Loading initial data for hbase. Installed 0 object(s) from 0 fixture(s) Running migrations for jobsub: - Migrating forwards to 0006_chg_varchars_to_textfields. > jobsub:0001_initial > jobsub:0002_auto__add_ooziestreamingaction__add_oozieaction__add_oozieworkflow__ad > jobsub:0003_convertCharFieldtoTextField > jobsub:0004_hue1_to_hue2 - Migration 'jobsub:0004_hue1_to_hue2' is marked for no-dry-run. > jobsub:0005_unify_with_oozie - Migration 'jobsub:0005_unify_with_oozie' is marked for no-dry-run. > jobsub:0006_chg_varchars_to_textfields - Loading initial data for jobsub. Installed 0 object(s) from 0 fixture(s) Running migrations for oozie: - Migrating forwards to 0027_auto__chg_field_node_name__chg_field_job_name. > oozie:0026_set_default_data_values - Migration 'oozie:0026_set_default_data_values' is marked for no-dry-run. > oozie:0027_auto__chg_field_node_name__chg_field_job_name - Loading initial data for oozie. Installed 0 object(s) from 0 fixture(s) Running migrations for pig: - Nothing to migrate. - Loading initial data for pig. Installed 0 object(s) from 0 fixture(s) Running migrations for search: - Migrating forwards to 0003_auto__add_field_collection_owner. > search:0001_initial > search:0002_auto__del_core__add_collection > search:0003_auto__add_field_collection_owner - Loading initial data for search. Installed 0 object(s) from 0 fixture(s) Running migrations for spark: - Migrating forwards to 0001_initial. > spark:0001_initial - Loading initial data for spark. Installed 0 object(s) from 0 fixture(s) Running migrations for sqoop: - Migrating forwards to 0001_initial. > sqoop:0001_initial - Loading initial data for sqoop. Installed 0 object(s) from 0 fixture(s) Running migrations for useradmin: - Migrating forwards to 0006_auto__add_index_userprofile_last_activity. > useradmin:0001_permissions_and_profiles - Migration 'useradmin:0001_permissions_and_profiles' is marked for no-dry-run. > useradmin:0002_add_ldap_support - Migration 'useradmin:0002_add_ldap_support' is marked for no-dry-run. > useradmin:0003_remove_metastore_readonly_huepermission - Migration 'useradmin:0003_remove_metastore_readonly_huepermission' is marked for no-dry-run. > useradmin:0004_add_field_UserProfile_first_login > useradmin:0005_auto__add_field_userprofile_last_activity > useradmin:0006_auto__add_index_userprofile_last_activity - Loading initial data for useradmin. Installed 0 object(s) from 0 fixture(s) Running migrations for notebook: - Migrating forwards to 0001_initial. > notebook:0001_initial - Loading initial data for notebook. Installed 0 object(s) from 0 fixture(s) Thanks, Srinivasa ... View more

Since the context of the errors are different than the original post, I will close this thread and post a new one. ... View more

I found the sqlite3 database file in /usr/local/hue/desktop/desktop.db But, I still cannot create a dump of this to .json to use mysql. Thanks for the help. ... View more

The problem is I am unable to create a dump of the desktop.db. I downloaded the tar file and un-tarred it to a directory (hue-3.10.0). 1: I cannot find /var/lib/hue/desktop.db 2: I cannot dump to temp.json 3: huedb file does not have any tables in MySql, 4. MySql also hosts db files for tomcat, hive and ambari. These dbs work fine. ... View more

I hope someone can advise on this error. thanks ... View more

I made some progress. I am getting the following error: ProgrammingError: (1146, "Table 'huedb.desktop_settings' doesn't exist") ... View more

Many thanks for this. It worked. I have a few more problems. I completed the configuration and changed the db path to mysql before starting hue. I used this post as a guide (https://community.hortonworks.com/questions/399/how-to-move-hue-database-from-default-sqlite-datab.html). Issues: 1: Commands below do not work. As the Hue user, configure Hue to load the existing data and create the necessary database tables. /usr/lib/hue/build/env/bin/hue syncdb --noinput /usr/lib/hue/build/env/bin/hue migrate /usr/lib/hue/build/env/bin/hue loaddata /tmp/hue_db_dump.json Your system is now configured and you can start the Hue server as normal. /etc/init.d/hue start I am getting this error /usr/lib/hue/build/env/bin/hue: command not found or no such file or directory I tried to start hue with the following command, which also produces an error on the browser /usr/local/hue/build/env/bin/supervisor File "/usr/local/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/mysql/base.py", line 435, in get_new_connection conn = Database.connect(**conn_params) File "/usr/local/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect return Connection(*args, **kwargs) File "/usr/local/hue/build/env/lib/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 193, in __init__ super(Connection, self).__init__(*args, **kwargs2) OperationalError: (1045, "Access denied for user 'hue'@'namenode.teg' (using password: YES)") ... View more