Archives of Support Questions (Read Only)

GrazittiAPI · ‎05-17-2016

Hello,

I wish to load balance multiple hue servers under a load balancer. Each hue server keeps the record in its own prostgre database. For running a multiple hue servers, I need to keep these records in a centralized DB. Is it possible to maintain the entire hue servers in my cluster in a centralized db?

Thanks in advance.

bandarusridhar1 · ‎05-18-2016

Scheme should be created automatically, Follow below steps:

To set up Hue to use a MySQL database:

Create a new user in MySQL, and grant privileges to it to manage the database using the MySQL database admin utility:

# mysql -u root -p<
CREATE USER $HUEUSER IDENTIFIED BY '$HUEPASSWORD';
GRANT ALL PRIVILEGES on *.* to ‘$HUEUSER’@’localhost’ WITH GRANT OPTION;
GRANT ALL on $HUEUSER.* to ‘$HUEUSER’@’localhost’ IDENTIFIED BY $HUEPASSWORD;
FLUSH PRIVILEGES;

where $HUEUSER is the Hue user name and $HUEPASSWORD is the Hue user password.

Create the MySQL database for Hue:
# mysql -u root -p
CREATE DATABASE $DBNAME;

Open the /etc/hue/conf/hue.ini file and edit the [[database]] section (modify for your MySQL setup).

[[database]] 
engine=mysql
host=$DATABASEIPADDRESSORHOSTNAME
port=$PORT
user=$HUEUSER
password=$HUEPASSWORD
name=$DBNAME

Synchronize Hue with the external database to create the schema and load the data.
/usr/lib/hue/build/env/bin/hue syncdb --noinput
Start Hue.
/etc/init.d/hue start

View solution in original post

VidyaSargur · ‎05-21-2021

Hi @Rajuambala as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.

Regards,

Vidya Sargur,
Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
Community Guidelines
How to use the forum

radhakrishnan_r · ‎05-22-2016

Thank you for all your responses. It works fine. But I got some error while restarting hue service in all hosts.

[centos@ip-172-31-56-224 ~]$ sudo -i [root@ip-172-31-56-224 ~]# /etc/init.d/hue restart

Shutting down hue: [ OK ] Traceback (most recent call last):

File "/usr/lib/hue/build/env/bin//hue", line 9, in <module> load_entry_point('desktop==2.6.1', 'console_scripts', 'hue')()

File "/usr/lib/hue/desktop/core/src/desktop/manage_entry.py", line 41, in entry from desktop import settings, appmanager File "/usr/lib/hue/desktop/core/src/desktop/settings.py", line 52, in <module> desktop.log.basic_logging(os.environ[ENV_HUE_PROCESS_NAME])

File "/usr/lib/hue/desktop/core/src/desktop/log/__init__.py", line 125, in basic_logging logging.config.fileConfig(log_conf) File "/usr/lib64/python2.6/logging/config.py", line 84, in fileConfig handlers = _install_handlers(cp, formatters)

File "/usr/lib64/python2.6/logging/config.py", line 162, in _install_handlers h = klass(*args)

File "/usr/lib64/python2.6/logging/handlers.py", line 112, in __init__ BaseRotatingHandler.__init__(self, filename, mode, encoding, delay)

File "/usr/lib64/python2.6/logging/handlers.py", line 64, in __init__ logging.FileHandler.__init__(self, filename, mode, encoding, delay)

File "/usr/lib64/python2.6/logging/__init__.py", line 835, in __init__ StreamHandler.__init__(self, self._open())

File "/usr/lib64/python2.6/logging/__init__.py", line 854, in _open stream = open(self.baseFilename, self.mode)

IOError: [Errno 13] Permission denied: '/usr/lib/hue/logs/access.log'

Starting hue: [ OK ]

[root@ip-172-31-56-224 ~]# /etc/init.d/hue status

supervisor (pid 12586) is running...

[root@ip-172-31-56-224 ~]#

Will it impact my environment?

Thanks and Regards,

Radhakrishnan.R

Archives of Support Questions (Read Only)

Centralized DB for multiple hue servers