WebVirtMgr with MySQL on CentOS 6.5 and nginx setup notes

[open-cloud-builder]

Privjet,

First: Thank you for this great GUI.
Second: I have no experience in Django or Python, so I struggled with the setup.

I´m trying to set up WebVirtMgr with a MySQL db so I can use a HA MySQL DB backend. The goal is to have multiply redundand WebVirtMgr instances via ucarp with
identical settings & users on different hosts. In this scenario multiply hosts and
vm´s in the cluster can fail, still giving you a nice frontend to manage the
remaining hosts via a nice single web interface and ip/hostname without a complex
full cloud engine.

I´m using Centos 6.5 in this test. I skip the steps to configure a MySQL master/master
setup and ucarp.

Before starting edit the db backend in webvirtmgr/settings.py and settings_jenkins.py

You can enter the creditals for your ucarped master/master mysql db here.

Important changes:

'ENGINE': 'django.db.backends.mysql',
'NAME': 'webvirtmgr',

"NAME" here is the db name not a path. You first must create the db on your mysql server manually.

This further setup needs mysql-python.

python-pip install mysql-python didn´t work, so I used:

yum install MySQL-python

Continue with the steps in the current documentation for CentOS.

---

I will be using the official nginx repo with the latest nginx for CentOS from here:
http://wiki.nginx.org/Install

In this setup the default www base dir is not "/var/www" but "/usr/share/nginx/html"

So the setup step in the documentation is not

cp /var/www/webvirtmgr/conf/initd/webvirtmgr-novnc-redhat /etc/init.d/webvirtmgr-novnc

but

cp /usr/share/nginx/html/conf/initd/webvirtmgr-novnc-redhat /etc/init.d/webvirtmgr-novnc

Since this is a nginx server running

service webvirtmgr-novnc start

results in
chown: invalid user: `apache'

Therefor edit the webvirtmgr-novnc file:

nano /etc/init.d/webvirtmgr-novnc

Change
username="apache"
to
username="nginx" and save

Change
exec="/var/www/webvirtmgr/console/$prog"
to
exec="/usr/share/nginx/html/console/$prog"

Change the owner & group of "/var/run/webvirtmgr/" to the nginx user/group (498/497)

The novnc service can now start.

service webvirtmgr-novnc start

The documentation is missing the service registering, run:

chkconfig --add webvirtmgr-novnc

chkconfig webvirtmgr-novnc on

The novnc service can now start on every reboot.

---

The mentioned /etc/supervisor.conf don´t exist, but there is a /etc/supervisord.conf

So change it instead:

nano /etc/supervisord.conf

The correct settings for a nginx setup are:

[program:webvirtmgr]
command=/usr/bin/python /usr/share/nginx/html/manage.py run_gunicorn -c /usr/share/nginx/html/conf/gunicorn.conf.py
directory=/usr/share/nginx/html
autostart=true
autorestart=true
stdout_logfile=/var/log/supervisor/webvirtmgr.log
redirect_stderr=true
user=nginx

---

To enter the site you first must start supervisord:

service supervisord start

The supervisord is not enabled to start in the default setup (see "#chkconfig --list"),
enable it to start on each reboot:

chkconfig supervisord on

---

You must remove the default config for nginx afther adding webvirtmgr.conf
run:

mv /etc/nginx/conf.d/default.conf /etc/nginx/conf.d/default.conf.bak

Then run:

service nginx restart

Follow the other steps in the documentation accordingly.
You can now log in and use WebVirtMgr with ngingx and mysql on CentOS.

[retspen]

Thanks! Nice article.