Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Cinder and Nova keep creating .sqlite files?

I asked a question a few weeks ago. I had the problem that cinder and nova weren't able to write into my mysql db. The logs said that the attempts failed while trying to write into a readonly database. That wasn't the problem though. I've figured out that cinder and nova keep creating their .sqlite files in /var/lib/cinder|nova/ after running the command

cinder|nova-manage db sync

The result is that tables for cinder and nova aren't created. How can I solve this problem?

best regards Matteo

Cinder and Nova keep creating .sqlite files?

I asked a question a few weeks ago. I had the problem that cinder and nova weren't able to write into my mysql db. The logs said that the attempts failed while trying to write into a readonly database. That wasn't the problem though. I've figured out that cinder and nova keep creating their .sqlite files in /var/lib/cinder|nova/ after running the command

cinder|nova-manage db sync

The result is that tables for cinder and nova aren't created. How can I solve this problem?

my api-paste.inis look like this (switching cinder for nova in the ini for nova and of course using a different password)

[filter:authtoken]
paste.filter_factory = keystoneclient.middleware.auth_token:filter_factory
service_protocol = http
service_host = keystone01
service_port = 5000
auth_host = keystone01
auth_port = 35357
auth_protocol = http
admin_tenant_name = service
admin_user = cinder
admin_password = 70c36bed72a866d7b701
signing_dir = /var/lib/cinder

and that's how the configs look like:

[DEFAULT]
rootwrap_config = /etc/cinder/rootwrap.conf
api_paste_confg = /etc/cinder/api-paste.ini
iscsi_helper = tgtadm
volume_name_template = volume-%s
volume_group = cinder-volumes
verbose = True
auth_strategy = keystone
state_path = /var/lib/cinder
lock_path = /var/lock/cinder
volumes_dir = /var/lib/cinder/volumes
rpc_backend = cinder.openstack.common.rpc.impl_kombu
rabbit_host = rabbitmq01
rabbit_port = 5672
rabbit_userid = guest
rabbit_password = 57b3f5450c826b0118f0
volume_driver=cinder.volume.drivers.rbd.RBDDriver
rbd_pool=volumes
rbd_ceph_conf=/etc/ceph/ceph.conf
rbd_flatten_volume_from_snapshot=false
rbd_max_clone_depth=5
glance_api_version=2
rbd_user=cinder
rbd_secret_uuid=605e6b61-65b7-490c-aec1-c75c2892bfd8
backup_driver=cinder.backup.drivers.ceph
backup_ceph_conf=/etc/ceph/ceph.conf
backup_ceph_user=cinder-backup
backup_ceph_chunk_size=134217728
backup_ceph_pool=backups
backup_ceph_stripe_unit=0
backup_ceph_stripe_count=0
restore_discard_excess_bytes=true
[database]
connection = mysql://cinder:60f3945e2c4af64ab142@sqldb01/cinder

here passwords and user differs in nova again.

best regards Matteo