Ask Your Question

Matteo's profile - activity

2016-08-24 09:25:54 -0500 received badge  Taxonomist
2014-05-16 12:09:18 -0500 received badge  Famous Question (source)
2014-04-29 07:46:38 -0500 commented answer caught error: Timeout while waiting on RPC response - topic: "network", RPC method: "validate_networks" info: "<unknown>"

Is this the conf for nova or neutron? Because I'm running into the same errors at the moment.

2014-04-21 04:07:41 -0500 received badge  Notable Question (source)
2014-04-17 05:18:32 -0500 received badge  Teacher (source)
2014-04-17 05:18:32 -0500 received badge  Self-Learner (source)
2014-04-17 05:06:53 -0500 answered a question Cinder and Nova keep creating .sqlite files?

The problem wasn't cinder neither was nova. The problem was my ubuntu version. I'm running OpenStack on a 13.04 Ubuntu Server. But for 13.04 there aren't the most current packages available and the command

add-apt-repository cloud-archive:havana

doesn't work. I had to run following command to add the repository

echo deb http://ubuntu-cloud.archive.canonical.com/ubuntu precise-updates/havana main >> /etc/apt/sources.list.d/havana.list

After running the command and updating the required packages there weren't any sqlite files created anymore.

Perhaps the package repository should be available for 13.04 as well.

2014-04-17 04:57:35 -0500 received badge  Popular Question (source)
2014-04-16 01:08:37 -0500 commented question Cinder and Nova keep creating .sqlite files?

There isn't any special debug output when I run the command and the nova-manage.log persists empty.

One thing I've noticed is that nova-consoleauth recreates the sqlite file over and over as long as it runs and tries to read it. But despite I gave nova all rights on the file it says that it can't read the database. If I stop nova-consoleauth the nova.sqlite file persists deleted. So two scenarios recreate the sqlite file:

  • a running nova-consoleauth service
  • and running the nova-manage db sync command

But neither of both can read the created file. I don't know why they doesn't use the given mysql connection in the config though.

When I run your command with cinder I recieve an output though. : http://paste.openstack.org/show/75872/

E:// Okay for cinder I managed to figure outwhat the was with the sqlite file. It ... (more)

2014-04-16 01:08:37 -0500 received badge  Commentator
2014-04-16 01:01:31 -0500 received badge  Enthusiast
2014-04-15 07:01:10 -0500 commented question Cinder and Nova keep creating .sqlite files?

Sure I can do this.

  • Cinder.conf: http://paste.openstack.org/show/75759/
  • cinder api-paste.ini: http://paste.openstack.org/show/75760/
  • nova.conf: http://paste.openstack.org/show/75763/
  • nova api-paste.ini: http://paste.openstack.org/show/75764/
2014-04-15 05:11:23 -0500 commented question Cinder and Nova keep creating .sqlite files?

It seems that it isn't the manage db sync command particular. The sqlite file is created everytime if it not exist. I managed to figure out that nova-consoleauth is responsible for creating the file over and over if it's not there. When I stop the service the file keeps deleted. When I start db sync with consoleauth deactivated the sqlfile is wirten again though.

The DATABASE exist and I have rights with nova in mysql to create tables. I think mysql permissions aren't the thing what's wrong here.

2014-04-15 04:06:34 -0500 asked a question 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

2014-04-08 05:19:15 -0500 commented answer Cinder is unable to open my database

Unfortunately this doesn't solve the problem.

2014-04-08 04:16:58 -0500 commented answer Cinder is unable to open my database

Yes. I've deleted the database and the user as well and created it again. The problem still persists.

2014-04-08 03:11:30 -0500 commented answer Cinder is unable to open my database

My config doesn't include the wrong connection term anymore but it still doesn't work. As before the log still says that cinder can't write into an readonly db.

2014-04-08 02:13:19 -0500 received badge  Famous Question (source)
2014-04-08 01:29:01 -0500 received badge  Editor (source)
2014-04-08 01:17:36 -0500 answered a question Cinder is unable to open my database

Okay. I've managed to solve the problem. The Problem was with the /var/lib/cinder/cinder.sqlite file. I forgot deleting the file.

E:// Okay it solved not the whole problem. But it was still one.

2014-04-07 07:21:19 -0500 commented question Cinder is unable to open my database

Based on the fact that cinder can't write into the db it won't start. The output for "service openstack-cinder-scheduler status -l" is:

openstack-cinder-scheduler: unrecognized service

The MySQL user cinder has been granted write privileges with mentioned grant commands before the whole problem started.

2014-04-07 02:44:17 -0500 commented question Cinder is unable to open my database

Yes. It was of the one things I tested on Friday. I have access with the user to the database cinder. And as it should be there aren't tables in it because cinder can't use the db as it seems. I also can create manually tables within the database "cinder" with the user cinder.

2014-04-07 02:24:05 -0500 received badge  Notable Question (source)
2014-04-07 02:08:34 -0500 commented question Cinder is unable to open my database

My configuration looks like this:

    [DEFAULT]
rootwrap_config=/etc/cinder/rootwrap.conf
api_paste_config = /etc/cinder/api-paste.ini

iscsi_helper=tgtadm
volume_name_template = volume-%s
volume_group = cinder-volumes
verbose = True
auth_strategy = keystone
#osapi_volume_listen_port=5900

# Add these when not using the defaults.
rabbit_host = rabbitmq01
rabbit_port = 5672
rabbit_userid = guest
rabbit_password = 02eb12d641f407244c7e
#rabbit_virtual_host = /nova

[database]
connection = mysql://cinder:2592af999f96947f9c17@sqldb01/cinder

And that's the error message from the cinder-scheduler.log (despite the error is saying it, the DB isn't read only)

DBError: (OperationalError) attempt to write a readonly database u'INSERT INTO services (created_at, updated_at, deleted_at, deleted, host, binary, topic, report_count, disabled, availability_zone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' ('2014-04-07 07:29:41.694794', None, None, 0, 'oscontroller01', 'cinder-scheduler', 'cinder-scheduler', 0, 0, 'nova')
2014-04-05 07:46:44 -0500 received badge  Popular Question (source)
2014-04-04 08:04:23 -0500 asked a question Cinder is unable to open my database

Hello I'm running a Ubuntu Server 13.04 server and following the OpenStack installation guide. Cinder isn't working proberbly, though. The problem is the cinder.conf. It wasn't filled correctly and a lot of stuff was missing. So I insert the default conf from github into it and uncommented the needed settings. It still doesn't work, though. The error message I receive is:

CRITICAL [cinder] (OperationalError) unable to open database file None None

Mysql is set up right, though. Am I missing anything?

2014-04-04 04:47:49 -0500 commented answer ERROR: The server has either erred or is incapable of performing the requested operation. (HTTP 500)

Is your nova table created correctly? Because if not the db sync command didn't work. If not look into /var/lib/nova/ and search for the nova.sqlite file. If it is there delete it and use the db sync command again.