[Openstack] [ceilometer] ERROR in collector : Failed to record metering data

Kelam, Koteswara Rao koteswara.kelam at hp.com
Mon Jun 2 11:32:01 UTC 2014


Hi all,

I am trying to use mysql as database for ceilometer. I created database as follows
CREATE DATABASE ceilometer;

GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'localhost' \
IDENTIFIED BY 'CEILOMETER_DBPASS';

GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'%' \
IDENTIFIED BY 'CEILOMETER_DBPASS';

And mentioned it in ceilometer conf file.
connection=mysql://ceilometer:CEILOMETER_DBPASS@100.30.30.221/ceilometer?charset=utf8

But ceilometer collector is failing to create metering data

root at koteswar-ice-osc:~# ceilometer meter-list
WARNING (http:172) Request returned failure status.
HTTPInternalServerError (HTTP 500)

LOG:
2014-06-01 22:26:41.220 32219 ERROR ceilometer.dispatcher.database [req-c0453bd8-2849-4cfb-9698-3032f65e4d32 - - - - -] Failed to record metering data: (ProgrammingError) (1146, "Table 'ceilometer.source' doesn't exist") 'SELECT source.id AS source_id \nFROM source \nWHERE source.id = %s' ('openstack',)
2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database Traceback (most recent call last):
2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database   File "/usr/lib/python2.7/dist-packages/ceilometer/dispatcher/database.py", line 67, in record_metering_data
2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database     self.storage_conn.record_metering_data(meter)
2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database   File "/usr/lib/python2.7/dist-packages/ceilometer/storage/impl_sqlalchemy.py", line 322, in record_metering_data
2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database     data['source'])

Am I missed anything here? Please give me some pointers to "how to use mysql for celometer".
It is working fine with mongoDB but failing with MYSQL with the above errors.

Thanks in advance,
Koteswar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140602/fc17cdf3/attachment.html>


More information about the Openstack mailing list