It works if I use embedded DB (http://gethue.com/password-management-in-hue). However, if I am using external DB, /etc/hue/conf/hue.ini doesn't contain the credentails for the external DB.
I did "sudo find / -name hue.ini" to locate the latest hue.ini, but it doesn't contain the password either. It actually calls a script to get the password.
What should I set before calling "build/env/bin/hue createsuperuser" to make it work?
The password called from the script is for the DB user to access the external database. If it is connected to that DB and working you shouldn't need it to run these commands. The first user logged into Hue is made the superuser. This is by default Admin. If that account doesn't exist then run the command you listed to create a new one. Then you should be able to log into that account and set the password.
Are you getting an error when you try that command?
If I run the command out of box as user hue, I get the exception stating not connecting to DB. Since hue.ini in /etc/hue/conf has no info on MySQL, I tried to use the one .ini used by HUE process. However, the password in .ini was hidden. I could reset the hue user password in MySQL database, but it is a little too much.
I don't have the hue admin user and password since I didn't set up it. I am taking over the cluster now and tried to create another super user to replace the existing admin user.