You need to run: ceilometer-dbsync --config-file /etc/ceilometer/ceilometer.conf
in order to create the required schema in the database. Cheers, Eoghan ----- Original Message ----- > > > 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:[email protected]/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 : [email protected] > Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
