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@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
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
