Ask Your Question
0

Any Nova-manage command not run as root results in 'unable to open database file None None'

asked 2013-06-24 15:56:48 -0500

anonymous user

Anonymous

updated 2013-08-19 12:05:13 -0500

Jobin gravatar image

Any nova-manage command not run as root results in the error message

Command failed, please check log for more info
2013-06-24 16:45:28.158 CRITICAL nova [req-74b265d7-1956-411f-9203-09a3be25a4b4 None None] (OperationalError) unable to open database file None None

I go to /var/log/nova/nova-manage.log and the file is empty, while the other log files are constantly updated. My cloud controller is on one box and another box is a compute node running nova-network and nova-compute.

Does anyone know the proper permissions to be set on /etc/nova/nova.conf and /var/log/nova?

My nova.conf is below.

Also when I run nova-manage service list it shows almost all the Zones as internal.

[DEFAULT]

# LOGS/STATE
verbose=True
logdir=/var/log/nova
state_path=/var/lib/nova
lock_path=/var/lock/nova
rootwrap_config=/etc/nova/rootwrap.conf

# SCHEDULER
compute_scheduler_driver=nova.scheduler.filter_scheduler.FilterScheduler

# VOLUMES
volume_api_class=nova.volume.cinder.API
volume_driver=nova.volume.driver.ISCSIDriver
volume_group=cinder-volumes
volume_name_template=volume-%s
iscsi_helper=tgtadm

# DATABASE
sql_connection=mysql://nova:secret@10.168.1.130/nova

# COMPUTE
libvirt_type=kvm
libvirt_cpu_mode=host-passthrough
compute_driver=libvirt.LibvirtDriver
instance_name_template=instance-%08x
api_paste_config=/etc/nova/api-paste.ini

# COMPUTE/APIS: if you have separate configs for separate services
# this flag is required for both nova-api and nova-compute
allow_resize_to_same_host=True

# APIS
osapi_compute_extension=nova.api.openstack.compute.contrib.standard_extensions
ec2_dmz_host=10.168.1.130
s3_host=10.168.1.130
enabled_apis=ec2,osapi_compute,metadata

# RABBITMQ
rabbit_host=10.168.1.130

# GLANCE
image_service=nova.image.glance.GlanceImageService
glance_api_servers=10.168.1.130:9292

# NETWORK
network_manager=nova.network.manager.FlatDHCPManager
force_dhcp_release=True
dhcpbridge_flagfile=/etc/nova/nova.conf
firewall_driver=nova.virt.libvirt.firewall.IptablesFirewallDriver
# Change my_ip to match each host
my_ip=10.168.1.131
public_interface=eth0
vlan_interface=eth0
flat_network_bridge=br100
flat_interface=eth0
fixed_range=10.168.1.150/26


# NOVNC CONSOLE
novncproxy_base_url=http://10.168.1.130:6080/vnc_auto.html
# Change vncserver_proxyclient_address and vncserver_listen to match each compute host
vncserver_proxyclient_address=10.168.1.131
vncserver_listen=10.168.1.131

# AUTHENTICATION
auth_strategy=keystone
[keystone_authtoken]
auth_host = 127.0.0.1
auth_port = 35357
auth_protocol = http
admin_tenant_name = service
admin_user = nova
admin_password = nova
signing_dirname = /tmp/keystone-signing-nova

default_availability_zone=someAZ
edit retag flag offensive close merge delete

Comments

which version of OpenStack is this?

fifieldt gravatar imagefifieldt ( 2013-08-10 21:15:16 -0500 )edit

1 answer

Sort by » oldest newest most voted
1

answered 2013-08-19 09:46:15 -0500

annegentle gravatar image

Like Tom mentioned, we'll need to know what version you're running. A few thoughts:

The nova.conf file should have its owner set to root:nova, and mode set to 0640, since the file could contain your MySQL server’s username and password. You also want to ensure that the nova user belongs to the nova group.

Also be aware of rootwrap settings in your nova.conf. http://docs.openstack.org/grizzly/openstack-compute/admin/content/root-wrap-reference.html

In older documentation (say, diablo release), we had nova, glance, and keystone all connect with the same username and password, but this is not best practice nor secure, so the docs now indicate a nova user to connect to the MySQL database separate from a keystone user and separate from a glance user.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2013-06-24 15:56:48 -0500

Seen: 3,305 times

Last updated: Aug 19 '13