<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Weird, creating a dummy database solved this error for me. <br>
<br>
In the script, it doesn't check to see if a database called nova
exists, lines 312-314:<br>
<br>
if [ "$USE_MYSQL" == 1 ]; then<br>
mysql -p$MYSQL_PASS -e 'DROP DATABASE nova;'<br>
mysql -p$MYSQL_PASS -e 'CREATE DATABASE nova;'<br>
<br>
I'm assuming you're running the script as root so db permissions to
drop should not be an issue. You might try dropping nova manually
and commenting out the drop database line from the script.<br>
<br>
Thanks<br>
Arvind<br>
<br>
On 08/09/2011 05:06 PM, Mauricio Arango wrote:
<blockquote
cite="mid:CAEXAJn3xVCqtybUKbCyG-1h4XvypGtYgRE4GOyYppY6=keg7UA@mail.gmail.com"
type="cite">Tied it, no luck, error indicating db nova already
exists:<br>
<br>
+ mysql -pnova -e 'CREATE DATABASE nova;'<br>
ERROR 1007 (HY000) at line 1: Can't create database 'nova';
database exists<br>
<br>
Thanks,<br>
<br>
Mauricio<br>
<br>
<br>
<br>
<br>
<div class="gmail_quote">On Tue, Aug 9, 2011 at 3:52 PM, Arvind
Somya <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:asomya@cisco.com">asomya@cisco.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> Yeah<br>
<br>
It's trying to clear an existing database named nova in
mysql.. try the following before install and run:<br>
<br>
mysql -u root -p <root_password> -e"create database
nova"<br>
<br>
This should create an empty database called nova for it to
whack.<br>
<br>
Thanks<br>
<font color="#888888"> Arvind</font>
<div>
<div class="h5"><br>
<br>
On 08/09/2011 03:34 PM, Mauricio Arango wrote:
<blockquote type="cite">Arvind,<br>
<br>
I ran the script with USE_MYSQL=1, also inverted the
order of lines 321 & 322 in the nova.sh script
(was generating an error). Didn't complete due to the
following db-related error:<br>
<br>
"Command failed, please check log for more info<br>
2011-08-09 14:58:47,555 CRITICAL nova [-]
(OperationalError) (1049, "Unknown database 'nova'")
None None ...."<br>
<br>
Any ideas what could be the problem?<br>
<br>
Thanks for your help,<br>
<br>
Mauricio<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div class="gmail_quote">On Tue, Aug 9, 2011 at 1:49
PM, Arvind Somya <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:asomya@cisco.com" target="_blank">asomya@cisco.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt
0pt 0pt 0.8ex; border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> Mauricio,<br>
<br>
The cloudbuilders script starts the server on
port 80 automatically. Afaik it also runs the
sampledata script from keystone to set up a
couple of users. You might try user:'joeuser'
pass: 'secrete' or user:'joeadmin'
pass:'secrete' .. both accounts are autocreated
from the sample data script.<br>
<br>
As to your sql problem.. I ran into the same
when using sqlite with the cloudbuilders image.
Try this, install mysql and:<br>
<br>
export USE_MYSQL=1<br>
export MYSQL_PASS=<your mysql root
password><br>
<br>
then <br>
// Clear our existing install data<br>
nova.sh terminate<br>
nova.sh clean<br>
nova.sh scrub<br>
nova.sh install<br>
nova.sh run<br>
<br>
The nova processes are run in a SCREEN command.
The script does not install euca2ools so you'll
need to install those separately.<br>
<br>
Thanks<br>
<font color="#888888"> Arvind</font>
<div>
<div><br>
<br>
<br>
On 08/09/2011 01:15 PM, Mauricio Arango
wrote:
<blockquote type="cite">Got the environment
up and went to the Dashboard's entry page
by pointing my browser to <a
moz-do-not-send="true"
href="http://localhost:80/"
target="_blank">http://localhost:80/</a>
(<a moz-do-not-send="true"
href="http://localhost:8000/"
target="_blank">http://localhost:8000/</a>
doesn't work).<br>
<br>
Logged successfully with 'admin' user
name;<br>
entered the System Panel page;<br>
got error in the Overview page:<br>
"Unable to get service info: User does not
have admin privileges"<br>
<br>
got error in the Instances page:<br>
"Unable to get instance list:
(InterfaceError) Error binding parameter 6
- probably unsupported type......"<br>
<br>
got error in the System Panel Services
page:<br>
"Unable to get service info: User does not
have admin privileges"<br>
it does display glance, identity ,
nova-compat, nova as up.<br>
<br>
got error in User Dashboard Image when
launching the only listed image (id=3,
ami-tty):<br>
"Unable to launch instance:
(InterfaceError) Error binding parameter 0
- probably unsupported type. ....."<br>
<br>
<br>
I didn't see any of the nova processes
running with 'nova-*' names. What names do
they have?<br>
<br>
I wasn't able to run either the
nova-manage nor the euca tools. How can I
do this? It is very helpful to have both
access to the command line tools in nova
as well as the Dashboard.<br>
<br>
Thanks,<br>
<br>
Mauricio<br>
<br>
<br>
<br>
<br>
<div><br>
<div class="gmail_quote">On Mon, Aug 8,
2011 at 8:55 PM, Mark Gius <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:mark@markgius.com"
target="_blank">mark@markgius.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin: 0pt 0pt 0pt 0.8ex;
border-left: 1px solid rgb(204, 204,
204); padding-left: 1ex;"> $ sudo
./nova.sh branch
<div>$ sudo ./nova.sh install</div>
<div>$ sudo ./nova.sh run</div>
<div><br>
</div>
<div>This starts up everything in a
screen session. When you detach
the screen with Ctrl-A, D all of
the openstack components will shut
down.</div>
<div><br>
</div>
<div>The nova.sh script generally
sets up a clean environment every
time it is run. This makes it
mostly useful for demo and test
environments.</div>
<div><br>
</div>
<div>Hopefully this helps.</div>
<div><br>
</div>
<div><font color="#888888">Mark</font>
<div>
<div><br>
<br>
<div class="gmail_quote">On
Mon, Aug 8, 2011 at 5:40 PM,
Mauricio Arango <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:arango.mauricio@gmail.com"
target="_blank">arango.mauricio@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px
solid rgb(204, 204, 204);
padding-left: 1ex;">
Thanks Mark,
<div><br>
</div>
<div>I'm trying your
nova.sh script. I run it
in a clean Ubuntu
instance as 'nova.sh
install'. However it
didn't start the nova
processes.</div>
<div><br>
</div>
<div>Please let me know
what is the correct way
of runnig the scrpt to
get everything running.</div>
<div><br>
</div>
<font color="#888888">
<div>Mauricio</div>
</font>
<div>
<div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
<div
class="gmail_quote">On
Mon, Aug 8, 2011
at 5:28 PM, Mark
Gius <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:mark@markgius.com" target="_blank">mark@markgius.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:
0pt 0pt 0pt
0.8ex;
border-left: 1px
solid rgb(204,
204, 204);
padding-left:
1ex;">Have you
set up and
configured a
keystone
instance for
authentication?
The dashboard
only supports
Keystone based
authentication
right now, and
it looks like
you're trying to
connect to nova
using Nova's
builtin auth.
That howto you
are following is
quite old. If
you're looking
to get openstack
up and running
on a single box,
you might want
to try this
script (<a
moz-do-not-send="true"
href="https://github.com/4P/deployscripts/blob/master/nova.sh"
target="_blank">https://github.com/4P/deployscripts/blob/master/nova.sh</a>)
which sets up
nova+keystone+glance+dashboard
on a single
host.
<div> <br>
</div>
<div> If you'd
like to modify
your existing
setup, take a
look at <a
moz-do-not-send="true"
href="https://github.com/openstack/keystone" target="_blank">https://github.com/openstack/keystone</a>,
which talks
about how to
set up
keystone and
integrate it
into your nova
installation.</div>
<div><br>
</div>
<div><font
color="#888888">Mark<br>
<br>
</font>
<div
class="gmail_quote">
<div>
<div>On Mon,
Aug 8, 2011 at
10:15 AM,
Mauricio
Arango <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:arango.mauricio@gmail.com"
target="_blank">arango.mauricio@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote
class="gmail_quote"
style="margin:
0pt 0pt 0pt
0.8ex;
border-left:
1px solid
rgb(204, 204,
204);
padding-left:
1ex;">
<div>
<div> Hi,
<div><br>
</div>
<div>I
installed Nova
and Dashboard
on a single
VirtualBox
Ubuntu guest,
following the
instructions
in:</div>
<div><a
moz-do-not-send="true"
href="http://uksysadmin.wordpress.com/2011/02/17/running-openstack-under-virtualbox-a-complete-guide/"
target="_blank">http://uksysadmin.wordpress.com/2011/02/17/running-openstack-under-virtualbox-a-complete-guide/</a></div>
<div>and</div>
<div><a
moz-do-not-send="true"
href="http://wiki.openstack.org/OpenStackDashboard" target="_blank">http://wiki.openstack.org/OpenStackDashboard</a></div>
<div><br>
</div>
<div>I added
the following
lines in
Dahsboard's
local_settings.py,
based on
information
extracted from
the novarc
file in Nova:</div>
<div>[</div>
<div>
<div>EC2_ACCESS_KEY="afa00c4d-7c1f-4a26-8986-1e291abb4e9d:myproject"</div>
<div>EC2_SECRET_KEY="e77a7fd0-bd94-4e67-9dc1-75a9ee2da45c"</div>
<div>EC2_URL="<a
moz-do-not-send="true" href="http://172.241.0.101:8773/services/Cloud"
target="_blank">http://172.241.0.101:8773/services/Cloud</a>"</div>
<div><br>
</div>
<div>NOVA_API_KEY="afa00c4d-7c1f-4a26-8986-1e291abb4e9d"</div>
<div>NOVA_USERNAME="mauricio"</div>
<div>NOVA_URL="<a
moz-do-not-send="true" href="http://172.241.0.101:8774/v1.0/"
target="_blank">http://172.241.0.101:8774/v1.0/</a>"</div>
<div>NOVA_CERT="/home/mauricio/ostack/cloud/creds/cacert.pem"</div>
</div>
<div>]</div>
<div><br>
</div>
<div>The nova
install, runs
well, tested
it using euca
tools.</div>
<div><br>
</div>
<div>The GUI
part of
Dashboard
works but
fails
connecting to
Nova,
generating the
this error on
any connection
attempt:</div>
<div>[</div>
<div>
<div>DEBUG:django_openstack.api:extras_api
connection
created using
token
"e1d4b8ca-9386-4f8e-b194-de6e504d6fa5"
and url "<a
moz-do-not-send="true"
href="http://localhost:8774/v1.1" target="_blank">http://localhost:8774/v1.1</a>"</div>
<div>ERROR:django_openstack.dash:ApiException
in instance
usage</div>
<div>Traceback
(most recent
call last):</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/django-openstack/django_openstack/dash/views/instances.py",
line 167, in
usage</div>
<div> usage
=
api.usage_get(request,
tenant_id,
datetime_start,
datetime_end)</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/django-openstack/django_openstack/api.py",
line 270, in
inner</div>
<div>
return
f(*args,
**kwargs)</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/django-openstack/django_openstack/api.py",
line 520, in
usage_get</div>
<div>
return
Usage(extras_api(request).usage.get(tenant_id,
start, end))</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/openstack-dashboard/.dashboard-venv/src/openstackx/openstackx/extras/usage.py",
line 15, in
get</div>
<div>
return
self._get("/extras/usage/%s?start=%s&end=%s"
% (tenant_id,
start.isoformat(),
end.isoformat()),
"usage")</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/openstack-dashboard/.dashboard-venv/src/openstackx/openstackx/api/base.py",
line 36, in
_get</div>
<div> resp,
body =
self.api.connection.get(url)</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/openstack-dashboard/.dashboard-venv/src/openstackx/openstackx/api/connection.py",
line 78, in
get</div>
<div>
return
self._cs_request(url,
'GET',
**kwargs)</div>
<div> File
"/home/mauricio/ostack/openstack-dashboard/openstack-dashboard/.dashboard-venv/src/openstackx/openstackx/api/connection.py",
line 66, in
_cs_request</div>
<div> raise
ex</div>
<div>Unauthorized:
This server
could not
verify that
you are
authorized to
access the
document you
requested.
Either you
supplied the
wrong
credentials
(e.g., bad
password), or
your browser
does not
understand how
to supply the
credentials
required.
(HTTP 401)</div>
</div>
<div>]</div>
<div><br>
</div>
<div><br>
</div>
<div>I'm
including the
contents of
the novarc
file:</div>
<div>[</div>
<div>
<div>NOVA_KEY_DIR=$(pushd
$(dirname
$BASH_SOURCE)>/dev/null;
pwd;
popd>/dev/null)</div>
<div> export
EC2_ACCESS_KEY="afa00c4d-7c1f-4a26-8986-1e291abb4e9d:myproject"</div>
<div>export
EC2_SECRET_KEY="e77a7fd0-bd94-4e67-9dc1-75a9ee2da45c"</div>
<div>export
EC2_URL="<a
moz-do-not-send="true"
href="http://172.241.0.101:8773/services/Cloud" target="_blank">http://172.241.0.101:8773/services/Cloud</a>"</div>
<div>export
S3_URL="<a
moz-do-not-send="true"
href="http://172.241.0.101:3333" target="_blank">http://172.241.0.101:3333</a>"</div>
<div>export
EC2_USER_ID=42
# nova does
not use user
id, but
bundling
requires it</div>
<div>export
EC2_PRIVATE_KEY=${NOVA_KEY_DIR}/pk.pem</div>
<div>export
EC2_CERT=${NOVA_KEY_DIR}/cert.pem</div>
<div>export
NOVA_CERT=${NOVA_KEY_DIR}/cacert.pem</div>
<div>export
EUCALYPTUS_CERT=${NOVA_CERT}
#
euca-bundle-image
seems to
require this
set</div>
<div>alias
ec2-bundle-image="ec2-bundle-image
--cert
${EC2_CERT}
--privatekey
${EC2_PRIVATE_KEY}
--user 42
--ec2cert
${NOVA_CERT}"</div>
<div>alias
ec2-upload-bundle="ec2-upload-bundle
-a
${EC2_ACCESS_KEY}
-s
${EC2_SECRET_KEY}
--url
${S3_URL}
--ec2cert
${NOVA_CERT}"</div>
<div>export
NOVA_API_KEY="afa00c4d-7c1f-4a26-8986-1e291abb4e9d"</div>
<div>export
NOVA_USERNAME="mauricio"</div>
<div>export
NOVA_URL="<a
moz-do-not-send="true"
href="http://172.241.0.101:8774/v1.0/" target="_blank">http://172.241.0.101:8774/v1.0/</a>"</div>
</div>
<div>]</div>
<div><br>
</div>
<div> <br>
</div>
<div> Thanks
in advance for
your help,</div>
<div><br>
</div>
<font
color="#888888">
<div>Mauricio</div>
<div><br>
</div>
</font><br>
</div>
</div>
<div>_______________________________________________<br>
Mailing list:
<a
moz-do-not-send="true"
href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to :
<a
moz-do-not-send="true"
href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
Unsubscribe :
<a
moz-do-not-send="true"
href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help :
<a
moz-do-not-send="true"
href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<pre><fieldset></fieldset>
_______________________________________________
Mailing list: <a moz-do-not-send="true" href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a>
Post to : <a moz-do-not-send="true" href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a>
Unsubscribe : <a moz-do-not-send="true" href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a>
More help : <a moz-do-not-send="true" href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
</body>
</html>