Hue 3.10.0 creates a fatal error

[#1]

We have a HDP 2.4 on AWS. I tried to configure hue 3.10.0. I get the error below after trying to install it.

building '_cffi_backend' extension
gcc -pthread -fno-strict-aliasing -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecor                           d-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-st                           rong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -DUSE__THREAD -I/usr/include/ffi -I/usr/i                           nclude/libffi -I/usr/include/python2.7 -c c/_cffi_backend.c -o build/temp.linux-x86_64-2.7/c/_cffi_backend.o
c/_cffi_backend.c:15:17: fatal error: ffi.h: No such file or directory
 #include <ffi.h>
                 ^
compilation terminated.
error: command 'gcc' failed with exit status 1
make[2]: *** [/hue-3.10.0/desktop/core/build/cffi-1.5.2/egg.stamp] Error 1
make[2]: Leaving directory `/hue-3.10.0/desktop/core'
make[1]: *** [.recursive-install-bdist/core] Error 2
make[1]: Leaving directory `/hue-3.10.0/desktop'
make: *** [install-desktop] Error 2

Thanks.

[#2 · Accepted solution]

@S Srinivasa it looks that libffi-devel pkg is not installed.

libffi-devel rpm provides ffi.h header file. Please try to install this pkg and retry again.

#yum install libffi-devel

[#3]

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.h...

Issues:

1: Commands below do not work.

As the Hue user, configure Hue to load the existing data and create the necessary database tables.

1. /usr/lib/hue/build/env/bin/hue syncdb --noinput
2. /usr/lib/hue/build/env/bin/hue migrate
3. /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.

1. /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)")

[#4]

I made some progress. I am getting the following error:

ProgrammingError: (1146, "Table 'huedb.desktop_settings' doesn't exist")

[#5]

I hope someone can advise on this error. thanks

[#6]

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.

[#7]

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.

[#8]

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