Here is instruction for moving Hue from Sqlite to MySQL and same can be changed to work with Postgres. Self posting the answer after test. 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;
Create the MySQL database for Hue. # mysql -u root -pCREATE DATABASE $DBNAME;
Stop Hue if it is running. /etc/init.d/hue stop
To migrate your existing data to MySQL, use the following command to dump the existing database data to a text file. Note that using the “.json” extension is required. /usr/lib/hue/build/env/bin/hue dumpdata > /tmp/hue_db_dump.json
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
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
... View more
